50% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Telemarketing Consultants Business Plan

Roth & Calder Telemarketing Professionals, Inc.

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

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
Sales
Large Companies 0% £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £9,000 £24,000
Medium Companies 0% £0 £0 £0 £0 £0 £2,000 £4,000 £4,000 £5,000 £5,000 £6,000 £7,000
Small Companies 0% £0 £0 £0 £0 £7,000 £5,000 £3,000 £26,000 £4,000 £7,000 £10,000 £7,000
Other 0% £0 £0 £0 £0 £0 £0 £7,000 £5,000 £12,000 £5,000 £2,000 £5,000
Total Sales £6,000 £6,000 £6,000 £6,000 £13,000 £13,000 £20,000 £41,000 £27,000 £23,000 £27,000 £43,000
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
All client projects £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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Mr. Thomas Roth - President 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Ms. Jane Calder - Operations Head/Principal Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Mrs. Susan Howell - Telemarketing Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Mr. Leonard Grey - Telemarketing Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Office Manager 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Cold Caller 0% £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120
Total People 0% 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
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 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 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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £6,000 £6,000 £6,000 £6,000 £13,000 £13,000 £20,000 £41,000 £27,000 £23,000 £27,000 £43,000
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 £500 £0 £700 £0 £0 £0 £0
Total Cost of Sales £0 £0 £0 £0 £0 £500 £0 £700 £0 £0 £0 £0
Gross Margin £6,000 £6,000 £6,000 £6,000 £13,000 £12,500 £20,000 £40,300 £27,000 £23,000 £27,000 £43,000
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 96.15% 100.00% 98.29% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
Sales and Marketing and Other Expenses £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Rent £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Utilities £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Insurance £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Payroll Taxes 15% £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223
Travel 15% £1,200 £3,000 £1,000 £2,000 £2,000 £3,000 £2,000 £1,000 £2,000 £3,000 £1,000 £3,000
Other £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Total Operating Expenses £21,393 £23,193 £21,193 £22,193 £22,193 £23,193 £22,193 £21,193 £22,193 £23,193 £21,193 £23,193
Profit Before Interest and Taxes (£15,393) (£17,193) (£15,193) (£16,193) (£9,193) (£10,693) (£2,193) £19,107 £4,807 (£193) £5,807 £19,807
EBITDA (£15,393) (£17,193) (£15,193) (£16,193) (£9,193) (£10,693) (£2,193) £19,107 £4,807 (£193) £5,807 £19,807
Interest Expense £433 £431 £428 £425 £422 £420 £417 £414 £412 £409 £406 £403
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£15,826) (£17,624) (£15,621) (£16,618) (£9,615) (£11,113) (£2,610) £18,693 £4,395 (£602) £5,401 £19,404
Net Profit/Sales -263.77% -293.73% -260.35% -276.97% -73.97% -85.48% -13.05% 45.59% 16.28% -2.62% 20.00% 45.12%
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 £1,500 £1,500 £1,500 £1,500 £3,250 £3,250 £5,000 £10,250 £6,750 £5,750 £6,750 £10,750
Cash from Receivables £0 £150 £4,500 £4,500 £4,500 £4,675 £9,750 £9,925 £15,525 £30,400 £20,150 £17,350
Subtotal Cash from Operations £1,500 £1,650 £6,000 £6,000 £7,750 £7,925 £14,750 £20,175 £22,275 £36,150 £26,900 £28,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 £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 £1,500 £1,500 £0 £0 £0 £0
Subtotal Cash Received £1,500 £1,650 £6,000 £6,000 £7,750 £7,925 £16,250 £21,675 £22,275 £36,150 £26,900 £28,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 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
Bill Payments £3,234 £7,066 £8,737 £6,834 £7,798 £7,845 £9,243 £7,780 £7,497 £7,818 £8,715 £6,846
Subtotal Spent on Operations £18,054 £21,886 £23,557 £21,654 £22,618 £22,665 £24,063 £22,600 £22,317 £22,638 £23,535 £21,666
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 £181 £181 £181 £181 £181 £181 £181 £181 £181 £181 £190
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £0 £181 £181 £181 £181 £181 £181 £181 £181 £181 £181 £190
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 £15,000
Subtotal Cash Spent £18,054 £22,248 £23,919 £22,016 £22,980 £23,027 £24,425 £22,962 £22,679 £23,000 £23,897 £37,046
Net Cash Flow (£16,554) (£20,598) (£17,919) (£16,016) (£15,230) (£15,102) (£8,175) (£1,287) (£404) £13,150 £3,003 (£8,946)
Cash Balance £100,746 £80,148 £62,229 £46,213 £30,983 £15,881 £7,706 £6,419 £6,015 £19,165 £22,168 £13,222
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 £117,300 £100,746 £80,148 £62,229 £46,213 £30,983 £15,881 £7,706 £6,419 £6,015 £19,165 £22,168 £13,222
Accounts Receivable £0 £4,500 £8,850 £8,850 £8,850 £14,100 £19,175 £24,425 £45,250 £49,975 £36,825 £36,925 £51,825
Other Current Assets £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Total Current Assets £122,300 £110,246 £93,998 £76,079 £60,063 £50,083 £40,056 £37,131 £56,669 £60,990 £60,990 £64,093 £70,047
Long-term Assets
Long-term Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Total Assets £132,300 £120,246 £103,998 £86,079 £70,063 £60,083 £50,056 £47,131 £66,669 £70,990 £70,990 £74,093 £80,047
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 £3,000 £6,773 £8,510 £6,574 £7,538 £7,536 £8,983 £7,530 £7,238 £7,525 £8,489 £6,553 £8,484
Current Borrowing £16,000 £16,000 £15,819 £15,638 £15,457 £15,276 £15,095 £14,914 £14,733 £14,552 £14,371 £14,190 £14,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £19,000 £22,773 £24,329 £22,212 £22,995 £22,812 £24,078 £22,444 £21,971 £22,077 £22,860 £20,743 £22,484
Long-term Liabilities £45,000 £45,000 £44,819 £44,638 £44,457 £44,276 £44,095 £43,914 £43,733 £43,552 £43,371 £43,190 £43,000
Total Liabilities £64,000 £67,773 £69,148 £66,850 £67,452 £67,088 £68,173 £66,358 £65,704 £65,629 £66,231 £63,933 £65,484
Paid-in Capital £100,000 £100,000 £100,000 £100,000 £100,000 £100,000 £100,000 £101,500 £103,000 £103,000 £103,000 £103,000 £103,000
Retained Earnings (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£46,700)
Earnings £0 (£15,826) (£33,450) (£49,071) (£65,689) (£75,305) (£86,417) (£89,027) (£70,335) (£65,939) (£66,541) (£61,140) (£41,737)
Total Capital £68,300 £52,474 £34,850 £19,229 £2,611 (£7,005) (£18,117) (£19,227) £965 £5,361 £4,759 £10,160 £14,563
Total Liabilities and Capital £132,300 £120,246 £103,998 £86,079 £70,063 £60,083 £50,056 £47,131 £66,669 £70,990 £70,990 £74,093 £80,047
Net Worth £68,300 £52,474 £34,850 £19,229 £2,611 (£7,005) (£18,117) (£19,227) £965 £5,361 £4,759 £10,160 £14,563
previous
next
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
Sales
Large Companies 0% £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £6,000 £9,000 £24,000
Medium Companies 0% £0 £0 £0 £0 £0 £2,000 £4,000 £4,000 £5,000 £5,000 £6,000 £7,000
Small Companies 0% £0 £0 £0 £0 £7,000 £5,000 £3,000 £26,000 £4,000 £7,000 £10,000 £7,000
Other 0% £0 £0 £0 £0 £0 £0 £7,000 £5,000 £12,000 £5,000 £2,000 £5,000
Total Sales £6,000 £6,000 £6,000 £6,000 £13,000 £13,000 £20,000 £41,000 £27,000 £23,000 £27,000 £43,000
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
All client projects £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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Mr. Thomas Roth - President 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Ms. Jane Calder - Operations Head/Principal Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Mrs. Susan Howell - Telemarketing Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Mr. Leonard Grey - Telemarketing Consultant 0% £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000
Office Manager 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Cold Caller 0% £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120 £1,120
Total People 0% 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
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 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 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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £6,000 £6,000 £6,000 £6,000 £13,000 £13,000 £20,000 £41,000 £27,000 £23,000 £27,000 £43,000
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 £500 £0 £700 £0 £0 £0 £0
Total Cost of Sales £0 £0 £0 £0 £0 £500 £0 £700 £0 £0 £0 £0
Gross Margin £6,000 £6,000 £6,000 £6,000 £13,000 £12,500 £20,000 £40,300 £27,000 £23,000 £27,000 £43,000
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 96.15% 100.00% 98.29% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
Sales and Marketing and Other Expenses £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Rent £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Utilities £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Insurance £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Payroll Taxes 15% £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223 £2,223
Travel 15% £1,200 £3,000 £1,000 £2,000 £2,000 £3,000 £2,000 £1,000 £2,000 £3,000 £1,000 £3,000
Other £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Total Operating Expenses £21,393 £23,193 £21,193 £22,193 £22,193 £23,193 £22,193 £21,193 £22,193 £23,193 £21,193 £23,193
Profit Before Interest and Taxes (£15,393) (£17,193) (£15,193) (£16,193) (£9,193) (£10,693) (£2,193) £19,107 £4,807 (£193) £5,807 £19,807
EBITDA (£15,393) (£17,193) (£15,193) (£16,193) (£9,193) (£10,693) (£2,193) £19,107 £4,807 (£193) £5,807 £19,807
Interest Expense £433 £431 £428 £425 £422 £420 £417 £414 £412 £409 £406 £403
Taxes Incurred £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit (£15,826) (£17,624) (£15,621) (£16,618) (£9,615) (£11,113) (£2,610) £18,693 £4,395 (£602) £5,401 £19,404
Net Profit/Sales -263.77% -293.73% -260.35% -276.97% -73.97% -85.48% -13.05% 45.59% 16.28% -2.62% 20.00% 45.12%
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 £1,500 £1,500 £1,500 £1,500 £3,250 £3,250 £5,000 £10,250 £6,750 £5,750 £6,750 £10,750
Cash from Receivables £0 £150 £4,500 £4,500 £4,500 £4,675 £9,750 £9,925 £15,525 £30,400 £20,150 £17,350
Subtotal Cash from Operations £1,500 £1,650 £6,000 £6,000 £7,750 £7,925 £14,750 £20,175 £22,275 £36,150 £26,900 £28,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 £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 £1,500 £1,500 £0 £0 £0 £0
Subtotal Cash Received £1,500 £1,650 £6,000 £6,000 £7,750 £7,925 £16,250 £21,675 £22,275 £36,150 £26,900 £28,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 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820 £14,820
Bill Payments £3,234 £7,066 £8,737 £6,834 £7,798 £7,845 £9,243 £7,780 £7,497 £7,818 £8,715 £6,846
Subtotal Spent on Operations £18,054 £21,886 £23,557 £21,654 £22,618 £22,665 £24,063 £22,600 £22,317 £22,638 £23,535 £21,666
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 £181 £181 £181 £181 £181 £181 £181 £181 £181 £181 £190
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £0 £181 £181 £181 £181 £181 £181 £181 £181 £181 £181 £190
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 £15,000
Subtotal Cash Spent £18,054 £22,248 £23,919 £22,016 £22,980 £23,027 £24,425 £22,962 £22,679 £23,000 £23,897 £37,046
Net Cash Flow (£16,554) (£20,598) (£17,919) (£16,016) (£15,230) (£15,102) (£8,175) (£1,287) (£404) £13,150 £3,003 (£8,946)
Cash Balance £100,746 £80,148 £62,229 £46,213 £30,983 £15,881 £7,706 £6,419 £6,015 £19,165 £22,168 £13,222
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 £117,300 £100,746 £80,148 £62,229 £46,213 £30,983 £15,881 £7,706 £6,419 £6,015 £19,165 £22,168 £13,222
Accounts Receivable £0 £4,500 £8,850 £8,850 £8,850 £14,100 £19,175 £24,425 £45,250 £49,975 £36,825 £36,925 £51,825
Other Current Assets £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000 £5,000
Total Current Assets £122,300 £110,246 £93,998 £76,079 £60,063 £50,083 £40,056 £37,131 £56,669 £60,990 £60,990 £64,093 £70,047
Long-term Assets
Long-term Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Total Assets £132,300 £120,246 £103,998 £86,079 £70,063 £60,083 £50,056 £47,131 £66,669 £70,990 £70,990 £74,093 £80,047
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 £3,000 £6,773 £8,510 £6,574 £7,538 £7,536 £8,983 £7,530 £7,238 £7,525 £8,489 £6,553 £8,484
Current Borrowing £16,000 £16,000 £15,819 £15,638 £15,457 £15,276 £15,095 £14,914 £14,733 £14,552 £14,371 £14,190 £14,000
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £19,000 £22,773 £24,329 £22,212 £22,995 £22,812 £24,078 £22,444 £21,971 £22,077 £22,860 £20,743 £22,484
Long-term Liabilities £45,000 £45,000 £44,819 £44,638 £44,457 £44,276 £44,095 £43,914 £43,733 £43,552 £43,371 £43,190 £43,000
Total Liabilities £64,000 £67,773 £69,148 £66,850 £67,452 £67,088 £68,173 £66,358 £65,704 £65,629 £66,231 £63,933 £65,484
Paid-in Capital £100,000 £100,000 £100,000 £100,000 £100,000 £100,000 £100,000 £101,500 £103,000 £103,000 £103,000 £103,000 £103,000
Retained Earnings (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£31,700) (£46,700)
Earnings £0 (£15,826) (£33,450) (£49,071) (£65,689) (£75,305) (£86,417) (£89,027) (£70,335) (£65,939) (£66,541) (£61,140) (£41,737)
Total Capital £68,300 £52,474 £34,850 £19,229 £2,611 (£7,005) (£18,117) (£19,227) £965 £5,361 £4,759 £10,160 £14,563
Total Liabilities and Capital £132,300 £120,246 £103,998 £86,079 £70,063 £60,083 £50,056 £47,131 £66,669 £70,990 £70,990 £74,093 £80,047
Net Worth £68,300 £52,474 £34,850 £19,229 £2,611 (£7,005) (£18,117) (£19,227) £965 £5,361 £4,759 £10,160 £14,563