EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN: 9781337514835
Author: MOYER
Publisher: CENGAGE LEARNING - CONSIGNMENT
expand_more
expand_more
format_list_bulleted
Related questions
Question
Scenario:
Suppose that your client, a real estate investor, has asked you to evaluate an anchored retail shopping center that is for sale for $3,595,000 in Clearwater, Florida. You have been asked to perform an analysis of the property, including an estimate of cash flows and
The shopping center has 33,250 square feet of rentable space. Since detailed information is not available on existing leases, assume that the property will lease at the average rent for the Tampa/St. Petersburg market. The average asking rent for Tampa is $12.90, and the average vacancy rate is 6.5%. Assume that rents will increase by 5% per year.
Annual expenses are as follows:
- Insurance: $12,312
- Utilities: $14,500
- Real Estate Taxes: $34,200
- Cleaning: $4,500
- Landscaping: $9,400
- Repairs & Maintenance: $16,500
- Miscellaneous: $6,000
These expenses will increase at the same rate as PGI. Financing is available up to 80% LTV with a 5-year interest-only mortgage at 7.5%, with financing costs of 2% of the loan amount. The current overall cap rate (OAR) for this type of property is 8.7%. Apply it to year 6 NOI to calculate the sales price at the end of year 5. Assume sales costs of 5%.
Assume that the building value equals 20% of the purchase price and can be
Essay Questions:
Using Excel, construct a five-year discounted cash flow
- What is the initial equity at "time 0"?
- What is the net sales price and after-tax equity reversion in year 5?
- What is the 1st year’s after-tax cash flow?
- What is the after-tax IRR for this investment?
- Would you recommend purchase of this property to your client?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 3 images
Knowledge Booster
Similar questions
- 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…arrow_forwardYou 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…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
- 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…arrow_forwardwhat is the sale price?arrow_forwardAssume that you are planning to buy a property producing natural resources. You think you will keep the property for the next 23 years. You plan to spend $700 per acre. You will have incurred costs of $11 per acre for the 23 years prior to selling the property. You believe that you will receive $26/acre/year in revenue during the investment period. What price (at time of the future sale) will you need to get for the property under 2 MAR scenarios. (using both 5.8% and 8% as MAR).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 purchase of a small office building. The NOI is expected to be the following: year 1, $200,000; year 2, $210,000; year 3, $220,000; year 4, $230,000; year 5, $240,000. The property will be sold at the end of year 5 and the investor believes that the property value should have appreciated at a rate of 3 percent per year during the five-year period. The investor plans to pay all cash for the property and wants to earn a 10 percent return on investment (IRR) compounded annually. a. What should be the property value (REV) at the end of year 5 in order for the investor to earn the 10% IRR? b. What should be the present value of the property today? c. Based on your answer in (b), if the building could be reproduced for $2,300,000 today, what would be the underlying value of the land? O $3,420,843; $2,950,850; $650,850 O $3,528,887; $2,590,850; $725.250 O $3,720.786; $2,476,180; $665.450arrow_forwardYou have been instructed to complete a market valuation on a single tenant commercial property located in Mt Wellington for mortgage security purposes. The bank has specifically requested that you value this property having regard to the two most common investment approaches - Direct Capitalisation and Discounted Cash Flow. Your client has advised you that the building has been leased today, to a national tenant for a nine-year term at a gross commencement income of $457,000 per annum plus GST paid yearly in advance, which in your opinion is above market rental levels. However, the tenant was given a rental incentive, equivalent to nine months' rent, as a cash payment on commencement, to go towards office fit out works. You have been provided with the following assumptions/ determinants: Valuation Date: DCF Period: Discount rate: Terminal yield: Today Five years 6.50% 8.00% Market Derived capitalisation rate: Current assessed net market rental: Building net lettable area: Unrecovered…arrow_forward
- Your boss asks you to review an option to lease an equipment storage facility that the firm needs. You are to compare it with the purchase of the facility. The following information are pertinent to your decision: - The facility will be needed for twelve years -If the facility is leased, the lessor will conduct all maintenance; if purchased, your firm must conduct maintenance - Facility maintenance is expected to cost $85000 per year - The cost to lease the facility is $800000 per year at the beginning of each year - The purchase price of the facility is $6000000 and the market value at the end of twelve years is expected to be $3000000 The before-tax cost of debt is 8%, and the tax rate is 30% - The company's current EBIT is $1800000 (before leasing or purchasing the facility). Assuming that the facility has a twelve-year depreciation life for tax purposes (i.e. it can be fully depreciated over twelve-years), compute the NPV for cach option and based on the cost, indicate your…arrow_forwardUse the following information to answer questions 1 to 5. A development corporation purchased land that will be the site of a new luxury condominium complex. Management is considering a six month market research study designed to learn more about potential market acceptance of the condominium project. Management anticipates that, if conducted, the market research study will provide one of the following two results. 1. Favorable report (F): A significant number of the individuals contacted express interest in purchasing a condominium. 2. Unfavorable report (U): Very few of the individuals contacted express interest in purchasing a condo- minium. After deciding whether to conduct the market research study, they have the following two decision alternatives. d1 = a small complex with 30 condominiumsd2 = a medium complex with 60 condominiumsFollowing this, a chance event concerning the demand for the condominiums has two states of nature. s1 = strong demand for the condominiumss2 = weak…arrow_forwardUse the following information to answer questions 1 to 5. A development corporation purchased land that will be the site of a new luxury condominium complex. Management is considering a six month market research study designed to learn more about potential market acceptance of the condominium project. Management anticipates that, if conducted, the market research study will provide one of the following two results. 1. Favorable report (F): A significant number of the individuals contacted express interest in purchasing a condominium. 2. Unfavorable report (U): Very few of the individuals contacted express interest in purchasing a condo- minium. After deciding whether to conduct the market research study, they have the following two decision alternatives. d1 = a small complex with 30 condominiumsd2 = a medium complex with 60 condominiumsFollowing this, a chance event concerning the demand for the condominiums has two states of nature. s1 = strong demand for the condominiumss2 = weak…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT