Question: Task 1 : Construct the cash flow proforma statement for the following project by filling out the white cells of the following table. A 2-year


Task 1 : Construct the cash flow proforma statement for the following project by filling out the white cells of the following table. A 2-year levered equity investment between t=0 and t=2. The first NOI is 10 at t=1, and NOI grows at 5%lyr until t=3. The cap rate is 5% (going-in) at t=0 and increases by 0.5%lyr to 6% (going-out) at t=2. Capital Expenditures are 10% of NOI. The investment is levered with a two-year interest-only loan at a 5% interest rate with the face value of 80 (i.e., the initial loan amount is 80). Today 1 year later 2 years later 3 years later Cash flow at Cash flows for Cash flows for the beginning the first period the second of the project (between t=0 period and t=1) (between t=1 and t=2) and the last CF NOI Acquisition CF at t = 0 (0) DS incl. the final pmt. (
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
