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

Other questions on the subject: Business

Business, 21.06.2019 21:30, Officaljazz18

Dr. dow jones wants to know whether a problem-based approach to teaching economics will result in higher academic performance than his traditional method. of the six sections of economics 101 at his university, dr. jones randomly assigns three sections to the traditional method and three sections to the problem-based method for unit 1 of the course. then all sections switch the instructional method for unit 2. he plans to compare the performance of the two groups of sections on their unit 1 and unit 2 exams. this study employs a design.

Answers: 3

continue

Business, 22.06.2019 03:00, dimpleschris101

50 points mark brainliest 1) the information in the interactive presentation suggests that people a) utilize the perception of others rather that out own perception b) learn more about the positive aspects of perception c) should monitor how perceptual barriers influence our relationship d) spend more times on our personal relationships rather than our professional relationships 2) you are about to take the dog out for a walk but pause to watch the news because you hear the name of your town being mentioned hearing your town being mentioned on the news is an example of a) stimulation b) interaction c) organization d) interpretation- evaluation 3) tamara thinks ivan is upset with her because hes been unusually quiet today to better interpret the situation and communicate appropriately tamara should a) ask ivan why hes quiet and explain that hes being inconsiderate b) leave ivan alone because hes obviously going through something c) ask her guidance counselor for tips on providing therapy to a friend d) examine her own perception and then check in with ivan about his behavior 4) of the following abilities which is the most important to the perceptual checking process a) critical thinking ability b) creative ability c) memorizing ability d) organizational ability

Answers: 2

continue

Business, 22.06.2019 12:50, tayjohn9774

Kendrick is leaving his current position at a company, and charlize is taking over. kendrick set up his powerpoint for easy access for himself. charlize needs to work in the program that is easy for her to use. charlize should reset advanced options

Answers: 3

continue

Business, 22.06.2019 17:10, mikailah0988

At the end of the current year, accounts receivable has a balance of $550,000; allowance for doubtful accounts has a credit balance of $5,500; and sales for the year total $2,500,000. an analysis of receivables estimates uncollectible receivables as $25,000. determine the net realizable value of accounts receivable after adjustment. (hint: determine the amount of the adjusting entry for bad debt expense and the adjusted balance of allowance of doubtful accounts.)

Answers: 3

continue

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% (...