Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please completed the calculation under the yellow highlighted sections. INCOME STATEMENT Sales Revenue Cost of Goods Sold Gross Profit (Loss) Selling, General, Admin Expenses Depreciation
Please completed the calculation under the yellow highlighted sections.
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 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 2018 BALANCE SHEET Cash and Short-Term Investments - To 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 2017 167 117 714 608 1,279 1,093 156 118 2,316 1,936 925 894 81 81 1,005 975 3,322 2,911 2016 113 500 993 115 1,721 900 48 948 2,669 Free Cash Flow A 10 pts A 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 Assets / Sales 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 2018 3 194 241 437 497 84 581 1,019 2,303 3,322 2017 10 148 194 351 412 51 463 814 2,097 2,911 2016 10 109 156 276 380 81 460 736 1,933 2,669 S.G.R. (end-yr Equity) >> 10 pts 10 pts 2018 752 138 47 2017 579 127 2018 176 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NET 2017 120 -59 -179 2 -174 -18 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 -120 193 93 -42 674 -104 -76 74 3 585 2016 499 104 32 -40 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -73 369 0 -407 -446 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 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 2018 BALANCE SHEET Cash and Short-Term Investments - To 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 2017 167 117 714 608 1,279 1,093 156 118 2,316 1,936 925 894 81 81 1,005 975 3,322 2,911 2016 113 500 993 115 1,721 900 48 948 2,669 Free Cash Flow A 10 pts A 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 Assets / Sales 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 2018 3 194 241 437 497 84 581 1,019 2,303 3,322 2017 10 148 194 351 412 51 463 814 2,097 2,911 2016 10 109 156 276 380 81 460 736 1,933 2,669 S.G.R. (end-yr Equity) >> 10 pts 10 pts 2018 752 138 47 2017 579 127 2018 176 continued from lower left Capital Expenditures Other Cash Flow from Investin INVESTING ACTIVITIES - NET 2017 120 -59 -179 2 -174 -18 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 -120 193 93 -42 674 -104 -76 74 3 585 2016 499 104 32 -40 -81 -46 46 514 Common and Preferred Stock Cash Dividends Other - Increase (Decrease) FINANCING ACTIVITIES - NET -90 442 0 -73 369 0 -407 -446Step 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