0	1	2	3	4	5	6
Purchase Price	(1,538,462)
Loan Proceeds	833,333
Loan Fees	(16,667)
NOI		100,000	103,000	109,273	119,406	134,393	155,798
-DS		(50,000)	(50,000)	(50,000)	(50,000)	(50,000)	(50,000)
BTCF		50,000	53,000	59,273	69,406	84,393	105,798
NSP						2,110,000
-Loan Payoff						(830,000)
BTER						1,280,000
Unlevered Discount Rate:	10%
Levered Discount Rate:	12%

Need to know what to put into cf0,cf1,cf2 in calculator

1. Using the pro-forma table below, what is your unlevered IRR?

2. Using the pro-forma table below, what is your levered NPV?

3. Using the pro-forma table below, what is your levered equity multiple?

4. Using the pro-forma table below, what is your levered IRR?

5. Using the pro-forma table below, what is your unlevered NPV?

6. Considering the pro-forma table below, if you change your levered discount rate to 25%, you will make an even higher levered NPV, and should go forward with the investment.