Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve free cash flow and SGR, thank you INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation
Please solve free cash flow and SGR, thank you
INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation and Amortization - Total Operating Income EBIT Interest and Related Expense Pretax Income Income Taxes Expense (Credit) NET INCOME (LOSS) 2017 2018 4,965 2,428 2,537 1,400 138 999 12 987 235 752 2017 2016 4,391 3,962 2,100 1,893 2,291 2,069 1,283 1,169 127 104 881 795 8 5 873 790 294 291 579 499 Part-1 AT-HOME Due Oct.19 Individual Effort - no outside help Calculate Free Cash Flow for 2 Yrs USE 24% INC.TAX RATE 2018 EBIT EBIT X (1 - 24 tax rate) Depreciation CHANGE, Work Cap Capital Spending BALANCE SHEET Cash and Short-Term Investments - Top Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Property Plant and Equipment - Total ( Non-Current Assets - Other - Total Long-term Assets Total ASSETS TOTAL 2018 2017 2016 167 117 113 714 608 500 1,279 1,093 993 156 118 115 2,316 1,936 1,721 925 894 900 81 81 48 1,005 975 948 3,322 2,911 2,669 Free Cash Flow - 10 ptsn ^ 10 pts Below use Year-end Assets, Equity, not AVG Compute Sustain Growth % 2018 2017 for 2 Yrs Net Profit Margin 'd' Div Payout Debt / Equity 2018 2017 2016 Assets / Sales 10 10 + 3 194 241 437 148 194 351 109 156 276 Numerator Denoninator Current Liabilities Debt Payable - Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total LIABILITIES + SHAREHOLDERS' EQUITY 497 412 380 S.G.R. (end-yr Equity) >> 84 51 81 A 10 pts ^ 10 pts 581 1,019 2,303 3,322 463 460 814 736 2,097 1,933 2,911 2,669 2018 752 138 47 2017 579 127 2018 176 2016 499 104 32 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NETT 2017 120 -59 2 -18 -174 -179 STATEMENT OF CASH FLOWS Income Before Extraordinary Items Depreciation and Amortization Adjustments to Net Income Accounts Receivable - Decrease (Increa Inventory - Decrease (Increase) Accounts Payable and Accrued Liabilite Other Changes in Operation Activities OPERATING ACTIVITIES - NET CASH FLC -104 -40 -120 -193 93 -76 74 3 585 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -446 -73 369 0 -407 -42 674 INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation and Amortization - Total Operating Income EBIT Interest and Related Expense Pretax Income Income Taxes Expense (Credit) NET INCOME (LOSS) 2017 2018 4,965 2,428 2,537 1,400 138 999 12 987 235 752 2017 2016 4,391 3,962 2,100 1,893 2,291 2,069 1,283 1,169 127 104 881 795 8 5 873 790 294 291 579 499 Part-1 AT-HOME Due Oct.19 Individual Effort - no outside help Calculate Free Cash Flow for 2 Yrs USE 24% INC.TAX RATE 2018 EBIT EBIT X (1 - 24 tax rate) Depreciation CHANGE, Work Cap Capital Spending BALANCE SHEET Cash and Short-Term Investments - Top Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Property Plant and Equipment - Total ( Non-Current Assets - Other - Total Long-term Assets Total ASSETS TOTAL 2018 2017 2016 167 117 113 714 608 500 1,279 1,093 993 156 118 115 2,316 1,936 1,721 925 894 900 81 81 48 1,005 975 948 3,322 2,911 2,669 Free Cash Flow - 10 ptsn ^ 10 pts Below use Year-end Assets, Equity, not AVG Compute Sustain Growth % 2018 2017 for 2 Yrs Net Profit Margin 'd' Div Payout Debt / Equity 2018 2017 2016 Assets / Sales 10 10 + 3 194 241 437 148 194 351 109 156 276 Numerator Denoninator Current Liabilities Debt Payable - Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total LIABILITIES + SHAREHOLDERS' EQUITY 497 412 380 S.G.R. (end-yr Equity) >> 84 51 81 A 10 pts ^ 10 pts 581 1,019 2,303 3,322 463 460 814 736 2,097 1,933 2,911 2,669 2018 752 138 47 2017 579 127 2018 176 2016 499 104 32 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NETT 2017 120 -59 2 -18 -174 -179 STATEMENT OF CASH FLOWS Income Before Extraordinary Items Depreciation and Amortization Adjustments to Net Income Accounts Receivable - Decrease (Increa Inventory - Decrease (Increase) Accounts Payable and Accrued Liabilite Other Changes in Operation Activities OPERATING ACTIVITIES - NET CASH FLC -104 -40 -120 -193 93 -76 74 3 585 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -446 -73 369 0 -407 -42 674Step 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