Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pro forma income-statement I need help creating a proforma income statement in excel (Value given) for 2021, 2022, 2023 1. Reduce SG&A expanse by 10%
Pro forma income-statement
I need help creating a proforma income statement in excel (Value given) for 2021, 2022, 2023
1. Reduce SG&A expanse by 10% through the years
2. Reduce COGS by 10% through the years
please show formula in excel
A B C D E 1 2021 2022 2023 Pro Forma Income Statement 2 3 Sales/Revenue 4 COGS 5 Depreciation & Amortization Expense 6 Gross Income 7 SG&A Expense 8 EBIT 9 Unusual Expense 10 Non Operating Income/Expense 11 Interest Expense 12 Pretax Income 13 Income Tax 14 Net Income 15 16 2020 1,041 692 609 349 275 74 0 3 2 74 18 56Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started