Question

In: Finance

You purchase a boat for $35,000 and pay $5,000 down. You also agree to pay the...

You purchase a boat for $35,000 and pay $5,000 down. You also agree to pay the rest over the next 10 years in 10 equal end of the year payments plus 13 percent compound interest on the unpaid balance.

What will be the amount of each payment?

-monthly rate?

-number of payments?

-down payment?

-total loan amount?

Please show work in excel

Solutions

Expert Solution

The answers can be calculated using PMT formula in excel or using the formula of Equated Annual Installment-

Loan Amount	$ 30000
Loan Term (Years)	10
Payments Per Year	1
Rate of Interest	13.00%

USING PMT FORMULA

Annual Installment

$ 5528.69

=PMT(F9/F8, F7*F8, -F6)

USING EQUATED ANNUAL INSTALLMENT FORMULA

P = (r * A ) / ( 1 - (1+r)^-n)

=(13%*30000)/(1-(1+13%)^^-10)

= $ 5528.69

Q 1 What will be the amount of each payment?

Answer: $ 5,528.69

Q 2 monthly rate?

Answer: The annual interest compounded annually is 13%. So, the monthly interest rate can be 1.0833%

Q 3 number of payments?

Answer: 10 payments at every year-end

Q 4 down payment?

Answer: $ 5,000

Q 5 total loan amount?

Answer: $ 30,000

Note: The above calculation was done in excel but since the file can't be uploaded here the values along with formulas have been posted here.

jeff jeffy answered 1 week ago

Next > < Previous

Related Solutions

Original price of the car: 18,935 You pay 5,000 down

Original price of the car: 18,935You pay 5,000 downInterest rate 4%What is your monthly payment for the next 48 months?

You are considering the purchase of an investment that would pay you $5,000 per year for...

You are considering the purchase of an investment that would pay you $5,000 per year for Years 1‑5, $3,000 per year for Years 6‑8, and $2,000 per year for Years 9 and 10. If you require a 9.5 percent rate of return, and the cash flows occur at the end of each year, then what is the MOST you would be willing to pay for this investment? Answer to 0 decimal places.

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)

You wish to buy a speed boat that costs $45,000. You will put down 10% down...

You wish to buy a speed boat that costs $45,000. You will put down 10% down payment and finance the remaining cost of the boat with a 6-year fully amortized loan at an annual rate of 12%. If you want to make equal quarterly payments with the first payment three months from now, how much will your quarterly payment be? View keyboard shortcuts

1. You purchase a $350,000 town home and you pay 25% down. You obtain a 30...

1. You purchase a $350,000 town home and you pay 25% down. You obtain a 30 year fixed rate mortgage with an annual interest rate of 6.25%. After 5 years you refinance the mortgage for 25 years at a 5% annual interest rate. After you refinance what is the new monthly payment? 2. You plan to purchase a $175,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 7.75%. You will make...

You purchase a $225,000 town home and you pay 20% down. You obtain a 30 year...

You purchase a $225,000 town home and you pay 20% down. You obtain a 30 year fixed rate mortgage with an annual interest rate of 3.75%. After 20 years you refinance the mortgage for 10 years at a 3.25% annual interest rate. After you refinance what is the new monthly payment to the nearest dollar? 1.) 797 2.)814 3.) 932 4.)1,335 5.) 1,500

PLEASE SHOW IN EXCEL You purchase a $325,000 town home and you pay 25 percent down....

PLEASE SHOW IN EXCEL You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 5.75 percent and monthly payments. After five years you refinance the mortgage for 25 years at a 5.1 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

Suppose you purchase a new car today for $25,000. You pay $2,000 as down payment towards...

Suppose you purchase a new car today for $25,000. You pay $2,000 as down payment towards this purchase, and finance the balance over 5 years at an annual interest rate of 5%, the first payment to be made in one month. Payments are made every month over the next 5 years. Calculate the monthly payment using both formula and function method. (Hint: need to multiply time by 12 to find the number of months and need to divide interest rate...

You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year...

You purchase a $325,000 town home and you pay 25 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 5.75 percent and monthly payments. After five years you refinance the mortgage for 25 years at a 5.1 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

You purchase a $450,000 town home and you pay 20 percent down. You obtain a 30-year...

You purchase a $450,000 town home and you pay 20 percent down. You obtain a 30-year fixed-rate mortgage with an annual interest rate of 6.5 percent. After five years you refinance the mortgage for 25 years at a 5.75 percent annual interest rate. After you refinance, what is the new monthly payment (to the nearest dollar)?

Subjects