Sens anau 7-fundat7un for nat Unton Case 3: Body Shop Financial Forecast hPrupave and pevavman ivnluetu What are the purposes of financial statement forecast? What's the main purpose of financial forecasting in the Body Shop case? What are the different methods of financial statement forecast? What are the potential issues with each method? Understand and explain how to develop pro forma financial statements and how to construct such statements in Excel (four steps). What accounts typically use T-account forecasting, and what accounts use percentage-of- sales forecasting? What are the different choices of sales growth forecast? . . The relationship between income statement and balance sheet, and why we need iteration to find out the plug and the offsetting plug Calculate trial assets, trial liabilities, plug and offsetting plug. Understand how to use the Excel "IF" statement to calculate the plug and offsetting plug. Why do we need sensitivity analysis and scenario analysis in financial forecasting and financial analysis? Understand how to use the Excel data table for one-way and two-way sensitivity analysis. Understand the key drivers for external financing needs. managuria needs. managivial md