Edit This Plan
 

Get real P&L data for your plan!

We have complete profit and loss financial data from companies like MSN Real Estate.

SIC 6531 Real Estate - Real estate agents and managers

Get Finanicals

*Reports start as low as $89

 

Real Estate Management Business Plan

MSN Real Estate

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Unit Sales
Single Units 0% 24 24 24 24 24 24 24 24 29 29 29 32
Double Units 0% 10 10 10 10 10 10 16 16 20 20 20 22
Quad Units 0% 8 8 8 8 8 8 12 12 14 14 14 15
Luxury Suites 0% 2 2 2 2 2 2 2 2 3 3 3 4
Total Unit Sales 44 44 44 44 44 44 54 54 66 66 66 73
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Single Units $425.00 $425.00 $425.00 $425.00 $425.00 $350.00 $350.00 $350.00 $350.00 $440.00 $440.00 $440.00
Double Units $820.00 $820.00 $820.00 $820.00 $820.00 $820.00 $740.00 $740.00 $740.00 $850.00 $850.00 $850.00
Quad Units $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,000.00 $1,000.00 $1,000.00 $1,300.00 $1,300.00 $1,300.00
Luxury Suites $675.00 $675.00 $675.00 $675.00 $675.00 $675.00 $600.00 $600.00 $600.00 $725.00 $725.00 $725.00
Sales
Single Units $10,200 $10,200 $10,200 $10,200 $10,200 $8,400 $8,400 $8,400 $10,150 $12,760 $12,760 $14,080
Double Units $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $11,840 $11,840 $14,800 $17,000 $17,000 $18,700
Quad Units $9,600 $9,600 $9,600 $9,600 $9,600 $9,600 $12,000 $12,000 $14,000 $18,200 $18,200 $19,500
Luxury Suites $1,350 $1,350 $1,350 $1,350 $1,350 $1,350 $1,200 $1,200 $1,800 $2,175 $2,175 $2,900
Total Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Single Units 0.00% $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00
Double Units 0.00% $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00
Quad Units 0.00% $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00
Luxury Suites 0.00% $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00
Direct Cost of Sales
Single Units $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $7,540 $7,540 $7,540 $8,320
Double Units $4,280 $4,280 $4,280 $4,280 $4,280 $4,280 $6,848 $6,848 $8,560 $8,560 $8,560 $9,416
Quad Units $4,088 $4,088 $4,088 $4,088 $4,088 $4,088 $6,132 $6,132 $7,154 $7,154 $7,154 $7,665
Luxury Suites $604 $604 $604 $604 $604 $604 $604 $604 $906 $906 $906 $1,208
Subtotal Direct Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Nathan Koach (CFO) 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Shawn Menashe (CEO) 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Denise Richards (Admin. Mgr.) 0% $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Joe Nash (Brokerage Mgr.) 0% $950 $950 $950 $950 $950 $950 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Head Contractor (Development Mgr.) 0% $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Other 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Direct Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Gross Margin $14,138 $14,138 $14,138 $14,138 $14,138 $12,338 $13,616 $13,616 $16,590 $25,975 $25,975 $28,571
Gross Margin % 48.17% 48.17% 48.17% 48.17% 48.17% 44.78% 40.72% 40.72% 40.71% 51.81% 51.81% 51.78%
Expenses
Payroll $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Marketing/Promotion $1,350 $1,350 $1,350 $1,350 $1,350 $1,350 $1,150 $900 $950 $950 $900 $850
Depreciation $0 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111
Leased Equipment $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $1,095 $1,095 $1,095 $1,095 $1,095 $1,095 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $11,995 $13,106 $13,106 $13,106 $13,106 $13,106 $13,481 $13,231 $13,281 $13,281 $13,231 $13,181
Profit Before Interest and Taxes $2,143 $1,032 $1,032 $1,032 $1,032 ($768) $135 $385 $3,309 $12,694 $12,744 $15,390
EBITDA $2,143 $2,143 $2,143 $2,143 $2,143 $343 $1,246 $1,496 $4,420 $13,805 $13,855 $16,501
Interest Expense $5,440 $5,433 $5,427 $5,420 $5,413 $5,409 $5,400 $5,391 $5,382 $5,381 $5,379 $5,378
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,297) ($4,401) ($4,395) ($4,388) ($4,381) ($6,177) ($5,265) ($5,006) ($2,073) $7,313 $7,365 $10,012
Net Profit/Sales -11.23% -15.00% -14.97% -14.95% -14.93% -22.42% -15.74% -14.97% -5.09% 14.59% 14.69% 18.14%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Subtotal Cash from Operations $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $1,000 $800 $800 $800 $800 $1,200 $500 $500 $500 $500 $500 $500
New Other Liabilities (interest-free) $200 $0 $0 $200 $200 $200 $200 $200 $200 $202 $0 $200
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $100 $150 $150 $150 $1,000 $1,000 $1,011 $1,001 $100 $100 $1,000 $100
Subtotal Cash Received $30,650 $30,300 $30,300 $30,500 $31,350 $29,950 $35,151 $35,141 $41,550 $52,437 $53,135 $57,480
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Bill Payments $4,735 $25,347 $25,340 $25,333 $25,327 $25,320 $25,465 $29,785 $29,681 $33,912 $33,909 $33,939
Subtotal Spent on Operations $12,035 $32,647 $32,640 $32,633 $32,627 $32,620 $33,265 $37,585 $37,481 $41,712 $41,709 $41,739
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Other Liabilities Principal Repayment $0 $200 $0 $200 $0 $0 $0 $0 $0 $0 $250 $0
Long-term Liabilities Principal Repayment $0 $2,075 $2,080 $2,085 $2,091 $2,096 $2,102 $2,107 $2,113 $2,118 $2,124 $2,130
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $1,080,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,092,035 $35,172 $34,970 $35,168 $34,968 $34,966 $35,617 $39,942 $39,844 $44,080 $44,333 $44,119
Net Cash Flow ($1,061,385) ($4,872) ($4,670) ($4,668) ($3,618) ($5,016) ($466) ($4,801) $1,706 $8,357 $8,802 $13,361
Cash Balance $49,945 $45,073 $40,403 $35,735 $32,117 $27,101 $26,635 $21,834 $23,540 $31,897 $40,699 $54,059
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $1,111,330 $49,945 $45,073 $40,403 $35,735 $32,117 $27,101 $26,635 $21,834 $23,540 $31,897 $40,699 $54,059
Other Current Assets $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Total Current Assets $1,123,330 $61,945 $57,073 $52,403 $47,735 $44,117 $39,101 $38,635 $33,834 $35,540 $43,897 $52,699 $66,059
Long-term Assets
Long-term Assets $120,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000
Accumulated Depreciation $0 $0 $1,111 $2,222 $3,333 $4,444 $5,555 $6,666 $7,777 $8,888 $9,999 $11,110 $12,221
Total Long-term Assets $120,000 $1,200,000 $1,198,889 $1,197,778 $1,196,667 $1,195,556 $1,194,445 $1,193,334 $1,192,223 $1,191,112 $1,190,001 $1,188,890 $1,187,779
Total Assets $1,243,330 $1,261,945 $1,255,962 $1,250,181 $1,244,402 $1,239,673 $1,233,546 $1,231,969 $1,226,057 $1,226,652 $1,233,898 $1,241,589 $1,253,838
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $3,890 $24,502 $24,496 $24,489 $24,483 $24,476 $24,472 $28,801 $28,551 $32,782 $32,780 $32,731 $35,048
Current Borrowing $5,000 $6,000 $6,550 $7,100 $7,650 $8,200 $9,150 $9,400 $9,650 $9,900 $10,150 $10,400 $10,650
Other Current Liabilities $0 $200 $0 $0 $0 $200 $400 $600 $800 $1,000 $1,202 $952 $1,152
Subtotal Current Liabilities $8,890 $30,702 $31,046 $31,589 $32,133 $32,876 $34,022 $38,801 $39,001 $43,682 $44,132 $44,083 $46,850
Long-term Liabilities $1,080,000 $1,080,000 $1,077,925 $1,075,845 $1,073,760 $1,071,669 $1,069,573 $1,067,471 $1,065,364 $1,063,251 $1,062,633 $1,062,009 $1,061,379
Total Liabilities $1,088,890 $1,110,702 $1,108,971 $1,107,434 $1,105,893 $1,104,545 $1,103,595 $1,106,272 $1,104,365 $1,106,933 $1,106,765 $1,106,092 $1,108,229
Paid-in Capital $246,000 $246,100 $246,250 $246,400 $246,550 $247,550 $248,550 $249,561 $250,562 $250,662 $250,762 $251,762 $251,862
Retained Earnings ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560)
Earnings $0 ($3,297) ($7,698) ($12,093) ($16,481) ($20,862) ($27,039) ($32,304) ($37,310) ($39,383) ($32,070) ($24,705) ($14,693)
Total Capital $154,440 $151,243 $146,992 $142,747 $138,509 $135,128 $129,951 $125,697 $121,692 $119,719 $127,132 $135,497 $145,609
Total Liabilities and Capital $1,243,330 $1,261,945 $1,255,962 $1,250,181 $1,244,402 $1,239,673 $1,233,546 $1,231,969 $1,226,057 $1,226,652 $1,233,898 $1,241,589 $1,253,838
Net Worth $154,440 $151,243 $146,992 $142,747 $138,509 $135,128 $129,951 $125,697 $121,692 $119,719 $127,132 $135,497 $145,609
previous
next
Edit This Plan
Share this page:
Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Unit Sales
Single Units 0% 24 24 24 24 24 24 24 24 29 29 29 32
Double Units 0% 10 10 10 10 10 10 16 16 20 20 20 22
Quad Units 0% 8 8 8 8 8 8 12 12 14 14 14 15
Luxury Suites 0% 2 2 2 2 2 2 2 2 3 3 3 4
Total Unit Sales 44 44 44 44 44 44 54 54 66 66 66 73
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Single Units $425.00 $425.00 $425.00 $425.00 $425.00 $350.00 $350.00 $350.00 $350.00 $440.00 $440.00 $440.00
Double Units $820.00 $820.00 $820.00 $820.00 $820.00 $820.00 $740.00 $740.00 $740.00 $850.00 $850.00 $850.00
Quad Units $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,000.00 $1,000.00 $1,000.00 $1,300.00 $1,300.00 $1,300.00
Luxury Suites $675.00 $675.00 $675.00 $675.00 $675.00 $675.00 $600.00 $600.00 $600.00 $725.00 $725.00 $725.00
Sales
Single Units $10,200 $10,200 $10,200 $10,200 $10,200 $8,400 $8,400 $8,400 $10,150 $12,760 $12,760 $14,080
Double Units $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $11,840 $11,840 $14,800 $17,000 $17,000 $18,700
Quad Units $9,600 $9,600 $9,600 $9,600 $9,600 $9,600 $12,000 $12,000 $14,000 $18,200 $18,200 $19,500
Luxury Suites $1,350 $1,350 $1,350 $1,350 $1,350 $1,350 $1,200 $1,200 $1,800 $2,175 $2,175 $2,900
Total Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Single Units 0.00% $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00 $260.00
Double Units 0.00% $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00 $428.00
Quad Units 0.00% $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00 $511.00
Luxury Suites 0.00% $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00 $302.00
Direct Cost of Sales
Single Units $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $6,240 $7,540 $7,540 $7,540 $8,320
Double Units $4,280 $4,280 $4,280 $4,280 $4,280 $4,280 $6,848 $6,848 $8,560 $8,560 $8,560 $9,416
Quad Units $4,088 $4,088 $4,088 $4,088 $4,088 $4,088 $6,132 $6,132 $7,154 $7,154 $7,154 $7,665
Luxury Suites $604 $604 $604 $604 $604 $604 $604 $604 $906 $906 $906 $1,208
Subtotal Direct Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Nathan Koach (CFO) 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Shawn Menashe (CEO) 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Denise Richards (Admin. Mgr.) 0% $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Joe Nash (Brokerage Mgr.) 0% $950 $950 $950 $950 $950 $950 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Head Contractor (Development Mgr.) 0% $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Other 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Direct Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $15,212 $15,212 $15,212 $15,212 $15,212 $15,212 $19,824 $19,824 $24,160 $24,160 $24,160 $26,609
Gross Margin $14,138 $14,138 $14,138 $14,138 $14,138 $12,338 $13,616 $13,616 $16,590 $25,975 $25,975 $28,571
Gross Margin % 48.17% 48.17% 48.17% 48.17% 48.17% 44.78% 40.72% 40.72% 40.71% 51.81% 51.81% 51.78%
Expenses
Payroll $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Marketing/Promotion $1,350 $1,350 $1,350 $1,350 $1,350 $1,350 $1,150 $900 $950 $950 $900 $850
Depreciation $0 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111
Leased Equipment $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $1,095 $1,095 $1,095 $1,095 $1,095 $1,095 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $11,995 $13,106 $13,106 $13,106 $13,106 $13,106 $13,481 $13,231 $13,281 $13,281 $13,231 $13,181
Profit Before Interest and Taxes $2,143 $1,032 $1,032 $1,032 $1,032 ($768) $135 $385 $3,309 $12,694 $12,744 $15,390
EBITDA $2,143 $2,143 $2,143 $2,143 $2,143 $343 $1,246 $1,496 $4,420 $13,805 $13,855 $16,501
Interest Expense $5,440 $5,433 $5,427 $5,420 $5,413 $5,409 $5,400 $5,391 $5,382 $5,381 $5,379 $5,378
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,297) ($4,401) ($4,395) ($4,388) ($4,381) ($6,177) ($5,265) ($5,006) ($2,073) $7,313 $7,365 $10,012
Net Profit/Sales -11.23% -15.00% -14.97% -14.95% -14.93% -22.42% -15.74% -14.97% -5.09% 14.59% 14.69% 18.14%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Subtotal Cash from Operations $29,350 $29,350 $29,350 $29,350 $29,350 $27,550 $33,440 $33,440 $40,750 $50,135 $50,135 $55,180
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $1,000 $800 $800 $800 $800 $1,200 $500 $500 $500 $500 $500 $500
New Other Liabilities (interest-free) $200 $0 $0 $200 $200 $200 $200 $200 $200 $202 $0 $200
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $100 $150 $150 $150 $1,000 $1,000 $1,011 $1,001 $100 $100 $1,000 $100
Subtotal Cash Received $30,650 $30,300 $30,300 $30,500 $31,350 $29,950 $35,151 $35,141 $41,550 $52,437 $53,135 $57,480
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Bill Payments $4,735 $25,347 $25,340 $25,333 $25,327 $25,320 $25,465 $29,785 $29,681 $33,912 $33,909 $33,939
Subtotal Spent on Operations $12,035 $32,647 $32,640 $32,633 $32,627 $32,620 $33,265 $37,585 $37,481 $41,712 $41,709 $41,739
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Other Liabilities Principal Repayment $0 $200 $0 $200 $0 $0 $0 $0 $0 $0 $250 $0
Long-term Liabilities Principal Repayment $0 $2,075 $2,080 $2,085 $2,091 $2,096 $2,102 $2,107 $2,113 $2,118 $2,124 $2,130
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $1,080,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,092,035 $35,172 $34,970 $35,168 $34,968 $34,966 $35,617 $39,942 $39,844 $44,080 $44,333 $44,119
Net Cash Flow ($1,061,385) ($4,872) ($4,670) ($4,668) ($3,618) ($5,016) ($466) ($4,801) $1,706 $8,357 $8,802 $13,361
Cash Balance $49,945 $45,073 $40,403 $35,735 $32,117 $27,101 $26,635 $21,834 $23,540 $31,897 $40,699 $54,059
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $1,111,330 $49,945 $45,073 $40,403 $35,735 $32,117 $27,101 $26,635 $21,834 $23,540 $31,897 $40,699 $54,059
Other Current Assets $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Total Current Assets $1,123,330 $61,945 $57,073 $52,403 $47,735 $44,117 $39,101 $38,635 $33,834 $35,540 $43,897 $52,699 $66,059
Long-term Assets
Long-term Assets $120,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000
Accumulated Depreciation $0 $0 $1,111 $2,222 $3,333 $4,444 $5,555 $6,666 $7,777 $8,888 $9,999 $11,110 $12,221
Total Long-term Assets $120,000 $1,200,000 $1,198,889 $1,197,778 $1,196,667 $1,195,556 $1,194,445 $1,193,334 $1,192,223 $1,191,112 $1,190,001 $1,188,890 $1,187,779
Total Assets $1,243,330 $1,261,945 $1,255,962 $1,250,181 $1,244,402 $1,239,673 $1,233,546 $1,231,969 $1,226,057 $1,226,652 $1,233,898 $1,241,589 $1,253,838
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $3,890 $24,502 $24,496 $24,489 $24,483 $24,476 $24,472 $28,801 $28,551 $32,782 $32,780 $32,731 $35,048
Current Borrowing $5,000 $6,000 $6,550 $7,100 $7,650 $8,200 $9,150 $9,400 $9,650 $9,900 $10,150 $10,400 $10,650
Other Current Liabilities $0 $200 $0 $0 $0 $200 $400 $600 $800 $1,000 $1,202 $952 $1,152
Subtotal Current Liabilities $8,890 $30,702 $31,046 $31,589 $32,133 $32,876 $34,022 $38,801 $39,001 $43,682 $44,132 $44,083 $46,850
Long-term Liabilities $1,080,000 $1,080,000 $1,077,925 $1,075,845 $1,073,760 $1,071,669 $1,069,573 $1,067,471 $1,065,364 $1,063,251 $1,062,633 $1,062,009 $1,061,379
Total Liabilities $1,088,890 $1,110,702 $1,108,971 $1,107,434 $1,105,893 $1,104,545 $1,103,595 $1,106,272 $1,104,365 $1,106,933 $1,106,765 $1,106,092 $1,108,229
Paid-in Capital $246,000 $246,100 $246,250 $246,400 $246,550 $247,550 $248,550 $249,561 $250,562 $250,662 $250,762 $251,762 $251,862
Retained Earnings ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560) ($91,560)
Earnings $0 ($3,297) ($7,698) ($12,093) ($16,481) ($20,862) ($27,039) ($32,304) ($37,310) ($39,383) ($32,070) ($24,705) ($14,693)
Total Capital $154,440 $151,243 $146,992 $142,747 $138,509 $135,128 $129,951 $125,697 $121,692 $119,719 $127,132 $135,497 $145,609
Total Liabilities and Capital $1,243,330 $1,261,945 $1,255,962 $1,250,181 $1,244,402 $1,239,673 $1,233,546 $1,231,969 $1,226,057 $1,226,652 $1,233,898 $1,241,589 $1,253,838
Net Worth $154,440 $151,243 $146,992 $142,747 $138,509 $135,128 $129,951 $125,697 $121,692 $119,719 $127,132 $135,497 $145,609