It is currently the end of 2019, and you have been asked to determine the projected...

 

Transcribed Image Text:

It is currently the end of 2019, and you have been asked to determine the projected cash flows of your firm, Home Depot (symbol: HD), next year for decision-making purposes. Below is some financial statement information that is loosely based on HD for the fiscal year ended December 31, 2022: Income Statement (in millions $) Year Ended December 31, 2022 Sales Cost of Sales Gross Income Selling, General, Administrative Expenses Depreciation Interest Expense Pre-Tax Income Tax Net Income 151,000 100,000 51,000 25,400 2,400 1,300 21,900 5,300 16,600 a) Construct a pro-forma income statement for December 31, 2023. Management assumes that sales will grow by 10 percent next year. Also assume that net property, plant, and equipment at the end of 2021 is valued at $30,700M, net property, plant, and equipment at the end of 2022 is valued at $31,200M, long-term debt at the end of 2021 is $41,200M, and long-term debt at the end of 2022 is valued at $42,000M. b) Suppose that management plans to issue a large dividend of $15,000M and purchase $3,000M worth of new buildings and equipment in 2023. Using this information and numbers from part (a), calculate the following: (1) projected net, property, plant and equipment at the end of 2023, and (2) projected shareholders' equity at the end of 2023. Assume that shareholders' equity at the end of 2022 equals negative $1,700M. c) Using numbers from parts (a) and (b), calculate the projected net funding need for HD in 2023. Management projects that net working capital will increase by $1,500M in 2023. d) What is the projected free cash flow in 2023? If the free cash flow is projected to grow at 2% per year in perpetuity, and the discount rate for these free cash flows is 6.5%, then what is the present value in 2022 of all HD free cash flows? It is currently the end of 2019, and you have been asked to determine the projected cash flows of your firm, Home Depot (symbol: HD), next year for decision-making purposes. Below is some financial statement information that is loosely based on HD for the fiscal year ended December 31, 2022: Income Statement (in millions $) Year Ended December 31, 2022 Sales Cost of Sales Gross Income Selling, General, Administrative Expenses Depreciation Interest Expense Pre-Tax Income Tax Net Income 151,000 100,000 51,000 25,400 2,400 1,300 21,900 5,300 16,600 a) Construct a pro-forma income statement for December 31, 2023. Management assumes that sales will grow by 10 percent next year. Also assume that net property, plant, and equipment at the end of 2021 is valued at $30,700M, net property, plant, and equipment at the end of 2022 is valued at $31,200M, long-term debt at the end of 2021 is $41,200M, and long-term debt at the end of 2022 is valued at $42,000M. b) Suppose that management plans to issue a large dividend of $15,000M and purchase $3,000M worth of new buildings and equipment in 2023. Using this information and numbers from part (a), calculate the following: (1) projected net, property, plant and equipment at the end of 2023, and (2) projected shareholders' equity at the end of 2023. Assume that shareholders' equity at the end of 2022 equals negative $1,700M. c) Using numbers from parts (a) and (b), calculate the projected net funding need for HD in 2023. Management projects that net working capital will increase by $1,500M in 2023. d) What is the projected free cash flow in 2023? If the free cash flow is projected to grow at 2% per year in perpetuity, and the discount rate for these free cash flows is 6.5%, then what is the present value in 2022 of all HD free cash flows?

Answer rating: 100% (QA)

The question consists of several parts so Ill break it down accordingly a Construct a proforma income statement for December 31 2023 with the assumption that sales will grow by 10 percent and that the ... View the full answer