Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    FINANCIAL-PLAN-notes

    Uploaded by

    rhiziajanedepaz68

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    FINANCIAL-PLAN-notes

    Uploaded by

    rhiziajanedepaz68
    2 views7 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2 views7 pages

    FINANCIAL-PLAN-notes

    Uploaded by

    rhiziajanedepaz68

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    VI.

    FINANCIAL PLAN

    MAJOR ASSUMPTIONS:
    Ingredients and other supplies for production is just enough for 1 production cycle.
    Sales and Cost of Sales is expected to increase 5% yearly.
    Salary of employees is expected to increase 2% yearly.
    Depreciation is not treated unless the equipment’s have totally worn out.
    Transportation and utilities expense is expected to increase 2% yearly.
    Cash is paid upon the release of the products.
    a. Projected Startup Cost
    Estimated Cost
    Supplies
    Ingredients ₱ 11,170.00
    Packaging Materials 1,700.00
    Equipment and Tools
    Electric Oven 4,000.00
    Electric Mixer 1,000.00
    Baking Utensils 2,000.00
    Administrative Expenses
    Licenses and Permits 8,000.00
    TOTAL EXPENSES 30,000.00
    Contingency Fund 7,130.00
    TOTAL PROJECTED COST ₱ 35,000.00
    A.Projected Monthly Sales
    Estimated
    Price Projected Monthly Sales
    Orders/mo.
    Cupcake Orders
    Regular
    Online
    100 dozens 100 per ½ dozen 20,000.00
    Customers
    Stores to Supply 200 dozens 100 per ½ dozen 40,000.00
    Personalized
    Online
    20 dozens 175 per ½ dozen 7,000.00
    Customers
    Stores to Supply 30 dozens 175 per ½ dozen 10,500.00
    TOTAL ₱77,500.00

    100 x 200 = 20,000


    200x200=40,000
    30X350=10,500
    20X350=7,000
    A.Projected Comparative Sales for 5 Years
    SWEET SWABTASTE ONLINE PRODUCTS
    PROJECTED COMPARATIVE SALES
    Year 1 Year 2 Year 3 Year 4 Year 5
    Regular Cupcakes 720,000.00 756,000.00 793,800.00 833,490.00 875,164.50
    Personalized Cupcakes 210,000.00 220,500.00 231,525.00 243,101.25 255,256.31
    TOTAL 930,000.00 976,500.00 1,025,325.00 1,076,591.25 1,130,420.81

    60,000 X12months= P720,000


    17,500 X12months= 210,000
    720,000 X.05 = 36,000
    720,000+36,000
    = P756,000
    SWEET SWABTASTE ONLINE PRODUCTS
    PROJECTED COMPARATIVE INCOME STATEMENT
    Year 1 Year 2 Year 3 Year 4 Year 5
    SALES 930,000.00 976,500.00 1,025,325.00 1,076,591.25 1,130,420.81
    Less: Cost of Sales 50,000.00 52,500.00 55,125.00 57,881.25 60,775.31
    GROSS PROFIT 880,000.00 924,000.00 970,200.00 1,018,710.00 1,069,645.50
    OPERATING EXPENSE
    Transportation 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32
    Utilities 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32
    Internet 3,000.00 3,060.00 3,121.20 3,183.62 3,247.30
    Salaries 50,000.00 51,000.00 52,020.00 53,060.40 54,121.61
    Repair and Maintenance 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32
    Net Income 797,000.00 839,340.00 883,846.80 930,629.74 979,803.63

    GROSS PROFIT NET INCOME


    = SALES – COST OF SALES GROSS PROFIT –OPERATING EXPENSE
    930,000- 50,000 880,000 – 83,000
    P880,000 P797,000
    a. Projected Comparative Cash Flow Statement

    SWEET SWABTASTE ONLINE PRODUCT


    PROJECTED COMPARATIVE CASH FLOW STATEMENT
    Year 1 Year 2 Year 3 Year 4 Year 5
    CASH IN
    Sales 930,000.00 976,500.00 1,025,325.00 1,076,591.25 1,130,420.81

    TOTAL CASH INFLOWS 930,000.00 976,500.00 1,025,325.00 1,076,591.25 1,130,420.81

    CASH OUT
    Cost of Sales 50,000.00 52,500.00 55,125.00 57,881.25 60,775.31
    Transportation 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32
    Utilities 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32
    Salaries 3,000.00 3,060.00 3,121.20 3,183.62 3,247.30
    Internet 50,000.00 51,000.00 52,020.00 53,060.40 54,121.61
    Repair and Maintenance 10,000.00 10,200.00 10,404.00 10,612.08 10,824.32

    TOTALCASH OUTFLOW 133,000.00 137,160.00 141,478.20 145,961.51 150,617.18


    NET INFLOW 797,000.00 839,340.00 883,846.80 930,629.74 979,803.63

    CASH BALANCE, BEG 7,130.00 804,130.00 1,643,470.00 2,527,316.80 3,457,946.54


    CASH BALANCE, END 804,130.00 1,643,470.00 2,527,316.80 3,457,946.54 4,437,750.17
    SWEET SWAB TASTE ONLINE PRODUCTS
    PROJECTED COMPARATIVE STATEMENT OF FINANCIAL POSITION
    Year 1 Year 2 Year 3 Year 4 Year 5
    ASSETS
    Cash 804,130.00 1,643,470.00 2,527,316.80 3,457,946.54 4,437,750.17
    Equipment and Tools 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00
    TOTAL ASSETS 811,130.00 1,650,470.00 2,534,316.80 3,464,946.54 4,444,750.17

    LIABILITIES AND EQUITY


    Total Liabilities - - - - -

    Owner's Equity 811,130.00 1,650,470.00 2,534,316.80 3,464,946.54 4,444,750.17

    TOTAL LIABILITIES AND EQUITY 811,130.00 1,650,470.00 2,534,316.80 3,464,946.54 4,444,750.17

    You might also like