Your success in business thus far has put you in a position to purchase a home...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your success in business thus far has put you in a position to purchase a home for $500,000 located close to the university you attend. You plan to pay a 20% down payment of $100,000 and borrow the remaining $400,000. You need to decide on a mortgage, and realize you can apply the skills you acquired in the last several chapters to evaluate your choices. To find the available options, go to www. bankrate.com. Select "Mortgages," then "Mortgage Rates." For location, choose the nearest large city; for mortgage type, choose purchase (not refinance). Consider 30-ycar fixed rate mortgages with 20% down, and assume your credit score is the highest possible. Consider all the options by selecting loans with "All points." Update rates and sort by "Rate" to find the loan with the lowest rate (not APR). Record the rate, points, fees, "APR," and monthly payment for this loan. Next consider only loans with "0 points" and find the loan with the lowest fees. Again, record the rate, points, fees, "APR." and monthly payment for this loan. First, use the annuity formula or PMT function in Excel to verify the monthly payment for each loan. (Note that to convert the "Rate" to a monthly interest rate you must divide by 12. Your result may differ slightly due to rounding.) Next, calculate the actual amount you will receive from cach loan after both fees and points. (Note that fees are a fixed dollar amount; points are also paid up front and are calculated as a % of the loan amount.) Using this net amount as the amount you will receive (rather than $400,000). show that the quoted "APR" of the loan is the effective IRR of the loan once all fees are included (you may use the Rate function in Excel, or calculate the NPV ar the quoted "APR"). Compare the loans, assuming you will keep them for 30 years, as follows: 1. Compute the incremental cash flows of the lower rate loan; that is, determine how much more have will in fees, and how much you will save on your monthly payment. you 2. What is the payback period of the lower rate loan? That is, how many years of lower monthly payments will it take to save an amount equal to the higher fees? 3. What is the IRR associated with paying the higher fees for the lower rate loan? (Again, the RATE function can be used.) 4. Plot the NPV profile of the decision to pay points for the lower rate loan. Do the NPV rule and the IRR rule coincide? раy Next, compare the loans assuming you expect to keep them for only 5 years: 5. Compute the final payment you will need to make to pay off each loan at the end of 5 (Hint: the FV function in Excel can be used). Which loan will be more expensive to repay? 6. Including the incremental cost to repay the loan after 5 years, what is the IRR and NPV profile associated with paying points now? Create a data table showing the NPV of paying points for different horizons (1 to 30 years) and different discount rates (0% to the IRR in (3) above). What can you conclude about whether it is a good idea to pay points? Suppose the bank gives you the option to increase either loan amount so that for either loan, you receive $400,000 today after all fees and points are paid. How would this affect your decision to pay points? Note: Updates to this data case may be found at www.berkdemarzo.com. years i will Your success in business thus far has put you in a position to purchase a home for $500,000 located close to the university you attend. You plan to pay a 20% down payment of $100,000 and borrow the remaining $400,000. You need to decide on a mortgage, and realize you can apply the skills you acquired in the last several chapters to evaluate your choices. To find the available options, go to www. bankrate.com. Select "Mortgages," then "Mortgage Rates." For location, choose the nearest large city; for mortgage type, choose purchase (not refinance). Consider 30-ycar fixed rate mortgages with 20% down, and assume your credit score is the highest possible. Consider all the options by selecting loans with "All points." Update rates and sort by "Rate" to find the loan with the lowest rate (not APR). Record the rate, points, fees, "APR," and monthly payment for this loan. Next consider only loans with "0 points" and find the loan with the lowest fees. Again, record the rate, points, fees, "APR." and monthly payment for this loan. First, use the annuity formula or PMT function in Excel to verify the monthly payment for each loan. (Note that to convert the "Rate" to a monthly interest rate you must divide by 12. Your result may differ slightly due to rounding.) Next, calculate the actual amount you will receive from cach loan after both fees and points. (Note that fees are a fixed dollar amount; points are also paid up front and are calculated as a % of the loan amount.) Using this net amount as the amount you will receive (rather than $400,000). show that the quoted "APR" of the loan is the effective IRR of the loan once all fees are included (you may use the Rate function in Excel, or calculate the NPV ar the quoted "APR"). Compare the loans, assuming you will keep them for 30 years, as follows: 1. Compute the incremental cash flows of the lower rate loan; that is, determine how much more have will in fees, and how much you will save on your monthly payment. you 2. What is the payback period of the lower rate loan? That is, how many years of lower monthly payments will it take to save an amount equal to the higher fees? 3. What is the IRR associated with paying the higher fees for the lower rate loan? (Again, the RATE function can be used.) 4. Plot the NPV profile of the decision to pay points for the lower rate loan. Do the NPV rule and the IRR rule coincide? раy Next, compare the loans assuming you expect to keep them for only 5 years: 5. Compute the final payment you will need to make to pay off each loan at the end of 5 (Hint: the FV function in Excel can be used). Which loan will be more expensive to repay? 6. Including the incremental cost to repay the loan after 5 years, what is the IRR and NPV profile associated with paying points now? Create a data table showing the NPV of paying points for different horizons (1 to 30 years) and different discount rates (0% to the IRR in (3) above). What can you conclude about whether it is a good idea to pay points? Suppose the bank gives you the option to increase either loan amount so that for either loan, you receive $400,000 today after all fees and points are paid. How would this affect your decision to pay points? Note: Updates to this data case may be found at www.berkdemarzo.com. years i will
Expert Answer:
Answer rating: 100% (QA)
4 Down payment 50000 Borrowed amount 200000 1 for 30 years mortgage loan Rate 3750 APR 3774 monthly payment 92800 Fees 4488 5 For 51 ARM Rate 3125 APR 3648 Fees 4937 Monthly payment Year 15 85676 Year ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Portland College is planning to purchase a home for its president in downtown Albuquerque. One property, with a selling price of $780,000, has been found, and the college treasurer is debating on the...
-
(1) Show the DMA steps of sending emoticons (2KB) in KakaoTalk and the process state in each step. Describe the steps in detail. Assume that network device is accessed via memory-mapped I/O, and DMA...
-
Go to http://www.bestbuy.com. Find a product with a rebate or instant savings. Calculate the percent markdown after rebate. Discussion Questions 1. What are the pros and cons of rebates from the...
-
Palmer Cheese Company is a small manufacturer of several different cheese products. One product is a cheese spread sold to retail outlets. Susan Palmer must decide how many cases of cheese spread to...
-
Determine the required thickness t of the tube if its outside diameter d is 200 mm and the desired factor of safety with respect to Euler buckling is n = 3.0. (Assume E = 72 GPa.)
-
At the end of 2019, Sapporo Group tests a machine for impairment. The machine is carried at depreciated historical cost, and its carrying amount is ¥150,000. It has an estimated remaining useful...
-
Define outsourcing and offshoring. Compare and contrast the two as HR administrative tools. Give examples of the decision factors to consider when choosing one over the other.
-
On January 4, 2013, Runyan Bakery paid $324 million for 10 million shares of Lavery Labeling Company common stock . The investment represents a 30% interest in the net assets of Lavery and gave...
-
Provide References In September of 2015, the EPA issued Volkswagen ( OTCPK:VLKAY ) a notice of violation of the Clean Air Act of 1963. The EPA accused the Volkswagen Group of intentionally...
-
Susan Jones would like her investment portfolio to be selected from a combination of three stocks Alpha, Beta, and Gamma. Let variables A, B, and G denote the percentages of the portfolio devoted to...
-
Kash Klothing Inc. is a high-end global clothing company. They are using secondary data to locate areas with high market potential for their line of designer clothes. They need areas with average...
-
What role does estate planning play in comprehensive personal financial management, and what advanced strategies can individuals employ to minimize estate taxes and ensure the smooth transfer of...
-
Why do some people like Mundell want to go back to the gold standard? Would this be possible/wise/feasible?
-
What is the simple interest and compound interest in the UCLA student loans? Explain
-
Describe two specific actions that you could use to advocate for a "culture of safety"
-
Consider the following statement: For each integer a, if a = 3 (mod 8), then a = 1 (mod 4). (1) Demonstrate that the result is true for a = 3, a = 11 and a = -5. (2) Prove the statement. Proof. Let a...
-
Question 7 How do consumers learn? Using examples, explain how brand managers can use theories of learning and memory to build strong brands. Question 8 Pick a product or brand you are knowledgeable...
-
Distinguish among total-moisture content, free-moisture content, equilibrium-moisture content, unbound moisture, and bound moisture.
-
Silence is Golden is a division of Tranquility, Inc. The division produces relaxation tapes and is considered a prot center. The following budgeted and actual information is available for August...
-
On June 30, 2009, Newsom Company sold equipment for $7,250 that had been acquired for $14,500 on January 1, 2007. Newsom originally estimated that the computer would have a ve-year useful life and a...
-
Why is a rms income from continuing operations of interest to decision makers?
-
The pendulum on a grandfather clock has a period of 2.00 s. If the clock is not wound, the pendulums amplitude begins to decay at a rate of 0.53% each pendulum period. a. What is the time constant of...
-
The motion of a nightingales wingtips can be modeled as simple harmonic motion. In one study, the tips of a birds wings were found to move up and down with an amplitude of 8.8 cm and a period of 0.82...
-
A block with a mass of 0.28 kg is attached to a horizontal spring. The block is pulled back from its equilibrium position until the spring exerts a force of 1.0 N on the block. When the block is...
Study smarter with the SolutionInn App