Question

2) Youve obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 Categor Crrent Assets 2015 S50 2016 $80 2016 $50 Categor Sales Cost of Goods Sold Interest Expense 420 60 $24 S5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owners Equity 250 30 25 150 95 40 250 150 Depreciation Tax Rate S6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c)What is the free cash flow to creditors? What is the free cash flow to bondholders? d)If accounts payable increases, briefly explain in a sentence or two, how that would affect free cash flow for the company,

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut copy ▼ Format Painter Σ AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Clipboard Alignment Number Cells LK234 LK LM LN LO LP LQ LR LS LT LU LV 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 /4 く トト1 OCF CASH FLOW STAT N | FCF . ARM, MS,confidenceINDEX . CURRENCY . LOAN , CROSS OVER , HEDGING MONEY MARKET . GM HPR AM , TAX , GROWTH SUST, PREF AND DIV POLICY SALES COGS DEPRECIATION EBIT INTEREST EBT TAX NET INCOME 24 6 20 15 4.50 10.50 OPERATING CASH FLOW EBIT DEPRECIATION TAXES OCF 20.00 6.00 4.50 21.50 ADD LESS FCF OCF INCREASE IN CAPITAL EXPENDITURE INCREASE IN OPERATING WORKING CAPITAL FCF = 21.50-176-(-15)- -139.50 erences: EV46 25-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Σ AutoSum 11.A. A.--- 9- ー E ゴText ずWrap Text General copy ▼ Format Painter B l U. -...Δ.-=-- Conditional Format Cell Formatting, as Table w styles. Paste Merge & Center. $ , % , , , Insert Delete Format Sort &Find & 2 ClearFe Select Edting ▼ ㆆ ▼ Clipboard LU268 LI Alignment Number Cells LK LM 1쎄 1(》 LP LQ I.S LT LU LV 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 FCF OCF - INCREASE IN CAPITAL EXPENDITURE INCREASE IN OPERATING WORKING CAPITAL FCF-21.50-176-(-15)- 139.50 NOTE INCREASE IN CAPITAL EXPENDITURE DIFFERENCE IN NET FIXED ASSETSDEPRECIATION INCREASE IN CAPITAL EXPENDITURE 420-250 +6- 176 NOTEINCREASE IN OPERATING WORKING CAPITAL CURRENT ASSETS- CURRENT LIABILITIES) OF 2016 (CURRENT ASSETS- CURRENT LIABILITIES) OF 20 INCREASE IN OPERATING WORKING CAPITAL (80-(60+40)-(50-(30+25))- 15 CASH FLOW TO CREDITORS (INTEREST PAID NET NEW BORROWINGS) (5 (250-150)) CASH FLOW TO BOND HOLDERS IS SAME AS CASHFLOW TO CREDITORS -95 FREE CASH FLOW CASH FLOW FROM ASSETS CASH FLOW TO CREDITORS +CASHFLOW TO STOKHOLDERS -139.5 95 CASH FLOW TO STOCK HOLDERS CASHFLOW TO STOCK HOLDERS -44.5 IF ACCOUNTS PAYABLE INCREASES, WORKING CAPITAL WILL DECREASE, SO FREE CASH FLOW WILL INCREASE OF CASH FLOW STATW FCFARM, MSI,confidence INDEX CURRENCY LOAN CROSS OVER HEDGING MONEY MARKET GM HPR AM TAX GROTH SUST PREF AND DIV POLICYD erences: EV46 25-01-2019

Add a comment
Know the answer?
Add Answer to:
2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement...

    2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016. 2016 Categor Current Assets 2015 S50 Categor Sales Cost of Goods Sold Interest Expense $80 S50 250 30 420 60 $24 $5 Net Fixed Assets Accounts Pavable Accrued Expenses Long-term Debt Owner's Equit 25 150 95 40 250 150 Depreciation Tax Rate S6 30% a)Calculate the Operating Cash Flow for 2016. b)Calculate the Free Cash Flow for 2016. c)What is the...

  • 2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement...

    2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 2016 $80 Catego 2015 $50 Cate 2016 $50 Sales Cost of Goods Sold Interest Expense Current Assets 420 60 $24 $5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owner's Equit 250 30 25 150 95 40 250 150 Depreciation Tax Rate $6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c) What...

  • 2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement...

    2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 2016 $80 Catego 2015 $50 Cate 2016 $50 Sales Cost of Goods Sold Interest Expense Current Assets 420 60 $24 $5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owner's Equit 250 30 25 150 95 40 250 150 Depreciation Tax Rate $6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c) What...

  • Please refrain from using excel thanks! 2) You've obtained the following balance sheet information for 2015...

    Please refrain from using excel thanks! 2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 Catego 2015 $50 2016 Cate 2016 $50 $80 Sales Cost of Goods Sold Interest Expense Current Assets 420 60 $24 $5 Net Fixed Assets Accounts Payable Accrued Expenses 250 30 25 150 95 40 250 150 $6 30% Depreciation Long-term Debt Owner's Equity Tax Rate a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free...

  • Incorporation reported the following financial statements for the last two years. 2016 Income Statement Sales $...

    Incorporation reported the following financial statements for the last two years. 2016 Income Statement Sales $ 567,200 Costs of goods sold 274,005 Selling and administrative 124,729 Depreciation 54,572 EBIT $ 113,894 Interest 19,384 EBT $ 94,510 Taxes 37,804 Net income $ 56,706 Dividends $ 10,000 Addition to retained earnings $ 46,706 INC. Balance Sheet as of December 31, 2015 Cash $ 13,360 Accounts payable $ 9,500 Accounts receivable 18,990 Notes payable 14,504 inventory 13,798 Current liabilities $ 24,004 Current assets...

  • Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016....

    Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016. The income statement for 2016 is also given. Find the following: 1. What was cash flow from assets in 2016? 2. What was the cash flow to creditors in 2016? 3. What was the cash flow to stockholders in 2016? Intro Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016. 2015 2016 Cash 900 1,000 Accounts receivable...

  • Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016....

    Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016. 1. What was the cash flow to creditors in 2016? 2. What was the cash flow to stockholders in 2016? Intro Below is the balance sheet for Southern Comfort Company for December 31 of 2015 and 2016. 2015 2016 2015 2016 Cash 900 1,000 Accounts payable 2,700 3,000 Accounts receivable 2,700 3,000 Current liabilities 2,700 3,000 Inventory 2,700 3,000 Long-term debt 5,400 6,000 Current...

  • The balance sheet of December 31, 2015, 2016, and 2017 and income statement for the years...

    The balance sheet of December 31, 2015, 2016, and 2017 and income statement for the years ended December 31, 2015, 2016, and 2017 for Navajo Inc. include the following data Click icon to view the balance sheet.) Click icon to view the income statement) Requirements Use the years of data to answer the following: 1. Calculate the current ratio for 2015, 2016 and 2017 2. Chovate the debt ratio for 2015, 2016, and 2017 3. Evaluate each rate and determine...

  • Use the following information to create an income statement and balance sheet for 2018 and 2019;...

    Use the following information to create an income statement and balance sheet for 2018 and 2019; assume the tax rate is 34%. Then, using those statements, calculate for 2019: Cash flow from assets, Cash flow to creditors, Cash flow to stockholders 2016 2017 Sales 50,920 56,916 Depreciation expense 7,308 7,640 Cost of goods sold 17,508 20,712 Other expense 4,164 3,624 Interest  expenses 3,416 4,076 Cash 26,696 28,452 Accounts receivables 33,348 41,484 short term notes payables 5,152 5,048 long term debt 89,408...

  • Use the following information for the remaining problems. First, construct an income statement and two balance...

    Use the following information for the remaining problems. First, construct an income statement and two balance sheets. Enter all answers as whole dollar numbers with no $ or commas (e.g. 20000). 2015 Sales = $60,000 2015 COGS = $25,000 2015 SG&A Expense = $10,000 2015 Depreciation Expense = $5,000 2015 Interest Expense = $3,000 Average Tax Rate = 30% Dividend Payout Ratio = 55% 2015 Current Assets = $24,000 and 2016 Current Assets = $27,000 2015 Net Working Capital =...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT