Complete the budget projections for years 2023-2026 using the following information Revenue increases 4% annually Expense...

 

Transcribed Image Text:

Complete the budget projections for years 2023-2026 using the following information Revenue increases 4% annually Expense increases 24% annually For Depreciation and Interest expenses assume the Acutal 2022 figure as the base for the budget and and forecast then add the amount calculated in the Payback tab for both budget and forecast. Largo Global Income Statement of December 31, 2022 (millions) Sales (net sales) Cost of goods sold Gross profit Selling, general, and administrative expenses Earnings before Interest, taxes, depreciation, and amortization (EBITDA) Depreciation and amortization Earning before interest and taxes (EBIT) Operating income (loss) Interest expense Earnings before taxes (EBT) Taxes (34%) Net earnings (loss)/Net Income ACTUAL BUDGET 2022 2023 $ $2,013 $2,094 1400 1439 613 655 125 128 488 174 314 141 173 59 114 527 174 353 141 212 72 140 2024 $2,177 $2,264 1478 1519 699 746 132 567 198 369 FORECAST 2025 150 219 75 145 136 610 198 412 149 263 89 174 2026 $2,355 1560 794 139 655 198 457 148 309 105 204 Complete the budget projections for years 2023-2026 using the following information Revenue increases 4% annually Expense increases 24% annually For Depreciation and Interest expenses assume the Acutal 2022 figure as the base for the budget and and forecast then add the amount calculated in the Payback tab for both budget and forecast. Largo Global Income Statement of December 31, 2022 (millions) Sales (net sales) Cost of goods sold Gross profit Selling, general, and administrative expenses Earnings before Interest, taxes, depreciation, and amortization (EBITDA) Depreciation and amortization Earning before interest and taxes (EBIT) Operating income (loss) Interest expense Earnings before taxes (EBT) Taxes (34%) Net earnings (loss)/Net Income ACTUAL BUDGET 2022 2023 $ $2,013 $2,094 1400 1439 613 655 125 128 488 174 314 141 173 59 114 527 174 353 141 212 72 140 2024 $2,177 $2,264 1478 1519 699 746 132 567 198 369 FORECAST 2025 150 219 75 145 136 610 198 412 149 263 89 174 2026 $2,355 1560 794 139 655 198 457 148 309 105 204

Answer rating: 100% (QA)

To complete the budget projections for years 20232026 based on the provided information well apply t... View the full answer