Estimate the ratios of a percent of "sales forecast method". Prepare a five year Pro-Forma Income Statement and Balance Sheet. Please make sure you create a separate worksheet where you input...

1 answer below »
Estimate the ratios of a percent of "sales forecast method". Prepare a five year Pro-Forma Income Statement and Balance Sheet. Please make sure you create a separate worksheet where you input assumptions for the forecast such as sales growth rate, etc.
Answered Same DayApr 23, 2021

Answer To: Estimate the ratios of a percent of "sales forecast method". Prepare a five year Pro-Forma Income...

Aarti J answered on Apr 25 2021
148 Votes
Income statement
    Powered by Clearbit
    Chipotle Mexican Grill Inc (NYS: CMG)
    Exchange rate used is that of the Year End reported date
    Sales growth    4.9%
    As Reported Annu
al Income Statement
    Report Date    12/31/2018        2019        2020        2021        2022
    Currency    USD        USD        USD        USD        USD
    Audit Status    Not Qualified        Not Qualified        Not Qualified        Not Qualified        Not Qualified
    Consolidated    Yes        Yes        Yes        Yes        Yes
    Scale    Thousands        Thousands        Thousands        Thousands        Thousands
    Revenue    4864985        5103369        5353434        5615753        5890925
    Restaurant operating costs - food, beverage & packaging    1600760        1679197        1761478        1847790        1938332
    Restaurant operating costs - labor    1326079        1391057        1459219        1530720        1605726
    Restaurant operating costs - occupancy    347123        364132        381974        400691        420325
    Restaurant operating costs - other operating costs    680031        713353        748307        784974        823438
    General & administrative expenses    375460        393858        413157        433401        454638
    Depreciation & amortization    201979        211876        222258        233149        244573
    Pre-opening costs    8546        8965        9404        9865        10348
    Gain (loss) on disposal & impairment of assets    66639        69904        73330        76923        80692
    Total operating expenses    4606617        4832341        5069126        5317513        5578071
    Income (loss) from operations    258368        271028        284308        298240        312853
    Interest & other income (expense), net    10068        10068        10068        10068        10068
    Income (loss) before income taxes    268436        260960        274240        288172        302785
    Provision (benefit) for current income taxes - U.S. federal    58878        61763        64789        67964        71294
    Provision (benefit) for current income taxes - U.S. state    21780        22847        23967        25141        26373
    Provision (benefit) for current income taxes - foreign    637        668        701        735        771
    Total provision (benefit) for current income...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here