Question: #1026

Loan Amortization

Can you please show me how to do this in ms Excel. Find the payment you would need to make per year at a discount rate (interest rate that the bank charges you) from 0% to 50% (51 answers), if you borrow $5,000,000 ($5 million) today (PV) and pay it back in equal amounts over the next 30 years. Make a table and graph of your answers. 

Additional Requirements 



Min Pages: 1 

Level of Detail: Show all work

Solution: #1030

Loan Amortization

Can you pl...

Tutormaster
Rating: A+ Purchased: 11 x Posted By: Johnson7
Related Solutions

No related questions were found.

Comments
Posted by: Johnson7

Online Users