Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will
5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage? Be sure to have a zero balance at the end of amortization.
Loan Amount | 180,576 | Loan Length in months | 240 | ||||||||
Interest (APR) | 4.250% | Total interest payment | Hint: Be sure to compute the total interest payments using "Sum()" function. | ||||||||
Prepayment | $150 | Total # of pmts with prepay | With the prepayments, note that your payments will be shortened. |
Month | Beginning Principal | Monthly Payment | Interest | Principal pmt | Outstanding Balance |
1 | 180,576 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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