Answered step by step
Verified Expert Solution
Question
1 Approved Answer
projected income statement assuming sales increase by 6% in 2020. Oct. 28, 2016 % Nov. 03, 2017 % Nov. 02, 2018 % Nov. 01, 2019
projected income statement assuming sales increase by 6% in 2020.
Oct. 28, 2016 | % | Nov. 03, 2017 | % | Nov. 02, 2018 | % | Nov. 01, 2019 | % | Average Percentage | Nov. 02, 2020 | |
$ 140,063 | $ 167,223 | $ 174,257 | $ 188,785 | |||||||
84,850 | 105,637 | 117,751 | 127,121 | |||||||
55,213 | 61,586 | 56,506 | 61,664 | |||||||
44,377 | 48,816 | 49,929 | 52,837 | |||||||
58 | 6,236 | (290) | ||||||||
10,836 | 12,828 | 12,813 | 8,537 | |||||||
3,066 | 3,999 | 6,296 | 2,053 | |||||||
$ 7,770 | $ 8,829 | $ 6,517 | $ 6,484 |
AutoSave o 8 Copy of Financial Statements - Bridgford Foods - Excel insert Draw Page Layout Formulas Data Review View Help Search File A Home X Cut == = Bad Good Copy - 2 Wrap Text Merge & Center - Percentage $ % 7 Normal Conditional Formats Check Cell Paste Neutral Linked Cell - 10 - AA 2. 0.A. Font B TU 68-8 Note Explanatory.. Input Formatting Format Painter Clipboard Table Alignment Number Styles HT 1 Consolidated Statements of Operations - USD ($) Sin Thousands UCL ZO, INOV.UZ % Nov 03, 2017 % INOY UI, 104 % Average Percentage Nov. 02, 2020 + $ 140,063 84,850 55,213 44,377 4 Net sales 5 Cost of products sold 6 Gross margin 7 Selling, general and administrative expenses & Gain (loss) on sale of property, plant and equipment 9 Income before taxes 10 Provision for (benefit on) income taxes 11 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 10,836 3,066 $ 7,770 13 14 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 N/A NA NIA NIA Income Statement Balance Sheet AutoSave o 8 Copy of Financial Statements - Bridgford Foods - Excel insert Draw Page Layout Formulas Data Review View Help Search File A Home X Cut == = Bad Good Copy - 2 Wrap Text Merge & Center - Percentage $ % 7 Normal Conditional Formats Check Cell Paste Neutral Linked Cell - 10 - AA 2. 0.A. Font B TU 68-8 Note Explanatory.. Input Formatting Format Painter Clipboard Table Alignment Number Styles HT 1 Consolidated Statements of Operations - USD ($) Sin Thousands UCL ZO, INOV.UZ % Nov 03, 2017 % INOY UI, 104 % Average Percentage Nov. 02, 2020 + $ 140,063 84,850 55,213 44,377 4 Net sales 5 Cost of products sold 6 Gross margin 7 Selling, general and administrative expenses & Gain (loss) on sale of property, plant and equipment 9 Income before taxes 10 Provision for (benefit on) income taxes 11 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 10,836 3,066 $ 7,770 13 14 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 N/A NA NIA NIA Income Statement Balance Sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started