I cannot figure out how to complete the following to forecast sheets.
Question
I cannot figure out how to complete the following to forecast sheets. One is forecasting the next three years and
the second is forcasting the best and worst. Any help would be greatly appreciated.
McKesson Corp (in millions) Actual Forecast Period
Income Statement 2018 2019 2020 2021
Revenue 214319.00 226106.55 238542.40 251662.24
Cost of Sales -202565.00
Gross Profit 11754.00
Expenses
Operating Expenses -8474.00
Goodwill Impairment Charges -1797.00
Interest
Depreciation& Amortization
Total Expenses -10271.00
Earnings Before Tax 204048.00
Taxes -197.00
Net Earnings 203851.00
McKesson Corp (in millions) Actual Forecast Period
Income Statement 2018 Best Worst
Revenue 214319.00 226106.55 238542.40
Cost of Sales -202565.00
Gross Profit 11754.00
Expenses
Operating Expenses -8474.00
Goodwill Impairment Charges -1797.00
Interest
Depreciation& Amortization
Total Expenses -10271.00
Earnings Before Tax 204048.00
Taxes -197.00
Net Earnings