Stage 2 Document

Stage 2 - Evidence
Evaluative Criteria
Assessment Evidence
Spreadsheet Analysis of Loan Offers
PERFORMANCE TASK(S):                                                                                                  
Students will create a spreadsheet using Google Sheets or Microsoft Excel with the purpose of evaluating loan offers for the purchase of a new car.  Variables for analysis will include:
1. Required down payment for the loan
2. Interest rate of the loan
3. How the interest is compounded (daily or monthly)
4. The total cost of the loan
5. Monthly payment
Written Rationale
OTHER EVIDENCE:                                                                                                                
Students will explain the rationale for their selection of a loan offer for a new car. They will engage in a cost/benefit analysis of the various loans and defend their loan decision based on the financial trade-offs of accepting one loan over another.
They will consider a number of factors including:
1. The initial cost of the loan
2. The total cost of the loan
3. Impact on monthly budget

Comments

Popular posts from this blog

Curating Information