You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,290,000; rents are estimated at $165,120 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 7 percent interest for 30 years (total annual payments will be monthly payments x 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is the NPV using a 13 percent discount rate? e. What is the profitability index using a 13 percent discount rate?

You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,290,000; rents are estimated at $165,120 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 7 percent interest for 30 years (total annual payments will be monthly payments x 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is the NPV using a 13 percent discount rate? e. What is the profitability index using a 13 percent discount rate?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,290,000; rents are estimated at $165,120 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 7 percent interest for 30 years (total annual payments will be monthly payments × 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? Answer: 1.33 b. What is the terminal capitalization rate? c. What is the investor’s expected before-tax internal rate of return on equity invested…
You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,280,000; rents are estimated at $163,840 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 8 percent interest for 30 years (total annual payments will be monthly payments 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is…
You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,400,000; rents are estimated at $179,200 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 8 percent interest for 30 years (total annual payments will be monthly payments 12). The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What is…
You are an employee of University Consultants, Ltd., and have been given the following assignment. You are to present an investment analysis of a new small residential income-producing property for sale to a potential investor. The asking price for the property is $1,250,000; rents are estimated at $200,000 during the first year and are expected to grow at 3percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A 70 percent loan can be obtained at 11 percent interest for 30 years. The property is expected to appreciate in value at 3 percent per year and is expected to be owned for five years and then sold. a. What is the investor’s expected before-tax internal rate of return on equity invested (BTIRR)?b. What is the first-year debt coverage ratio?c. What is the terminal capitalization rate?d. What is the NPV using a 14 percent discount rate? What does this mean?
This is a single question. ...and I need all five parts.....Don't attempt if you will not solve all five parts You are an employee of University Consultants, Limited, and have been given the following assignment. You are to present an investment analysis of a small retail income-producing property for sale to a potential investor. The asking price for the property is $1,450,000; rents are estimated at $185,600 during the first year and are expected to grow at 2.5 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of rents. Operating expenses will be 35 percent of effective gross income. A fully amortizing 70 percent loan can be obtained at 6 percent interest for 30 years (total annual payments will be monthly payments × 12). The property is expected to appreciate in value at 4 percent per year and is expected to be owned for five years and then sold. Required: a. What is the first-year debt coverage ratio? b. What is the terminal…
You are an employee of University Consultants, Ltd and have been given the following information. You are to present an investment analysis of a new small income-producing property for sale to a potential inventor. The asking price for the property is $8.5 million. You determine that the building was worth $7.225 million and could be depreciated over 39 years (use 1/39 per year). NOls are estimated to be $901,375 for year 1, $900,681 for year 2, $899,962 for year 3, $943,700 for year 4, $961,855 for year 5 and expected to increase by 3.16% thereafter. A fully amortizing 70 percent loan can be obtained at 10 percent interest for 20 years (total annual payments will be monthly payments *12). The property is expected to be sold for $9,360,805 after 5 years. Capital gains from price appreciation will be taxed at 15 percent and depreciation recapture will be taxed at 25 percent. Your ordinary income will be taxed at 35 percent. Assume that there is no selling cost and equity discount rate…
You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $218,000. If you buy the property, you believe that you will have to spend (1) $10,800 on various acquisition-related expenses and (2) an average of $2,300 per month during the next 12 months for repair costs, and so on, in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $198,000 in financing at 4.25 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $248,000 at the end of one year. Furthermore, you will probably have to pay about $3,300 in fees and selling expenses in order to sell the property at that time. Required: a. If you wanted to earn a 20 percent returi compounded monthly, do you believe that this…
You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition-related expenses and (2) an average of $2,000 per monthduring the next 12 months for repair costs, etc., in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $180,000 in financing at 8 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $225,000 at the end of one year. Furthermore, you will probably have to pay about $3,000 in fees and selling expenses in order to sell the property at that time. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a good…
You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained the property from a borrower who defaulted on his loan. First Capital is offering the property for $200,000. If you buy the property, you believe that you will have to spend (1) $10,500 on various acquisition related expenses and (2) an average of $2,000 per month during the next 12 months for repair costs, and so on, in order to prepare it for sale. Because First Capital Bank would like to sell the property as soon as possible, it is willing to provide $180,000 in financing at 4.25 percent interest for 12 months payable monthly (interest only). Your market research indicates that after you repair the property, it may sell for about $225,000 at the end of one year. Furthermore, you will probably have to pay about $3,000 in fees and selling expenses in order to sell the property at that time. If you wanted to earn a 20 percent return compounded monthly, do you believe that this would be a…
Lou Lewis, the president of Lewisville Company has asked you to give him an analysis of the best use of a warehouse the company owns. The company has a 40% effective tax rate. a. Lewisville Company is currently leasing the warehouse to another company for $5,000 per month on a year-to-year basis. b. The warehouse's estimated sales value is $200,000. A commercial realtor believes that the price is likely to remain unchanged in the near future. The building originally cost $60,000 and is being depreciated at $1,500 annually. Its current net book value (NBV) is $7,500. 1. Show how you would handle the individual items in determining whether the company should continue to lease the space or convert it to a factory outlet. Use PV function in Excel, VDB function in Excel to calculate annual depreciation charges. Use NPV function to calculate depreciation tax savings. (complete questions is attached.) Thank you!!!
An investor is considering the acquisition of a "distressed property" which is on Northlake Bank's REO list. The property is available for $200,800 and the investor estimates that he can borrow $160,000 at 4.5 percent interest and that the property will require the following total expenditures during the next year: Inspection Title search Renovation Landscaping Loan interest Insurance Property taxes Selling expenses Required: a. The investor is wondering what such a property must sell for after one year in order to earn a 20 percent return (IRR) on equity. b. The lender is now concerned that if the property does not sell, investor may have to carry the property for one additional year. He believes that he could rent it (starting in year 2) and realize a net cash flow before debt service of $1,440 per month. However, he would have to make an additional $7,440 in interest payments on his loan during that time, and then sell. What would the price have to be at the end of year 2 in order…
Your company must obtain some laser measurement devices for the next six years and is considering leasing. You have been directed to perform an actual-dollar after-tax study of the leasing approach. The pertinent information for the study is as follows: Lease costs: First year, $80,000; second year, $60,000; third through sixth years, $50,000 per year. Assume that a six-year contract has been offered by the lessor that fixes these costs over the six-year period. Other costs (not covered under contract): $4,000 in year-zero dollars, and estimated to increase 10% each year. Effective income tax rate: 40%. Solve, a. Develop the actual-dollar ATCF for the leasing alternative. b. If the real MARR (ir) after taxes is 5% per year andthe annual inflation rate (f ) is 9.524% per year, what is the actual-dollar after-tax equivalent annual cost for the leasing alternative?