STABILIZED YEAR INCOME AND EXPENSE PRO FORMA
Try our calculator to see if your project makes sense. We look at the business and the deal to determine overall feasibility.
Questions? Contact us.
The Business
SALES | $’s | % |
---|---|---|
Sales – Food | $ | 80.65% |
Sales – Beverage (N / A) | $ | 4.30% |
Sales – Beverage (Alcohol) | $ | 15.05% |
Gross Sales | 4,650,000 | 100.00% |
Less: Comps and Discounts | 93,000 | % |
Net Sales | 4,557,000 | 98.00% |
COST OF GOODS SOLD | ||
Food | 1,125,000 | % |
Beverage (N / A) | 40,000 | % |
Beverage (Alcohol) | 210,000 | % |
Total Cost of Goods Sold | 1,375,000 | 29.57% |
GROSS PROFIT | 3,182,000 | 68.43% |
OPERATING EXPENSES | ||
Payroll | 1,395,000 | % |
Employee Benefits | 232,500 | % |
Direct Operating | 186,000 | % |
Marketing | 139,500 | % |
Utilities | 139,500 | % |
Admin & General | 232,500 | % |
Repairs & Mainteance | 46,500 | % |
Total Operating Expenses | 2,371,500 | 51.00% |
Operating Income | 810,500 | 17.43% |
Occupancy Expense | ||
-Rent | $ | 3.23% |
-Property Taxes / C.A.M. | $ | 0.43% |
Total Expenses | 2,541,500 | 54.66% |
E B I T D A Earnings Before Interst, Taxes, Depreciation and Amortization | 640,500 | 13.77% |
The Deal
E B I T D A Earnings Before Interst, Taxes, Depreciation and Amortization | 640,500 | 13.77% |
---|---|---|
Depreciation / Amortization | $ | 2.15% |
Interest Expense | $ | 0.57% |
Management Fee | 227,850 | % |
NET INCOME | 285,995 | 6.15% |
Add: Depreciation / Amort | $ | 2.15% |
Less Capital Expenditures | ($) | -0.22% |
Less: Principal Payments | ($) | -0.86% |
NET CASH FLOW | 336,038 | 7.23% |
Return on Development Cost | 336,038 | 22.40% |
Return On Invested Equity | 336,038 | 33.60% |
Sales-To-Investment Ratio | 3.10 | x |
Loan to Cost Ratio | 33.33% | N / A |
Debt Service Coverage | 9.62 | x |
Sales / Square Foot | 930 | N / A |
Totals
Total Development Cost | $ |
Loan Amount | $ |
Interest Rate (%) | % |
Term (Years) | $ |
Equity Requirement | 1,000,000 |
Square Footage |