Complete the business plan (i.e. Income Statement and Balance Sheet) for the years 2024-28 based on the presented planning assumptions (see sheet "DCF Valuation"); please make sure that total assets equal total liabilities and equity for all planning years.

Revenue >Planning based growth rate: 2024 -2,2%; 2025 +7,6%; 2026 +5%; 2027 +5%; 2028 +2%

COGS> Planning based on COGS ratio (to sales): linear improvement (i.e. decrease in ratio) from value in 2023 to 73% in 2028.

SGA > Planning based on SGA ratio (to sales): Linear increase to 12,5% (to sales) in 2028

R&D > Constant at 2023 levels

> Constant at 2023 levels

Depreciation > Planning based in absolute terms: 140 m for 2024 and 2025 and 170 m for the remaining years

Interest expense> Planning based on the assumed cost of debt (see assumptions in the sheet 'Task') and the level of debt at the beginning of the period

Interest income> Planning based in absolute terms: constant at the of the last 6 years (i.e. 2018-23) for all planning years

> na

> na

> na

> na

Tax > Planning based on the assumed tax rate (23.0%) for all planning years

> na

can You help me to fill up. I'm not sure about my calculation.

- Does COGS are good ? For 2024 it is = COGS of 2023- (COGS of 2023*(0.73/5)), do i do right?

- Same for SGA? (SGA2024= SGA2023+(SGA2023*(0.125/5)), do i do right?

-When they say constant levels is the same number as 2023?

- when they say Absolute terms is the number to enter ?

-How do i fill up : ?

Currency Exchange Gains (Loss)

Restructuring costs

Income (Loss) from Affiliates

Gain (Loss) On Sale Of Assets

Other Non-Operating Inc. (Exp.)

Other extraordinary items

- When they say "value remains unchanged" is it the same as 2023 value?

- HOW do i calculate Net property, Plant and equipment ? This is what i have done but not sure : Net property, Plant and euipement of 2024= SGA2024+R&D2024- Depreciation of 2024, do i do right?

- Same for inventory , how do i calculate? This is what i have done but not sure : Inventory of 2024= COGS2024/Turnover ratio to COGS of 2023(= COGS2023/AVERAGE OF inventory since 2018 to 2023), do i do right?

-Same for AR, how do i calculate? This is what i have done but not sure : AR of 2024= revenue2024*Turnover ratio to sale of 2023(= AR2023/AVERAGE OF revenue since 2018 to 2023), do i do right?

-Same for AP, how do i calculate? This is what i have done but not sure : AP of 2024= COGS2024/Turnover ratio to COGS of 2023(= COGS2023/AVERAGE OF AP since 2018 to 2023), do i do right?

-HOW do i calculate EQUITY ? say they me "Residual variable, i.e. end result from income statement based on all other planning assumptions (please assume no dividends, no other changes in equity such as capital increase/decrease, etc)"

-How do i calculate CASH ? say they me " Residual variable, i.e. end result of the cashflow statement based on all other planning assumptions."

I dont have any CASH flow statement