Our biggest savings of the year
Comgate
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Unit Sales | |||||||||||||
Crown Molding | 0% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 342 | 342 | 342 |
Pilasters | 0% | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 22 | 22 | 22 |
Haunched Passage Doors (Paint Grade) | 0% | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 27 | 27 | 27 |
Haunched Passage Doors (Stain Grade) | 0% | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 27 | 27 | 27 |
Cabinets | 0% | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 77 | 77 | 77 |
Site Work | 0% | 523 | 523 | 523 | 523 | 523 | 523 | 523 | 523 | 523 | 980 | 980 | 980 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 971 | 971 | 971 | 971 | 971 | 971 | 971 | 971 | 971 | 1,475 | 1,475 | 1,475 | |
Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Crown Molding | $4.20 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | |
Pilasters | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | $316.96 | |
Haunched Passage Doors (Paint Grade) | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | $592.35 | |
Haunched Passage Doors (Stain Grade) | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | $783.09 | |
Cabinets | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | $194.76 | |
Site Work | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | $35.33 | |
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 | |
Sales | |||||||||||||
Crown Molding | $1,499 | $1,428 | $1,428 | $1,428 | $1,428 | $1,428 | $1,428 | $1,428 | $1,428 | $1,368 | $1,368 | $1,368 | |
Pilasters | $5,388 | $5,388 | $5,388 | $5,388 | $5,388 | $5,388 | $5,388 | $5,388 | $5,388 | $6,973 | $6,973 | $6,973 | |
Haunched Passage Doors (Paint Grade) | $10,070 | $10,070 | $10,070 | $10,070 | $10,070 | $10,070 | $10,070 | $10,070 | $10,070 | $15,993 | $15,993 | $15,993 | |
Haunched Passage Doors (Stain Grade) | $13,313 | $13,313 | $13,313 | $13,313 | $13,313 | $13,313 | $13,313 | $13,313 | $13,313 | $21,143 | $21,143 | $21,143 | |
Cabinets | $7,790 | $7,790 | $7,790 | $7,790 | $7,790 | $7,790 | $7,790 | $7,790 | $7,790 | $14,997 | $14,997 | $14,997 | |
Site Work | $18,478 | $18,478 | $18,478 | $18,478 | $18,478 | $18,478 | $18,478 | $18,478 | $18,478 | $34,623 | $34,623 | $34,623 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $56,538 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $95,098 | $95,098 | $95,098 | |
Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Crown Molding | 0.00% | $2.06 | $2.06 | $2.06 | $2.06 | $2.06 | $2.06 | $2.06 | $2.06 | $2.06 | $1.82 | $1.82 | $1.82 |
Pilasters | 0.00% | $50.04 | $50.04 | $50.04 | $50.04 | $50.04 | $50.04 | $50.04 | $50.04 | $50.04 | $44.09 | $44.09 | $44.09 |
Haunched Passage Doors (Paint Grade) | 0.00% | $148.15 | $148.15 | $148.15 | $148.15 | $148.15 | $148.15 | $148.15 | $148.15 | $148.15 | $130.53 | $130.53 | $130.53 |
Haunched Passage Doors (Stain Grade) | 0.00% | $281.34 | $281.34 | $281.34 | $281.34 | $281.34 | $281.34 | $281.34 | $281.34 | $281.34 | $247.88 | $247.88 | $247.88 |
Cabinets | 0.00% | $65.44 | $65.44 | $65.44 | $65.44 | $65.44 | $65.44 | $65.44 | $65.44 | $65.44 | $57.66 | $57.66 | $57.66 |
Site Work | 0.00% | $24.53 | $24.53 | $24.53 | $24.53 | $24.53 | $24.53 | $24.53 | $24.53 | $24.53 | $27.69 | $27.69 | $27.69 |
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 | $0.00 |
Direct Cost of Sales | |||||||||||||
Crown Molding | $735 | $735 | $735 | $735 | $735 | $735 | $735 | $735 | $735 | $622 | $622 | $622 | |
Pilasters | $851 | $851 | $851 | $851 | $851 | $851 | $851 | $851 | $851 | $970 | $970 | $970 | |
Haunched Passage Doors (Paint Grade) | $2,519 | $2,519 | $2,519 | $2,519 | $2,519 | $2,519 | $2,519 | $2,519 | $2,519 | $3,524 | $3,524 | $3,524 | |
Haunched Passage Doors (Stain Grade) | $4,783 | $4,783 | $4,783 | $4,783 | $4,783 | $4,783 | $4,783 | $4,783 | $4,783 | $6,693 | $6,693 | $6,693 | |
Cabinets | $2,618 | $2,618 | $2,618 | $2,618 | $2,618 | $2,618 | $2,618 | $2,618 | $2,618 | $4,440 | $4,440 | $4,440 | |
Site Work | $12,829 | $12,829 | $12,829 | $12,829 | $12,829 | $12,829 | $12,829 | $12,829 | $12,829 | $27,136 | $27,136 | $27,136 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $43,386 | $43,386 | $43,386 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Production Personnel | |||||||||||||
**David Malkinson | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,467 | $3,467 | $3,467 | |
**Simon Lang | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $2,890 | $2,890 | $2,890 | |
**Brian Mason | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,890 | $2,890 | $2,890 | |
Production/Project Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
**Charles Davidson | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,185 | $3,230 | $3,230 | $3,230 | |
Subtotal | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $12,477 | $12,477 | $12,477 | |
Sales and Marketing Personnel | |||||||||||||
Andrew Comins | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
General and Administrative Personnel | |||||||||||||
**Stacy Greer | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | |
Other Personnel | |||||||||||||
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 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $18,670 | $18,670 | $18,670 |
General Assumptions | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term 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% | |
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 | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $56,538 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $95,098 | $95,098 | $95,098 | |
Direct Cost of Sales | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $24,334 | $43,386 | $43,386 | $43,386 | |
Production Payroll | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $9,555 | $12,477 | $12,477 | $12,477 | |
Other | $3,089 | $3,089 | $3,089 | $3,089 | $3,089 | $3,089 | $3,089 | $3,089 | $5,539 | $5,539 | $5,539 | $5,539 | |
Total Cost of Sales | $36,978 | $36,978 | $36,978 | $36,978 | $36,978 | $36,978 | $36,978 | $36,978 | $39,428 | $61,402 | $61,402 | $61,402 | |
Gross Margin | $19,560 | $19,489 | $19,489 | $19,489 | $19,489 | $19,489 | $19,489 | $19,489 | $17,039 | $33,696 | $33,696 | $33,696 | |
Gross Margin % | 34.60% | 34.51% | 34.51% | 34.51% | 34.51% | 34.51% | 34.51% | 34.51% | 30.17% | 35.43% | 35.43% | 35.43% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
Advertising/Promotion | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Travel | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $100 | $100 | $100 | |
Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $3,383 | $3,383 | $3,383 | $3,383 | $3,383 | $3,383 | $3,383 | $3,383 | $3,383 | $3,433 | $3,433 | $3,433 | |
Sales and Marketing % | 5.98% | 5.99% | 5.99% | 5.99% | 5.99% | 5.99% | 5.99% | 5.99% | 5.99% | 3.61% | 3.61% | 3.61% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | $2,860 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $456 | $456 | $456 | $456 | $456 | $456 | $456 | $456 | $456 | $456 | $456 | $456 | |
Depreciation | $27 | $27 | $27 | $27 | $27 | $27 | $27 | $27 | $27 | $27 | $27 | $27 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
Fees and Permits | $390 | $390 | $390 | $390 | $390 | $390 | $390 | $390 | $390 | $390 | $390 | $390 | |
Office Supplies | $346 | $346 | $346 | $346 | $346 | $346 | $346 | $346 | $346 | $346 | $346 | $346 | |
Bank Charges | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | |
Rent | $196 | $196 | $196 | $196 | $196 | $196 | $196 | $196 | $196 | $196 | $196 | $196 | |
Payroll Taxes | 22% | $3,457 | $3,457 | $3,457 | $3,457 | $3,457 | $3,457 | $3,457 | $3,457 | $3,457 | $4,098 | $4,098 | $4,098 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $10,442 | $10,442 | $10,442 | $10,442 | $10,442 | $10,442 | $10,442 | $10,442 | $10,442 | $11,083 | $11,083 | $11,083 | |
General and Administrative % | 18.47% | 18.49% | 18.49% | 18.49% | 18.49% | 18.49% | 18.49% | 18.49% | 18.49% | 11.65% | 11.65% | 11.65% | |
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 | $1,925 | $1,925 | $1,925 | $1,925 | $1,925 | $3,625 | $1,925 | $1,925 | $3,725 | $5,550 | $5,150 | $5,200 | |
CAD Contract Employee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,633 | $1,633 | $1,633 | $1,633 | |
Total Other Expenses | $1,925 | $1,925 | $1,925 | $1,925 | $1,925 | $3,625 | $1,925 | $1,925 | $5,358 | $7,183 | $6,783 | $6,833 | |
Other % | 3.40% | 3.41% | 3.41% | 3.41% | 3.41% | 6.42% | 3.41% | 3.41% | 9.49% | 7.55% | 7.13% | 7.19% | |
Total Operating Expenses | $15,750 | $15,750 | $15,750 | $15,750 | $15,750 | $17,450 | $15,750 | $15,750 | $19,183 | $21,699 | $21,299 | $21,349 | |
Profit Before Interest and Taxes | $3,810 | $3,739 | $3,739 | $3,739 | $3,739 | $2,039 | $3,739 | $3,739 | ($2,144) | $11,997 | $12,397 | $12,347 | |
EBITDA | $6,030 | $5,959 | $5,959 | $5,959 | $5,959 | $4,259 | $5,959 | $5,959 | $76 | $14,217 | $14,617 | $14,567 | |
Interest Expense | $1,313 | $1,303 | $1,293 | $1,283 | $1,274 | $1,264 | $1,669 | $1,650 | $1,631 | $1,612 | $1,594 | $1,575 | |
Taxes Incurred | $749 | $609 | $611 | $614 | $616 | $194 | $518 | $522 | ($944) | $2,596 | $2,701 | $2,693 | |
Net Profit | $1,748 | $1,827 | $1,834 | $1,842 | $1,849 | $581 | $1,553 | $1,567 | ($2,831) | $7,789 | $8,103 | $8,079 | |
Net Profit/Sales | 3.09% | 3.24% | 3.25% | 3.26% | 3.27% | 1.03% | 2.75% | 2.77% | -5.01% | 8.19% | 8.52% | 8.50% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $80,657 | $82,541 | $56,536 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $57,754 | $95,098 | |
Subtotal Cash from Operations | $80,657 | $82,541 | $56,536 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $56,467 | $57,754 | $95,098 | |
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 | $54,072 | $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 | $108,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $80,657 | $82,541 | $164,536 | $56,467 | $56,467 | $56,467 | $110,539 | $56,467 | $56,467 | $56,467 | $57,754 | $95,098 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $15,748 | $18,670 | $18,670 | $18,670 | |
Bill Payments | $60,247 | $56,409 | $36,672 | $36,664 | $36,657 | $36,692 | $37,885 | $36,946 | $37,078 | $42,865 | $86,666 | $66,106 | |
Subtotal Spent on Operations | $75,995 | $72,157 | $52,420 | $52,412 | $52,405 | $52,440 | $53,633 | $52,694 | $52,826 | $61,535 | $105,336 | $84,776 | |
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 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Other Liabilities Principal Repayment | $0 | $8,126 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $0 | $2,400 | $2,400 | $2,400 | $2,300 | $2,400 | |
Purchase Other Current Assets | $0 | $0 | $0 | $2,855 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $0 | $50,000 | $0 | $0 | $60,412 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,992 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $77,295 | $81,583 | $103,720 | $56,567 | $53,705 | $114,152 | $53,733 | $61,186 | $55,326 | $64,035 | $107,736 | $87,276 | |
Net Cash Flow | $3,362 | $958 | $60,816 | ($101) | $2,762 | ($57,685) | $56,806 | ($4,719) | $1,140 | ($7,568) | ($49,982) | $7,822 | |
Cash Balance | $7,350 | $8,307 | $69,124 | $69,023 | $71,785 | $14,099 | $70,905 | $66,186 | $67,327 | $59,759 | $9,777 | $17,598 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $3,988 | $7,350 | $8,307 | $69,124 | $69,023 | $71,785 | $14,099 | $70,905 | $66,186 | $67,327 | $59,759 | $9,777 | $17,598 |
Accounts Receivable | $161,313 | $137,195 | $111,120 | $111,051 | $111,051 | $111,051 | $111,051 | $111,051 | $111,051 | $111,051 | $149,682 | $187,026 | $187,026 |
Inventory | $6,500 | $26,768 | $26,768 | $26,768 | $26,768 | $26,768 | $26,768 | $26,768 | $26,768 | $26,768 | $47,724 | $47,724 | $47,724 |
Other Current Assets | $0 | $0 | $0 | $0 | $2,855 | $2,855 | $2,855 | $2,855 | $2,855 | $2,855 | $2,855 | $2,855 | $2,855 |
Total Current Assets | $171,801 | $171,312 | $146,196 | $206,943 | $209,697 | $212,459 | $154,773 | $211,579 | $206,860 | $208,001 | $260,020 | $247,382 | $255,203 |
Long-term Assets | |||||||||||||
Long-term Assets | $140,203 | $140,203 | $140,203 | $190,203 | $190,203 | $190,203 | $250,615 | $250,615 | $250,615 | $250,615 | $250,615 | $250,615 | $250,615 |
Accumulated Depreciation | $104,893 | $107,113 | $109,333 | $111,553 | $113,773 | $115,993 | $118,213 | $120,433 | $122,653 | $124,873 | $127,093 | $129,313 | $131,533 |
Total Long-term Assets | $35,310 | $33,090 | $30,870 | $78,650 | $76,430 | $74,210 | $132,402 | $130,182 | $127,962 | $125,742 | $123,522 | $121,302 | $119,082 |
Total Assets | $207,111 | $204,402 | $177,066 | $285,593 | $286,127 | $286,669 | $287,175 | $341,761 | $334,822 | $333,743 | $383,542 | $368,684 | $374,285 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $58,344 | $55,187 | $35,450 | $35,442 | $35,435 | $35,428 | $36,654 | $35,714 | $35,701 | $39,952 | $84,463 | $63,902 | $63,924 |
Current Borrowing | $69,477 | $69,377 | $69,277 | $69,177 | $69,077 | $68,977 | $68,877 | $68,777 | $68,677 | $68,577 | $68,477 | $68,377 | $68,277 |
Other Current Liabilities | $10,000 | $10,000 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 | $1,874 |
Subtotal Current Liabilities | $137,821 | $134,564 | $106,601 | $106,493 | $106,386 | $106,279 | $107,405 | $106,365 | $106,252 | $110,403 | $154,814 | $134,153 | $134,075 |
Long-term Liabilities | $99,179 | $97,979 | $96,779 | $95,579 | $94,379 | $93,179 | $91,979 | $146,051 | $143,651 | $141,251 | $138,851 | $136,551 | $134,151 |
Total Liabilities | $237,000 | $232,543 | $203,380 | $202,072 | $200,765 | $199,458 | $199,384 | $252,416 | $249,903 | $251,654 | $293,665 | $270,704 | $268,226 |
Paid-in Capital | $2,000 | $2,000 | $2,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 |
Retained Earnings | ($65,014) | ($31,889) | ($31,889) | ($31,889) | ($31,889) | ($31,889) | ($31,889) | ($31,889) | ($37,881) | ($37,881) | ($37,881) | ($37,881) | ($37,881) |
Earnings | $33,125 | $1,748 | $3,575 | $5,409 | $7,251 | $9,100 | $9,681 | $11,234 | $12,801 | $9,969 | $17,758 | $25,861 | $33,940 |
Total Capital | ($29,889) | ($28,141) | ($26,314) | $83,520 | $85,362 | $87,211 | $87,792 | $89,345 | $84,920 | $82,088 | $89,877 | $97,980 | $106,059 |
Total Liabilities and Capital | $207,111 | $204,402 | $177,066 | $285,593 | $286,127 | $286,669 | $287,175 | $341,761 | $334,822 | $333,743 | $383,542 | $368,684 | $374,285 |
Net Worth | ($29,889) | ($28,141) | ($26,314) | $83,520 | $85,362 | $87,211 | $87,792 | $89,345 | $84,920 | $82,088 | $89,877 | $97,980 | $106,059 |