Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 674

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Analysis and Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

10th Edition

978-0538482387

Students also viewed these Accounting questions