I don't understand how to evaluate future performance of a company.
This tab is used for the corporate valuatiased on assumptions you will explain in written report) in yellow cells only. Past performance and trends, text, course resources, research and most recent Annual Report Form 10-K on https://www.sec.gov/edgar/searchedgar/compa CURRENCY: e.g., euros or pesos). We will use U.S. dollars. SCALING: x meaning amounts in Thousands), or Millions (meaning amounts in millions). We will use x1000. TION Fiscal Year -> 0 2021 2022 2023 Total TOTAL REVENUES 4,904,403 5,017,204 5,132,600 29,114,343 Growth Rate vs Prior Year 2.3% 2.3% 2.3% Total Operating Expenses 4,248,594 OPERATING INCOME or (Loss) 4,904,403 5,017,204 5,132,600 Operating Margin 100.0% 100.0% 24,865,749 100.0% Operating margin equals Operating Income (or Loss) divided by Revenue. Interest expense 90.826 nterest & other income (expense) 30,176 INCOME (LOSS) BEFORE INCOME ,904.403 5,017,204 5,132,600 24,805,099 Provision for (or benefit from) Income Taxes Discontinued Operations Income (Loss), Net 0 O NET INCOME OR (LOSS) 4,904,403 5,017,204 5,132,600 24,805,099 Weighted average (Number of) Diluted Shares Outstanding 0 0 DILUTED EARNINGS OR (LOSS) PER SHARE S 1.74 Net Income or (Loss), from Above 4,904,403 5,017,204 5,132,600 24,755,131 Depreciation and Amortization Expense C 67,958 Other Operating Sources and (Uses) 257,605 Cash Flow from Operating Activities 4,904,403 5,017,204 5,132,600 25,180,694 Purchases of property & equip., & other capital expenditu (140,426) Other Investing Activities (146,051) Cash Flow from Investing Activities olo o olo (286,477) Increase or (Decrease) in Debt Increase or (Decrease) in Common Stock Dividend Payments Other Financing Activities Cash Flow from Financing Activities loo oo oo ooo oo ooo ooo (220,055) 309,258) Payments would be entered as a negative. 207,788 (737,101) Cumulative Translation Adjustmen (21,282) 21,282) (21,282) (127,692) For this course, we will assume zero change over 10 years. NET CASH FLOW 4.883,121 4,995,922 5,111,318 24.029,424 Free Cash Flow 4,904,403 5,017,204 5,132,600 25,040,268 VALUATION CALCULATIONS FREE CASH FLOW "FCF" (from above 4,904,403 5,017,204 5,132,600 25,040,268 For the project analysis, we EXCLUDE the funding proceeds & repayment. NET PRESENT VALUE "NPV" OF FUTURE FREE CASH NPV @ discount rate of NPV 5.0% s. The value here is what you may be willing to pay to buy the company under these assumptions. @ discount rate of 10.0%panies. The value here is what you may be willing to pay to buy the company under these assumptions. NPV @ discount rate of 18.0% es. The value here is what you may be willing to pay to buy the company under these assumptionsCURRENCY: USD