Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Proforma 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%

Proforma 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

3. Increase in sales revenue by 10%

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

Recommended Textbook for

Advanced Accounting

Authors: Floyd A. Beams, Robin P. Clement, Suzanne H. Lowensohn, Joseph H. Anthony

9th Edition

0131851225, 978-0131851221

More Books

Students also viewed these Accounting questions

Question

=+a) What is the maximin choice?

Answered: 1 week ago