Question: What formula goes in cell C33? B E F. H 1 2021 2022 2023 2024 2025 2026 2027 2 Income Statement (000) 3 Sales 1,617,400
What formula goes in cell C33?


B E F. H 1 2021 2022 2023 2024 2025 2026 2027 2 Income Statement (000) 3 Sales 1,617,400 1,717,679 1,824,175 1,937,274 2,057,385 2,184,943 2,320,409 4 Operating expense 954,266 1,013,431 1,076,263 1,142,992 1,213,857 1,289,116 1,369,041 5 Depreciation Expense 99,572 239,154 317,244 392,325 461,994 524,215 572,6821 6 EBIT 563,562 465,094 430,668 401,957 381,534 371,612 378,686 7 Interest 23,291 23,291 23,291 23,291 23,291 23,291 23,291 8 EBT 540,271 441,803 407,377 378,666 358,243 348,321 355,395 9 Taxes 113,457 92,779 85,549 79,520 75,231 73,147 74,633 10 Net Income 426,814 349,024 321,828 299,146 283,012 275,174 280,762 11 12 Partial Balance Sheet (000) 13 Current Assets** 291,132 309,182 328,352 348,709 370,329 393,290 417,674 14 Accounts Payable 145,566 154,591 164,176 174,355 185,165 196,645 208,837 15 Accrued Expenses 64,696 68,707 72,967 77,491 82,295 87,398 92,816 16 Working Capital** 80,870 85,884 91,209 96,863 102,869 109,247 116,021 17 18 Cash Spent on PP&E 1,991,444 800,200 761,600 740,002 653,390 591,029 378,313 19 **Excludes cash and equivalenls nol needed for the operation of the business B F G H 1 T= 0 4 5 6 7. D E Answer 1 2 3 Cash Flow and NPV (000) 465,094 430,668 401,957 97,670 90,440 84,411 563,562 118,348 381,534 80,122 371,612 78,039 378,686 79,524 A 22 23 24 25 EBIT 26 Taxes 27 Unlevered Net 28 Income 29 Depreciation 30 Unlevered CF from 31 Ops 32 PP&E 33 Change in WC 445,214 99,572 367,424 239,154 340,228 317,244 317,546 392,325 301,412 461,994 293,573 524,215 299,162 572,682 544,786 -1,991,444 80,870 606,578 657,472 709,871 763,406 817,788 -800,200 -761,600 -740,002-653,390 -591,029 871,844 -378,313 21
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
