Question: 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

Proforma Income statement I need help creating a proforma income statement in

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Complete diagram of a replication fork in bacterial DNA Drag the appropriate labels to their respective targets. Label the components first (blue) and then the strands (pink). helcase 998 protein...

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...

A B D E F G I 1 Bio Hawaii Corporation 2 Company Description 3 Five year old Hawaii ocean plant based pharmaceutical company 4 BioHawaii has 2 promising drugs that are in phase III of FDA approval 5...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

***I have posted this question now five times. Each time I am told I need more information so I add something and no one returns back to answer; which means I have now wasted five questions. Can...

***I have posted this question now six times. Each time I am told I need more information, I add something and no one returns to answer. Yesterday I posted everything and no one has responded; which...

Need help with the pro forma excel A B D E 1 2 3 9 10 12 13 14 15 16 Jupiter Auto Repair & Maintenance Case Facts and Assumptions Module 10 Exercise Jupiter Auto Repair wants to evaluate the...

Questions are at the bottom. Use the Courier pages below to answer them. TOP Round 1 Dec. 31 2024 COMP-XM Riya Report INQUIRER Singh Andrews Baldwin Chester Riya Singh Digby Selected Financial...

Will give likes please help asap Section B (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "*" in column C such that formula could be copied and pasted into columns D...

please provide answers as excel formula's after reading the questions! thank you Refer to Table 1. Write the Excel formula for each cell marked with ?" in column C such that formula could be copied...

With the data, I will attach and the example (which we can't use) we were given can someone please help, me analyze round four for my report, which includes the data as the example did below? We were...

Let A be a 2 2 matrix and let one solution of the system A x =0 be x =(-3, 1). (a) Find all solutions to the system A x =0. (b) What was the reduced row echelon form of [A 0]?

Munder Difflin has US source income of $300 million and foreign source income of $200 million Munder Difflin paid $40 million in foreign taxes The US Tax rate is 35

[ - / 6 Points ] Consider the following series. n = 2 1 n 6 7 - 1 Use the Direct Comparison Test to complete the inequality. 1 n 6 7 - 1 Determine the convergence or divergence of the series....

A 1.00-kg iron horseshoe is taken from a forge at 900C and dropped into 4.00 kg of water at 10.0C. Assuming that no energy is lost by heat to the surroundings, determine the total entropy change of...

A 1.00-kg block of copper at 20.0C is dropped into a large vessel of liquid nitrogen at 77.3 K. How many kilograms of nitrogen boil away by the time the copper reaches 77.3 K? (The specific heat of...

A 1.00-kg block of aluminum is heated at atmospheric pressure so that its temperature increases from 22.0C to 40.0C. Find (a) The work done on the aluminum, (b) The energy added to it by heat and (c)...

Caughlin Company needs to raise $55 million to start a new project and will raise the money by selling new bonds. The company will generate no internal equity for the foreseeable future. The company...

A 1-L Thermos bottle is full of tea at 90C. You pour out one cup and immediately screw the stopper back on. Make an order-of-magnitude estimate of the change in temperature of the tea remaining in...

You just returned from a two - week vacation and are meeting with the Production Supervisor to review the control charts that have been maintained during your absence . He tells you that the process...

3.72 An analyst attempting to predict a corporations earnings next year believes that the corporations business is quite sensitive to the level of interest rates. He believes that, if average rates...

3.73 Forty-two percent of a corporations blue-collar employees were in favor of a modified health care plan, and 22% of its blue-collar employees favored a proposal to change the work schedule....

3.71 A campus student club distributed material about membership to new students attending an orientation meeting. Of those receiving this material 40% were men and 60% were women. Subsequently, it...