Question: use excel please Problem #3: Create a table showing the payment of a mortgage of $176,000 month by month. Create columns for: Time (in years)

use excel please Problem #3: Create a table showing the payment ofuse excel please

Problem #3: Create a table showing the payment of a mortgage of $176,000 month by month. Create columns for: Time (in years) - Interest (for that month) - Payment (always the same value) Payment against principal - Remaining Principal The mortgage is to last 31 years, and the nominal interest rate is 8.71% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th month? (c) How much of the principal is paid down by the payment made at the end of the 22nd month? (d) The first time that the portion of a monthly payment that is paying down the principal will be larger than the portion paying interest will occur at the end of month number_ ? Problem #3(a): Answer correct to 2 decimals Problem #3(b): Answer correct to 2 decimals Problem #3(c): Answer correct to 2 decimals Problem #3(d)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!