Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 56

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions