Question: Hello, I am trying to forecast data. I have to find data using a different percentage for the year 2020 I will be using the

Hello,

I am trying to forecast data. I have to find data using a different percentage for the year 2020 I will be using the year 2021 data

2021:

Total revenue: 548,743,000

Total Expenses: 526,360,000

Pre-tax Income: 28,830,000

Net Income: 19,742,000

Cash Flow: 15,910,000,000

Assets: 250,863,000,000

Liabilities: 163,359,000

Net Cash Provided by Operating Activities: 25,225,000

Net Cash Used in Investing Activities: 9,128,000

Net Cash Used In Financing Activities 14,299,000

Eccommerce Technology Supply Chain and Other: 5,643,000

2020 %: 0.53

I need the formula to use in an excel sheet to solve for 2020 so I can workout the other problems

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!

Q:

Statement of Cost of Goods Sold : Prepare the statement of cost of goods sold in the COGS tab of the workbook. Remember to show your work using calculations to the side of the table or using...

Q:

NOTE: THERE ARE INFORMATION NEEDED, REFER TO THE 2020 ANNUAL REPORT OF WALT DISNEY 1. WHAT IS THE DEFINITION OF LIABILITIES? A. EVEN THOUGH THEY ARE NOT RECORDED AS LIABILITIES, DO THESE OPERATING...

Q:

choose any topic on business statistic chapter identify the problem statement write down the objective our company for this project is Dominos the reference i give is only for example This consist of...

Q:

This problem will provide you with practice in NPV, margin and markup, breakeven analysis, forecasting, and decision analysis, which are all important tools for managers to know. The problem also...

Q:

This problem will provide you with practice in NPV, margin and markup, breakeven analysis, forecasting, and decision analysis, which are all important tools for managers to know. The problem also...

Q:

Having a hard time figuring out how to do this, can someone help? See Table 2.5, , showing financial statement data and stock price data for Mydeco Corp. a. By what percentage did Mydeco's net income...

Q:

M7_A1. Jennifer Kelly is a WCU student who has just finished her junior year. The data in Worksheet A1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) Compute the...

Q:

this is the question at the bottom. a. use time-series decomposition and the regression program included in the excel data analysis toolpak to find the seasonally-adjusted forecast for Quarters I,...

Q:

Trendfitters Ltd is a small company that manufactures and sells only one product; a standard face mask for the construction industry. During the last financial year, which ended on 31st January 2021,...

Q:

Trendfitters Ltd is a small company that manufactures and sells only one product; a standard face mask for the construction industry. During the last financial year, which ended on 31st January 2021,...

Q:

Trendfitters Ltd is a small company that manufactures and sells only one product; a standard face mask for the construction industry. During the last financial year, which ended on 31st January 2021,...

Q:

Why does the preceding reaction form two stereoisomers?

Q:

The annual snowfall in city A is 44.9 inches. This is 14.5 inches more than four times the snowfall in city B. Find the annual snowfall for city B.

Q:

Question 1 6 : The "Check - The - Box" Option ( Form 8 8 3 2 ) enables certain entities which have corporate characteristics to be taxed as Partnerships. A . True B . False

Q:

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...