Question: Please build a 10-year pro forma based on the assumptions below. 1) Please build a sources and uses table and calculate unlevered and levered IRR.

Please build a 10-year pro forma based on the assumptions below.

1) Please build a sources and uses table and calculate unlevered and levered IRR. 2) Please build a sensitivity table sensitizing Unlevered IRR and Exit Years.

Purchase:

Purchase- 5% cap rate

Closing Cost- 2% of purchase price

Operations:

Revenue- $100,000

Expenses- 20% of revenue

Revenue Growth- 3%

Financing:

Loan to Value- 60%

Payment- Monthly

Amortization Years- 30

Interest- 4%

Exit:

Year- 6

Cap Rate- 5.25%

Sales Cost- 5.00%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!