Please make sure answer is correct. 5. Celtic Pride Corp. borrowed $120,000 from its bank and...
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 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. 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. 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 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 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 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 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 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 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...