Question: A B C D E F G H I J K L M N PCC FORECASTED FINANCIALS USING COMPANY FORECASTS (May) O P Q R

A B C D E F G H I J K L M N PCC FORECASTED FINANCIALS USING COMPANY FORECASTS (May) O P Q R N - 3 In millions 4 Period 0 3 4 5 6 7 8 9 5 Year 10 2015 2016 2017 2018 2019 2020 2021 2022 2023 5 Revenue 2024 2025 10,005 10,323 10,993 11,913 12,897 13,346 14,147 14,996 15,895 16,849 YoY growth 17,860 0.03 0.06 0.08 0.08 0.03 0.06 0.06 0.06 0.06 Cost structure 0.06 COGS,net D&A 6,825 6,545 6,958 7,514 8,097 8,364 8,866 9,398 9,962 10 10,559 11,193 % of revenue 641.00 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 11 SG&A 0.63 0.63 641 698 743 805 872 902 956 1,013 1,074 12 1,139 1,207 % of revenue 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 13 EBITDA 0.07 2,539 3,080 3,292 3,594 3,928 4,080 4,325 4,584 14 4,859 5,151 5,460 15 Income tax rate =32% 16 17 18 Current Assets 6,458 6,046 7,386 7,996 8,275 8,771 9,297 9,855 10,446 11,073 12487 19 Current Liabilities 4,756 4,356 4,765 5,159 5,338 5,659 5,998 6,358 6,740 7,144 8865 20 Depreciation 325 349 357 358 368 380 414 439 465 493 523 21 Capital Expenditures 702 382 407 441 477 494 523 555 588 22 623 661 23 Number of shares 143.5 24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Calculate the Beta for Dick's Sporting Goods and write 2-3 paragraphs suggesting whether the current share price of Dick's Sporting Goods is too high, low or correct. in that paragraph answer this...

hi I need those questions about the estimate of cost of capital and expansion scenario answered as soon as possible please thank you for your help -- - ---- - - -- - - -- - - - - - - - - --- --- i)...

E Wrap Text Calibri (Body) 12v A A BI U BILA X fx Paste 24 Merge & Center 1 A B C D E F G H I J K L M N -E174 - Assien overhead using traditional.costing and ABC Name: Altex Inc, manufactures two...

hi I need those questions about the estimate of the cost of capital and expansion scenario answered as soon as possible please thank you for your help hi I need those questions about the estimate of...

B C D E F G H I J K L M N O 5 The Tracey Company is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st...

I did the last excel sheet already. Having trouble with the others. Need guidance C Apache Airlines, A Privately Held X This case has the following road X M Inbox (936) - chelsea.collier.cc@ x +...

Need help preparing these ratios from a financial statement. I am not good with excel and have been trying for hours! Here are the ratios I need help filling in for Target and Wal-Marts numbers. Only...

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio...

Apache Airlines, a privately held firm, is looking to buy additional gates at its home airport for $500,000. Apache has $240,000 in the bank but that money may not be spent as it is used to pay...

Discuss the advantages and disadvantages for a country such as Germany of requiring or permitting companies to apply accounting principles based on IFRS in their individual financial statements.

Explain limits to growth and no limits to growth and relate to one of the following concepts: biodiversity climate change the Holocene extinction water Nuclear energy.

2 Zara wants to give a questionnaire to 100 people who travel on a bus route. a Describe an advantage of this method. Describe b Describe two disadvantages of this method. Describe C Describe a...

Margin of SafetyYellow Sticker Company's variable expenses are 40% of sales. Thecompany has monthly fixed expensesof $15,000 and sells each unit for $0.50. The monthly targetoperating income is $...