Finance

Market analysis. Sales forecast. Expenditures on staff

2 downloads 209 Views 277KB Size

Story Transcript

Highlights The renovation/modification cost estimate will include the costs associated with preparing the site for opening business. Start−up Start−up Plan Start−up Expenses Legal Brochures Consultants Insurance Rent 4−group Automatic Coffee Machine Coffee Grinder Computer Systems (x2) Cooker Fridge Freezer Fume−fan Communication Lines Fixtures / Re−model Other Total Start−up Expense

£500 £600 £2,000 £700 £1,445 £10,000 £795 £1500 £800 £600 £700 £200 £140 £20,000 £0 £40,480

Start−up Assets Needed Cash Requirements Start−up inventory Other Short−term Assets Total Short−term Assets

£24,000 £2,000 £0 £26,000

Long−term Assets Total Assets

£0 £26,000

Total Start−up Requirements: £66,480 Left to finance: £24,000 Start−up Funding Plan Investment Owners Investors Other Total investment

£13,000 £18,000 £0 £31,000

Short−term Liabilities 1

Unpaid Expenses Short−term Loans Interest−free Short−term Loans Subtotal Short−term Liabilities Long−term Liabilities Total Liabilities

£0 £9,290

Loss at Start−up Total Capital Total Capital and Liabilities Check−line

(£38,290) (£7,290) £26,000 £0

£0 £9,290 £24,000 £33,290

Market Analysis (Pie) Market Analysis Potential Customers University Students Office Workers Seniors Teenagers Other Total

Growth 4% 3% 5% 2% 0% 2.68%

1999 15,000 25,000 18,500 12,500 25,000 96,000

2000 15,600 25,750 19,425 12,750 25,000 98,525

2001 16,224 26,523 20,396 13,005 25,000 101,148

2002 16,873 27,319 21,416 13,265 25,000 103,873

2003 17,548 28,139 22,487 13,530 25,000 106,704

CAGR 4.00% 3.00% 5.00% 2.00% 0.00% 2.68%

5.4.1 Sales Forecast 2

Sales Monthly

Sales Forecast Unit Sales 2003 Coffee (based on average) 12,015 Speciality Beverages (based on 6,654 average) Baked Goods (based on 32,673 average) Other 0 Total Unit Sales 51,342 Unit Prices 2003 Coffee (based on average) £1.00 Speciality Beverages (based on £3.00 average) Baked Goods (based on £1.25 average) Other £0.00 Milestones Milestone Business Plan Secure Start−up Funding Site Selection Architect Designs Designer Proposal Year 1 Plan Personnel Plan Accounting Plan Licensing Totals

2004 14,068

2005 15,475

7,913

8,705

42,150

46,365

0 64,135

0 70,544

2004 £1.00

2005 £1.00

£3.00

£3.00

£1.25

£1.25

£0.00

£0.00

Start Date 1/1/00

End Date 2/1/00

Budget £1,000

Manager Owners

Department Admin

2/15/00

3/1/00

£1,000

Owners

Admin

3/1/00 4/1/00 4/1/00 6/1/00 7/1/00 7/1/00 9/1/00

3/15/00 5/1/00 4/15/00 6/5/00 7/10/00 7/5/00 9/15/00

£1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £10,000

Owners Owners Owners Owners Owners Owners Owners

Admin Admin Admin Admin Admin Admin Admin

Expenditures on staff Personnel Plan Personnel Owner Part Time 1 Part Time 2 Part Time 3 Part Time 4 Part Time 5 Part Time 6

2003 £24,000 £7,920 £7,920 £7,920 £7,920 £3,960 £7,920

2004 £26,400 £7,920 £7,920 £7,920 £7,920 £7,920 £7,920

2005 £29,040 £7,920 £7,920 £7,920 £7,920 £7,920 £7,920 3

Manager Other Total Payroll

£4,000 £0 £71,72

£24,000 £0 £97,94

£26,400 £0 £102,98

Total Headcount Payroll Burden Total Payroll Expenditures

0 £13,994

0 £18,274

0 £19,388

£85,71

£116,21

£122,37

7.1 Important Assumptions General Assumptions Short−term Interest Rate % Long−term Interest Rate % Payment Days Estimator Inventory Turnover Estimator Tax Rate % Expenses in Cash % Personnel Burden %

2003 10.00% 10.00% 30 48.00 25.00% 10.00% 15.00%

2004 10.00% 10.00% 30 48.00 25.00% 10.00% 15.00%

