The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Amortization schedule
Loan amount to be repaid (PV)	$39,000.00
Interest rate (r)	11.00%
Length of loan (in years)	3
a. Setting up amortization table		Formula
Calculation of loan payment		#N/A
Year	Beginning Balance	Payment	Interest
1
2
3
b. Calculating % of Payment Representing Interest and Principal for Each Year
Year	Payment % Representing Interest	Payment % Representing Principal	Check: Total = 100%
1
2
3
Formulas

Year Beginning Balance Payment Interests Repayment of Principal Ending Balance

1

2

3