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?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Vishnu
The building management is planning to replace the central heating system with a modern plant, costing $1M (all expenses included). To secure the required grant, all 250 tenants are asked to pay additional monthly fees; the management is planning to invest the additional money in a credit union, paying 26% interest, compounded every three months. How much extra should each tenant pay per month so that the new system can be bought within 2.5 year?
Your firm is considering purchasing an old office building with an estimated remaining service life of 25 years. Recently, the tenants signed a long-term lease, which leads you to believe that the current rental income of $250,000 per year will remain constant for the first five years. Then the rental income will increase by 10% for every five-year interval over the remaining life of the asset. That is, the annual rental income would be $275,000 for years 6 through 10, $302,500 for years 11 through 15, $332,750 for years 16 through 20, and $366,025 for years 21 through 25. You estimate that operating expenses, including income taxes, will be $85,000 for the first year and that they will increase by $5,000 each year thereafter. You also estimate that razing the building and selling the lot on which it stands will realize a net amount of $50,000 at the end of the 25-year period. If you had the opportunity to invest your money elsewhere and thereby earn interest at the rate of 12% per…
Help me fast.....I will give good rating....
Assume a broker has listed a grocery-anchored shopping center with 100,000 sf of total retail space for lease, at a price of $9 million at an advertised 7.0% cap rate in a suburban market approximately 30 miles northwest of Pittsburgh. a. Calculate the price in dollars per square feet (show your work). b. Calculate the net operating income (NOI) (show your work)? C. If you purchase this asset and hold it for five years, what is a reasonable exit cap rate you could obtain for the sale, assuming no major investment in the property while you own it, only routine maintenance (no roof replacement or mechanical upgrades)?
NEED ALL FIVE PARTS THIS SINGLE QUESTION. ....DON'T ATTEMPT IF YOU WILL NOT DO ALL PARTS
You are the financial manager of the firm LAB.inc which does research in the medical field, your company needs an estimate of a financing plan for a research project. The research project according to the evaluation of the experts will be spread over a period of 4 years. The annual funding required to conduct this research is $100,000 at the beginning of each year. The firm has set a term of 7 years to raise the necessary funds to finance this research, the nominal interest rate is 8% capitalized quarterly. 1. How much does the company need to save at the end of each month to fund this research in 7 years? 2. Draw the timeline for this financing plan by presenting all the relevant elements. If the firm wants to start financing the research project today t=0, by taking out a bank loan equal to the VA of all the financing needs of the research project (for the 4 years). 3. Calculate the amount of monthly payments that the firm must pay to repay this bank loan for a period of 5 years?
Based on what was reviewed in class, please submit a BOE analysis for the multi tenant retail center based on the information below. Please determine the Net Operating Income of this property. Also, what price would you pay for this property, if you wanted to achieve a 5% Cap Rate (Capitalization Rate)? NOTE: Common Area Maintenance (CAM) paid by tenants are $0.67 Per Square Foot, Per Month. Assume 5% Vacancy Rate. BOE Analysis - Assignment.png
can you show the formula in excel. Benford Inc. is planning to open a new sporting goods store in a suburban mall. Benford will lease the needed space in the mall. Equipment and fixtures for the store will cost $200,000 and be depreciated over a five-year period on a straight-line basis to $0. The new store will require Benford to increase its net working capital by $200,000 at time 0. First-year sales are expected to be $1 million and to increase at an annual rate of 8 percent over the expected 10-year life of the store. Operating expenses (including lease payments and excluding depreciation) are projected to$700,000 during the first year and increase at a 7 percent annual rate. The salvage value of the store’s equipment and fixtures is anticipated to be $10,000 at the end of 10 years. Benford’s marginal tax rate is 40 percent. a. Compute the net investment required for Benford. b. Compute the annual net cash flows for the 10-year projected life of the store. c. Compute the…
Zenith Investment Company is considering the purchase of an office property. It has done an extensive market analysis and has estimated that based on current market supply or demand relationships, rents, and its estimate of operating expenses, annual NOI will be as follows: Year NOI 1 $ 1,030,000 2 1,030,000 3 1,030,000 4 1,210,000 5 1,260,000 6 1,310,000 7 1,349,000 8 1,389,170 A market that is currently oversupplied is expected to result in cash flows remaining flat for the next three years at $1,030,000. During years 4, 5, and 6, market rents are expected to be higher. It is further expected that beginning in year 7 and every year thereafter, NOI will tend to reflect a stable, balanced market and should grow at 3 percent per year indefinitely. Zenith believes that investors should earn a 12 percent return (r) on an investment of this kind.Required: a. Assuming that the investment is expected to produce NOI in years 1 to 8 and is expected to be owned for…
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,430,000; rents are estimated at $183,040 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 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 capitalization rate? c. What is the investor's expected before-tax internal rate of return on equity invested (BTIRR)? d. What…
The market value of the property that you own is $15 million. The gross annual rental income for this property is $600,000. The tax rate is 28% . The set up costs (renovations ect) in order to use the building and land for your own business operations are $7,000,000. The annual revenue if you were to use the building forr your own business operations with low demand would be $5 million and have a 30% chance of occuring. The annual revenue if you were to use the building for your own business operations with medium demand would be $9 million and have a 40% chance of occuring. he annual revenue if you were to use the building for your own business operations with high demand would be $13 million. The variable costs (% of revenue) is 65 %. The fixed costs are $2.5 million. The costs of capital is 10% and the risk free rate is 3%. he initial cost for setting up the expansion of business can be fully depreciated over 10 years using the straight-line method. The value of land will be…