Question

Please use engineering economy relations. no excel. Problem 3: A family decided to buy a super ski and water sports boat. They took out an $80,000,5-year, 6% per year, compounde

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution

Given:

Details of current loan:

Principal = $80,000 ; Time = 5 year ; Interest = 6% p.a,compounded monthly => monthly rate = 0.5%

=> Effective interest rate / effective annual interest rate = [ { [( 0.5 / 100) + 1] ^ (12)} - 1] * (100)

=> 6.16% p.a

It is calculated as : monthly installment = P * r * [ (1+r) ^ n) /(((1+r) ^ n) - 1) ]

where r = annual interest rate / 12 / 100

= 80,000 * (0.00513) * (1.00513 ^ 60) / ((1.00513 ^ 60) - 1)

= 80,000 * (0.00513) * (1.359 / 0.359)

= $1553.575 ~ $1553.57 per month

(b) principal due after 2 months :

principal per month = 80,000 / 60 i.e., $1333.33

So, principal due after 2 months is : 80,000 - ( $1333.33 * 2) => $ 77,333.34

(c) Interest already paid in 1 st 2 installements = (1553.57 - 1333.33) * 2 => $440.48

(d) From month 3 onwards the new monthly installment for new loan repayment is :

Principal = $77,333.34 ; Time = 5 year ; Interest = 4.2% p.a,compounded monthly => monthly rate = 0.35%

=> Effective interest rate / effective annual interest rate = [ { [( 0.35 / 100) + 1] ^ (12)} - 1] * (100)

=> 4.28% p.a

It is calculated as : monthly installment = P * r * [ (1+r) ^ n) /(((1+r) ^ n) - 1) ]

where r = annual interest rate / 12 / 100

= 77333.34 * (0.00356) * (1.00356 ^ 58) / ((1.00356 ^ 58) - 1)

= 77333.34 * (0.00356) * (1.228 / 0.228)

= $1482.79  per month

Add a comment
Know the answer?
Add Answer to:
Please use engineering economy relations. no excel. Problem 3: A family decided to buy a super...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Good evening, everyone , may someone answer this engineering economics question on excel spreadsheet? Some years...

    Good evening, everyone , may someone answer this engineering economics question on excel spreadsheet? Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5-year, 6% per year, compounded monthly loan with 60 monthly payments of $386.66 each. She is examining her loan situation and would like to have some specific information. Help her obtain the following: a) ) Verification of the current monthly payment amount. b)...

  • Your boss, who never took an engineering economy course, is buying a new house and needs...

    Your boss, who never took an engineering economy course, is buying a new house and needs your help in answering some questions. The loan amount will be in the ‘‘jumbo loan’’ category of $600,000 at (1) 6% per year compounded monthly over 30 years, or (2) 5.625% compounded monthly over 15 years. There are no loan initiation fees, points paid, or other charges. Prepayment, if desired, can be done without penalty. a) What is the monthly payment for plan (1)?...

  • Lease or Buy Wolfson Corporation has decided to purchase a new machine that costs $4.2 million....

    Lease or Buy Wolfson Corporation has decided to purchase a new machine that costs $4.2 million. The machine will be depreciated on a straight-line basis and will be worthless after four years. The corporate tax rate is 35 percent. The Sur Bank has offered Wolfson a four-year loan for $4.2 million. The repayment schedule is four yearly principal repayments of $1.05.million and an interest charge of 9 percent on the outstanding balance of the loan at the beginning of each...

  • please no excel use formuls only 4. Tim got a new car with a loan of...

    please no excel use formuls only 4. Tim got a new car with a loan of $23,000 at 6% per year compounded monthly. There are 35 payments. If each payment is larger than the previous one by $17.00. What would be the size of first and last payment?

  • Can you please solve this and show the steps Im using a financial calculator, so please...

    Can you please solve this and show the steps Im using a financial calculator, so please list the inputs. 2. Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-year mortgage for $30,000 at a 3% annual interest rate. Their bank, the First Amityville National Bank, has recently offered the Spirits two alternatives by which they could prepay their mortgage. The Spirits have just made their 20th annual payment. [A] Under the first alternative, the...

  • 23. a. A couple estimates that they will need to buy a new car in 4 years. They estimate that the...

    23. a. A couple estimates that they will need to buy a new car in 4 years. They estimate that the car will cost $20,000. They decide to set up a sinking fund by making equal monthly payments into an account paying an annual rate of 5.5% compounded monthly. What is the amount of each payment? a. $321.99 b. $340.85 c. $365.25 d. $373.46 b. Consider a car loan amount of $8,000 for a term of 3 years at 12%...

  • Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down...

    Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5 years, 6% per year, compounded monthly loan with 60 monthly payments of $3866.66 each. She is examining her loan situation and would like to have some specific information. Help her obtain the following: (a) Verification of the current monthly payment amount. (b) Total amount she will pay over 5 years. (c) Total interest she will pay...

  • should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...

    should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...

  • please no excel only formulas 4. Tim got a new car with a loan of $23,000...

    please no excel only formulas 4. Tim got a new car with a loan of $23,000 at 6% per year compounded monthly. There are 35 payments. If each payment is larger than the previous one by $17.00. What would be the size of first and last payment?

  • 4 Balloons You are an important local real estate investor; you just got a $10,000,000 balloon...

    4 Balloons You are an important local real estate investor; you just got a $10,000,000 balloon loan to buy a new office building in your home town. The nominal maturity of the loan is 30 years, but the loan has a 10-year balloon payment. In other words, the loan will end at the end of the 10th year, and the outstanding balance will be paid off in a lump sum at that time. The interest on the loan is 6.7%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT