Question: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the
Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. a. Use the financial statements along with the additional information below to forecast property, plant and equipment, net for fiscal year ended April 2020. $ millions April 27, 2018 Actual April 26, 2019 Actual April 2020 Forecast Net sales $29,953 $30,557 $33,002 CAPEX 1,068 1,134 Depreciation expense 821 895 Property, plant, and equipment, gross 10,259 10,920 Property, plant, and equipment, net Answer 1 4,946 b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal year ended April 2020 is as follows. Company anticipated CAPEX for fiscal year ended April 2020 $1,500 million Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Property, plant, and equipment, net Answer 2 5,225 milli
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
