Evergreen TV Productions
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 | |||||||||||||
Photo Memories | 0% | 15 | 20 | 40 | 50 | 60 | 60 | 70 | 80 | 95 | 90 | 100 | 120 |
News Story Reels | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 10 | 16 | 25 | 40 | 65 |
Tampa Bay Video | 0% | 0 | 0 | 0 | 2 | 3 | 5 | 12 | 2 | 2 | 18 | 2 | 2 |
Other Projects | 0% | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
Total Unit Sales | 16 | 20 | 41 | 52 | 64 | 65 | 87 | 92 | 114 | 133 | 143 | 187 | |
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 | |
Photo Memories | $200.00 | $200.00 | $200.00 | $200.00 | $250.00 | $250.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | |
News Story Reels | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | |
Tampa Bay Video | $0.00 | $0.00 | $0.00 | $0.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
Other Projects | $1,000.00 | $0.00 | $1,000.00 | $0.00 | $1,000.00 | $0.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | |
Sales | |||||||||||||
Photo Memories | $3,000 | $4,000 | $8,000 | $10,000 | $15,000 | $15,000 | $14,000 | $16,000 | $19,000 | $18,000 | $20,000 | $24,000 | |
News Story Reels | $0 | $0 | $0 | $0 | $0 | $0 | $800 | $2,000 | $3,200 | $5,000 | $8,000 | $13,000 | |
Tampa Bay Video | $0 | $0 | $0 | $0 | $150 | $250 | $600 | $100 | $100 | $900 | $100 | $100 | |
Other Projects | $1,000 | $0 | $1,000 | $0 | $1,000 | $0 | $1,000 | $0 | $1,000 | $0 | $1,000 | $0 | |
Total Sales | $4,000 | $4,000 | $9,000 | $10,000 | $16,150 | $15,250 | $16,400 | $18,100 | $23,300 | $23,900 | $29,100 | $37,100 | |
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 | |
Photo Memories | 0.00% | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 |
News Story Reels | 0.00% | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 |
Tampa Bay Video | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 |
Other Projects | 0.00% | $75.00 | $0.00 | $50.00 | $0.00 | $500.00 | $0.00 | $500.00 | $0.00 | $500.00 | $0.00 | $500.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Photo Memories | $45 | $60 | $120 | $150 | $180 | $180 | $210 | $240 | $285 | $270 | $300 | $360 | |
News Story Reels | $0 | $0 | $0 | $0 | $0 | $0 | $60 | $150 | $240 | $375 | $600 | $975 | |
Tampa Bay Video | $0 | $0 | $0 | $0 | $15 | $25 | $60 | $10 | $10 | $90 | $10 | $10 | |
Other Projects | $75 | $0 | $50 | $0 | $500 | $0 | $500 | $0 | $500 | $0 | $500 | $0 | |
Subtotal Direct Cost of Sales | $120 | $60 | $170 | $150 | $695 | $205 | $830 | $400 | $1,035 | $735 | $1,410 | $1,345 |
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 | |||||||||||||
Photo Editor | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Photo Editor | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Photo Editor | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | |
Photo Editor (2) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,500 | |
Additional Employees (3 stores) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Additional Employees (5 stores) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $0 | $0 | $1,500 | $3,000 | $3,000 | $3,000 | $3,000 | $4,500 | $4,500 | $4,500 | $6,000 | |
Sales and Marketing Personnel | |||||||||||||
Marketing Manager (President) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
News Sales Representative | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,666 | $1,666 | $1,666 | |
News Sales Representative Commission | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $500 | $1,000 | $1,500 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,166 | $2,666 | $3,166 | |
General and Administrative Personnel | |||||||||||||
Store Manager | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
Store Manager Commission | $0 | $300 | $300 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Store Manager (2) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,600 | $1,600 | |
Store Manager Commission (2) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $400 | $400 | |
Store Mgr/Commission (3 & 5 stores) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $1,900 | $1,900 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | |
Other Personnel | |||||||||||||
President | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $3,500 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | |
Operations Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Home Division Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
B2B Division Manager | $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 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $3,500 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | |
Total People | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 5 | 6 | 6 | 8 | |
Total Payroll | $2,500 | $4,400 | $4,400 | $6,000 | $7,500 | $7,500 | $8,500 | $8,500 | $10,000 | $12,666 | $15,166 | $17,166 |
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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | |
Long-term Interest Rate | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | |
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 | $4,000 | $4,000 | $9,000 | $10,000 | $16,150 | $15,250 | $16,400 | $18,100 | $23,300 | $23,900 | $29,100 | $37,100 | |
Direct Cost of Sales | $120 | $60 | $170 | $150 | $695 | $205 | $830 | $400 | $1,035 | $735 | $1,410 | $1,345 | |
Production Payroll | $0 | $0 | $0 | $1,500 | $3,000 | $3,000 | $3,000 | $3,000 | $4,500 | $4,500 | $4,500 | $6,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $120 | $60 | $170 | $1,650 | $3,695 | $3,205 | $3,830 | $3,400 | $5,535 | $5,235 | $5,910 | $7,345 | |
Gross Margin | $3,880 | $3,940 | $8,830 | $8,350 | $12,455 | $12,045 | $12,570 | $14,700 | $17,765 | $18,665 | $23,190 | $29,755 | |
Gross Margin % | 97.00% | 98.50% | 98.11% | 83.50% | 77.12% | 78.98% | 76.65% | 81.22% | 76.24% | 78.10% | 79.69% | 80.20% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,166 | $2,666 | $3,166 | |
Advertising/Promotion | $2,000 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Travel | $0 | $0 | $0 | $0 | $0 | $750 | $750 | $750 | $750 | $1,500 | $1,000 | $1,000 | |
Miscellaneous | $500 | $500 | $500 | $500 | $500 | $500 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,500 | |
Total Sales and Marketing Expenses | $2,500 | $2,000 | $2,000 | $2,500 | $2,500 | $3,250 | $3,250 | $3,250 | $3,250 | $6,166 | $6,166 | $7,166 | |
Sales and Marketing % | 62.50% | 50.00% | 22.22% | 25.00% | 15.48% | 21.31% | 19.82% | 17.96% | 13.95% | 25.80% | 21.19% | 19.32% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $0 | $1,900 | $1,900 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | |
Sales and Marketing and Other Expenses | $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 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $160 | |
Insurance | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $160 | |
Rent | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $1,500 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $930 | $2,830 | $2,830 | $2,930 | $2,930 | $2,930 | $2,930 | $2,930 | $2,930 | $2,930 | $4,930 | $5,820 | |
General and Administrative % | 23.25% | 70.75% | 31.44% | 29.30% | 18.14% | 19.21% | 17.87% | 16.19% | 12.58% | 12.26% | 16.94% | 15.69% | |
Other Expenses: | |||||||||||||
Other Payroll | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $3,500 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | |
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 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $3,500 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | |
Other % | 62.50% | 62.50% | 27.78% | 25.00% | 15.48% | 16.39% | 21.34% | 19.34% | 15.02% | 16.74% | 13.75% | 10.78% | |
Total Operating Expenses | $5,930 | $7,330 | $7,330 | $7,930 | $7,930 | $8,680 | $9,680 | $9,680 | $9,680 | $13,096 | $15,096 | $16,986 | |
Profit Before Interest and Taxes | ($2,050) | ($3,390) | $1,500 | $420 | $4,525 | $3,365 | $2,890 | $5,020 | $8,085 | $5,569 | $8,094 | $12,769 | |
EBITDA | ($2,050) | ($3,390) | $1,500 | $420 | $4,525 | $3,365 | $2,890 | $5,020 | $8,085 | $5,569 | $8,094 | $12,769 | |
Interest Expense | $54 | $44 | $42 | $40 | $38 | $36 | $34 | $32 | $30 | $28 | $26 | $24 | |
Taxes Incurred | ($631) | ($858) | $365 | $95 | $1,122 | $832 | $714 | $1,247 | $2,014 | $1,385 | $2,017 | $3,186 | |
Net Profit | ($1,473) | ($2,575) | $1,094 | $285 | $3,366 | $2,497 | $2,142 | $3,741 | $6,042 | $4,156 | $6,051 | $9,559 | |
Net Profit/Sales | -36.82% | -64.38% | 12.15% | 2.85% | 20.84% | 16.37% | 13.06% | 20.67% | 25.93% | 17.39% | 20.80% | 25.77% |
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 | $4,000 | $4,000 | $9,000 | $10,000 | $16,150 | $15,250 | $16,400 | $18,100 | $23,300 | $23,900 | $29,100 | $37,100 | |
Subtotal Cash from Operations | $4,000 | $4,000 | $9,000 | $10,000 | $16,150 | $15,250 | $16,400 | $18,100 | $23,300 | $23,900 | $29,100 | $37,100 | |
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 | $5,000 | $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 | $9,000 | $4,000 | $9,000 | $10,000 | $16,150 | $15,250 | $16,400 | $18,100 | $23,300 | $23,900 | $29,100 | $37,100 | |
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 | $2,500 | $4,400 | $4,400 | $6,000 | $7,500 | $7,500 | $8,500 | $8,500 | $10,000 | $12,666 | $15,166 | $17,166 | |
Bill Payments | $528 | $3,795 | $2,156 | $3,344 | $3,632 | $5,571 | $5,082 | $6,050 | $5,539 | $7,866 | $7,366 | $8,106 | |
Subtotal Spent on Operations | $3,028 | $8,195 | $6,556 | $9,344 | $11,132 | $13,071 | $13,582 | $14,550 | $15,539 | $20,532 | $22,532 | $25,272 | |
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 | $980 | $185 | $185 | $185 | $185 | $185 | $185 | $185 | $185 | $185 | $185 | |
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 | $3,028 | $9,175 | $6,741 | $9,529 | $11,317 | $13,256 | $13,767 | $14,735 | $15,724 | $20,717 | $22,717 | $25,457 | |
Net Cash Flow | $5,972 | ($5,175) | $2,259 | $471 | $4,833 | $1,994 | $2,633 | $3,365 | $7,576 | $3,183 | $6,383 | $11,643 | |
Cash Balance | $20,072 | $14,897 | $17,156 | $17,627 | $22,460 | $24,453 | $27,086 | $30,451 | $38,027 | $41,210 | $47,593 | $59,236 |
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 | $14,100 | $20,072 | $14,897 | $17,156 | $17,627 | $22,460 | $24,453 | $27,086 | $30,451 | $38,027 | $41,210 | $47,593 | $59,236 |
Inventory | $0 | $880 | $820 | $650 | $500 | $805 | $600 | $913 | $513 | $1,139 | $1,404 | $1,551 | $1,480 |
Other Current Assets | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Total Current Assets | $14,600 | $21,452 | $16,217 | $18,306 | $18,627 | $23,765 | $25,553 | $28,499 | $31,464 | $39,665 | $43,113 | $49,644 | $61,216 |
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 | $14,600 | $21,452 | $16,217 | $18,306 | $18,627 | $23,765 | $25,553 | $28,499 | $31,464 | $39,665 | $43,113 | $49,644 | $61,216 |
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 | $400 | $3,724 | $2,045 | $3,225 | $3,446 | $5,403 | $4,880 | $5,868 | $5,277 | $7,621 | $7,098 | $7,762 | $9,960 |
Current Borrowing | $0 | $5,000 | $4,020 | $3,835 | $3,650 | $3,465 | $3,280 | $3,095 | $2,910 | $2,725 | $2,540 | $2,355 | $2,170 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $400 | $8,724 | $6,065 | $7,060 | $7,096 | $8,868 | $8,160 | $8,963 | $8,187 | $10,346 | $9,638 | $10,117 | $12,130 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $400 | $8,724 | $6,065 | $7,060 | $7,096 | $8,868 | $8,160 | $8,963 | $8,187 | $10,346 | $9,638 | $10,117 | $12,130 |
Paid-in Capital | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Retained Earnings | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) |
Earnings | $0 | ($1,473) | ($4,048) | ($2,954) | ($2,669) | $697 | $3,194 | $5,336 | $9,078 | $15,119 | $19,275 | $25,327 | $34,886 |
Total Capital | $14,200 | $12,727 | $10,152 | $11,246 | $11,531 | $14,897 | $17,394 | $19,536 | $23,278 | $29,319 | $33,475 | $39,527 | $49,086 |
Total Liabilities and Capital | $14,600 | $21,452 | $16,217 | $18,306 | $18,627 | $23,765 | $25,553 | $28,499 | $31,464 | $39,665 | $43,113 | $49,644 | $61,216 |
Net Worth | $14,200 | $12,727 | $10,152 | $11,246 | $11,531 | $14,897 | $17,394 | $19,536 | $23,278 | $29,319 | $33,475 | $39,527 | $49,086 |