Question
You are ready to buy a house and you have $85,000 for a down payment and closing costs. Closing costs are estimated to be 3.5%
You are ready to buy a house and you have $85,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $125,000. The bank is willing to allow your monthly mortgage payment to be equal to 28% of your monthly income. The interest rate on the loan is 4.5% per year with monthly compounding for a 30-year fixed rate loan. How much money will the bank loan you? How much can you offer for the house? Construct a loan amortization table for the mortgage. Please submit the actual Excel spreadsheet with formulas embedded in the spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started