1. Prepare a vertical analysis of Bridgfords income statement. Enter the percentages in columns C, E, G, I and K.

2. Prepare a projected income statement assuming sales increase by 3% in 2020 and 6% in 2021.

1. Average your vertical analysis percentages for each income statement account and enter the results in column L, rows 5 - 11. Example: Add columns C, E, G, I and K and divide by 5. (64.07+60.58+63.17+67.57+67.34)/5=64.55%. Column L, row 5 = 64.55%.
2. Enter your projected sales number in columns M & N, row 4.
3. Columns M and N: 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 seven years (i.e. 2015-2021). Do not prepare ratios that require data from the 2020 and 2021 balance sheet. In this case, N/A is entered in the appropriate cell.

Consolidated Statements of Operations - USD ($) $ in Thousands Oct 30. 2015 % Oct 28, 2016 % Nov. 03, 2017 % Nov. 02, 2018 % Nov. 01, 2019 % Average Percentage Nov. 02, 2020 Nov. 02, 2021 $ 130,448 83,579 46,869 38,751 $ 140,063 84,850 55,213 44,377 Net sales Cost of products sold Gross margin Selling, general and administrative expenses Gain (loss) on sale of property, plant and equipment Income before taxes Provision for (benefit on) income taxes Net income $ 167,223 105,637 61,586 48,816 58 12,828 3,999 $ 8,829 $ 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 8,118 (7,324) $ 15,442 10,836 3,066 $ 7,770 Enter ratios in columns B, D, F, H, and J N/A N/A N/A N/A N/A N/A Fixed Asset Turnover Cash Flow per share Earnings per share Profit Margin Ratio Gross Profit (marginRatio Return on Assets Return on Equity Inventory Turnover Days' Sales in Inventory Receivables Turnover Days' Sales in receivables N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Oct. 30, 2015 Oct. 28, 2016 Nov. 03, 2017 Nov. 02, 2018 Nov. 01, 2019 $ 5,842 14,619 19,977 319 40,757 10,235 13,666 10,644 75,302 $ 6,985 16,582 24,081 937 48,585 10,362 13,775 14,532 87,254 $ 12,109 19,148 23,016 1,550 55,823 18,571 13,111 10,040 97,545 $ 8,179 20,293 23,413 1,331 53,216 32,638 11,630 4,010 101,494 $3,478 21,875 26,367 1,048 52,768 54,346 12,295 4,047 123,456 Consolidated Balance Sheets - USD ($) $ in Thousands Current assets: Cash and cash equivalents Accounts receivable, less allowance for doubtful accounts Inventories, net Prepaid expenses Total current assets Property, plant and equipment, net of accumulated depreciation and Other non-current assets Deferred income taxes Total assets Current liabilities: Accounts payable Accrued payroll, advertising and other expenses Income taxes payable Current portion of non-current liabilities Total current liabilities Non-current liabilities Total liabilities Shareholders' equity: Preferred stock, without par value Authorized, - 1,000 shares; issued and Common stock $1.00 par value Authorized - 20,000 shares; issued and Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity 6,087 5,203 96 2,825 14,211 25,446 39,657 4,085 4,089 130 3,918 12,222 36,123 48,345 5,365 4,555 216 6,108 16,244 25,263 41,507 7,655 4,577 155 5,980 18,367 17,447 35,814 7,993 5,480 90 6,377 19,940 37,032 56,972 9,138 8,334 40,303 (22,130) 35,645 $ 75,302 9,134 8,298 48,073 (26,596) 38,909 $ 87,254 9,134 8,298 56,902 (18,296) 56,038 $ 97,545 9,134 8,298 65,948 (17,700) 65,680 $ 101,494 9,134 8,298 72,432 (23,380) 66,484 $ 123,456 Enter ratios in columns B,D,F, H, and J Net Working Capital Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ratio