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,330,000; rents are estimated at $170,240 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 2 percent per year and is expected to be owned for five years and then sold.

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,330,000; rents are estimated at $170,240 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 2 percent per year and is expected to be owned for five years and then sold.

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? 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…
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 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…
Prepare a project charter for the Fixer Upper Project. Assume the project will take six months to complete and cost about $350,000 (or agreed upon price), that you estimate you will spend $40,000 for renovations. The first three months of the project will involve finding and closing on the property, and the last three months will involve fixing up the property, finding renters (preferably two renters), and preparing financial information for you and your aunt. Assume the project starts on October 1 and finishes on April 1. Recall that the main project objectives are to find and renovate a house that your Aunt Julie would own but you would live in and be able to rent out one to three rooms. Julie has also agreed that she will let you earn equity on the house. As she has said to you a few times, "Pretend I'm your banker, and it's your home." You will do all of the renovation planning work, including creating detailed cost estimates for all of the renovations, preparing a detailed…
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…
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…
ABC Residential Investors, LLP, is considering the purchase of a 120 unit apartment complex in steel city, Pennsylvania. A market study of the area reveals that an average rental of $600 per month unit could be realized in the appropriate market area. During the last six months, two very comparable apartment complexes sold in the same market area. The oaks, 140 unit project, sold for $9 million. its rental schedule indicates that the average rent per unit is $550 per month. Palms, a 90 unit complex, Is presently renting units at $650 per month, and its selling price with $6.6 million the mix of number of bedrooms and sizes of units for both complexes is very similar to the subject property in both appear to have normal vacancy rates about 10% annually. All rents are net so tenants pay all utilities and expenses. a. Based on the data provided here, how would an appraiser establish an estimate of value? b. What other information would be desirable in reaching a conclusion about the…
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?