Find the best answers to your questions at Westonci.ca, where experts and enthusiasts provide accurate, reliable information. Our platform offers a seamless experience for finding reliable answers from a network of experienced professionals. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.
Sagot :
Answer:
Please find the complete question in the attached file.
Explanation:
Use PMT for the interest amount computation
[tex]PMT(12\%, 55, 232000, 0 , 0) = \$27,894.77[/tex]
At first, the bulk of an initial premium is paid at the rate of interest, and that only the remainder of the small part is used for amortization. The very first three years schedule is shown below:
[tex]Loan\ \ \ \ \ \ \ \ \ \ Annual\ \ \ \ \ \ \ \ \ \ Interest\ \ \ \ \ \ \ \ \ \ Principal\\\\[/tex]
[tex]1\ \ \ \ \ \ \ \ \$232,000.00\ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,840.00\ \ \ \ \ \ \ \ \$54.77\\\\2\ \ \ \ \ \ \ \ \$231,945.23\ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,833.43\ \ \ \ \ \ \ \ \$61.34\\\\3\ \ \ \ \ \ \ \ \$231,883.89 \ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,826.07\ \ \ \ \ \ \ \ \$68.70\\\\[/tex]
By the 49th payment, upwards of half of the initial amount borrowed would be the total principal paid. Using the formula CUMPRINC in excel, the entire principal payment is calculated twice.
Total Interest Expense [tex]= 27,894.77 \times 55 - 232,000 = \$1,302,212.27[/tex]
We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.