AutoSave DH P rilidl Side rent - bruglord roods - Neu-UHY - ELEI Draw Page Layout Formulas Data Review View Help Search File m LL - Arial . General Neutr Home Insert X cut Copy Format Painter Clipboard - 10-AA BIU. 2. OA Wrap Text Merge & Center Normal Conditional Format as Check Cell Formatting Table Bad Good Explanatory... Input Linked Font Alignment Styles MS C D E 1 Consolidated Statements of Operations. USD ($) $ in Thousands VOL. 20, NUV.UZ INOV. , % Nov. 03, 2017 % % Average Percentage Nov. 02, 2020 $ 140,063 84,850 55,213 44,377 $ 167,223 105,637 61,586 48,816 4 Net sales 5 Cost of products sold 6 Gross margin 7 Selling, general and administrative expenses 8 Gain (loss) on sale of property, plant and equipment 9 Income before taxes 10 Provision for benefit on) income taxes 11 Net income $ 174,257 117,751 56,506 49,929 6,236 12,813 6,296 $6,517 $ 188,785 127,121 61,664 52,837 (290) 8,537 2,053 $ 6,484 10,836 3,066 $7,770 12,828 3,999 $ 8,829 15 Enter ratios in columns B,D, F, H, and L NA NA Profit Margin Ratio Gross Profit (margin) Ratio Return on Assets Return on Equity Inventory Turnover Days Sales in Inventory Receivables Turnover Days' Sales in receivables NA N/A NIA NA Income Staf ment Balance Sheet E O Type here to search 2. Prepare a projected income statement assuming sales increase by 6% in 2020. 1. Average your vertical analysis percentages for each income statement account and enter the results in column), rows 5 - 11. Example: Add columns C, E, G, and I and divide by 4. (60.58+63.17+67.57+67.343/4-64.6796. Column), row 5 = 64.67%. 2. Enter your projected sales number in column L row 4. 3. Column L: Multiply projected sales by the average percentage for each income statement account. Reply CROP Tom Myers 2/5/20, 12:15 PM Vertical Analysis 2. Prepare a projected income statement assuming sales increase by 6% in 2020. 1. Average your vertical analysis percentages for each income statement account and enter the results in column). rows 5 - 11. Example: Add columns CE G, and I and divide by 4. (60.58+63.17+67.57+67.3474-64.67% Column] row 5 - 64.67% 2. Enter your projected sales number in column L row 4. 3. Column L: Multiply projected sales by the average percentage for each income statement account. 3. Ratio Computations. Use Excel formulas to calculate financial ratios listed with the income statement and balance sheet tabs. Calculate ratios for all five years (ie 2016-2020). Do not prepare ratios that require data from the 2020 balance sheet. In this case, "NIA is entered in the appropriate cell. For additional information regarding ratios, please review the following Financial Ratios Note: If there is a discrepancy between the formula used in our text versus the formula included with the above link use the formula incorporated WE X Financial Statements - Bridgfor... 4. Synopsis and Loan Proce discussion, and CFO question explain how you plan to in t includes a synopsis of the company, Ioan proceed resources to write a synopsis and to evaluate and earch - W E RT Y ulo