About

Would you be able to help me with this project? - 1. Use Excel to forecast balance sheet, income statement, and cash flow numbers for the next five years. You should refer to the company 10-K to examine historic cash flow statements for depreciation expense, capital expenditures, dividend payments, and stock repurchases. BUT MAKE YOUR CASH FLOW STATEMENT FROM SCRATCH JUST LIKE IN THE APPLE FORECASTING EXERCISE!! Connect Gross PP&E to depreciation and purchases in the cash flow statement Connect Debt, Dividends, and Common Stock in the cash flow statement to changes in those items on the balance sheet Pay special attention to unique accounts that are important to your company or items they highlight as being risky or important in their 10-K (e.g., “content assets” and “content liabilities” – how are these accounted for and what do they represent???)