Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with Part 3 only. Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house. The interest rate

image text in transcribedimage text in transcribed

Please help with Part 3 only.

Intro You just took out a 15-year traditional fixed-rate mortgage for $400,000 to buy a house. The interest rate is 4.8% (APR) and you have to make payments monthly. Part 1 Attempt 1/10 for 10 pts. What is your monthly payment? Correct Since it's a traditional fixed-rate mortgage, the cash flows are constant and make up an annuity. We can thus use the annuity formula, solved for C. Monthly interest rate: r=0.048/12=0.004 Number of months: t=1512=180 PV=C[r11/(1+r)t]C=11/(1+r)tPVr=11/(1+0.004)180400,0000.004=3,122 Using a financial calculator: Using Excel (do not enter the thousands separators): = PMT(rate, nper, pv) =PMT(0.048/12,180,400,000) How much of your first monthly payment goes towards paying down the outstanding balance (in \$)? Correct Since the initial balance is $400,000 and the monthly interest rate is 0.004 , we have to pay $400,0000.004=$1,600 in interest in the first month. Therefore, the remainder of the payment is principal repayment, which reduces the outstanding balance: Principal repayment = Payment - Interest =3,1221,600=1,521.66 Using Excel (do not enter the thousands separators): = PPMT (rate, per, nper, pv) = PPMT (0.048/12,1,180,400,000) =1,521.66 Part 3 (1) Attempt 5/10 for 10 pts. How much of your 13th monthly payment goes towards paying down the outstanding balance (in \$)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Derivatives And Internal Models

Authors: H. Deutsch

4th Edition

1349307661, 9781349307661

More Books

Students also viewed these Finance questions