Scribd Logo
Upload

Welcome to Scribd!

  • 58 views

    Financial Projection Converted EDITED

    Uploaded by

    Mr. Dummy
    The document contains daily, monthly, and yearly sales data for a company including quantities sold, prices, costs, and revenues. It also includes monthly operating expenses, yearly labor costs, and a 5-year profit and loss projection. The projection shows increasing revenues and costs each year at a 10% growth rate, with consistent material costs as a percentage of revenues and increasing profits each year.

    Copyright:

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

    Financial Projection Converted EDITED

    Uploaded by

    Mr. Dummy
    58 views3 pages
    The document contains daily, monthly, and yearly sales data for a company including quantities sold, prices, costs, and revenues. It also includes monthly operating expenses, yearly labor costs, and a 5-year profit and loss projection. The projection shows increasing revenues and costs each year at a 10% growth rate, with consistent material costs as a percentage of revenues and increasing profits each year.

    Original Title

    financial-projection-converted-EDITED

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains daily, monthly, and yearly sales data for a company including quantities sold, prices, costs, and revenues. It also includes monthly operating expenses, yearly labor costs, and a 5-year profit and loss projection. The projection shows increasing revenues and costs each year at a 10% growth rate, with consistent material costs as a percentage of revenues and increasing profits each year.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    58 views3 pages

    Financial Projection Converted EDITED

    Uploaded by

    Mr. Dummy
    The document contains daily, monthly, and yearly sales data for a company including quantities sold, prices, costs, and revenues. It also includes monthly operating expenses, yearly labor costs, and a 5-year profit and loss projection. The projection shows increasing revenues and costs each year at a 10% growth rate, with consistent material costs as a percentage of revenues and increasing profits each year.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    DAILY SALES

    QUANTI PRI MATERIAL TOTAL TOTAL PROFIT


    TY CE COST REVENUE COSTS 162,500
    10,000 30 13.75 300000 137,500

    MONTHLY
    SALES
    QUANTI PRI MATERIAL TOTAL TOTAL PROFIT
    TY CE COST REVENUE COSTS 4,875,0

    YEARLY SALES
    QUANTITY PRI MATERIAL TOTAL TOTAL COSTS PROFIT
    3,600,000 CE COST REVENUE 49,500,000 58,500,0
    30 13.75 108000000 00

    MONTHLY INFORMATION YEARLY INFORMATION


    MANAGEMENT 360000 4320000
    RENT 150000 1800000
    ELECTRIC 100000 1200000
    WATER 10000 120000
    INTERNET 7000 84000
    INSURANCE 15000 180000
    ACCOUNTING/LEGAL 5000 60000
    ADVERTISING 50000 600000
    OTHER 300000 3600000
    TOTAL 997000 11964000
    TOTAL FIXED COST 637000 7644000
    Equity
    (PHP) Total
    Pre-Operating
    Expenses 11,964,000.00 11,964,000.00
    (permits,
    licenses, etc.)
    Fixed Investments
    (land, building, 10,000,000. 10,000,000.
    equipment, etc.) 00 00
    Working Capital
    (minimum cash
    needed for one year
    to pay raw
    55,147,680.00 55,147,680.00
    materials, labour,
    manufacturing
    overhead and
    operating
    expenses)
    TOTAL 77,111,680.00
    LABOR
    QUANTIT RAT HOUR PAY DAILY MONTHLY
    Y E S TOTAL PAY
    FACTORY WORKER 20 75 8 600 12000 360000
    JANITOR 2 55 8 440 880 26400
    SECURITY PERSONNEL 2 72 12 864 1728 51840
    QUALITY ANALYST 1 135 8 1080 1080 32400
    TOTAL 470640

    5 YEARS PROFIT AND LOSS STATEMENT


    YEAR 1 YEAR YEAR 3 YEAR YEAR 5
    2 4
    GROWTH 10% 10% 10% 10%
    MONTHS IN YEAR 12 12 12 12 12

    REVENUE 108,000,000 118800000 130680000 143748000 158122800


    MATERIAL COSTS 49500000 54450000 59895000 65884500 72472950
    SALARY 4320000 4320000 4320000 4320000 4320000
    LABOR 5647680 6212448 6833692.8 7517062.08 8268768.288
    FIXED COSTS 7644000 7644000 7644001 7644002 7644003
    MACHINES 10000000
    PROFIT/LOSS 30,888,320 46,173,552 51,987,306 58,382,436 65,417,079

    COMMON SIZE
    MATERIAL COST 0.458333333 0.458333333 0.458333333 0.458333333 0.458333333
    LABOR 0.052293333 0.052293333 0.052293333 0.052293333 0.052293333

    You might also like