Financials

profiledherin
Financials1.docx

Running head: FINANCIAL PLAN 1

FINANCIAL PLAN 2

Financial Plan

Dorian d. Herring

Strayer University

Financial Plan

Sources and Uses of Funds

The total start up cost is estimated to be $60,000. A bigger portion of the cost will go towards payroll, acquiring machinery and equipment as well as raw materials and inventories. The total cost for administrative functions is expected to be $10,800 during the first year of operation. The total cost for machinery and equipment is reported to be $4,000, while that of raw materials is expected to be $10,000. More than $1,400, $1,720 and $1,200 will go towards marketing and promotion, utilities and insurance respectively. Additional start up costs of $30,880 is expected in the form of working capital. The owner will contribute $10,000 and borrow the rest from a financial institution. The loan is expected to be fully repaid within 5 years.

Sources of Funds

Amount

Owners contribution

$10,000

Bank Loan

$50,000

Total Source of Funds

$60,000

Uses of Funds

Amount

Administrative

$10,800

Raw materials

$10,000

Machinery and equipment

$4,000

Marketing and promotion

$1,410

Utilities

$1,720

Insurance

$1,200

Working capital

$30,870

Total Use of Funds

$60,000

Key Financial Plan Assumptions

· It is assumed that the selling price per bottle of beverage will be $10

· The bank loan interest will be at 10.00% per annum

· The income tax rate will be 30.00 per annum

· The variable cost per unit is $4.5

· The organization uses a straight line depreciation which is at 10% of the total value of machinery and equipment

Break Even Analysis

Tsorakidis et al. (2011) define break even analysis as a point at which the total cost equates the total revenue. Break-even point analysis helps in determining the number of units or amount of revenue required to cover the total costs- fixed costs and variable costs. Fruity Surprise’s break even analysis indicates that the business will have to sell 2,824 units of beverages to cover its total costs. At the break-even point of 2,824 units the total revenue equates the total costs at $28,240. Fixed costs stand at $15,530 while variable cost amounts to $12,708.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Units Required for Break-Even:

2,824

 

 

 

 

 

Dollar Sales Required for Break-Even:

$28,236.36

 

 

 

 

 

Variable Costs Per Unit:

$4.50

 

 

 

 

 

Total Variable Costs:

$12,708.00

 

 

 

 

 

Total Fixed Costs:

$15,530.00

 

 

 

 

 

Months to Break-Even:

1.4

 

 

 

 

 

 

 

 

 

Break Even Table

Number of Units

Total Fixed Costs

Total Variable Costs

Total Sales Revenues

0

$15,530

$0

$0

282

$15,530

$1,271

$2,824

565

$15,530

$2,542

$5,648

847

$15,530

$3,812

$8,472

1130

$15,530

$5,083

$11,296

1412

$15,530

$6,354

$14,120

1694

$15,530

$7,625

$16,944

1977

$15,530

$8,896

$19,768

2259

$15,530

$10,166

$22,592

2542

$15,530

$11,437

$25,416

2824

$15,530

$12,708

$28,240

3106

$15,530

$13,979

$31,064

3389

$15,530

$15,250

$33,888

3671

$15,530

$16,520

$36,712

3954

$15,530

$17,791

$39,536

4236

$15,530

$19,062

$42,360

4518

$15,530

$20,333

$45,184

4801

$15,530

$21,604

$48,008

5083

$15,530

$22,874

$50,832

5366

$15,530

$24,145

$53,656

5648

$15,530

$25,416

$56,480

Reference

Tsorakidis, N., Papadoulos, S., Zerres, M., & Zerres, C. (2011). Break-even analysis. London, LN: Bookboon.

Total Fixed Costs 0 282.39999999999975 564.79999999999995 847.2 1129.5999999999999 1412 1694.4 1976.8 2259.1999999999998 2541.6 2824 3106.4 3388.8 367 1.2 3953.6 4236 4518.4000000000005 4800.8 5083.2 5365.6 5648 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 15530 Total Variable Costs 0 282.39999999999975 564.79999999999995 847.2 1129.5999999999999 1412 1694.4 1976.8 2259.1999999999998 2541.6 2824 3106.4 3388.8 3671.2 3953.6 4236 4518.4000000000005 4800.8 5083.2 5365.6 5648 0 1270.8 2541.6 3812.4 5083.2 6354 7624.8 8895.6 10166.4 11437.199999999992 12708 13978.800000000001 15249.6 16520.399999999983 17791.2 19062 20332.8 21603.600000000002 22874.399999999983 24145.200000000001 25416 Total Sales Revenues 0 282.39999999999975 564.79999999999995 847.2 1129.5999999999999 1412 1694.4 1976.8 2259.1999999999998 2541.6 2824 3106.4 3388.8 3671.2 3953.6 4236 4518.4000000000005 4800.8 5083.2 5365.6 5648 0 2824 5648 8472 11296 14120 16944 19768 22592 25416 28240 31064 33888 36712 39536 42360 45184 48008 50832 53656 56480

Number of Units

Dollars