Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Related questions
Question
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.
SAVE
AI-Generated Solution
info
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
to generate a solution
Click the button to generate
a solution
a solution
Knowledge Booster
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…arrow_forwardYou 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…arrow_forwardYou 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…arrow_forward
- please step by step solution.arrow_forwardThis 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…arrow_forwardA 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%arrow_forward
- 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…arrow_forwardAn 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…arrow_forwardABC 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…arrow_forward
- 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%?arrow_forwardABC 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…arrow_forwardABC 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College