3. A family borrows $185,000 over 10 years at 4.75% annually compounded monthly. Compute their monthly payement and develop an amortization table that shows the split between interest and principal for each payement. Use Excels's IPMT and PPMT functions. Hand in a graph of the interst and principal component of each payement versus time with your short-hand calculations.

Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter3: Journalizing Transactions
Section3.4: Proving And Ruling A Journal
Problem 2AYU
icon
Related questions
Question
please draw cash flow diagrams
Transcribed Image Text:please draw cash flow diagrams
3. A family borows $185,000 over 10 years at 4.75% annually compounded monthly. Compute their monthly
payement and develop an amortization table that shows the split between interest and principal for each
payement. Use Excels's IPMT and PPMT functions. Hand in a graph of the interst and principal
component of each payement versus time with your short-hand calculations.
Transcribed Image Text:3. A family borows $185,000 over 10 years at 4.75% annually compounded monthly. Compute their monthly payement and develop an amortization table that shows the split between interest and principal for each payement. Use Excels's IPMT and PPMT functions. Hand in a graph of the interst and principal component of each payement versus time with your short-hand calculations.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

Blurred answer