Assumption

Question,

Please complete the levered free cashflow section using the assumption provided. what is the equity balance ( cumulative fcf)?

1. 16,669,000

2. 20,616,000

3. 18,644,000

4. 15,616,000

Please complete the levers free cashdlow section using assumption provided. what is the levered IRR percentage?

01. 37.4

02.40.5

03. 34.3

04. 28.7

During wich period (no of month) does the last distribution of cashlow of tier 1 happen?

01. 34

02. 37

03. 40

04. 28

Please complete the cashflow waterfall section using the assumption given. what is the IRR for LPs?

01. 28.7

02. 37.4

03. 34.3

04. 40.5

What is the project NPV if discout rate was 10%

01. 16,854,166

02. 9,416,544

03. 12,354,657

04. 13,511,476

% Equity invested 54 1-Apr 17 1-Sep-18 1.00-17 1-Dec-18 30% 3 2096 2 % of Cash Flow Tier 1 Tier 2 Tier 3 Schedule Transaction Date Sales Start Cordruction Start Construction End % Sold at Commencement Units Sold/Month % Closed at Completion Units Closed Por Month Post Property Stats (Square Feet) Gross Site Area Deducions 3 # of Unts FSR GBA 5 Con GBA Net Stable 0% 1040 30% Development Costs Land Building Costs Servicing Hard Cortingency DCCS Consulting & Warranty Finance / Bank Costs Other Marketing Overhead Sot Contingency 50% Commissions TOTAL Pre-Construction Spending ($/month) Financing Loan to Cost Interest Rate Land Loan Warranty (s/unt) Sale Price (S/SF) $30,000,000 10,000,000 1,500,000 5% 225,000 700,000 225.000 800,000 850,000 596 5.0% 120,000 40.000 50 90,000 90,000 100,000 + 809 20% $15,000,000 2.000 800 % Equity invested 54 1-Apr 17 1-Sep-18 1.00-17 1-Dec-18 30% 3 2096 2 % of Cash Flow Tier 1 Tier 2 Tier 3 Schedule Transaction Date Sales Start Cordruction Start Construction End % Sold at Commencement Units Sold/Month % Closed at Completion Units Closed Por Month Post Property Stats (Square Feet) Gross Site Area Deducions 3 # of Unts FSR GBA 5 Con GBA Net Stable 0% 1040 30% Development Costs Land Building Costs Servicing Hard Cortingency DCCS Consulting & Warranty Finance / Bank Costs Other Marketing Overhead Sot Contingency 50% Commissions TOTAL Pre-Construction Spending ($/month) Financing Loan to Cost Interest Rate Land Loan Warranty (s/unt) Sale Price (S/SF) $30,000,000 10,000,000 1,500,000 5% 225,000 700,000 225.000 800,000 850,000 596 5.0% 120,000 40.000 50 90,000 90,000 100,000 + 809 20% $15,000,000 2.000 800