Business, 10.06.2020 16:57 lucycbrumby3150

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a 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 out-of-pocket costs must be paid in full at the time of refinancing.
Build a spreadsheet model to evaluate this offer. The Excel function:
=PMT(rate, nper, pv, fv, type)
alculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are as follows:
rate = the interest rate for the loan
nper = the total number of payments
pv= present value - - the amount borrowed
fv = future value - - the desired cash balance after the last payment (usually 0)
type = payment type (0 = end of period, 1 = beginning of the period)
For example, for Dave and Jana's original loan there will be 180 payments (12*15 = 180), so we would use =PMT( .0549/12, 180, 230415,0,0) = $1881.46. Note that since payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment calculations, we assume that the payment is made at the end of the month.
Assume that Dave and Jana have accepted the refinance offer, and that there is no pre-payment penalty, so that anything above the beyond the required payment is applied to the principal. Construct a spreadsheet model in Excel so that you may use Goal Seek to determine the monthly payment that will allow Dave and Jana to pay off the loan in 12 years. Do the same for 10 and 11 years. Which option for prepayment if any, would you choose and why?
(Hint: Break each monthly payment up into interest and principal [the amount that gets deducted from the balance owed] Recall that the monthly interest that is charged is just the monthly loan rate multiplied by the remaining loan balance.)
If required, round your answers to two decimal places.
Pay off loan in years Additional Payment
10 Years $
11 Years $
12 Years $
Which option for prepayment if any, would you choose and why?

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 05:40

Grant, inc., acquired 30% of south co.’s voting stock for $200,000 on january 2, year 1, and did not elect the fair value option. the price equaled the carrying amount and the fair value of the interest purchased in south’s net assets. grant’s 30% interest in south gave grant the ability to exercise significant influence over south’s operating and financial policies. during year 1, south earned $80,000 and paid dividends of $50,000. south reported earnings of $100,000 for the 6 months ended june 30, year 2, and $200,000 for the year ended december 31, year 2. on july 1, year 2, grant sold half of its stock in south for $150,000 cash. south paid dividends of $60,000 on october 1, year 2. before income taxes, what amount should grant include in its year 1 income statement as a result of the investment?

Answers: 1

Answer

Business, 22.06.2019 07:30

What is the relationship between the national response framework and the national incident management system (nims)? a. the national response framework replaces the nims, which is now obsolete. b. the response protocols and structures described in the national response framework align with the nims, and all nims components support response. c. the nims relates to local, state, and territorial operations, whereas the nrf relates strictly to federal operations. d. the nims and the national response framework cover different aspects of incident managementâ€”the nims is focused on tactical planning, and the national response framework is focused on coordination.

Answers: 3

Answer

Business, 22.06.2019 10:50

You are evaluating two different silicon wafer milling machines. the techron i costs $285,000, has a three-year life, and has pretax operating costs of $78,000 per year. the techron ii costs $495,000, has a five-year life, and has pretax operating costs of $45,000 per year. for both milling machines, use straight-line depreciation to zero over the project’s life and assume a salvage value of $55,000. if your tax rate is 24 percent and your discount rate is 11 percent, compute the eac for both machines.

Answers: 3

Answer

Business, 22.06.2019 23:20

Nnette henri is paid an hourly wage of $8.90 for a 32-hour workweek of 4 days, 8 hours daily. for any work on the fifth day and on saturdays, she is paid one and one-half times her regular hourly rate. during a certain week, in addition to her regular 32 hours, henri worked 6 hours on the fifth day and 5 hours on saturday. for this workweek, henri’s total earnings are:

Answers: 1

Answer

You know the right answer?

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a fixed rate of 5.49% (...

Questions