Acme Insurance

Start your own business plan »

Insurance Company Business Plan

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