Plynthe Insurance
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 | |||||||||||||
Propery Insurance | 25 | 29 | 32 | 37 | 42 | 48 | 55 | 63 | 71 | 81 | 93 | 106 | |
Life Insurance | 12 | 13 | 15 | 17 | 20 | 22 | 25 | 28 | 37 | 38 | 42 | 49 | |
Long Term Care/Disability | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | 5 | 6 | 8 | |
Valuable Items | 13 | 15 | 17 | 20 | 23 | 26 | 29 | 33 | 38 | 43 | 49 | 57 | |
Personal Liability | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 7 | 11 | 15 | 18 | |
Total Unit Sales | 50 | 57 | 64 | 74 | 85 | 97 | 112 | 130 | 156 | 178 | 205 | 238 | |
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 | |
Propery Insurance | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | |
Life Insurance | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | |
Long Term Care/Disability | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | |
Valuable Items | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | |
Personal Liability | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | |
Sales | |||||||||||||
Propery Insurance | $2,500 | $2,900 | $3,200 | $3,700 | $4,200 | $4,800 | $5,500 | $6,300 | $7,100 | $8,100 | $9,300 | $10,600 | |
Life Insurance | $1,800 | $1,950 | $2,250 | $2,550 | $3,000 | $3,300 | $3,750 | $4,200 | $5,550 | $5,700 | $6,300 | $7,350 | |
Long Term Care/Disability | $0 | $0 | $0 | $0 | $0 | $150 | $150 | $300 | $450 | $750 | $900 | $1,200 | |
Valuable Items | $975 | $1,125 | $1,275 | $1,500 | $1,725 | $1,950 | $2,175 | $2,475 | $2,850 | $3,225 | $3,675 | $4,275 | |
Personal Liability | $0 | $0 | $0 | $0 | $0 | $0 | $150 | $300 | $525 | $825 | $1,125 | $1,350 | |
Total Sales | $5,275 | $5,975 | $6,725 | $7,750 | $8,925 | $10,200 | $11,725 | $13,575 | $16,475 | $18,600 | $21,300 | $24,775 | |
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 | |
Propery Insurance | 16.00% | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 | $16.00 |
Life Insurance | 16.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Long Term Care/Disability | 16.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Valuable Items | 16.00% | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 |
Personal Liability | 16.00% | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 |
Direct Cost of Sales | |||||||||||||
Propery Insurance | $400 | $464 | $512 | $592 | $672 | $768 | $880 | $1,008 | $1,136 | $1,296 | $1,488 | $1,696 | |
Life Insurance | $288 | $312 | $360 | $408 | $480 | $528 | $600 | $672 | $888 | $912 | $1,008 | $1,176 | |
Long Term Care/Disability | $0 | $0 | $0 | $0 | $0 | $24 | $24 | $48 | $72 | $120 | $144 | $192 | |
Valuable Items | $156 | $180 | $204 | $240 | $276 | $312 | $348 | $396 | $456 | $516 | $588 | $684 | |
Personal Liability | $0 | $0 | $0 | $0 | $0 | $0 | $24 | $48 | $84 | $132 | $180 | $216 | |
Subtotal Direct Cost of Sales | $844 | $956 | $1,076 | $1,240 | $1,428 | $1,632 | $1,876 | $2,172 | $2,636 | $2,976 | $3,408 | $3,964 |
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 | ||
Kolem Plynthe | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Associate Agent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 |
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 | $5,275 | $5,975 | $6,725 | $7,750 | $8,925 | $10,200 | $11,725 | $13,575 | $16,475 | $18,600 | $21,300 | $24,775 | |
Direct Cost of Sales | $844 | $956 | $1,076 | $1,240 | $1,428 | $1,632 | $1,876 | $2,172 | $2,636 | $2,976 | $3,408 | $3,964 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $844 | $956 | $1,076 | $1,240 | $1,428 | $1,632 | $1,876 | $2,172 | $2,636 | $2,976 | $3,408 | $3,964 | |
Gross Margin | $4,431 | $5,019 | $5,649 | $6,510 | $7,497 | $8,568 | $9,849 | $11,403 | $13,839 | $15,624 | $17,892 | $20,811 | |
Gross Margin % | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | |
Expenses | |||||||||||||
Payroll | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Marketing/Promotion | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Utilities | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $450 | $450 | $450 | $600 | $600 | $600 | $600 | $600 | $750 | $750 | $750 | $750 |
Education | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Total Operating Expenses | $6,300 | $6,300 | $6,300 | $7,450 | $7,450 | $7,450 | $7,450 | $7,450 | $8,600 | $8,600 | $8,600 | $8,600 | |
Profit Before Interest and Taxes | ($1,869) | ($1,281) | ($651) | ($940) | $47 | $1,118 | $2,399 | $3,953 | $5,239 | $7,024 | $9,292 | $12,211 | |
EBITDA | ($1,869) | ($1,281) | ($651) | ($940) | $47 | $1,118 | $2,399 | $3,953 | $5,239 | $7,024 | $9,292 | $12,211 | |
Interest Expense | $48 | $45 | $42 | $39 | $35 | $32 | $27 | $23 | $18 | $12 | $6 | $0 | |
Taxes Incurred | ($575) | ($398) | ($208) | ($294) | $3 | $326 | $712 | $1,179 | $1,566 | $2,103 | $2,786 | $3,663 | |
Net Profit | ($1,342) | ($928) | ($485) | ($685) | $8 | $761 | $1,660 | $2,751 | $3,655 | $4,908 | $6,500 | $8,548 | |
Net Profit/Sales | -25.44% | -15.54% | -7.21% | -8.84% | 0.09% | 7.46% | 14.16% | 20.27% | 22.18% | 26.39% | 30.52% | 34.50% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $176 | $5,298 | $6,000 | $6,759 | $7,789 | $8,968 | $10,251 | $11,787 | $13,672 | $16,546 | $18,690 | |
Subtotal Cash from Operations | $0 | $176 | $5,298 | $6,000 | $6,759 | $7,789 | $8,968 | $10,251 | $11,787 | $13,672 | $16,546 | $18,690 | |
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 | $0 | $176 | $5,298 | $6,000 | $6,759 | $7,789 | $8,968 | $10,251 | $11,787 | $13,672 | $16,546 | $18,690 | |
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 | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Bill Payments | $1,121 | $3,626 | $3,913 | $4,218 | $4,451 | $4,934 | $5,460 | $6,090 | $6,857 | $7,849 | $8,729 | $9,848 | |
Subtotal Spent on Operations | $4,121 | $6,626 | $6,913 | $8,218 | $8,451 | $8,934 | $9,460 | $10,090 | $11,857 | $12,849 | $13,729 | $14,848 | |
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 | $175 | $218 | $238 | $259 | $282 | $307 | $335 | $365 | $398 | $434 | $473 | $516 | |
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 | $4,296 | $6,844 | $7,151 | $8,477 | $8,733 | $9,241 | $9,795 | $10,455 | $12,255 | $13,283 | $14,202 | $15,364 | |
Net Cash Flow | ($4,296) | ($6,668) | ($1,853) | ($2,477) | ($1,974) | ($1,452) | ($828) | ($204) | ($468) | $388 | $2,344 | $3,326 | |
Cash Balance | $19,704 | $13,036 | $11,183 | $8,706 | $6,732 | $5,280 | $4,452 | $4,248 | $3,779 | $4,168 | $6,512 | $9,838 |
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 | $24,000 | $19,704 | $13,036 | $11,183 | $8,706 | $6,732 | $5,280 | $4,452 | $4,248 | $3,779 | $4,168 | $6,512 | $9,838 |
Accounts Receivable | $0 | $5,275 | $11,074 | $12,501 | $14,251 | $16,417 | $18,827 | $21,585 | $24,909 | $29,598 | $34,526 | $39,280 | $45,365 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $24,000 | $24,979 | $24,110 | $23,684 | $22,957 | $23,149 | $24,107 | $26,037 | $29,157 | $33,377 | $38,694 | $45,792 | $55,203 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $24,000 | $24,979 | $24,110 | $23,684 | $22,957 | $23,149 | $24,107 | $26,037 | $29,157 | $33,377 | $38,694 | $45,792 | $55,203 |
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 | $1,000 | $3,496 | $3,773 | $4,070 | $4,287 | $4,753 | $5,258 | $5,863 | $6,596 | $7,559 | $8,402 | $9,473 | $10,853 |
Current Borrowing | $4,000 | $3,825 | $3,607 | $3,369 | $3,110 | $2,828 | $2,521 | $2,186 | $1,821 | $1,423 | $989 | $516 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $5,000 | $7,321 | $7,380 | $7,439 | $7,397 | $7,581 | $7,779 | $8,049 | $8,417 | $8,982 | $9,391 | $9,989 | $10,853 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $5,000 | $7,321 | $7,380 | $7,439 | $7,397 | $7,581 | $7,779 | $8,049 | $8,417 | $8,982 | $9,391 | $9,989 | $10,853 |
Paid-in Capital | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 |
Retained Earnings | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) | ($8,000) |
Earnings | $0 | ($1,342) | ($2,270) | ($2,755) | ($3,440) | ($3,432) | ($2,672) | ($1,012) | $1,740 | $5,394 | $10,303 | $16,802 | $25,350 |
Total Capital | $19,000 | $17,658 | $16,730 | $16,245 | $15,560 | $15,568 | $16,328 | $17,988 | $20,740 | $24,394 | $29,303 | $35,802 | $44,350 |
Total Liabilities and Capital | $24,000 | $24,979 | $24,110 | $23,684 | $22,957 | $23,149 | $24,107 | $26,037 | $29,157 | $33,377 | $38,694 | $45,792 | $55,203 |
Net Worth | $19,000 | $17,658 | $16,730 | $16,245 | $15,560 | $15,568 | $16,328 | $17,988 | $20,740 | $24,394 | $29,303 | $35,802 | $44,350 |