2005 10.00% 10.00% 30 48.00 25.00% 10.00% 15.00%

7.2 Key Financial Indicators Profit Monthly 7.3 Break−even Analysis Break Even Analysis: Monthly Units Break−even Monthly Sales Break−even

20,000 £20,000

Assumptions: Average Per−Unit Revenue Average Per−Unit Variable Cost Estimated Monthly Fixed Cost

£1.00 £0.50 £10,000

Break−Even Analysis Units break−even point = where Total costs intersects with Sales revenue 7.4 Projected Profit and Loss Profit and Loss (Income Statement) Sales Direct Cost of Sales Other

2003 £248,878 £62,220 £0 −−−−−−−−−−−−

2004 £303,549 £75,887 £0 −−−−−−−−−−−−

2005 £333,904 £83,476 £0 −−−−−−−−−−−− 4

Total Cost of Sales Gross Margin Gross Margin % Operating expenses: Advertising/Promotion Travel Miscellaneous Payroll Expense Payroll Burden Depreciation Utilities Insurance Rent Contract/Consultants Total Operating Expenses Profit Before Interest and Taxes Interest Expense Short−term Interest Expense Long−term Taxes Incurred Net Profit Net Profit/Sales

£62,220 £186,659 75.00%

£75,887 £227,662 75.00%

£83,476 £250,428 75.00%

£25,000 £750 £12,000 £93,291 £13,994 £0 £18,000 £6,000 £24,000 £6,000 −−−−−−−−−−−− £199,034 (£12,376) £439 £1,880 (£3,674) (£11,021) −4.43%

£25,000 £0 £12,000 £121,824 £18,274 £0 £18,000 £6,000 £24,000 £3,000 −−−−−−−−−−−− £228,097 (£436) £0 £1,190 (£406) (£1,219) −0.40%

£28,000 £0 £12,000 £129,254 £19,388 £0 £18,000 £6,000 £24,000 £3,000 −−−−−−−−−−−− £239,642 £10,785 £0 £700 £2,521 £7,564 2.27%

7.5 Projected Cash Flow Cash Pro−Forma Cash Flow Net Profit Plus: Depreciation Change in Accounts Payable Current Borrowing (repayment) Increase (decrease) Other Liabilities Long−term Borrowing (repayment) Capital Input Subtotal Less: Change in Inventory Change in Other Short−term Assets Capital Expenditure Dividends Subtotal

2003 (£11,021)

2004 (£1,219)

2005 £7,564

£0 £12,433 (£9,290) £0 (£9,600) £0 (£17,478) 2003 (£255) £0 £0 £0 (£255)

£0 £1,036 £0 £0 (£5,000) £0 (£5,184) 2004 £383 £0 £0 £0 £383

£0 £1,049 £0 £0 (£4,800) £0 £3,813 2005 £213 £0 £0 £0 £213 5

Net Cash Flow Cash Balance

(£17,224) £6,776

(£5,567) £1,209

£3,600 £4,809

7.6 Projected Balance Sheet Pro−forma Balance Sheet Assets Short−term Assets Cash Inventory Other Short−term Assets Total Short−term Assets Long−term Assets Capital Assets Accumulated Depreciation Total Long−term Assets Total Assets

2003 £6,776 £1,745 £0 £8,522

2004 £1,209 £2,129 £0 £3,338

2005 £4,809 £2,342 £0 £7,151

£0 £0 £0 £8,522

£0 £0 £0 £3,338

£0 £0 £0 £7,151

Accounts Payable Short−term Notes Other Short−term Liabilities Subtotal Short−term Liabilities

2003 £12,433 £0 £0 £12,433

2004 £13,469 £0 £0 £13,469

2005 £14,518 £0 £0 £14,518

Long−term Liabilities Total Liabilities

£14,400 £26,833

£9,400 £22,869

£4,600 £19,118

Paid in Capital Retained Earnings Earnings Total Capital Total Liabilities and Capital Net Worth

£31,000 (£38,290) (£11,021) (£18,311) £8,522 (£18,311)

£31,000 (£49,311) (£1,219) (£19,531) £3,338 (£19,531)

£31,000 (£50,531) £7,564 (£11,967) £7,151 (£11,967)

Liabilities and Capital

7

6

30 25 20 15 10 5 0 £

7

0 0 0 s Months

8

9

Get in touch

Social

© Copyright 2013 - 2024 MYDOKUMENT.COM - All rights reserved.