I have highlighted the section in the document that needs to be completed. Below are the instructions. It is based around the Disney company The competition is Universal and Time Warner. Part II: F

Prepare a projected income statement and balance sheet for the firm by doing the following:

Refer to and follow the steps given in Chapter 8 of the David text to learn how to complete financial statements.
Apply current acceptable financing percentages afforded your CLC group’s company according to the Standard and Poor’s or Moody’s rating.
Make any other assumptions necessary for this segment of the project and have them approved by your instructor prior to completing this part of the assignment.
Assume that the firm needs to secure capital to implement the strategy your team proposes to recommend. Your instructor will give you an amount if the team doesn’t determine an amount that will accommodate the production of the required reports.
Use the information gathered above to prepare a projected income statement and balance sheet for the firm using your Strategic-Planning Template.
In 50-100 words each, provide an analysis overview for both the projected financial statement and balance sheet.

I have highlighted the section in the document that needs to be completed. Below are the instructions. It is based around the Disney company The competition is Universal and Time Warner. Part II: F
CLC-STEPS FOR FINANCIAL RECOMMENDATIONS 7 CLC-Steps Required for Financial Recommendations July 13, 2022 CLC-Steps Required for Financial Recommendations Part I: EPS / EBIT Analysis Prepare an EPS/EBIT Analysis for your CLC group’s company by doing the following: Determine whether the firm should use all debt, all stock, or a 50-50 combination of debt and stock to finance their market-development strategy. Use your Strategic-Planning Template to complete the EPS/EBIT tables and chart. In 50-100 words, provide a summary recommendation/analysis overview for this part Slide 22 from strategy club: https:// www.strategyclub.com/wp-content/uploads/2020/11/SandersonFarms.Sample.Project.pdf EBIT for Disney in 2021 was $3.005B a 254.82% decline from 2020 (Macrotrends) Disney plans to raise its capital by $8 Million Disney’s outstanding shares is 1.828B in 2021 Common Stock Financing Debt Financing Pessimistic Realistic Optimistic Pessimistic Realistic Optimistic EBIT 2.000,000 5,000,000 8,000,000 2,000,000 5,000,000 8,000,000 Interest 0 0 0 500 500 500 EBT 2,000,000 5,000,000 8,000,000 Taxes 438,000 1,095,000 1,752,000 EAT 1,562,000 3905,000 6,248,000 # shares EPS Stock 60% Debt 40% Pessimistic Realistic Optimistic EBIT 2,000,000 5,000,000 8,000,000 Interest EBT Taxes #Shares EPS Amount Needed $8,000,000 Interest Rate 5% # Shares Outstanding 1.828 B Additional Shares outstanding 1.818 Stock Price 290 MIL before taxes Below is a figure illustrating the changes of EPS (y-axis) with estimated EBIT values (x-axis). HAVE TO REDO CHART JUST AN EXAMPLE Summary The Financial mixes represented in the data tables above examine Disney’s earnings per share (EPS) and earnings before income tax (EBIT) from a pessimistic, realistic, and optimistic viewpoint. Both the EPS and EBIT consist of a combination of financing from stock and debt (David et al., 2020) Part II: Financial Statements Prepare a projected income statement and balance sheet for the firm by doing the following: Refer to and follow the steps given in Chapter 8 of the David text to learn how to complete financial statements. Apply current acceptable financing percentages afforded your CLC group’s company according to the Standard and Poor’s or Moody’s rating. Make any other assumptions necessary for this segment of the project and have them approved by your instructor prior to completing this part of the assignment. Assume that the firm needs to secure capital to implement the strategy your team proposes to recommend. Your instructor will give you an amount if the team doesn’t determine an amount that will accommodate the production of the required reports. Use the information gathered above to prepare a projected income statement and 8balance sheet for the firm using your Strategic-Planning Template. In 50-100 words each, provide an analysis overview for both the projected financial statement and balance sheet. I made a table below: Projected Income Statement 10/2/2021 10/02/2023 10/02/2024 Revenue Cost of Goods sold Operating Expenses EBIT Interest Expense EBT Tax Non-recurring Events Net Income Part III: Cash Value D2etermine the Cash Value of the company by doing the following: Refer to and follow the steps given in Chapter 8 of the David text to learn how to determine the cash value of your CLC group’s company. To construct this element of the project, it will be necessary for the team to make use of the financial information provided initially about the company as well as the information and data that you’ve discovered as a result of the research and assignments completed thus far in the course. Calculate the financial worth of the firm based on four approaches: (1) the net worth method, (2) the net income method, (3) the price-earnings ratio method, and (4) the outstanding shares method. Use your Strategic-Planning Template to complete the company valuation tables. In 50-100 words, provide an analysis overview for this part. Calculate the average of the four methods. State a dollar amount of how much the company is worth. Part IV: Projected Financial Ratios Prepare Projected Financial Ratios for your company by doing the following: Refer to and follow the steps given in Chapter 8 of the David text to learn how to prepare projected financial ratios. If you completed the previous parts of this assignment, the template will generate projected financial ratios after the team converts the firm’s financial statements to the template format and then creates projected financial statements based on recommended strategies. Compute the projected current ratio, debt-to-equity ratio, and return-on-investment ratio. Use your Strategic-Planning Template to complete the company ratio tables. In 50-100 words, provide an analysis overview for this part. Also explain how the projected ratios compare to the prior year ratios. Explain the importance of this comparison. Projected Ratios 12/31/2022 12/31/2023 12/31/2024 Current Ratio Quick Ratio Debt-to-Equity Ratio Times-interest- earned ratio Inventory turnover Fixed assets turnover Total assets turnover Accounts Receivable turnover Average collection period Gross Profit margin % Operating Profit margin % ROA% ROE% Part V: Retained Earnings Create a Retained Earnings Table by doing the following: Refer to and follow the steps given in Chapter 8 of the David text to learn how to complete a retained earnings table. Use the data you have compiled about your company throughout the course to assist you. Use your Strategic-Planning Template to complete the company retained earnings table. In 50-100 words, provide an analysis overview for this part. Dividend Information Balance Sheet Information Steps 1 2 3 4 5 Year Current Year’s Net income Less current year’s dividends paid New re Plus Prior Year’s RE Current year’s balance sheet RE 12/31/2022 12/31/2023 12/31/2024 Part VI: Analysis In 350-750 words, summarize the importance of each of the parts above in this assignment (Parts I-V). Explain how each of the steps contributes to the firm’s success going forward.