Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You just took out a 1 5 - year traditional fixed - rate mortgage for $ 3 0 0 , 0 0 0 to buy

You just took out a 15-year traditional fixed-rate mortgage for $300,000 to buy a house. The interest rate is 4.8%(APR) and you have to make payments monthly. Attempt 2/10 for 10 pts.Part 1What 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 forPMT.Monthly interest rate: I =0.048/12=0.004Number of months: N =15*12=180PVAN=PMT[11/(1+I)NI]PMT=PVANI11/(1+I)N=300,0000.00411/(1+0.004)180=2,341 Using a financial calculator: NI/YPVPMTFVInputs1800.4-300,0000Compute 2,341 Using Excel (do not enter the thousands separators):=PMT(rate, nper, pv)=PMT(0.048/12,180,-300,000)=2,341 Attempt 5/10 for 10 pts.Part 2How much of your first monthly payment goes towards paying down the outstanding balance (in $)?Correct Since the initial balance is $300,000 and the monthly interest rate is 0.004, we have to pay $300,000*0.004= $1,200 in interest in the first month.Therefore, the remainder of the payment is principal repayment, which reduces the outstanding balance:Principal repayment = Payment - Interest =2,341-1,200=1,141.24Using Excel (do not enter the thousands separators):=PPMT(rate, per, nper, pv)=PPMT(0.048/12,1,180,-300,000)=1,141.24 Attempt 3/10 for 10 pts.Part 3How 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_2

Step: 3

blur-text-image_3

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

Handbook Of Asset And Liability Management Volume 2

Authors: S. A. Zenios, W. T. Ziemba

1st Edition

0444528024, 978-0444528025

More Books

Students also viewed these Finance questions

Question

Define procedural justice. How does that relate to unions?

Answered: 1 week ago