Part B: Planning problems using Excel
- Mortgage payments : ( 10 % of this assignment)
- Loan amount : $200,000
- Interest rate (annual): 4.00 %
- Term : 30 years
- Calculate
- monthly payments: ( Hint : Rate and number of periods should be
adjusted for monthly)
- Total interest amount over the life of the loan
- In reference to (1, above). ( 10 % of this
assignment)
- Calculate PMT ( Monthly payments) if you want to pay of the
above loan in 20 years
- How much less interest will you pay over the life of the loan (
versus paying in 30 years)