Acme Insurance
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Sales | 0% | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Name or Title or Group | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Name or Title or Group | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Name or Title or Group | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 | |
Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Marketing/Promotion | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Profit Before Interest and Taxes | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 | |
EBITDA | $54,000 | $28,500 | $44,500 | $45,000 | $57,000 | $65,000 | $67,000 | $65,000 | $70,000 | $80,000 | $55,000 | $46,600 | |
Interest Expense | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | $3,767 | |
Taxes Incurred | $15,070 | $7,420 | $12,220 | $12,370 | $15,970 | $18,370 | $18,970 | $18,370 | $19,870 | $22,870 | $15,370 | $12,850 | |
Net Profit | $35,163 | $17,313 | $28,513 | $28,863 | $37,263 | $42,863 | $44,263 | $42,863 | $46,363 | $53,363 | $35,863 | $29,983 | |
Net Profit/Sales | 65.12% | 60.75% | 64.07% | 64.14% | 65.37% | 65.94% | 66.06% | 65.94% | 66.23% | 66.70% | 65.21% | 64.34% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $13,500 | $7,125 | $11,125 | $11,250 | $14,250 | $16,250 | $16,750 | $16,250 | $17,500 | $20,000 | $13,750 | $11,650 | |
Cash from Receivables | $127,970 | $129,320 | $39,863 | $21,775 | $33,388 | $34,050 | $42,950 | $48,800 | $50,200 | $48,875 | $52,750 | $59,375 | |
Subtotal Cash from Operations | $141,470 | $136,445 | $50,988 | $33,025 | $47,638 | $50,300 | $59,700 | $65,050 | $67,700 | $68,875 | $66,500 | $71,025 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $141,470 | $136,445 | $50,988 | $33,025 | $47,638 | $50,300 | $59,700 | $65,050 | $67,700 | $68,875 | $66,500 | $71,025 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Bill Payments | $336,628 | $18,582 | $11,347 | $15,992 | $16,257 | $19,817 | $22,157 | $22,717 | $22,187 | $23,737 | $26,387 | $19,053 | |
Subtotal Spent on Operations | $336,628 | $18,582 | $11,347 | $15,992 | $16,257 | $19,817 | $22,157 | $22,717 | $22,187 | $23,737 | $26,387 | $19,053 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $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 | $336,628 | $18,582 | $11,347 | $15,992 | $16,257 | $19,817 | $22,157 | $22,717 | $22,187 | $23,737 | $26,387 | $19,053 | |
Net Cash Flow | ($195,158) | $117,863 | $39,641 | $17,033 | $31,381 | $30,483 | $37,543 | $42,333 | $45,513 | $45,138 | $40,113 | $51,972 | |
Cash Balance | $207,482 | $325,345 | $364,986 | $382,019 | $413,400 | $443,883 | $481,426 | $523,759 | $569,272 | $614,410 | $654,523 | $706,495 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $402,640 | $207,482 | $325,345 | $364,986 | $382,019 | $413,400 | $443,883 | $481,426 | $523,759 | $569,272 | $614,410 | $654,523 | $706,495 |
Accounts Receivable | $255,940 | $168,470 | $60,525 | $54,038 | $66,013 | $75,375 | $90,075 | $97,375 | $97,325 | $99,625 | $110,750 | $99,250 | $74,825 |
Other Current Assets | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 | $309,137 |
Total Current Assets | $967,717 | $685,089 | $695,007 | $728,160 | $757,168 | $797,912 | $843,095 | $887,938 | $930,221 | $978,034 | $1,034,297 | $1,062,910 | $1,090,457 |
Long-term Assets | |||||||||||||
Long-term Assets | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 | $465,575 |
Accumulated Depreciation | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 | $181,651 |
Total Long-term Assets | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 | $283,924 |
Total Assets | $1,251,641 | $969,013 | $978,931 | $1,012,084 | $1,041,092 | $1,081,836 | $1,127,019 | $1,171,862 | $1,214,145 | $1,261,958 | $1,318,221 | $1,346,834 | $1,374,381 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $336,000 | $18,209 | $10,814 | $15,454 | $15,599 | $19,079 | $21,399 | $21,979 | $21,399 | $22,849 | $25,749 | $18,499 | $16,063 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 | $100,362 |
Subtotal Current Liabilities | $436,362 | $118,571 | $111,176 | $115,816 | $115,961 | $119,441 | $121,761 | $122,341 | $121,761 | $123,211 | $126,111 | $118,861 | $116,425 |
Long-term Liabilities | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 | $452,036 |
Total Liabilities | $888,398 | $570,607 | $563,212 | $567,852 | $567,997 | $571,477 | $573,797 | $574,377 | $573,797 | $575,247 | $578,147 | $570,897 | $568,461 |
Paid-in Capital | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
Retained Earnings | $88,096 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 | $363,143 |
Earnings | $275,047 | $35,163 | $52,476 | $80,989 | $109,852 | $147,116 | $189,979 | $234,242 | $277,105 | $323,468 | $376,831 | $412,694 | $442,677 |
Total Capital | $363,243 | $398,406 | $415,719 | $444,232 | $473,095 | $510,359 | $553,222 | $597,485 | $640,348 | $686,711 | $740,074 | $775,937 | $805,920 |
Total Liabilities and Capital | $1,251,641 | $969,013 | $978,931 | $1,012,084 | $1,041,092 | $1,081,836 | $1,127,019 | $1,171,862 | $1,214,145 | $1,261,958 | $1,318,221 | $1,346,834 | $1,374,381 |
Net Worth | $363,243 | $398,406 | $415,719 | $444,232 | $473,095 | $510,359 | $553,222 | $597,485 | $640,348 | $686,711 | $740,074 | $775,937 | $805,920 |