Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use these Consolidated Statement Sheets to fill in the 24-Month Pro Forma chart below: In the template, you will specifically address the following: Previous

Please use these Consolidated Statement Sheets to fill in the 24-Month Pro Forma chart below:

In the template, you will specifically address the following:

  • Previous fiscal year: Identify historical information for the previous fiscal year.
  • 24-month projections: Speculate projections for 24 months.
  • The company is Disney
  • Please fill out the 24-Month Pro Forma Chart (first chart) using provided material

here is an overview of the financial statement to look at in 2022.

Link to 10-K for Google: dis-20221001 (sec.gov)

image text in transcribedimage text in transcribedimage text in transcribed \begin{tabular}{|l|l|l|} \hline & Previous Fiscal Year & 24-Month Projections \\ \hline Sales & $82,772 & $ \\ \hline Cost of goods sold & $(75,925) & $ \\ \hline Gross profit & $6,847 & $ \\ \hline Selling expenses & $ & $ \\ \hline Administrative expenses & $(16,388) & $ \\ \hline Total operating expense & $ & $ \\ \hline Income from operations & $ & $ \\ \hline Other income & $ & $ \\ \hline Income before tax and interest & $ & $ \\ \hline Other expense (interest) & $ & $ \\ \hline Income before income tax & $5,285 & $ \\ \hline Income tax expense & $ & $ \\ \hline Net income & $3,505 & $ \\ \hline \end{tabular} CONSOLIDATED RESULTS (in millions, except per share data) PROJECTION FOR NEXT 24 MONTHS \begin{tabular}{|l|l|l|} \hline & Previous Fiscal Year & 24-Month Projections \\ \hline Sales & $82,772 & $ \\ \hline Cost of goods sold & $(75,925) & $ \\ \hline Gross profit & $6,847 & $ \\ \hline Selling expenses & $ & $ \\ \hline Administrative expenses & $(16,388) & $ \\ \hline Total operating expense & $ & $ \\ \hline Income from operations & $ & $ \\ \hline Other income & $ & $ \\ \hline Income before tax and interest & $ & $ \\ \hline Other expense (interest) & $ & $ \\ \hline Income before income tax & $5,285 & $ \\ \hline Income tax expense & $ & $ \\ \hline Net income & $3,505 & $ \\ \hline \end{tabular} CONSOLIDATED RESULTS (in millions, except per share data) PROJECTION FOR NEXT 24 MONTHS

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

Excel Para Auditores Aplicando Excel A La Auditoria

Authors: Antonio P. Peralta C.

1st Edition

9945803697, 978-9945803693

More Books

Students also viewed these Accounting questions