Question

5. Celtic Pride Corp. borrowed $120,000 from its bank and agreed to make monthly payments of principal and interest of7.8% over five years. What is the monthly payment required under the terms of the loan agreement? I/Y PV PMT FV MODE 0 0.0085 120,000 CPT Excel Formula-PNT 0.00C5, 6o,120000,p,o) Your Answer $2,421.70 E ND Please make sure answer is correct.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

DATE: Loan amount =圭12o, ooo am e 5 years To tind msnthly paymentPAGE NO.: DATE: 120,000 x-1-0:078 1 2 5x12) 0:07 アーーーー120,000 x 0.0865 t ( 12+0.078 C-6o) 2. 8o 子冠。 CO 5) 0065 780 Lo 1:006SDATE: 780 0:322 rourn 2422 ラ 4) 2422 Manthy-payment

Add a comment
Know the answer?
Add Answer to:
Please make sure answer is correct. 5. Celtic Pride Corp. borrowed $120,000 from its bank and...
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
  • Please make sure my answers are correct. 8. Ina Guarnaschelli wants to install a pool with...

    Please make sure my answers are correct. 8. Ina Guarnaschelli wants to install a pool with a changing cabana and an outdoor entertainment center at her home. A contractor estimated that the entire project would cost $85,000 to complete currently. Ina believes that she can save enough over five years so that she will only need to borrow 50% of the project's price. a. Ina expects the cost of the project to increase by 2.5% per year over the five...

  • A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an...

    A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87. Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The...

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • 1) You wish to borrow $150,000 from a lending institution for the purchase of a house....

    1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...

  • eBook A few years back, Dave and Jana bought a new home. They borrowed $230,415 at...

    eBook A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their 25th payment, and the current balance on the loan is $208,555.87, Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a n of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing Build...

  • Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments...

    Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments of principal. These were to be made annually with the first payment due exactly one year after she received the $24,000. Ms. Ho also had to make annual payments of interest to the loan holder at an annual effective rate of 8.5%. Immediately after the loan is made, Brady Investment Corporation purchases the right to receive all of Ms. Ho's payments from Stewart Financial...

  • Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments...

    Marilyn Ho borrowed $24,000 from Steward Financial Enterprises. She was required to make sixteen equal payments of principal. These were to be made annually with the first payment due exactly one year after she received the $24,000. Ms. Ho also had to make annual payments of interest to the loan holder at an annual effective rate of 8.5%. Immediately after the loan is made, Brady Investment Corporation purchases the right to receive all of Ms. Ho's payments from Stewart Financial...

  • 5. Bank loans Short-term financing through bank loans Consider this case: Central Corp. needs to take...

    5. Bank loans Short-term financing through bank loans Consider this case: Central Corp. needs to take out a one-year bank loan of $500,000 and has been offered loan terms by two different banks. One bank has offered a simple interest loan of 9% that requires monthly payments. The loan principal will be paid back at the end of the year. Another bank has offered 6% add-on interest to be repaid in 12 equal monthly installments. Based on a 360-day year,...

  • a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer...

    a.   Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...

  • I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...

    I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...

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
ADVERTISEMENT