Question: I need help with the formulas. 1). Complete the budget projections for years 2021-2024 using the following information - Revenue increases 4% annually - Expense

I need help with the formulas.

1). Complete the budget projections for years 2021-2024 using the following information

- Revenue increases 4% annually

- Expense increases 2% annually

For Depreciation and Interest expenses assume the Actual 2020 figure as the base for the budget and and forecast then add the amount calculated in the Payback tab for both budget and forecast.

Depreciation Expense: $23.89

Interest Expense: $9.03

1) Largo Global Income Statement of December 31, 2020 (millions)

ACTUAL BUDGET FORECAST
2020 2021 2022 2023 2024
Sales (net sales) $2,013
Cost of goods sold 1400
Gross profit 613
Selling, general, and administrative expenses 125
Earnings before Interest, taxes, depreciation, and amortization (EBITDA) 488
Depreciation and amortization 174
Earning before interest and taxes (EBIT) Operating income (loss) 314
Interest expense 141
Earnings before taxes (EBT) 173
Taxes (34%) 59
Net earnings (loss)/Net Income $ 114

2). Based on the changes suggested throughout the 5 projects, is Largo Global in a better financial position?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!