ZuoTi.Pro
Question
have to figure out the projection for 2020-2024 by the given %
Sale Growth Total Cost(POS) Tax Rate Dividends (% Net Income) Current Assets(POS) Fixed Assets(POS) Current Liabilities 12.70
D A 16 Total Costs 17 EBIT 18 Interest 19 Non-Op Income 20 EBT 21 Taxes 22 Net Income 23 24 Dividends 25 26 Chipotle 27 Balan
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer: Below mentioned is the forecast as mentioned growth rates:

Chipotle 2019 2020 2021 2022 2023 2024 Formulae For Colunm C Expected Growth rate
Income Statement Actual Project Project Project Project Project (In percentage)
Sales 5586.00 6295.42 7094.94 7996.00 9011.49 10155.95 B3+((I$3/100)*B3) 12.70
Total Costs 5076.00 5720.65 6447.17 7265.97 8188.74 9228.71 B4+((I$3/100)*B4) 91.00
EBIT 510.00 574.77 647.77 730.03 822.75 927.23 C3-C4
Interest 54.00 60.81 68.53 77.24 87.05 98.10 (C5*(10.58/100))
Non-Op Income -4.00 -4.00 -4.00 -4.00 -4.00 -4.00
EBT 458.00 517.96 583.23 656.79 739.70 833.13 C5-(C6+C7)
Tax Rate 23.58 28.53 34.52 41.77 50.55 61.16 (B9*I$9/100)+B9 21.00
Taxes 108.00 147.79 201.36 274.37 373.90 509.57 (C8*C9/100)
Net Income 350.00 370.17 381.87 382.42 365.80 323.57 C8-C10
Dividends 0.00 0.00 0.00 0.00 0.00 0.00 B13+((I$3/100)*B13) 0.00
Chipotle
Balance Sheet
Current Assets 1072.00 1208.14 1361.58 1534.50 1729.38 1949.01 B17+((I$3/100)*B17) 18.00
Fixed Assets 4032.00 4544.06 5121.16 5771.55 6504.53 7330.61 B18+((I$3/100)*B18) 72.00
Current Liabilities 667.00 751.71 847.18 954.77 1076.02 1212.68 B20+((I$3/100)*B20) 11.00
Long-term Debt 2678.00 2678.00 2678.00 2678.00 2678.00 2678.00
Long-term Liabilities 77.00 77.00 77.00 77.00 77.00 77.00
CS & Paid in Capitall -1233.00 -1233.00 -1233.00 -1233.00 -1233.00 -1233.00
Retained Earnings 2916.00 3286.17 3668.04 4050.46 4416.26 4739.83 B24+C11
Total Equity 1683.00 2053.17 2435.04 2817.46 3183.26 3506.83 C24+C23
0 0
Add a comment
Know the answer?
Add Answer to:
have to figure out the projection for 2020-2024 by the given % Sale Growth Total Cost(POS)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Calculate the internal and sustainable growth rates Integrated mihi-case Working with Financial Juma Listed are the...

    Calculate the internal and sustainable growth rates Integrated mihi-case Working with Financial Juma Listed are the 2021 financial statements for Garners' Platoon Mental Health Care, Inc. Spread the balance sheet and income statement. Calculate the financial ratios for the firm, including the internal and sustainable growth rates. Using the DuPont system of analysis and the industry ratios reported, evaluate the performance of the firm. GARNERS' PLATOON MENTAL HEALTH CARE, INC. Balance Sheet as of December 31, 2021 (in millions of...

  • Sangria Topochico - The Capital Budgeting Decision In December 2012, María Guadalupe, the owner of Sidral...

    Sangria Topochico - The Capital Budgeting Decision In December 2012, María Guadalupe, the owner of Sidral Mundet Sol, had just finished reading a report done by his general manager, Francisco Javier, about the possible investment in a new product line, Sangria Topochico. The idea of Sangria Topochico came about three months earlier when María attended a seminar on youth obesity organized by a local high school that his two children attended. Even though he had often heard of the rising...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT