Hint(s) Check My W A few years back, Dave and Jana bought a new home. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hint(s) Check My W 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 30th 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 cos 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) calculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are: 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 (0.0549/12, 180, 230415, 0, 0) = $1,881.46. Note that because 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. The savings from refinancing occur over time, and therefore need to be discounted back to current dollars. The formula for converting K dollars saved t months from now to current dollars is: K (1+r)*-1 where r is the monthly inflation rate. Assume that r = 0.002 and that Dave and Jana make their payment at the end of each month. Use your model to calculate the savings in current dollars associated with the refinanced loan versus staying with the original loan. If required, round your answer to the nearest whole dollar amount. If your answer is negative use "minus sign". Hint(s) Check My W 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 30th 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 cos 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) calculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are: 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 (0.0549/12, 180, 230415, 0, 0) = $1,881.46. Note that because 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. The savings from refinancing occur over time, and therefore need to be discounted back to current dollars. The formula for converting K dollars saved t months from now to current dollars is: K (1+r)*-1 where r is the monthly inflation rate. Assume that r = 0.002 and that Dave and Jana make their payment at the end of each month. Use your model to calculate the savings in current dollars associated with the refinanced loan versus staying with the original loan. If required, round your answer to the nearest whole dollar amount. If your answer is negative use "minus sign".
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
1.think about the evolution of the food industry, What was it in the past, and what will it be in the future? How will the 4 p's of marketing evolve within the industry you selected? 2.What is one...
-
Replace the force system acting on the post by a resultant force, and specify where its line of action intersects the post AB measured from pointB. 0.5 m B. 500 N 250 N 0.2 m 30 300 N
-
A circular shaft having a diameter of 4 in. is subjected to a torque of 250 kip # in. If the material is elastic perfectly plastic, with Y = 16 ksi, determine the radius of the elastic core.
-
Dividends per Share Calculate the company's dividend paid per share of common stock. What was the dividend payout ratio? Use the following financial data for Brenner Instruments Sales revenue.. Cost...
-
A bank in California has 13 branches spread throughout northern California, each with its own minicomputer where its data are stored. Another bank has ten branches spread throughout California, with...
-
What is the purpose of "Actions on Decisions" (AOD) issued by the IRS? What is the purpose of "Actions on Decisions" (AOD) issued by the IRS? To provide general tax guidance To create legally binding...
-
Example 4. Find the particular solution for y" - 3y = 3t + 2.
-
Tesar Chemicals is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. The CEO believes the IRR is the best...
-
1 . On January 1 , 2 0 2 3 , Geoffrey purchased 2 2 5 0 shares of Ted Ltd . at $ 2 2 per share and 5 7 5 shares at $ 3 2 per share on February 5 , 2 0 2 3 . He sold 2 6 5 of these shares on July 2 0...
-
Read the article and pay attention to the charts and graphs. https://www.visualcapitalist.com/cp/how-americans-spend-their-money-2022/ What stands out to you? Do you think this is an accurate...
-
Alton Inc. is working at full production capacity producing 20,000 units of a unique product. Manufacturing costs per unit for the product are as follows: Direct materials Direct labor Manufacturing...
-
With proper citation, write based on opportunity cost, demand and supply, elasticity, cost minimization, and profit maximization why Walmart is seeing increased sales for tops, but not bottoms during...
-
You have collected data on monthly profits of a group of traders over time and you wish to model the evolution of trading profits and its dependence on traders characteristics, including gender,...
-
1. Using the information from Problem 16-4B, prepare a statement of cash flows for Lim Garden Supplies Inc. using the direct method of presenting cash flows from operating activities. 2. How does Lim...
-
Critic Ivor Smallbrain is watching the horror movie Salamanders on a Desert Island. In the film, there are 30 salamanders living on a desert island: 15 are red, 7 blue and 8 green. When two of a...
-
Find \(n\), given that both \(n\) and \(\sqrt{n-2}+\sqrt{n+2}\) are positive integers.
-
Environmental Business Consultants, LLC (EBC) has a contract with Terrabean Coffee, a large retail coffee company with 5,000 shops across North America, to manage the companys waste disposal and...
Study smarter with the SolutionInn App