You got a well-paying job in Finance and took out a mortgage for your house. It is paid monthly. The amount you borrowed is $790,000, at a monthly rate of 0.5% for the next 30 years (360 months). 1 Use 0.5% as both the interest rate you are paying and the discount rate r.

-Show an amortization schedule if this loan had constant monthly payments. How much do you have to pay every month? Show how much of these payments is interest and how much is paying off the principal. Please show how to do this in excel