Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Business Financial Plan

    Uploaded by

    akundropbox315
    The document outlines projected startup costs and revenue for a new business over its first year of operation. It includes cost items, projected and actual costs, monthly revenue projections, expenses, gross profit, net income and other financial metrics.

    Copyright:

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

    Business Financial Plan

    Uploaded by

    akundropbox315
    3 views2 pages
    The document outlines projected startup costs and revenue for a new business over its first year of operation. It includes cost items, projected and actual costs, monthly revenue projections, expenses, gross profit, net income and other financial metrics.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines projected startup costs and revenue for a new business over its first year of operation. It includes cost items, projected and actual costs, monthly revenue projections, expenses, gross profit, net income and other financial metrics.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    3 views2 pages

    Business Financial Plan

    Uploaded by

    akundropbox315
    The document outlines projected startup costs and revenue for a new business over its first year of operation. It includes cost items, projected and actual costs, monthly revenue projections, expenses, gross profit, net income and other financial metrics.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    START-UP COSTS

    June 4, 2024

    COST ITEMS MONTHS PROJECTED COST ACTUAL COSTS DIFFERENCE

    Advertising/marketing 3 Rp 300.00 Rp 300.00 #REF!

    Employee salaries 4 Rp 3,500.00 Rp 3,500.00 #REF!

    Employee payroll taxes and benefits 4 Rp 500.00 Rp 500.00 #REF!

    Rent/lease payments/utilities 4 Rp 750.00 Rp 750.00 #REF!

    Postage/shipping 1 Rp 25.00 Rp 25.00 #REF!


    START-UP COSTS
    June 4, 2024

    REVENUE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD

    Estimated product sales Rp 8,000.00 Rp 13,000.00 Rp 16,000.00 Rp 7,000.00 Rp 14,500.00 Rp 16,400.00 Rp 22,500.00 Rp 23,125.00 Rp 24,549.00 Rp 22,000.00 Rp 25,000.00 Rp 27,349.00 Rp 219,423.00

    Less sales returns & discounts Rp - -Rp 350.00 Rp - -Rp 206.00 -Rp 234.00 Rp - Rp - -Rp 280.00 -Rp 1,200.00 -Rp 1,600.00 Rp - -Rp 2,400.00 -Rp 6,270.00

    Service revenue Rp - Rp - Rp - Rp - Rp - Rp 250.00 Rp 350.00 Rp 100.00 Rp - Rp - Rp 1,245.00 Rp 1,360.00 Rp 3,305.00

    Other revenue Rp - Rp - Rp - Rp - Rp - Rp - Rp - Rp 1,500.00 Rp - Rp - Rp - Rp - Rp 1,500.00

    Net sales Rp 8,000.00 Rp 12,650.00 Rp 16,000.00 Rp 6,794.00 Rp 14,266.00 Rp 16,650.00 Rp 22,850.00 Rp 24,445.00 Rp 23,349.00 Rp 20,400.00 Rp 26,245.00 Rp 26,309.00 Rp 217,958.00

    Cost of goods sold Rp 3,200.00 Rp 5,200.00 Rp 6,400.00 Rp 2,800.00 Rp 5,800.00 Rp 6,560.00 Rp 9,000.00 Rp 9,250.00 Rp 9,819.60 Rp 8,800.00 Rp 10,000.00 Rp 10,939.60 Rp 87,769.20

    Gross profit Rp 4,800.00 Rp 7,450.00 Rp 9,600.00 Rp 3,994.00 Rp 8,466.00 Rp 10,090.00 Rp 13,850.00 Rp 15,195.00 Rp 13,529.40 Rp 11,600.00 Rp 16,245.00 Rp 15,369.40 Rp 130,188.80

    EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD

    Salaries & wages Rp 2,500.00 Rp 2,500.00 Rp 3,500.00 Rp 5,000.00 Rp 5,000.00 Rp 5,000.00 Rp 8,000.00 Rp 9,000.00 Rp 9,000.00 Rp 9,000.00 Rp 9,000.00 Rp 9,000.00 Rp 76,500.00

    Marketing/advertising Rp 400.00 Rp 450.00 Rp 450.00 Rp 450.00 Rp 900.00 Rp 900.00 Rp 900.00 Rp 900.00 Rp 900.00 Rp 900.00 Rp 1,200.00 Rp 1,200.00 Rp 9,550.00

    Sales commissions Rp 250.00 Rp 650.00 Rp 800.00 Rp 350.00 Rp 725.00 Rp 820.00 Rp 1,125.00 Rp 1,156.25 Rp 1,227.45 Rp 1,100.00 Rp 1,250.00 Rp 1,367.45 Rp 10,821.15

    Rent Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 1,250.00 Rp 15,000.00

    Total expenses Rp 4,400.00 Rp 4,850.00 Rp 6,000.00 Rp 7,050.00 Rp 7,875.00 Rp 7,970.00 Rp 11,275.00 Rp 12,306.25 Rp 12,377.45 Rp 12,250.00 Rp 12,700.00 Rp 12,817.45 Rp 111,871.15

    Income before taxes Rp 400.00 Rp 2,600.00 Rp 3,600.00 -Rp 3,056.00 Rp 591.00 Rp 2,120.00 Rp 2,575.00 Rp 2,888.75 Rp 1,151.95 -Rp 650.00 Rp 3,545.00 Rp 2,551.95 Rp 18,317.65

    Income tax expense Rp 60.00 Rp 390.00 Rp 540.00 -Rp 458.40 Rp 88.65 Rp 318.00 Rp 386.25 Rp 433.31 Rp 172.79 -Rp 97.50 Rp 531.75 Rp 382.79 Rp 2,747.65

    NET INCOME Rp 340.00 Rp 2,210.00 Rp 3,060.00 -Rp 2,597.60 Rp 502.35 Rp 1,802.00 Rp 2,188.75 Rp 2,455.44 Rp 979.16 -Rp 552.50 Rp 3,013.25 Rp 2,169.16 Rp 15,570.00

    You might also like