Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Ultimate Startup Pro Forma: Synopsis

    Uploaded by

    Tarek Domiaty
    ecdec

    Copyright:

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

    Ultimate Startup Pro Forma: Synopsis

    Uploaded by

    Tarek Domiaty
    31 views22 pages
    ecdec

    Original Title

    ecec

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    ecdec

    Copyright:

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

    Ultimate Startup Pro Forma: Synopsis

    Uploaded by

    Tarek Domiaty
    ecdec

    Copyright:

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

    ULTIMATE STARTUP PRO FORMA

    SYNOPSIS
    Do you need to present the investment and reward opportunities of a new venture
    or project? The "Ultimate Start Up Pro Forma" model is intended to help corporate
    individuals and entrepreneurs who need to propose a venture and display how
    much it will cost, how much revenue will be generated, and at what point will cash
    flows become positive and the venture reach its "break-even point".
    Errors and omissions liability (E&O): You Exec LLC makes no guarantee that the fomulas, models, analysis, financial projections, estimates,
    graphs, reports, numbers, and any derivatives sourcing from this model are free of errors and omissions. Our financial modelers have audited
    this model to the best of their capabilities, yet You Exec LLC assumes no liability for erronous outcomes derived from this financial model.

    Copyright © You Exec LLC. All rights reserved.


    TABLE OF CONTENT

    Sheet 1 Synopsis

    Sheet 2 Table of content

    Sheet 3, 4, 5 Input Data


    Input essential variables to se

    Sheet 6 Pro Forma Summary


    Results of Input Data in the fo

    Sheet 7 Graphs & Break-Even Poin


    Visual representation of Pro F

    COLOR KEY
    Types Example
    User inputs $3,400
    Calculations $3,400
    Results $3,400
    Good results $3,400
    Bad results $3,400
    References $3,400

    Headers Example
    Header SOME TITLE
    Sub-header SOME TITLE
    Title Title
    Sub-title Some sub-title

    Styles
    Grid not shown
    ential variables to see the analysis do X, Y, Z

    a Summary
    Input Data in the form of a Pro Forma

    & Break-Even Point


    resentation of Pro Forma Results

    Description
    Enter your values where you see blue fields
    Calculations from existing sheet
    Analysis and results of calculations
    Favorable outcomes
    Unfavorable outcomes
    References to other sheets
    Sales Revenue
    Q1 Q2 Q3 Q4
    Y1 Y1 Y1 Y1
    Units Sold
    Product A 400 400 450 450
    Product B 280 300 300 300
    Product C 250 250 250 400
    Product Total 930 950 1,000 1,150

    Revenue Revenue/Unit
    Product A $400 $160,000 $160,000 $180,000 $180,000
    Product B $200 $56,000 $60,000 $60,000 $60,000
    Product C $100 $25,000 $25,000 $25,000 $40,000
    Total Revenue $241,000 $245,000 $265,000 $280,000

    COGS COGS/Unit
    Product A $45 $18,000 $18,000 $20,250 $20,250
    Product B $75 $21,000 $22,500 $22,500 $22,500
    Product C $25 $6,250 $6,250 $6,250 $10,000
    Total COGS $45,250 $46,750 $49,000 $52,750

    Gross Margin $195,750 $198,250 $216,000 $227,250


    Q1 Q2 Q3 Q4 Q1 Q2
    Y2 Y2 Y2 Y2 Y3 Y3

    650 650 650 700 700 700


    300 650 650 650 650 650
    400 400 400 400 400 400
    1,350 1,700 1,700 1,750 1,750 1,750

    $260,000 $260,000 $260,000 $280,000 $280,000 $280,000


    $60,000 $130,000 $130,000 $130,000 $130,000 $130,000
    $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
    $360,000 $430,000 $430,000 $450,000 $450,000 $450,000

    $29,250 $29,250 $29,250 $31,500 $31,500 $31,500


    $22,500 $48,750 $48,750 $48,750 $48,750 $48,750
    $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
    $61,750 $88,000 $88,000 $90,250 $90,250 $90,250

    $298,250 $342,000 $342,000 $359,750 $359,750 $359,750


    Q3 Q4
    Y3 Y3

    700 700
    650 650
    400 400
    1,750 1,750

    $280,000 $280,000
    $130,000 $130,000
    $40,000 $40,000
    $450,000 $450,000

    $31,500 $31,500
    $48,750 $48,750
    $10,000 $10,000
    $90,250 $90,250

    $359,750 $359,750
    Operating Expense
    Q1 Q2 Q3
    Y1 Y1 Y1
    Department A
    Expense
    Expense A $5,000 $5,000 $5,000
    Expense B $3,000 $3,000 $3,000
    Expense C $2,000 $2,000 $2,000
    Total Dept. A Expense $10,000 $10,000 $10,000

    Department B
    Expense
    Expense A $8,000 $8,000 $8,000
    Expense B $6,000 $6,000 $6,000
    Expense C $4,500 $4,500 $4,500
    Total Dept. B Expense $18,500 $18,500 $18,500

    Grand Total Expense $28,500 $28,500 $28,500


    Q4 Q1 Q2 Q3 Q4 Q1
    Y1 Y2 Y2 Y2 Y2 Y3

    $5,000 $5,000 $5,000 $5,000 $5,000 $5,000


    $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
    $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
    $10,000 $10,000 $10,000 $10,000 $10,000 $10,000

    $8,000 $8,000 $8,000 $8,000 $8,000 $8,000


    $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
    $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
    $18,500 $18,500 $18,500 $18,500 $18,500 $18,500

    $28,500 $28,500 $28,500 $28,500 $28,500 $28,500


    Q2 Q3 Q4
    Y3 Y3 Y3

    $5,000 $5,000 $5,000


    $3,000 $3,000 $3,000
    $2,000 $2,000 $2,000
    $10,000 $10,000 $10,000

    $8,000 $8,000 $8,000


    $6,000 $6,000 $6,000
    $4,500 $4,500 $4,500
    $18,500 $18,500 $18,500

    $28,500 $28,500 $28,500


    Salary Expense
    Q1 Q2 Q3
    Y1 Y1 Y1
    Department A Position
    Job Title A 1 1 1
    Job Title B 1 1 1
    Job Title C 2 2 2
    Job Title D 3 3 3
    Job Title E 4 4 4
    Total Dept. A Employees 11 11 11

    Department A Salary Salary/Position


    Job Title A $100,000 $25,000 $25,000 $25,000
    Job Title B $85,000 $21,250 $21,250 $21,250
    Job Title C $60,000 $30,000 $30,000 $30,000
    Job Title D $40,000 $30,000 $30,000 $30,000
    Job Title E $35,000 $35,000 $35,000 $35,000
    Total Dept. A Salary $141,250 $141,250 $141,250

    Department B Position
    Job Title A 1 1 1
    Job Title B 1 1 1
    Job Title C 2 2 2
    Job Title D 2 2 2
    Job Title E 3 3 3
    Total Dept. B Employees 9 9 9

    Department B Salary Salary/Position


    Job Title A $80,000 $20,000 $20,000 $20,000
    Job Title B $50,000 $12,500 $12,500 $12,500
    Job Title C $45,000 $22,500 $22,500 $22,500
    Job Title D $35,000 $17,500 $17,500 $17,500
    Job Title E $25,000 $18,750 $18,750 $18,750
    Total Dept B. Salary $91,250 $91,250 $91,250
    Grand Total Employee(s) 20 20 20
    Grand Total Salary $232,500 $232,500 $232,500
    Q4 Q1 Q2 Q3 Q4 Q1
    Y1 Y2 Y2 Y2 Y2 Y3

    1 1 1 1 1 1
    1 1 1 1 1 1
    2 2 2 2 2 2
    3 3 3 3 3 3
    4 4 4 4 4 4
    11 11 11 11 11 11

    $25,000 $25,000 $25,000 $25,000 $25,000 $25,000


    $21,250 $21,250 $21,250 $21,250 $21,250 $21,250
    $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
    $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
    $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
    $141,250 $141,250 $141,250 $141,250 $141,250 $141,250

    1 1 1 1 1 1
    1 1 1 1 1 1
    2 2 2 2 2 2
    2 2 2 2 2 2
    3 3 3 3 3 3
    9 9 9 9 9 9

    $20,000 $20,000 $20,000 $20,000 $20,000 $20,000


    $12,500 $12,500 $12,500 $12,500 $12,500 $12,500
    $22,500 $22,500 $22,500 $22,500 $22,500 $22,500
    $17,500 $17,500 $17,500 $17,500 $17,500 $17,500
    $18,750 $18,750 $18,750 $18,750 $18,750 $18,750
    $91,250 $91,250 $91,250 $91,250 $91,250 $91,250
    20 20 20 20 20 20
    $232,500 $232,500 $232,500 $232,500 $232,500 $232,500
    Q2 Q3 Q4
    Y3 Y3 Y3

    1 1 1
    1 1 1
    2 2 2
    3 3 3
    4 4 4
    11 11 11

    $25,000 $25,000 $25,000


    $21,250 $21,250 $21,250
    $30,000 $30,000 $30,000
    $30,000 $30,000 $30,000
    $35,000 $35,000 $35,000
    $141,250 $141,250 $141,250

    1 1 1
    1 1 1
    2 2 2
    2 2 2
    3 3 3
    9 9 9

    $20,000 $20,000 $20,000


    $12,500 $12,500 $12,500
    $22,500 $22,500 $22,500
    $17,500 $17,500 $17,500
    $18,750 $18,750 $18,750
    $91,250 $91,250 $91,250
    20 20 20
    $232,500 $232,500 $232,500
    Pro Forma
    Q1 Q2 Q3 Q4
    Y1 Y1 Y1 Y1

    Gross Revenue $241,000 $245,000 $265,000 $280,000

    COGS $45,250 $46,750 $49,000 $52,750

    Gross Margin $195,750 $198,250 $216,000 $227,250


    Gross Margin % 81% 81% 82% 81%

    Operating Expense $28,500 $28,500 $28,500 $28,500


    Salary Expense $232,500 $232,500 $232,500 $232,500

    Total Expense $261,000 $261,000 $261,000 $261,000

    Total Cost $306,250 $307,750 $310,000 $313,750

    Net Profit $ (65,250) $ (62,750) $ (45,000) $ (33,750)


    Net Profit % -27% -26% -17% -12%
    Q1 Q2 Q3 Q4 Q1 Q2
    Y2 Y2 Y2 Y2 Y3 Y3

    $360,000 $430,000 $430,000 $450,000 $450,000 $450,000

    $61,750 $88,000 $88,000 $90,250 $90,250 $90,250

    $298,250 $342,000 $342,000 $359,750 $359,750 $359,750


    83% 80% 80% 80% 80% 80%

    $28,500 $28,500 $28,500 $28,500 $28,500 $28,500


    $232,500 $232,500 $232,500 $232,500 $232,500 $232,500

    $261,000 $261,000 $261,000 $261,000 $261,000 $261,000

    $322,750 $349,000 $349,000 $351,250 $351,250 $351,250

    $ 37,250 $ 81,000 $ 81,000 $ 98,750 $ 98,750 $ 98,750


    10% 19% 19% 22% 22% 22%
    Q3 Q4
    Y3 Y3

    $450,000 $450,000

    $90,250 $90,250

    $359,750 $359,750
    80% 80%

    $28,500 $28,500
    $232,500 $232,500

    $261,000 $261,000

    $351,250 $351,250

    $ 98,750 $ 98,750
    22% 22%

    You might also like