Prepare a vertical analysis of Bridgford Foods income statement. Enter the percentages in columns C, E, and G.

Prepare a projected income statement assuming sales increase by 9% in 2020.

1. Average your vertical analysis percentages for each income statement account and enter the results in column H, rows 4 - 11. Example: Add columns C, E, and G and divide by 3. (60.58+63.17+67.57)/3=63.77%. Column H, row 5 = 63.77%.
2. Enter your projected sales number in column J, row 4.
3. Column J: Multiply projected sales by the average percentage.

thats all the information I have.

there is no more info!!!

Financial Analysis:

1. Open the Excel spreadsheet provided. Prepare a vertical analysis of Bridgford Foods income statement. Enter the percentages in columns C, E, and G. For additional information regarding vertical analysis, please review the following.

Vertical Analysis

2. Prepare a projected income statement assuming sales increase by 9% in 2020.

Average your vertical analysis percentages for each income statement account and enter the results in column H, rows 4 - 11. Example: Add columns C, E, and G and divide by 3. (60.58+63.17+67.57)/3=63.77%. Column H, row 5 = 63.77%.

Enter your projected sales number in column J, row 4.

Column J: Multiply projected sales by the nter your projected sales number in column J, row 4.

3. Ratio Computations. Use Excel formulas to calculate financial ratios listed with the income statement and balance sheet tabs. Calculate the ratio for all four years (i.e. 2016-2018 and 2020). Do not prepare ratios that require data from the 2020 balance sheet. In this case, an X is entered in the appropriate cell.

Remo Consolidated States or Operations. USD (S) Oct 28 Nov. 03, 2017 Consolidated Statements of Operations. USD (5) $ 140,063 84,850 55,213 $ 1673 105 637 $174957 117.251 54506 48,816 5 Cost of products sold 5 Grossman 7 Selling and administrative expenses 8 Gain on sale of property, plant and equipment 9 Income before 10 Provision for benefit on) income taxes 11 Net income 49.929 (6.236) 1213 6.296 $6512 SON 15 Enter ratios in columns B, D, and F Profit Margin Ratio Gross Profit (margin) Ratio Return on Assets Return on Equity Inventory Turnover Days Sales in Inventory Receivables Turnover Day Sales la receivables Remove Consolidated States of Operations. USD (S) Sin Thousands Oct 28 Nov. 03, 2017 $ 140,063 84,850 SS.213 $ 1673 105 637 Consolidated Statements of Operations. USD (5) Sin Thousands 5 Cost of products sold 5 Grossman 7 Selling general and administrative expenses 8 Gain on sale of property, plant and equipment 9 Income before 10 Provision for benefit on) income taxes 1 Net income 48,816 $174957 117.251 56 506 49.929 (6.236) 1213 6.296 $6512 58,829 15 Enter ratios in columns B, D, and F Profit Margin Ratio Gross Profit (marin) Ratio Return on Assets Return on Equity Inventory Turnover Duys Sales in Inventory Receivables Turnover Day Sales receivables Window Option a le Shen 03.2012 Nov. 02, 2018 S6,985 $ 8,179 20.293 23.413 $ 12.109 19.148 23,016 1.550 55,823 18571 13.111 10.040 97,545 10,362 13,275 32,638 11.630 101.494 Consolidated Balance Sheets - USD (S) Sim Current assets Cash and cash equivalents Accounts receivable, less allowance for doubtfal accounts of $146 Inventories, net Prepaid peste Total currentes Property, plant and equipment, net of accumulated depreciation Other non current 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 abilities Non current liabilities Total liabilities Shareholders' equity: Preferred stock, without par value Authorized - 1,000 shares Common stock. $1.00 par value Authorized - 20,000 shares issued Capital in excess of par value Retained casings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity S1365 4,55S 7,655 4.572 36.123 610B 16,244 25,263 41.507 18.367 17447 35,814 9,134 3,298 48,073 (26 396) 38,909 9,134 81298 56,902 (18,296) 56,038 $ 97,545 9,134 3.290 65,948 (17,700) 65.680 $101.494 $ 87,254 Enter ratios in columns C, E, and G Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ilatio Income statement Balance sheet 10 Type here to search 0 Ate 90