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…
please step by step solution.
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…
A client has requested advice on a potential investment opportunity involving an income-producing property. She would like you to determine the internal rate of return of the investment opportunity based on the following information: expected holding period: years; end of first year NOI estimate: $113,900; NOI estimates in subsequent years will grow by 5 % per year; price at which the property is expected to be sold at the end of year 5: $1,615,205.22; current market price of the property: $1,475,667.71. A. 8.6% B. 9.86% C. 10% D -15.3%
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…
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…
The Business Manager of a Commercial Laboratory needs to determine the present value of a $170,000 investment received at the end of year 7. What is the present value of the investment if the discount rate is 6%?
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 $624 per month per unit could be realized in the appropriate market area. During the last six months, two very comparable apartment complexes have been sold in the same market area. The Oaks, a 140-unit project, sold for $9 million. Its rental schedule indicates that the average rent per unit is $598 per month. Palms, a 90-unit complex, is presently renting units at $698 per month, and its selling price was $6.6 million. The mix of number of bedrooms and sizes of units for both complexes is very similar to that of the subject property, and both appear to have normal vacancy rates of about 10 percent annually. All rents are net as tenants pay all utilities and expenses. Required: a. Based on the data provided here, how would an appraiser establish an estimate of value? (Round intermediate calculations and…
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 $614 per month per unit could be realized in the appropriate market area. During the last six months, two very comparable apartment complexes have been sold in the same market area. The Oaks, a 140-unit project, sold for $9 million. Its rental schedule indicates that the average rent per unit is $578 per month. Palms, a 90-unit complex, is presently renting units at $678 per month, and its selling price was $6.6 million. The mix of number of bedrooms and sizes of units for both complexes is very similar to that of the subject property, and both appear to have normal vacancy rates of about 10 percent annually. All rents are net as tenants pay all utilities and expenses. Based on the data provided here, how would an appraiser establish an estimate of value? (Round intermediate calculations and final answers…