Question

In: Finance

Suppose that you are considering an investment in an apartment building. The specifics are:                            &

Suppose that you are considering an investment in an apartment building. The specifics are:                                                            
- The building is four years old, has a 85 percent occupancy rate, and has an expected useful life of 25 years. Assume that this occupancy rate is expected to continue for the life of the building.
- There are 130 2-bedroom units, 100 1-bedroom units, and 70 studios.
- The 2-bedroom units rent for $2800 per month, the 1-bedroom units for $2000 per month, and the studios for $1200 per month.
- Current rent control laws will prevent the rents from ever being raised.
- The estimated annual maintenance cost for the building is $1500000 per year (this is independent of the number of apartments rented).
- There is an additional estimated maintenance cost at $200 per unit per month, when each unit is rented.
- There will be no salvage value to the building in 25 years, but it is estimated that it will cost 6 million dollars at that time to demolish the building as will be required in the purchase contract. (You are not purchasing the land. You will have a 25-year lease of the land, which is paid for in the purchase of the building.)      
- The asking price of the building is $30 million.
- The tax-rate is 30%, and assume the building will be fully depreciated over its useful life.
- The WACC is 9%.                                                                   
Develop the pro-forma income statement, compute the Operating Cash-Flows and NPV. Assume that your bossy boss wants you to do a sensitivity analysis regarding the project. He is concerned that the vacancy rate may increase by as much as 5% (occupancy will go down to 80%). Compute the NPV for this scenario (round to nearest $10,000).

Solutions

Expert Solution

1.)

The NPV of the investment is 3970000 (rounded to nearest 10000)

Step 1: - computation of Net income

INCOME STATEMENT

sales

[(130*2800+100*2000+70*1200)*.85*12]

= 6609600

variable costs

[300*200*.85*12]

= 612000

Fixed costs

= 1500000

Depreciation

[35,000,000 / 25 ]

= 1200000

EBIT

= 3297600

interest

= 0

EBT

= 3297600

Taxes

[30%]

= 989280

Net income

= 2308320

Step 2: - computation of operating cash flow

Operating cash flow = Net income + Depreciation

= 2308320 + 1200000

=3508320

Step 3: - computation of NPV

Before calculating NPV we have to calculate after-tax cost of demolishing

after-tax cost of demolishing = 6000000 * (1-.3)

after-tax cost of demolition = 4200000

The NPV of the investment is positive. therefore, accept the investment.

2. Sensitivity analysis (occupancy rate = 80%)

The NPV of the investment when occupancy will go down to 80% is 1540000 (rounded to nearest 10000)

Step 1: - computation of Net income

INCOME STATEMENT

sales

[(130*2800+100*2000+70*1200)*.80*12]

= 6220800

variable costs

[300*200*.80*12]

= 576000

Fixed costs

= 1500000

Depreciation

[35,000,000 / 25 ]

= 1200000

EBIT

= 2944800

interest

= 0

EBT

= 2944800

Taxes

[30%]

= 883440

Net income

= 2061360

Step 2: - computation of operating cash flow

Operating cash flow = Net income + Depreciation

= 2061360 + 1200000

=3261360

Step 3: - computation of NPV

The NPV of the investment is positive. therefore, accept the investment.


Related Solutions

Suppose that you are considering an investment in an apartment building. The specifics are: - The...
Suppose that you are considering an investment in an apartment building. The specifics are: - The building is four years old, has a 85 percent occupancy rate, and has an expected useful life of 25 years. Assume that this occupancy rate is expected to continue for the life of the building. - There are 130 2-bedroom units, 100 1-bedroom units, and 70 studios. - The 2-bedroom units rent for $2800 per month, the 1-bedroom units for $2000 per month, and...
Suppose that you are considering an investment in an apartment building. The specifics are: - The...
Suppose that you are considering an investment in an apartment building. The specifics are: - The building is five years old, has a 80 percent occupancy rate, and has an expected useful life of 25 years. Assume that this occupancy rate is expected to continue for the life of the building. - There are 90 2-bedroom units, 100 1-bedroom units, and 70 studios. - The 2-bedroom units rent for $3000 per month, the 1-bedroom units for $2200 per month, and...
Suppose that you are considering an investment in an apartment building. The specifics are:                            &
Suppose that you are considering an investment in an apartment building. The specifics are:                                                             - The building is four years old, has a 85 percent occupancy rate, and has an expected useful life of 25 years. Assume that this occupancy rate is expected to continue for the life of the building. - There are 130 2-bedroom units, 100 1-bedroom units, and 70 studios. - The 2-bedroom units rent for $2800 per month, the 1-bedroom units for $2000 per month,...
You are considering a luxury apartment building project that requires an investment of $10,200,000. The building...
You are considering a luxury apartment building project that requires an investment of $10,200,000. The building has 50 units. You expect the maintenance cost for the apartment building to be $350,000 the first year and $400,000 the second year. The maintenance cost will continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $82,000 per year. After five years of operation, the apartment building can be sold for $12,000,000....
You are considering a luxury apartment building project that requires an investment of $1,300,000. The building...
You are considering a luxury apartment building project that requires an investment of $1,300,000. The building has 50 unites. We expect that the maintenance cost for the apartment building will be $150,000 in the first year, and to rise to $200,000 in the second year, and to continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimate to be $50,000 per year. After five years of operation, the apartment building can...
Suppose that you are considering the purchase of an apartment building for $2 million.A bank is...
Suppose that you are considering the purchase of an apartment building for $2 million.A bank is willing to loan you 85% of the purchase price with a 25 year loan with monthly payments and monthly compounding. If the bank charges you an annual interest rate of 10%. What will be your monthly payment for this loan. Show work a.10119 b.10373 c.13626 d. 14539 e.15444 Suppose that you are considering the purchase of a house for 300,000. A bank is willing...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below to answer the questions that follow: Type of Property: Apartment Building Number of Units: 30 Average Rent: $1,500 per unit per month Expected Growth in Rents: 5% per year Vacancy and Collection Losses: 5% of Potential Gross Income Other Income: $50 per unit per month Expected Growth in Other Income: 3% per year Operating Expenses: 35% of Effective Gross Income Capital Expenditures: 4% of...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below to answer the questions that follow: Type of Property: Apartment Building Number of Units: 30 Average Rent: $1,500 per unit per month Expected Growth in Rents: 5% per year Vacancy and Collection Losses: 5% of Potential Gross Income Other Income: $50 per unit per month Expected Growth in Other Income: 3% per year Operating Expenses: 35% of Effective Gross Income Capital Expenditures: 4% of...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below to answer the questions that follow: Type of Property: Apartment Building Number of Units: 30 Average Rent: $1,500 per unit per month Expected Growth in Rents: 5% per year Vacancy and Collection Losses: 5% of Potential Gross Income Other Income: $50 per unit per month Expected Growth in Other Income: 3% per year Operating Expenses: 35% of Effective Gross Income Capital Expenditures: 4% of...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below...
Suppose that you are contemplating an investment in an apartment building. Use the information provided below to answer the questions that follow: Type of Property: Apartment Building Number of Units: 30 Average Rent: $1,500 per unit per month Expected Growth in Rents: 5% per year Vacancy and Collection Losses: 5% of Potential Gross Income Other Income: $50 per unit per month Expected Growth in Other Income: 3% per year Operating Expenses: 35% of Effective Gross Income Capital Expenditures: 4% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT