Question

You are a real estate investor that has an interest in purchasing a multifamily property in Atlanta, Georgia. You received th
42. What is the before tax cash flow at the end of year 3? 43. What is the Levered IRR for this project? 44. Based upon your


D E F CASH FLOW ANALYSIS POTENTIAL RENTAL INCOME YEAR 1 YEAR 2 YEAR 3 397500409425 421707. 8 YEAR 4 YEAR 5 YEAR 6 434359 4473
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Potential Rental Income in Year 3 = $421,707.75

2) Year 4 Other Income is $1,273.45

3)  Year 6 Net Operating Income = $250,284.59

4) Projected Sales Price = Net Operating Income / Capitalisation Rate
= 250,284.59 / 7%
Projected Sales Price = $3,575,494.12

5) Cost of Sales = 6% * Sales Price = $214,529.65

6) Sales Proceeds before Taxes = Sales Price - Cost of Sales
= 3,575,494.12 - 214,529.65
  Sales Proceeds before Taxes = $3,360,964.47

O 2 6 F Year 4 5 Potential Rental Income 397,500.00 409,425.00 421,707.75 434,358.98 447,389.75 (-) Vacancy Loss (19,875.00)
G H Year 1 2 Potential Rental Income =B4 =E2*(1+$B$5) |=F2*(1+$B$5) =G2*(1+$B$5) =H2*(1+$B$5) =12*(1+$B$5) (-) Vacancy Loss =


answered by: ANURANJAN SARSAM
Add a comment
Know the answer?
Add Answer to:
You are a real estate investor that has an interest in purchasing a multifamily property in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 39. Brandon is considering selling a piece of residential real estate that he has owned for...

    39. Brandon is considering selling a piece of residential real estate that he has owned for 12 years. The apartment complex consists of 100 units with an average rental rate of $400 per month. Laundry and parking gross potential income is $20,000 per year. The vacancy rate is 7%, and operating expenses are 30% of potential gross income. Brandon takes $40,000 of depreciation each year, and his mortgage note costs $6,000 per month. Calculate the expected sales price of this...

  • 2. Determine the annual Net Operating Income (NOI) and the cash flow before taxes using the...

    2. Determine the annual Net Operating Income (NOI) and the cash flow before taxes using the assumptions and facts for the following real estate investment: a) 40 Units b) Rent per unit is $1,500 per month c) Vacancy and debt losses are 5% of gross potential income d) Operating Expenses are $426,000 per year e) Debt service is 106,000, which includes $90,000 in interest f) Depreciation expense is $46,000 per annum. 3. Using the information from question #2, determine the...

  • Name Real Estate Valuation Problems 1. If an investor has found a possible investment property with the net income...

    Name Real Estate Valuation Problems 1. If an investor has found a possible investment property with the net income after all operating expenses but before capital recapture from a small apartment house is estimated to be $48,000 per year: How much would an investor be willing to pay for the property if first mortgages are available for 75% the purchase price at 5.5% interest and the investor's equity capital investment requires a 15% return. The remaining life of the buildings...

  • A real-estate investor has the opportunity to purchase a small apartment complex.  The apartment complex costs $4...

    A real-estate investor has the opportunity to purchase a small apartment complex.  The apartment complex costs $4 million and is expected to generate net revenue (net after all operating and finance costs) of $60,000 per month.  Of course, the revenue could vary because the occupancy rate is uncertain.  Considering the uncertainty, the revenue could vary from a low of -$10,000 to a high of $100,000 per month.  Assume that the investor’s objective is to maximize the value of the investment at the end of...

  • Suppose an investor is considering a non-residential rental property that has an asking price of $400,000....

    Suppose an investor is considering a non-residential rental property that has an asking price of $400,000. The land is valued at $175,000. The property has four rental units that are expected to rent for $1.200 each per month for the next five years (PGI each year of $57,600). Vacancy and bad debt allowance is expected to be 5% of potential gross income Operating expenses are expected to be 16% of effective gross income. A mortgage loan is available for 80%...

  • Please fill out the rest Please fill out the property pro forma (last picture) Your investment...

    Please fill out the rest Please fill out the property pro forma (last picture) Your investment firm is considering acquiring a 76-unit, 43,548 rentable-square-foot multifamily property in Phoenix, Arizona (“Arcadia Gardens”). The Asking Price is $9.775 million, which equates to $128,618 per apartment unit and $225 per rentable square foot. Comparable properties have sold for median figures of $120,000 per unit and $157 per rentable square foot. The previous owner of Arcadia Gardens spent $3.5 million on a renovation, during...

  • please answer only if you know the answers, and explain the process, thank you An investor...

    please answer only if you know the answers, and explain the process, thank you An investor would like to purchase a new apartment property for $2 million. However, she faces the decision of whether to use 70 percent or 80 percent financing. The 70 percent loan can be obtained at 10 percent interest for 25 years. The 80 percent loan can be obtained at 11 percent interest for 25 years, NOI is expected to be $190,000 per year and increase...

  • Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use...

    Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use apartment building in Brooklyn, NY for $11,000,000. The property consists of 28 apartments, each 850 square feet, renting for $2,400 a month per unit, and 2 stores - the first is a 2,000 square foot space with a yoga studio as the tenant in place, paying a $8,500 rent per month and the second is a 3,000 square foot space with a sport equipment...

  • Name APPRAISAL PROBLEM Estimate the present market value of a 10 unit apartment house given the...

    Name APPRAISAL PROBLEM Estimate the present market value of a 10 unit apartment house given the following information pertaining to the property. Each apartment has 1,000 square feet of living area, 3 bedrooms, and kitchen appliances Tenants pay their own utilities The value of the land is $250,000 The estimate replacement value is $150 per square foot for this type of construction. Total operating expenses insurance and property taxes for the year are expected to be $25,000 Rental income, $6,000...

  • It is late November and you are undertaking an investment analysis of an office property that...

    It is late November and you are undertaking an investment analysis of an office property that your firm is considering purchasing at the end of this year. The property has 80,000 square feet of leasable space currently occupied by two tenants each leasing 40,000 square feet. Both tenants have triple-net leases; all operating expenses are passed through to tenants. The owner pays operating expenses associated with vacant space. Current ‘‘market’’ rent is $20 per square foot on a triple net...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT