4. Consider a $500,000, 7.5%, 25-year amortization mortgage with monthly payments. Determine the effective borrowing cost...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. Consider a $500,000, 7.5%, 25-year amortization mortgage with monthly payments. Determine the effective borrowing cost (or lender's yield) of this loan under the following circumstances: (b) Two points (i.e. 2% in fees) upfront, fully amortizing (c) Two points in upfront fees and a 7-year maturity with balloon (full repayment after 7 years) Background So far in the course we have treated mortgage debt at a basic level. Questions 4 through 6 in this assignment start to move us beyond that and bring in important real world considerations - and try to get you to extend your thinking without a whole lot of guidance; not replicating examples from class but attempting new twists. Question 4 introduces the notion that true "effective cost" of a loan to a borrower (EBC), or true "effective yield" to the lender - same thing from the other perspective in the lender/borrower relationship - can differ from the stated mortgage rate that is used to determine monthly mortgage payments (PMT) and outstanding loan balance during the life of the loan. Lenders will often charge fees up front at loan origination (or disbursement). Hence, the true cost of the loan to the borrower is higher than the mortgage rate once we incorporate the upfront fees. These fees can be associated with origination and underwriting, but lenders can also use upfront charges strategically to increase the expected return (IRR) on a loan above the mortgage rate without changing the posted mortgage rate - this might be borrower specific due to risk. Lenders may allow also borrowers to "buydown" the mortgage rate in exchange for fees paid upfront - another situation where the contract interest rate by itself does not reflect the true "yield" or IRR to the lender. This is what parts (b) and (c) of question 4 are asking you to explore. Note that 1 point = 1% of the loan balance. For part (b) The lender expects to receive 300 monthly payments PMT based on a $500k loan However, the lender does not advance the full $500k, but only 98% of it; 2% is held back Monthly payments (PMT) are based on the full LOAN amount, not the 98% of it disbursed. . After computing the monthly PMT, use the "=rate()" function in Excel to determine the monthly IRR for the lender with the PMT calculated, nper-300 and PV=500k*(1-02); this is the effective cost or yield that you should convert to an annual figure. Alternatively, you can work with monthly cash flows in Excel and use the IRR() function. For part (c) Same idea but now the monthly PMTs go for 84 months not 300 and the OLB after 84 months becomes the FV in the effective cost calculation using =rate(). Remember that the PMT and FV have to have the same sign, positive or negative, in Excel functions. I 4. Consider a $500,000, 7.5%, 25-year amortization mortgage with monthly payments. Determine the effective borrowing cost (or lender's yield) of this loan under the following circumstances: (b) Two points (i.e. 2% in fees) upfront, fully amortizing (c) Two points in upfront fees and a 7-year maturity with balloon (full repayment after 7 years) Background So far in the course we have treated mortgage debt at a basic level. Questions 4 through 6 in this assignment start to move us beyond that and bring in important real world considerations - and try to get you to extend your thinking without a whole lot of guidance; not replicating examples from class but attempting new twists. Question 4 introduces the notion that true "effective cost" of a loan to a borrower (EBC), or true "effective yield" to the lender - same thing from the other perspective in the lender/borrower relationship - can differ from the stated mortgage rate that is used to determine monthly mortgage payments (PMT) and outstanding loan balance during the life of the loan. Lenders will often charge fees up front at loan origination (or disbursement). Hence, the true cost of the loan to the borrower is higher than the mortgage rate once we incorporate the upfront fees. These fees can be associated with origination and underwriting, but lenders can also use upfront charges strategically to increase the expected return (IRR) on a loan above the mortgage rate without changing the posted mortgage rate - this might be borrower specific due to risk. Lenders may allow also borrowers to "buydown" the mortgage rate in exchange for fees paid upfront - another situation where the contract interest rate by itself does not reflect the true "yield" or IRR to the lender. This is what parts (b) and (c) of question 4 are asking you to explore. Note that 1 point = 1% of the loan balance. For part (b) The lender expects to receive 300 monthly payments PMT based on a $500k loan However, the lender does not advance the full $500k, but only 98% of it; 2% is held back Monthly payments (PMT) are based on the full LOAN amount, not the 98% of it disbursed. . After computing the monthly PMT, use the "=rate()" function in Excel to determine the monthly IRR for the lender with the PMT calculated, nper-300 and PV=500k*(1-02); this is the effective cost or yield that you should convert to an annual figure. Alternatively, you can work with monthly cash flows in Excel and use the IRR() function. For part (c) Same idea but now the monthly PMTs go for 84 months not 300 and the OLB after 84 months becomes the FV in the effective cost calculation using =rate(). Remember that the PMT and FV have to have the same sign, positive or negative, in Excel functions. I
Expert Answer:
Answer rating: 100% (QA)
b Two points upfront fully amortizing Loan amount 500000 Points fees 2 of 50... View the full answer
Related Book For
Real Estate Principles A Value Approach
ISBN: 978-0077836368
5th edition
Authors: David C Ling, Wayne Archer
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
An LNC can detect alterations in the record by Select one: a. Examining notes written in the margin b. Looking through late entries for detailed explanations c. Finding a doctor's explanation that is...
-
A drained trixial test is performed on al sand with 3c = 3f = 450 kPa. At failure, t max = 594 kPa. Find 1f, (1 - 3)f, and .?
-
Flow of a film on the outside of a circular tube (see Fig. 2B.6), in a gas absorption experiment a viscous fluid flows upward through a small circular tube and then downward in laminar flow on the...
-
If you want to maintain a potential difference of \(6000 \mathrm{~V}\) between the plates of a parallel-plate capacitor, what is the minimum value of the plate separation if the space between the...
-
At the beginning of January 201X, the stockholders equity of Mountain View Corporation consisted of the following: 1. Record the transactions in general journal form. 2. Prepare the stockholders...
-
1. 120g of an organic compound that contains only carbon and hydrogen gives 330g of CO2 and 270g of water on complete combustion. The percentage of carbon and hydrogen, respectively are (a) 25 and 75...
-
It is known that devices on a network have an IP address of 10.16.150.190, specify : i. Default subnet mask ? ii. Default net ID ? iii. Default broadcast ID ? iv. Default Class for this IP address ? ...
-
What is the purpose of a report abstract? What kind of information does it include?
-
The rate of progress in technology is so rapid that it is very difficult to predict exactly how new technology will affect accounting in the future. Can you suggest any developments in technology...
-
Formal reports contain a number of features that help readers navigate: a table of contents, lists of figures and tables, executive summaries, informative headings, and appendices for supplementary...
-
What three things should you do when answering a question in a presentation?
-
You work for a painting company, and you received an RFP from the city that asks you to submit a competitive proposal to paint the interior of the City Hall. What research should you do before...
-
Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored opening new restaurants in...
-
A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i% per year for the 20 years. At the end of the 20-year period, the total interest in...
-
Data for five comparable income properties that sold recently are shown below: What is the indicated overall rate (R O )? Property NOI Sale Price Overall Rate $ 57,800 S 566,600 496,900 630,000...
-
If you never sold the property, what would be the present value of the annual tax savings from depreciation?
-
If you deposit $1 at the end of each of the next ten years and these deposits earn interest at 10 percent compounded annually, what will the series of deposits be worth at the end of the 10 th year?
-
A cooling tower cools \(227 \mathrm{~m}^{3} / \mathrm{h}\) of water from \(314 \mathrm{~K}\) to \(306 \mathrm{~K}\) using a countercurrent forced draft of air entering at \(317 \mathrm{~K}\) and...
-
A recently installed induced-draft cooling tower (with the fan located at the top) was guaranteed by the manufacturer to cool \(450 \mathrm{~m}^{3} / \mathrm{h}\) of water from \(316 \mathrm{~K}\) to...
-
Water is to be cooled at the rate of \(10 \mathrm{~kg} / \mathrm{s}\) from \(317 \mathrm{~K}\) to \(300 \mathrm{~K}\) in a countercurrent cooling tower under conditions such that \(H_{t O G}=2.5...
Study smarter with the SolutionInn App