Assume the following Data Annual Salary $ 200,000.00 PMT % of Monthly Salary Set by Bank 14.50% Down Payment and Closing Cost $90,000 Closing Cost % of Loan 4% Annual Interest Rate 5% Years 30.00 Payments Per Year 12.00 Create an excel document with a full loan amortization table showing the total monthly payment, monthly principal payment, interest payment/month, and the mortgage balance per month. In your solution, you will have to solve for the monthly loan payment amount/month, the closing cost, and the maximum price of a house you can afford, given all restrictions. Use the following template for the assignment.

Payment Loan Amount

Closing Cost

How Much of a House can you Afford?

Payment #

Payment Principal

Interest Balance