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 with AI-Powered 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

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

15th edition

978-0077522940

Students also viewed these Accounting questions