Question
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate is 5.25 percent. You will make
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate is 5.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage 130,000 X .20 = 26,000 Loan amount 130,000 26,000 = 104,000 104,000; interest rate (.525 / 12) 30 years X 12 months = 360 b. Using an Excel Spreadsheet, construct the amortization schedule for the first 12 payments. c. Compute a breakdown of the total payments of the mortgage into interest and principal payment.
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