ACCT 370 Lecture 3: ACCT370ExcelProjectPt3
Document Summary
Common sized balance sheets (tabs 12), common sized income statements (tab 13), Horizontal analysis balance sheets (tab 14), horizontal analysis income statements (tab 15), and projected financial statements (tabs 16-18) Continue in the same excel workbook prepared in module 4: week 4, adding the following tabs: the 12th tab in your financial statement analysis template must be labeled. Common sized balance sheets: set-up like the historical balance sheets (tab 3), this worksheet should use formulas to calculate the common sized percentages, linking to the historical. Total assets should be used as the base for all common sized calculations on the balance sheets. Acct 370: the 13th tab in your financial statement analysis template must be labeled. Common sized income statements: set-up like the historical income statements (tab 2), this worksheet should use formulas to calculate the common sized percentages, linking to the historical.
