Calculate the before-tax and after-tax cash flows

Reference no: EM131937062

Question: Assume that you are an investment analyst preparing an analysis of an investment opportunity for a client. Your client is considering the acquisition of an apartment complex from a developer at the point in time when the apartments are ready for first occupancy. Your have developed the following information.

1) Number of units = 30

2) First year market rent per unit = $480 per month

3) Rent is projected to increase by 8% each year

4) Annual vacancy rate = 3% of PGI(Potential Gross Income)

5) Annual collection loss = 2% of PGI(Potential Gross Income)

6) Annual operating expense = 34% of EGI

7) Miscellaneous yearly income (parking and washers/dryers) = $1000

8) Monthly miscellaneous income is expected to remain constant

9) Purchase price = $1,800,000

10) Estimated value of land = $300,000

11) Anticipated mortgage terms:

a) Loan to value ratio = .80

b) Interest rate = 6.5%

c) Years to maturity = 25

d) Points charged = 3

e) Prepayment penalty = 2% of outstanding balance

f) Level payment, fully amortized

g) Fixed interest rate, annual payments

12) Anticipated holding period = 4 years

13) Proportion by which property is expected to appreciate during the holding period -- 5% a year

14) Estimated selling expenses as proportion of future sales price = 5%

15) Marginal income tax rate for the client = 28%

16) It is assumed that the property is put into service on January 1st and sold on December 31st

17) Assume the client is "active" in the property management

18) It is assumed that the client has an adjusted gross income of $95,000 and has no other passive income not offset by other passive losses (for each year of the anticipated holding period)

19) Client's minimum required after tax rate of return on equity = 13%

Calculate:

The before-tax and after-tax cash flows for each year of the holding period and the before-tax and after-tax equity reversion.

The after-tax net present value and after-tax internal rate of return to the investor.

The profitability index (this is calculated on an after-tax basis).

Should we invest in this project? Explain.

Reference no: EM131937062

Questions Cloud

Write an interactive program that requires the mechanic : Wright's Garage wants an interactive program that requires the mechanic to enter the tire pressure from four tires on any given car that comes into the garage.

What is the clinic variable cost rate : Assume that Good health Clinic has fixed costs of $1 million and a total cost forecast of $1.5 million at a volume of 20,000 patient visits.

Specific information from the article : Asks a thoughtful question, refers to specific information from the article, adds your own ideas or reasons for asking the question or indicates

Is this possible to solve using just the caculator keys : If the appropriate discount rate is 5.5 percent compounded daily, what is the present value? Is this possible to solve using just the caculator keys?

Calculate the before-tax and after-tax cash flows : The before-tax and after-tax cash flows for each year of the holding period and the before-tax and after-tax equity reversion.

Calculate the cost of adding peripherals to computer system : Reasonable Computers Corporation would like an applet to calculate the cost of adding peripherals to a basic computer system.

Shaped human populations in the relatively recent past : How have evolutionary forces shaped human populations in the relatively recent past (i.e., over the last 10,000 years)?

What does alan believe the inflation rate will be over : Alan Wingspan thinks the total real return on this investment will be only 5 percent. What does Alan believe the inflation rate will be over the next year?

Create an applet that could run from a browser : We Love Pets is a pet clinic with several locations. The office manager has asked you to create an applet that could run from a browser at all the offices.

User Account

All Pages