Question

In: Finance

Phil and Jill bought a fishing lodge for $750,000. They paid $75,000 down and agreed to...

Phil and Jill bought a fishing lodge for $750,000. They paid $75,000 down and agreed to make payments at the end of every month for fifteen years. Interest is 6% compounded quarterly.

a) What size payments are the Phil and Jill making every month.

  1. b) How much will they owe after ten years?

  2. c) How much will they have paid in total after 15 years?

  3. d) How much interest will they pay in total?

Solutions

Expert Solution

Loan = principal-down = 750000-75000=675000

EAR = [(1 +stated rate/no. of compounding periods) ^no. of compounding periods - 1]* 100
? = ((1+6/(4*100))^4-1)*100
Effective Annual Rate% = 6.1364
EAR = [(1 +stated rate/no. of compounding periods) ^no. of compounding periods - 1]* 100
6.1364 = ((1+Stated rate%/(12*100))^12-1)*100
Stated rate% = 5.9703

a

PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)]
C = Cash flow per period
i = interest rate
n = number of payments
675000= Cash Flow*((1-(1+ 5.9703/1200)^(-15*12))/(5.9703/1200))
Cash Flow = 5685.21

b

PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)]
C = Cash flow per period
i = interest rate
n = number of payments
PV= 5685.21*((1-(1+ 5.9703/1200)^(-10*12))/(5.9703/1200))
PV = 512775.1

c

total paid = CF*years*months per year = 5685.21*15*12=1023337.8

d

Interest =total paid-loan = 1023337.8-675000=348337.8


Related Solutions

Amby Dextrous bought a grand piano, make a down payment of $1500, and agreed to a...
Amby Dextrous bought a grand piano, make a down payment of $1500, and agreed to a series of monthly payments of $225 for 4 years starting the date of sale. The rate of interest is 13% compounded monthly. (a) Calculate the cash price                                                                                     ANSWER: __________________________ (b) How much of the total payments will be interest? ANSWER: __________________________
In December Beth bought a boat for $100,000 & payed $16,000 down & agreed to pay...
In December Beth bought a boat for $100,000 & payed $16,000 down & agreed to pay the balance In 5 equal annual installments that include both the principal & 9% interest on the declining balance. How big will the annual payments be? Beth bought the yacht for $100,000 & paid $16,000 down, how much doe she need to borrow for her purchase of the yacht? $__ (round to the nearest dollar)
John purchased a new house for $500,000. He paid 20 percent down and agreed to pay...
John purchased a new house for $500,000. He paid 20 percent down and agreed to pay the rest over the next 25 years in 25 equal annual payments at 6 percent compound interest. What will be his annual payments?
Today, we purchased a machine for $54,173. We paid $5,000 down and agreed to make six...
Today, we purchased a machine for $54,173. We paid $5,000 down and agreed to make six equal payments, including interest at a yearly rate of 12% compounded semiannually, every six months starting six months from now. How much should we pay every six months?
Tara bought a condo. She paid 22% down and is going to make payments for 20...
Tara bought a condo. She paid 22% down and is going to make payments for 20 years. She locked in the rate for five years. Which of the following statements is not true?      The interest rate cannot change for five years.     The way she has set this up, she will pay off the entire loan in 20 years.      The amortization period is five years.     The term is five years.
6) The Gomez Company Inc bought a machine for $175,000. They paid 20% down and amortized...
6) The Gomez Company Inc bought a machine for $175,000. They paid 20% down and amortized the rest at 11.2% over a 3-year period. a) Find their Quarterly payment. b) Using MS-Excel, prepare an amortization table to show how the payments are made and how interest and principal balance are determined c) How much will the company owe after 18 months? What is the amount of interest during their 5th payment?
On September 1, 2018, Susan Chao bought a motorcycle for $32,000. She paid $1,200 down and...
On September 1, 2018, Susan Chao bought a motorcycle for $32,000. She paid $1,200 down and financed the balance with a five-year loan at an annual percentage rate of 7.4 percent compounded monthly. She started the monthly payments exactly one month after the purchase (i.e., October 1, 2018). Two years later, at the end of October 2020, Susan got a new job and decided to pay off the loan.    If the bank charges her a 1 percent prepayment penalty...
On September 1, 2013, Susan Chao bought a motorcycle for $27,000. She paid $1,100 down and...
On September 1, 2013, Susan Chao bought a motorcycle for $27,000. She paid $1,100 down and financed the balance with a five-year loan at an APR of 6.9 percent, compounded monthly. She started the monthly payments exactly one month after the purchase (i.e., October 1, 2013). Two years later, at the end of October 2015, Susan got a new job and decided to pay off the loan.    If the bank charges her a 2 percent prepayment penalty based on...
On September 1, 2013, Susan Chao bought a motorcycle for $21,000. She paid $1,100 down and...
On September 1, 2013, Susan Chao bought a motorcycle for $21,000. She paid $1,100 down and financed the balance with a five-year loan at an APR of 6.3 percent, compounded monthly. She started the monthly payments exactly one month after the purchase (i.e., October 1, 2013). Two years later, at the end of October 2015, Susan got a new job and decided to pay off the loan. If the bank charges her a 2 percent prepayment penalty based on the...
You bought a new car today that cost you $40,000. You paid$2,000 DOWN and financed...
You bought a new car today that cost you $40,000. You paid $2,000 DOWN and financed the balance with a 4-year loan at a 2.99% annual promotional rate. How much is your monthly payment?N= I/Y= PV= PMT= FV=
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT