Question

12. you are borrowing $1 million to buy your dream home, taking a 30 -year mortgage...

12. you are borrowing $1 million to buy your dream home, taking a 30 -year mortgage at 6% per year and undertaking to make equal monthly payments at the end of each month for 30 years to amortize the loan. What is your monthly payment, interest portion of your first payment and principal portion of your first payment?

Homework Answers

Answer #1

Amount borrowed (PV) = $1,000,000

No of monthly installments (N) = 360

Interest rate per month (i) = 6% / 12 = 0.50% p.m.

Monthly installment (PMT) = ??

Using financial calculator or PMT function in excel,

Monthly installment (PMT) = $ 5,995.51

interest portion in 1st payment = loan Amount outstanding at the beginning of 1st payment x monthly interest rate

interest portion in 1st payment = 1000,000 x 0.5% = $5,000

Therefore principal portion of first payment = payment - interest portion = $ 5,995.51 - $ 5,000 = $ 995.51

Thumbs up please if satisfied. Thanks :)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are offered a 30-year fixed-rate mortgage on your dream home costing $350,000 at an APR...
You are offered a 30-year fixed-rate mortgage on your dream home costing $350,000 at an APR of 6% compounded monthly. You will make 360 monthly payments, but your first payment will not be due until Month 4 (Months 1-3 are part of a grace period where interest is still compounded but no payments are due). The final payment will therefore be due at the end of Month 363. a) What will be the value of your equal monthly payments (don't...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much will be your principal repayment from your monthly mortgage payment at the end of the second month?(Make a table for the mortgage loan payment schedule) Can you explain how to get interest and principle repaid please
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly...
3. You take a $500,000 mortgage to buy a vacation home. The mortgage entails equal monthly payments for 10 years, 120 payments in all, with the first payment in one month. The bank charges you an interest rate of 9.6% (APR with monthly compounding). a. How much of your first payment is interest, and how much is repayment of principal? b. What is the loan balance immediately after the 10th payment? (Calculate the loan balance using the annuity formula.) c....
You take out a $325,000 thirty-year mortgage (amortized loan) when you purchase your home. The interest...
You take out a $325,000 thirty-year mortgage (amortized loan) when you purchase your home. The interest rate is 6%. You make monthly payments of $1948.54. What is the principal portion of your first payment?
You need a 30-year, fixed-rate mortgage to buy a new home for $265,000. Your mortgage bank...
You need a 30-year, fixed-rate mortgage to buy a new home for $265,000. Your mortgage bank will lend you the money at an APR of 5.6 percent for this 360-month loan. However, you can only afford monthly payments of $1,050, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment.      How large will this balloon payment have to be for you to keep your monthly...
You have found your dream home. The selling price is $300,000. You will put $60,000 as...
You have found your dream home. The selling price is $300,000. You will put $60,000 as down payment and obtain a 30-year fixed-rate mortgage loan at 4.5 percent annual interest rate for the rest. a) You are required to make an equal payment every monthfor 360 months to pay off the balance on the loan. Assume that the first payment begins in one month after you obtained the loan. What will each monthly payment be? b) If you want to...
You need a 30-year, fixed-rate mortgage to buy a new home for $230,000. Your mortgage bank...
You need a 30-year, fixed-rate mortgage to buy a new home for $230,000. Your mortgage bank will lend you the money at a 7.6 percent APR for this 360-month loan. However, you can afford monthly payments of only $800, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. How large will this balloon payment have to be for you to keep your monthly payments at...
You borrow 410,000 to buy a home using a 30-year mortgage with an interest rate of...
You borrow 410,000 to buy a home using a 30-year mortgage with an interest rate of 3.75 percent and monthly payment. After making your monthly payments on time for exactly 6 years calculate your loan balance. Disregard property taxes and mortgage insurance.
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home....
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home. The bank charges 5.5% annual interest compounded monthly. You are going to pay off this loan by fixed installments (fixed total payment) to be made at the end of each month for thirty years. How much is each installment payment? How much is the total principal repayment after four months? How much is the total interest payment after four months. Draw an amortization table...
You need a 30-year, fixed-rate mortgage to buy a new home for $450,000. Your mortgage bank...
You need a 30-year, fixed-rate mortgage to buy a new home for $450,000. Your mortgage bank will lend you the money at a 6 percent APR for this loan. However, you can afford monthly payments of only $2,000, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single lump sum payment. How large is this lump sum payment?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT