Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Bob and Marcus are buying a house. They have $22000 for a down payment. The house price is $176000. They have secured a 25 year
Bob and Marcus are buying a house. They have $22000 for a down payment. The house price is $176000. They have secured a 25 year loan with an annual interest rate of 4.3% compounded monthly, Use Excel to determine the size of the monthly payments they must make over the next 25 years to pay off the house. How much will they pay total over the 25 years? How much will they pay in interest of the 25 years? Express your answer rounded to the nearest cent!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To solve this problem we can use the Excel function PMT to calculate the monthly payment The formula ...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