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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
