Financials
Running head: FINANCIAL PLAN 1
FINANCIAL PLAN 2
Financial Plan
Dorian d. Herring
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 |
|
|
|
|
|
|
|
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 56480Number of Units
Dollars