Employee Benefits Administration
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 | |||||||||||||
| COBRA/HIPAA | 0% | 0 | 0 | 0 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 |
| Flexible Spending | 0% | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 40 | 40 | 40 |
| Basic Admin | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| All Inclusive | 0% | 0 | 0 | 0 | 100 | 100 | 100 | 200 | 200 | 200 | 400 | 400 | 400 |
| Start-up Fees | 0% | 0 | 0 | 0 | 65 | 5 | 5 | 45 | 5 | 5 | 100 | 5 | 5 |
| Total Unit Sales | 0 | 0 | 0 | 295 | 240 | 245 | 490 | 455 | 460 | 990 | 900 | 905 | |
| 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 | |
| COBRA/HIPAA | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | $12.75 | |
| Flexible Spending | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | $7.50 | |
| Basic Admin | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | |
| All Inclusive | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | |
| Start-up Fees | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | |
| Sales | |||||||||||||
| COBRA/HIPAA | $0 | $0 | $0 | $255 | $319 | $383 | $446 | $510 | $574 | $638 | $701 | $765 | |
| Flexible Spending | $0 | $0 | $0 | $75 | $75 | $75 | $75 | $75 | $75 | $300 | $300 | $300 | |
| Basic Admin | $0 | $0 | $0 | $1,200 | $1,200 | $1,200 | $2,400 | $2,400 | $2,400 | $4,800 | $4,800 | $4,800 | |
| All Inclusive | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $3,600 | $3,600 | $3,600 | $7,200 | $7,200 | $7,200 | |
| Start-up Fees | $0 | $0 | $0 | $6,500 | $500 | $500 | $4,500 | $500 | $500 | $10,000 | $500 | $500 | |
| Total Sales | $0 | $0 | $0 | $9,830 | $3,894 | $3,958 | $11,021 | $7,085 | $7,149 | $22,938 | $13,501 | $13,565 | |
| 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 | |
| COBRA/HIPAA | 0.00% | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 |
| Flexible Spending | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Basic Admin | 0.00% | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 |
| All Inclusive | 0.00% | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 | $2.75 |
| Start-up Fees | 0.00% | $2.75 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| COBRA/HIPAA | $0 | $0 | $0 | $55 | $69 | $83 | $96 | $110 | $124 | $138 | $151 | $165 | |
| Flexible Spending | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Basic Admin | $0 | $0 | $0 | $275 | $275 | $275 | $550 | $550 | $550 | $1,100 | $1,100 | $1,100 | |
| All Inclusive | $0 | $0 | $0 | $275 | $275 | $275 | $550 | $550 | $550 | $1,100 | $1,100 | $1,100 | |
| Start-up Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $605 | $619 | $633 | $1,196 | $1,210 | $1,224 | $2,338 | $2,351 | $2,365 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketer Part Time | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| General and Administrative Personnel | |||||||||||||
| Cindy Wells | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
| Diane Davis | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
| Administrative Assistant Part Time | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,084 | $1,084 | $1,084 | |
| Benefits Administrator | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Receptionist Part Time | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Benefits Administrator | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $6,084 | $6,084 | $6,084 | |
| Other Personnel | |||||||||||||
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | |
| Total Payroll | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $6,084 | $6,084 | $6,084 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | $0 | $0 | $0 | $9,830 | $3,894 | $3,958 | $11,021 | $7,085 | $7,149 | $22,938 | $13,501 | $13,565 | |
| Direct Cost of Sales | $0 | $0 | $0 | $605 | $619 | $633 | $1,196 | $1,210 | $1,224 | $2,338 | $2,351 | $2,365 | |
| Production Payroll | $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 Cost of Sales | $0 | $0 | $0 | $605 | $619 | $633 | $1,196 | $1,210 | $1,224 | $2,338 | $2,351 | $2,365 | |
| Gross Margin | $0 | $0 | $0 | $9,225 | $3,275 | $3,325 | $9,825 | $5,875 | $5,925 | $20,600 | $11,150 | $11,200 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 93.85% | 84.11% | 84.02% | 89.15% | 82.92% | 82.88% | 89.81% | 82.58% | 82.57% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Advertising/Promotion | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Travel | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Miscellaneous | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
| Total Sales and Marketing Expenses | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 1.53% | 3.85% | 3.79% | 1.36% | 2.12% | 2.10% | 0.65% | 1.11% | 1.11% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $6,084 | $6,084 | $6,084 | |
| Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Depreciation | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | $85 | |
| Dues and Subscriptions | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Professional Fees | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
| Rent | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Software Purchases | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Telephone and Internet Access | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Miscellaneous | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Payroll Taxes | 8% | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $487 | $487 | $487 |
| Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total General and Administrative Expenses | $6,985 | $6,985 | $6,985 | $6,985 | $6,985 | $6,985 | $6,985 | $6,985 | $6,985 | $8,156 | $8,156 | $8,156 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 71.06% | 179.39% | 176.50% | 63.38% | 98.59% | 97.71% | 35.56% | 60.41% | 60.12% | |
| Other Expenses: | |||||||||||||
| Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | $7,135 | $7,135 | $7,135 | $7,135 | $7,135 | $7,135 | $7,135 | $7,135 | $7,135 | $8,306 | $8,306 | $8,306 | |
| Profit Before Interest and Taxes | ($7,135) | ($7,135) | ($7,135) | $2,090 | ($3,860) | ($3,810) | $2,690 | ($1,260) | ($1,210) | $12,294 | $2,844 | $2,894 | |
| EBITDA | ($7,050) | ($7,050) | ($7,050) | $2,175 | ($3,775) | ($3,725) | $2,775 | ($1,175) | ($1,125) | $12,379 | $2,929 | $2,979 | |
| Interest Expense | $0 | $375 | $375 | $370 | $365 | $360 | $355 | $350 | $345 | $339 | $334 | $329 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($7,135) | ($7,510) | ($7,510) | $1,720 | ($4,225) | ($4,170) | $2,335 | ($1,610) | ($1,555) | $11,955 | $2,510 | $2,565 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 17.50% | -108.51% | -105.37% | 21.19% | -22.72% | -21.75% | 52.12% | 18.59% | 18.91% | |
| 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 | $0 | $0 | $0 | $328 | $9,632 | $3,896 | $4,193 | $10,890 | $7,087 | $7,675 | $22,623 | |
| Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $328 | $9,632 | $3,896 | $4,193 | $10,890 | $7,087 | $7,675 | $22,623 | |
| 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 | $50,000 | $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 | $50,000 | $0 | $0 | $328 | $9,632 | $3,896 | $4,193 | $10,890 | $7,087 | $7,675 | $22,623 | |
| 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 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $6,084 | $6,084 | $6,084 | |
| Bill Payments | $68 | $2,063 | $2,425 | $2,445 | $3,025 | $3,034 | $3,061 | $3,601 | $3,610 | $3,658 | $4,814 | $4,822 | |
| Subtotal Spent on Operations | $5,068 | $7,063 | $7,425 | $7,445 | $8,025 | $8,034 | $8,061 | $8,601 | $8,610 | $9,742 | $10,898 | $10,906 | |
| 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 | $663 | $669 | $673 | $678 | $683 | $688 | $693 | $699 | $704 | |
| 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 | $5,068 | $7,063 | $7,425 | $8,108 | $8,694 | $8,707 | $8,739 | $9,284 | $9,298 | $10,435 | $11,597 | $11,610 | |
| Net Cash Flow | ($5,068) | $42,938 | ($7,425) | ($8,108) | ($8,367) | $925 | ($4,843) | ($5,091) | $1,592 | ($3,348) | ($3,922) | $11,013 | |
| Cash Balance | $5,932 | $48,869 | $41,444 | $33,336 | $24,970 | $25,895 | $21,051 | $15,960 | $17,552 | $14,204 | $10,282 | $21,295 | |
| 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 | $11,000 | $5,932 | $48,869 | $41,444 | $33,336 | $24,970 | $25,895 | $21,051 | $15,960 | $17,552 | $14,204 | $10,282 | $21,295 |
| Accounts Receivable | $0 | $0 | $0 | $0 | $9,830 | $13,396 | $7,721 | $14,847 | $17,739 | $13,998 | $29,848 | $35,674 | $26,616 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $11,000 | $5,932 | $48,869 | $41,444 | $43,166 | $38,366 | $33,616 | $35,898 | $33,699 | $31,550 | $44,052 | $45,956 | $47,911 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $85 | $170 | $255 | $340 | $425 | $510 | $595 | $680 | $765 | $850 | $935 | $1,020 |
| Total Long-term Assets | $0 | ($85) | ($170) | ($255) | ($340) | ($425) | ($510) | ($595) | ($680) | ($765) | ($850) | ($935) | ($1,020) |
| Total Assets | $11,000 | $5,847 | $48,699 | $41,189 | $42,826 | $37,941 | $33,106 | $35,303 | $33,019 | $30,785 | $43,202 | $45,021 | $46,891 |
| 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 | $0 | $1,982 | $2,344 | $2,344 | $2,924 | $2,933 | $2,941 | $3,481 | $3,489 | $3,498 | $4,653 | $4,661 | $4,670 |
| Current Borrowing | $0 | $0 | $50,000 | $50,000 | $49,337 | $48,668 | $47,995 | $47,317 | $46,634 | $45,946 | $45,253 | $44,554 | $43,850 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $0 | $1,982 | $52,344 | $52,344 | $52,261 | $51,601 | $50,936 | $50,798 | $50,123 | $49,444 | $49,906 | $49,215 | $48,520 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $1,982 | $52,344 | $52,344 | $52,261 | $51,601 | $50,936 | $50,798 | $50,123 | $49,444 | $49,906 | $49,215 | $48,520 |
| Paid-in Capital | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 | $31,428 |
| Retained Earnings | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) | ($20,428) |
| Earnings | $0 | ($7,135) | ($14,645) | ($22,155) | ($20,435) | ($24,660) | ($28,830) | ($26,495) | ($28,105) | ($29,659) | ($17,704) | ($15,194) | ($12,629) |
| Total Capital | $11,000 | $3,865 | ($3,645) | ($11,155) | ($9,435) | ($13,660) | ($17,830) | ($15,495) | ($17,105) | ($18,659) | ($6,704) | ($4,194) | ($1,629) |
| Total Liabilities and Capital | $11,000 | $5,847 | $48,699 | $41,189 | $42,826 | $37,941 | $33,106 | $35,303 | $33,019 | $30,785 | $43,202 | $45,021 | $46,891 |
| Net Worth | $11,000 | $3,865 | ($3,645) | ($11,155) | ($9,435) | ($13,660) | ($17,830) | ($15,495) | ($17,105) | ($18,659) | ($6,704) | ($4,194) | ($1,629) |
By 
