1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan.

2. In cell F8 use built-in function =PMT(k,n,PV). You should get identical answers.

3. Create amortization table (use absolute and relative addressing where appropriate).

4. Print worksheet.

5. Change loan amount and the rate (everything should adjust automatically) and print it again.

6. Print the cell formulas (force to one page).

7. Write report and explain all formulas and procedures.

8. Submit four printouts.

PMT=$1589.99 per month=$1589.99

Rate per month=0.75%

36 months

Total=$57239.52

Total Interest=$7239.52

Principal=$50000.00

Table 5.2 Loan Calculation & Amortization Table PV = Loan Amoul $50,000.00 k = Rate Per Year Per Month n = Term Years Months PMT Use Excel built-in formula Period PMT interest Principal Balance $50,000.00 Total I 5.2 N