Export Summary
This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
Numbers Sheet Name Numbers Table Name Excel Worksheet Name
Grading Sheet
Table 1 Grading Sheet
Savings and Loan Analysis
Table 1 Savings and Loan Analysis
Budget Cost Projection
Table 1 Budget Cost Projection
Conversions
Table 1 Conversions
Grading Sheet
Major Assignment 2 Grading Sheet
Competency Requirements for full credit (optional for student use) Did you meet the requirements? Points possible Your points Scoring comments
Savings and Loan Analysis Name You have entered your full name in the field provided. 1
Interests Rates The interest rates you have entered come from the mortgage rates table and match those for the months and years provided. 3
You have explicitly formatted the cells to display as Percentage with 2 decimal places of precision. 3
Monthly Costs and Savings Your Electric, Gas, Water, and Other entries are reasonable values, with at least two nonzero entries. For zero entries, you have explicitly entered values of 0. 4
Your Total Cost and Monthly Savings formulas are correct and use appropriate cell references. 4
All cost cells are formatted as Currency showing the $ symbol and with 2 decimal places of precision. 6
Savings Table You have brought forward your monthly savings amount, using Excel formulas. 3
Your number of contributions per year and number of years entries are correct. 6
Your formulas for total amount saved, total contributions, and total accrued interest are correct and use cell references. 18
All cells are explicitly formatted with the format given in the last column of the table. 18
Loan Table You have entered the correct number of contributions per year and number of years. 6
Your formulas for payment amount, total amount paid, and total amount of interest paid are correct and use cell references as inputs. 18
All cells are explicitly formatted with the format given in the last column of the table. 15
Comparison You have correctly brought forward your savings and loan amounts, using cell references. 6
Your savings and loan cells are explicitly formatted with the format given in the last column of the table. 6
You have answered the comparison questions correctly, answering either “yes” or “no” for each one. 3
Subtotals 120 0
Budget Cost Projection Inflation Rate Calculation Your reference CPI is correct for the month and year given. 1
Your next-year CPI, month, and year are correct. 3
Your inflation rate calculation is correct. 3
Your CPI values and inflation rate are explicitly formatted as indicated in the instructions. 3
Budget Projections You have correctly entered your Budget Total from cell G21 of the Monthly Budget sheet from your Major Assignment 1. 2
Your “value of t” entries are correct. 3
Your 1-year, 5-year, and 10-year projections are correct Excel formulas using cell references. 6
Your percent increase calculations are correct Excel formulas using cell references. 6
Your Current Budget, Projected Budget and Percent Increase cells are formatted as indicated in the instructions. 7
Subtotals 34 0
Conversions Monthly Savings You have brought forward your monthly savings amount from the Savings and Loan Analysis sheet, using an Excel formula with a sheet and cell reference. 2
Currency Conversions You have entered the first two letters of your first and last names, using the letter M if one or both names consist of only one letter. 4
You have chosen appropriate countries from the list provided below the table, using the procedure described in the instructions. 4
You have entered the date(s) on which you looked up the exchange rates for your currencies, and all dates are within 2 weeks of the due date of your assignment. 4
You have entered both the full name of your country’s currency and the correct currency code as indicated on the website. 8
You have provided each exchange rate to at least 5 significant digits, and the exchange rate matches the rate for the date you looked it up. 4
Your savings amount in the foreign currency is a correct Excel formula, using cell references. 8
Your calculation of the value of foreign currency units into dollars are correct Excel formulas, using cell references. (Note that the amount to convert is autogenerated and may differ from the amount shown in assignment resources.) 8
The cells containing your dates, savings amounts, and value of foreign currency converted to dollars are correctly formatted as specified in the last column of the table. 12
Subtotals 54 0
Totals 208 0
Percentage 100.00% 0.00%
Scaled out of 100 100.00 0.00
&”Helvetica Neue,Regular”&12&K000000&P
Savings and Loan Analysis
2 Enter your full name here (If fewer than 9 letters, add additional arbitrary letters) Madison
Recent Comments