I need help filling out this ProForma. Please show the formulas used. Thanks.
G H I K L M N 0 Year 3 Year 4 Year 5 % % % Per Door % % * Per Door % Per Door A B D E F 1 Independent Variables for Hotel 2 Total Rooms: 250 3 ADR Yr1: $175 4 ADR Growth Rate: 2% 5 Occupancy 91 65% 75% thereafter 6 Food Revenue POR: 6 $15 7 Food Cost POR: $11 B B Beverage Revenue POR $12 9 Beverage Cost POR : $4 10 Rooms Expense POR: $50 11 Other Departments Revenue POR: $10 12 Other Departments Expense POR: $6.00 13 Management Fee: 2% of Total Revenue 10% of Net Operating Income 14 Franchise Fee: 5% of Rooms Revenue 15 Admin Expense: 10% 16 Sales and Marketing Expense: 8% 17 Tech Expense: 4% 18 Maintenance Expense: 4% 19 Utilities Expense: 6% 20 Hard Construction Costs for the Hotel: $150,000 per room 21 FF&E Costs: $50,000 per room 22 Year 1 Year 2 23 % % Per Door % % Per Door 24 Redidential PSF 25 Residential 26 Misc. Income 27 Less: Vacancy 28 TOTAL RESIDENTIAL 29 30 Parking-Contract 31 Less: Vacancy 32 Parking Other 33 Less: Vacancy 34 TOTAL PARKING 35 36 Commercial 37 Less: Vacancy 38 TOTAL COMMERCIAL 39 40 TOTAL REVENUE 41 42 Expenses % Per Door % % Per Door 43 Property Management 44 Admin. & General 45 Maintenance 46 Utilities 47 Taxes 48 Insurance 49 Skywalk lease Payment 50 TOTAL EXPENSES 51 52 Capital Reserve 53 Net Operating Income 54 Expense Growth 55 56 TIF Proceeds 57 Income Available for Debt % % Per Door % % Per Door % % Per Door % G H I K L M N 0 Year 3 Year 4 Year 5 % % % Per Door % % * Per Door % Per Door A B D E F 1 Independent Variables for Hotel 2 Total Rooms: 250 3 ADR Yr1: $175 4 ADR Growth Rate: 2% 5 Occupancy 91 65% 75% thereafter 6 Food Revenue POR: 6 $15 7 Food Cost POR: $11 B B Beverage Revenue POR $12 9 Beverage Cost POR : $4 10 Rooms Expense POR: $50 11 Other Departments Revenue POR: $10 12 Other Departments Expense POR: $6.00 13 Management Fee: 2% of Total Revenue 10% of Net Operating Income 14 Franchise Fee: 5% of Rooms Revenue 15 Admin Expense: 10% 16 Sales and Marketing Expense: 8% 17 Tech Expense: 4% 18 Maintenance Expense: 4% 19 Utilities Expense: 6% 20 Hard Construction Costs for the Hotel: $150,000 per room 21 FF&E Costs: $50,000 per room 22 Year 1 Year 2 23 % % Per Door % % Per Door 24 Redidential PSF 25 Residential 26 Misc. Income 27 Less: Vacancy 28 TOTAL RESIDENTIAL 29 30 Parking-Contract 31 Less: Vacancy 32 Parking Other 33 Less: Vacancy 34 TOTAL PARKING 35 36 Commercial 37 Less: Vacancy 38 TOTAL COMMERCIAL 39 40 TOTAL REVENUE 41 42 Expenses % Per Door % % Per Door 43 Property Management 44 Admin. & General 45 Maintenance 46 Utilities 47 Taxes 48 Insurance 49 Skywalk lease Payment 50 TOTAL EXPENSES 51 52 Capital Reserve 53 Net Operating Income 54 Expense Growth 55 56 TIF Proceeds 57 Income Available for Debt % % Per Door % % Per Door % % Per Door %
