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

Pizzeria Franchise Business Plan

4 Moons Pizzeria

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
Total Restaurant Sales 0% £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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
Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
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
Wages 18% £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 14 14 14 14 14 14 14 14 14 14 14 14
Total Payroll £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Direct Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Gross Margin £23,000 £46,000 £46,231 £46,460 £46,693 £46,926 £47,161 £47,397 £47,633 £47,872 £48,111 £48,352
Gross Margin % 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Marketing/Promotion 4% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Depreciation £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500
Rent £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242
Royalty fees 5% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Equip rent/repair £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Utilities 11% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Admin charges £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Total Operating Expenses £17,242 £17,592 £17,644 £17,696 £17,748 £17,800 £17,853 £17,906 £17,960 £18,013 £18,067 £18,121
Profit Before Interest and Taxes £5,758 £28,408 £28,587 £28,764 £28,945 £29,126 £29,308 £29,491 £29,673 £29,859 £30,044 £30,231
EBITDA £8,258 £30,908 £31,087 £31,264 £31,445 £31,626 £31,808 £31,991 £32,173 £32,359 £32,544 £32,731
Interest Expense £2,013 £2,001 £1,989 £1,977 £1,966 £1,954 £1,942 £1,930 £1,918 £1,905 £1,893 £1,881
Taxes Incurred £1,124 £7,922 £7,979 £8,036 £8,094 £8,152 £8,210 £8,268 £8,327 £8,386 £8,445 £8,505
Net Profit £2,622 £18,485 £18,619 £18,751 £18,886 £19,020 £19,156 £19,293 £19,429 £19,567 £19,706 £19,845
Net Profit/Sales 9.12% 32.15% 32.22% 32.29% 32.36% 32.43% 32.49% 32.56% 32.63% 32.70% 32.77% 32.83%
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Subtotal Cash from Operations £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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 £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Bill Payments £263 £8,538 £27,619 £26,300 £26,404 £26,506 £26,612 £26,717 £26,822 £26,929 £27,034 £27,142
Subtotal Spent on Operations £10,263 £18,888 £38,021 £36,753 £36,910 £37,065 £37,224 £37,382 £37,539 £37,700 £37,860 £38,021
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 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £0 £1,993 £2,005 £2,017 £2,028 £2,040 £2,052 £2,064 £2,076 £2,088 £2,100 £2,113
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 £10,263 £20,881 £40,026 £38,770 £38,938 £39,105 £39,276 £39,446 £39,615 £39,788 £39,960 £40,134
Net Cash Flow £18,487 £36,619 £17,762 £19,306 £19,428 £19,553 £19,676 £19,800 £19,927 £20,052 £20,179 £20,306
Cash Balance £105,773 £142,393 £160,154 £179,460 £198,888 £218,441 £238,117 £257,918 £277,845 £297,897 £318,076 £338,382
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 £87,286 £105,773 £142,393 £160,154 £179,460 £198,888 £218,441 £238,117 £257,918 £277,845 £297,897 £318,076 £338,382
Inventory £10,000 £4,250 £5,750 £5,779 £5,808 £5,837 £5,866 £5,896 £5,925 £5,955 £5,984 £6,014 £6,044
Other Current Assets £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775
Total Current Assets £139,061 £151,798 £189,918 £207,708 £227,043 £246,499 £266,082 £285,788 £305,617 £325,574 £345,656 £365,865 £386,201
Long-term Assets
Long-term Assets £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732
Accumulated Depreciation £0 £2,500 £5,000 £7,500 £10,000 £12,500 £15,000 £17,500 £20,000 £22,500 £25,000 £27,500 £30,000
Total Long-term Assets £99,732 £97,232 £94,732 £92,232 £89,732 £87,232 £84,732 £82,232 £79,732 £77,232 £74,732 £72,232 £69,732
Total Assets £238,793 £249,030 £284,650 £299,940 £316,775 £333,731 £350,814 £368,020 £385,349 £402,806 £420,388 £438,097 £455,933
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 £7,616 £26,743 £25,420 £25,521 £25,620 £25,722 £25,824 £25,924 £26,028 £26,130 £26,234 £26,338
Current Borrowing £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £0 £7,616 £26,743 £25,420 £25,521 £25,620 £25,722 £25,824 £25,924 £26,028 £26,130 £26,234 £26,338
Long-term Liabilities £345,000 £345,000 £343,007 £341,002 £338,985 £336,957 £334,917 £332,865 £330,801 £328,725 £326,637 £324,537 £322,424
Total Liabilities £345,000 £352,616 £369,750 £366,422 £364,506 £362,577 £360,639 £358,689 £356,725 £354,753 £352,767 £350,771 £348,762
Paid-in Capital £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000
Retained Earnings (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207)
Earnings £0 £2,622 £21,107 £39,725 £58,476 £77,362 £96,382 £115,538 £134,831 £154,260 £173,828 £193,533 £213,378
Total Capital (£106,207) (£103,585) (£85,100) (£66,482) (£47,731) (£28,845) (£9,825) £9,331 £28,624 £48,053 £67,621 £87,326 £107,171
Total Liabilities and Capital £238,793 £249,030 £284,650 £299,940 £316,775 £333,731 £350,814 £368,020 £385,349 £402,806 £420,388 £438,097 £455,933
Net Worth (£106,207) (£103,585) (£85,100) (£66,482) (£47,731) (£28,845) (£9,825) £9,331 £28,624 £48,053 £67,621 £87,326 £107,171
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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 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
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
Total Restaurant Sales 0% £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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
Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
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
Wages 18% £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 14 14 14 14 14 14 14 14 14 14 14 14
Total Payroll £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Direct Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £5,750 £11,500 £11,557 £11,616 £11,673 £11,732 £11,791 £11,849 £11,909 £11,968 £12,028 £12,088
Gross Margin £23,000 £46,000 £46,231 £46,460 £46,693 £46,926 £47,161 £47,397 £47,633 £47,872 £48,111 £48,352
Gross Margin % 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Marketing/Promotion 4% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Depreciation £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500
Rent £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242 £4,242
Royalty fees 5% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Equip rent/repair £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Utilities 11% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Admin charges £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Total Operating Expenses £17,242 £17,592 £17,644 £17,696 £17,748 £17,800 £17,853 £17,906 £17,960 £18,013 £18,067 £18,121
Profit Before Interest and Taxes £5,758 £28,408 £28,587 £28,764 £28,945 £29,126 £29,308 £29,491 £29,673 £29,859 £30,044 £30,231
EBITDA £8,258 £30,908 £31,087 £31,264 £31,445 £31,626 £31,808 £31,991 £32,173 £32,359 £32,544 £32,731
Interest Expense £2,013 £2,001 £1,989 £1,977 £1,966 £1,954 £1,942 £1,930 £1,918 £1,905 £1,893 £1,881
Taxes Incurred £1,124 £7,922 £7,979 £8,036 £8,094 £8,152 £8,210 £8,268 £8,327 £8,386 £8,445 £8,505
Net Profit £2,622 £18,485 £18,619 £18,751 £18,886 £19,020 £19,156 £19,293 £19,429 £19,567 £19,706 £19,845
Net Profit/Sales 9.12% 32.15% 32.22% 32.29% 32.36% 32.43% 32.49% 32.56% 32.63% 32.70% 32.77% 32.83%
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
Subtotal Cash from Operations £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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 £28,750 £57,500 £57,788 £58,076 £58,366 £58,658 £58,952 £59,246 £59,542 £59,840 £60,139 £60,440
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 £10,000 £10,350 £10,402 £10,454 £10,506 £10,558 £10,611 £10,664 £10,718 £10,771 £10,825 £10,879
Bill Payments £263 £8,538 £27,619 £26,300 £26,404 £26,506 £26,612 £26,717 £26,822 £26,929 £27,034 £27,142
Subtotal Spent on Operations £10,263 £18,888 £38,021 £36,753 £36,910 £37,065 £37,224 £37,382 £37,539 £37,700 £37,860 £38,021
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 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £0 £1,993 £2,005 £2,017 £2,028 £2,040 £2,052 £2,064 £2,076 £2,088 £2,100 £2,113
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 £10,263 £20,881 £40,026 £38,770 £38,938 £39,105 £39,276 £39,446 £39,615 £39,788 £39,960 £40,134
Net Cash Flow £18,487 £36,619 £17,762 £19,306 £19,428 £19,553 £19,676 £19,800 £19,927 £20,052 £20,179 £20,306
Cash Balance £105,773 £142,393 £160,154 £179,460 £198,888 £218,441 £238,117 £257,918 £277,845 £297,897 £318,076 £338,382
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 £87,286 £105,773 £142,393 £160,154 £179,460 £198,888 £218,441 £238,117 £257,918 £277,845 £297,897 £318,076 £338,382
Inventory £10,000 £4,250 £5,750 £5,779 £5,808 £5,837 £5,866 £5,896 £5,925 £5,955 £5,984 £6,014 £6,044
Other Current Assets £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775 £41,775
Total Current Assets £139,061 £151,798 £189,918 £207,708 £227,043 £246,499 £266,082 £285,788 £305,617 £325,574 £345,656 £365,865 £386,201
Long-term Assets
Long-term Assets £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732 £99,732
Accumulated Depreciation £0 £2,500 £5,000 £7,500 £10,000 £12,500 £15,000 £17,500 £20,000 £22,500 £25,000 £27,500 £30,000
Total Long-term Assets £99,732 £97,232 £94,732 £92,232 £89,732 £87,232 £84,732 £82,232 £79,732 £77,232 £74,732 £72,232 £69,732
Total Assets £238,793 £249,030 £284,650 £299,940 £316,775 £333,731 £350,814 £368,020 £385,349 £402,806 £420,388 £438,097 £455,933
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 £7,616 £26,743 £25,420 £25,521 £25,620 £25,722 £25,824 £25,924 £26,028 £26,130 £26,234 £26,338
Current Borrowing £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £0 £7,616 £26,743 £25,420 £25,521 £25,620 £25,722 £25,824 £25,924 £26,028 £26,130 £26,234 £26,338
Long-term Liabilities £345,000 £345,000 £343,007 £341,002 £338,985 £336,957 £334,917 £332,865 £330,801 £328,725 £326,637 £324,537 £322,424
Total Liabilities £345,000 £352,616 £369,750 £366,422 £364,506 £362,577 £360,639 £358,689 £356,725 £354,753 £352,767 £350,771 £348,762
Paid-in Capital £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000 £160,000
Retained Earnings (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207) (£266,207)
Earnings £0 £2,622 £21,107 £39,725 £58,476 £77,362 £96,382 £115,538 £134,831 £154,260 £173,828 £193,533 £213,378
Total Capital (£106,207) (£103,585) (£85,100) (£66,482) (£47,731) (£28,845) (£9,825) £9,331 £28,624 £48,053 £67,621 £87,326 £107,171
Total Liabilities and Capital £238,793 £249,030 £284,650 £299,940 £316,775 £333,731 £350,814 £368,020 £385,349 £402,806 £420,388 £438,097 £455,933
Net Worth (£106,207) (£103,585) (£85,100) (£66,482) (£47,731) (£28,845) (£9,825) £9,331 £28,624 £48,053 £67,621 £87,326 £107,171
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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 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