Fill in the amortization table using formulas and cell references in the highlighted cells.
For grading purposes, all your values should be positive.
You will need to change some
formulas so you get a positive result.
Use cell references and formulas throughout this sheet - there should be no hard-coded
numbers in the amortization table.
Loan Amount
279,900
Interest Rate
7.125%
Loan Term (Years)
30
Monthly Payment
Period
Payment
Hint:
This number needs to be positive!
1
279,900.00
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Beginning
Balance
