lemonade stand template

Upload: nikki-dargahi

Post on 06-Mar-2016

98 views

Category:

Documents


0 download

DESCRIPTION

lst

TRANSCRIPT

  • Income Statement 2014Revenue $100

    COGS $50 Gross Profit $50

    GM 50.0%SG&A $10 OP Inc $40

    Op Margin 40.0%Interest 0

    Pre Tax Income $40 Taxes $14

    Net Income $26 Net Income Margin 26.0%

  • 1Build 2014Price per sale $1 Volume 100

    Price per Lemon 0.1Lemons per sale 3Cost of Lemons 30

    Price per Sugar Cube 0.05Sugar Cubes per sale 2Cost of Sugar 10

    Price per Cup 0.1Cups per sale 1Cost of Cups 10

    Price per Manager 10Manager per cup N/ACost of Manager 10

    Amount of Debt 0Interest rate 0.1Interest Payments 0

    Effective Tax Rate 0.35

  • 2015 2016 2017 2018 2019Price Price ScenarioVolume Scenario

    Volume Price ScenarioVolume Scenario

    Income StatementBuildAssumptions