Question

In: Finance

The Ricordi family has just bought a house for $275,000. They have been saving money for...

e) [4 pts] After ten years of payments, how much of their next monthly payment is devoted to interest?

Solutions

Expert Solution

10yrs of payment would mean 10yrs *12 months = 120 therefore after 120 months of payment it will be the 121st payment

For the 121st payment, you can use IPMT function in excel to arrive the interest portion

IPMT(rate, per,nper,PV,FV,Type)

rate 6.5%/12, per 121 (121st payment) nper 360 (Number of total payments are 360) PV 175000

IPMT(6.5%/12,121,360,175000)

$803.61 of the 121st monthly payment is devoted to interest

2nd Method (Manual)

House Cost $275000 less: down payment $100000 = Loan or present value $175000

Monthly rate or r 6.5% / 12 = 0.005416667

Total n or nper 30yrs * 12months = 360

PMT or Monthly payment formula = Present Value / [ 1- ( 1+r)^-n]/ r

Monthly payment = 200000 / ((1 - (1.005416667)^-360) / 0.005416667)

Monthly payment = 200000 / ((1 - 0.143024728) / 0.005416667)

Monthly payment = 200000 / (0.856975272 / 0.005416667)

Monthly payment = 200000 / 158.2108195

Monthly payment = 1106.12

You can make an amortization table using the concept mentioned below and manually check the interest portion for 121st payment

Month 1

The first interest payment will be (rate) * (beginning principal)

0.005416667 * 175000 =947.92

payment towards principal = Monthly Payment - interest portion

payment towards principal = 1106.12 - 947.92

payment towards principal = 158.20

Ending balance of principal = Beginning Principal Balance - payment towards Principal for that month

Ending balance of principal = 175000 - 158.20 = 174841.80

Month 2

Interest portion = (rate) * (ending principal)

0.005416667 * 174841.80 (ending principal) = 947.06

payment towards principal = Monthly Payment - interest portion

payment towards principal = 1106.12 - 947.06

payment towards principal = 159.06

Ending balance of principal = Principal Balance - payment towards Principal for that month

Ending balance of principal 174841.80 - 159.06 = 174682.74

and so on till 360 payments

jeff jeffy answered 2 hours ago

Next > < Previous

Related Solutions

The Ricordi family has just bought a house for $275,000. They have been saving money for...

The Ricordi family has just bought a house for $275,000. They have been saving money for a while and are able to make a $100,000 down payment. They have chosen a 30-year mortgage from their bank to borrow the balance of the purchase price. The interest rate of the mortgage is 6.5%, compounded monthly. a) [7 pts] What will the Ricordis' monthly payments be? b) [2 pts] What is the total interest the Ricordis will pay over the full 30-year...

You have just bought a house and have taken out a mortgage (an installment) loan for...

You have just bought a house and have taken out a mortgage (an installment) loan for $500,000. This is a 30-year loan that requires monthly payments and the first payment is due one month from today. The APR for the loan is 24%. You are interested to know how much of your 210th monthly payment will go toward the repayment of principal? That amount is _______________ Question 10 options: $762.65 $9,586.98 $625.64 $9,494.78 $513.24 $9,382.38 $421.04 $9,245.37

you just bought a house and have a $188,000 mortgage. the mortgage is for 15 years...

you just bought a house and have a $188,000 mortgage. the mortgage is for 15 years and has a nominal rate of 4.25%.on the 24th payment what will be the amount going to principal?

You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest...

You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest rate of 8.5 percent with monthly payments. Over the next five years, what percentage of your mortgage payments will go toward the repayment of principal?.

You have been saving to buy a house. The total cost will be $10 million. You...

You have been saving to buy a house. The total cost will be $10 million. You currently have about $2.3 million. If you earn 5% on your money. (i)how long will you have to wait until you are able to buy the house? (ii) At 16% how long will you have to wait?

Mr. Jones has just bought a house for $250,000. He will make a down payment of...

Mr. Jones has just bought a house for $250,000. He will make a down payment of 5% on the house, and pay for the rest with a mortgage. The Bank Le Friendly offers 10-year mortgage loans at 13% APR compounded semi-annually, with monthly mortgage payments starting today. What is the amount of Mr. Jones’s monthly mortgage payment? A. $3,462.31 B. $3,498.84 C. $3,546.13 D. $3,647.40 E. $3,605.56

It is holiday season at the Variable family house and you (the researcher) have been invited...

It is holiday season at the Variable family house and you (the researcher) have been invited to dinner to celebrate. You arrive to dinner and see that five members of the Variable family are there: Dependent, Independent, Control, Extraneous, and Moderator. Being the great researcher that you are, you spend much of your time at dinner observing the interactions among the members of the Variable family. When you get home, your friend calls and asks you about your evening. Your...

3) You just bought a house for $200,000. You have agreed to make 5 payments at...

3) You just bought a house for $200,000. You have agreed to make 5 payments at the end of the year for 5 years with an interest rate of 6%. What will the annual payment be? Create a loan amortization schedule. beginning balance payment interest principal ending balance 1 2 3 4 5

Wally has just bought a house by taking a 30-year, $127,500 mortgage from the bank. The...

Wally has just bought a house by taking a 30-year, $127,500 mortgage from the bank. The interest rate is 8.25%. The mortgage is to be retired by payments made every month starting next month. How much does Wally have to pay each month to repay the mortgage? What would the monthly payments be if Wally opts for a 15-year mortgage at the same interest rate?

Queenie just bought a house that cost $1,600,000. She has saved up $200,000 for the closing...

Queenie just bought a house that cost $1,600,000. She has saved up $200,000 for the closing costs--such as legal fees—and the down payment. When she approaches the local bank, she was quoted the rate for a two-year mortgage at 4% (APR, semi-annual compounding), 25 years amortization. But there is one problem; she was told that her income satisfied the bank’s GDS and TDS requirements, but the bank can lend only up to 75% of the purchase price of the house...

Subjects