Homework Answers
Firstly all the amounts given in the spreadsheet are not relevant.
- Total Cash flow from operating activities is always after considering the net taxes paid and hence the information of tax rate for calculating cash flow is of no use.
- Total cash flows from financing activities includes the effect of interest paid. Hence the amount of interest paid is of no use in calculation.
- The amount of cash flow from investing activities bears incorrect sign of (-) because if there are negative cash flows then words cannot be cash flow "from" investing activities. If there is a cash outflow then words have to be cash flow "Used in" investing activities.
The three main pillars of cash flow are operating, investing and financing activities.
There fore the cash flow is
| Particulars | 2017 | 2018 | 2019 |
| Operating | 11,491,000 | 10,079,000 | 10,173,000 |
| Investing | 1,473,000 | 1,459,000 | 6,238,000 |
| Financing | - | - | - |
| Cash flow | 12,964,000 | 11,538,000 | 16,411,000 |
Add Answer to:
Using the data in the attached spreadsheet what is the free cash flow for years 2017, 2018 and 20...
Go to the Quiz 5 Spreadsheet. Compute the free cash flow to invested capital for the...
Go to the Quiz 5 Spreadsheet. Compute the free cash flow to invested capital for the year ended January 31, 2018. thousands. (e.g. 2 billion, 851 million would be expressed as 2,851,000). Assume a tax rate of 30.70 % . Use the Walmart Income Stmt and Walmart Cash Flow tabs to Express your answer in compute this result. All Numbers in Thousands 1/31/2019 1/31/2018 1/31/2016 1/31/2017 Revenue 514,405,000 385,301,000 129,104,000 Total Revenue 500,343,000 373,396,000 126,947,000 482,130,000 360,984,000 121,146,000 485,873,000 361,256,000...
Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in 2019....
Compute the Coca-Cola's free cash flow in
2019 using the Coca-Cola's cash flow statement in 2019. Assume that
only "Investments in property, plant and equipment" item in the
investing activities section is operating-related. (Submit the
number in million dollars
E G H J K L M N o Р Q R A B с D 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non...
Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 Pa...
Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 Panel A Balance Sheet: DEBIT CREDIT 12/31/2018 Cash Accounts Receivable 15,300 4,330 14,600 (500) 33,730 19,800 5,330 16,300 (700) Plant Assets 1,700 Accumulated Depreciation 40,730 Total Assets Accounts Payable 6,700 5,400 Common Stock, no par 5,300 28,130 22,830 4,200 33,730 5,500 Retained Earnings 7,200 40,730 Total Liabilities and Stockholders' Equity Panel B_Statement of Cash Flows: 200 Cash Flows from Operating Activities: Net Income Adjustments...
A.) Assume that future free cash flow will grow at 4% per year and their cost...
A.) Assume that future free cash flow will grow at 4% per year
and their cost of capital is 14%, and estimate the fair market
value (i.e., the enterprise value) as of year-end 2017. Enterprise
value = ?
B.) Estimate the firm’s stock price, if there are 100 shares
outstanding. Stock price = ?
Here are the recent financial statements for Lynn Industries: 2017 Income Statement Sales 2,000 1,500 COGS EBIT 500 Interest expense Taxable income Taxes 20 480 192...
i Data Table 2018 2017 Current Assets: Cash $ 86,800 $ 64,200 87,000 17,000 69,000 82,000...
i Data Table 2018 2017 Current Assets: Cash $ 86,800 $ 64,200 87,000 17,000 69,000 82,000 Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable Income Tax Payable 58,000 14,700 55,600 16,500 i Data Table Transaction Data for 2018: Issuance of common stock for cash Depreciation expense Purchase of equipment with cash Acquisition of land by issuing long-term notes payable Book value of building sold $ 46,000 Payment of notes payable 17,000 Payment of cash dividends 69,000 Issuance of notes payable...
Assume that future free cash flow will grow at 4% per year and their cost of...
Assume that future free cash flow will grow at 4% per year and
their cost of capital is 14%, and estimate the fair market value
(i.e., the enterprise value) as of year-end 2017. Enterprise value
= ?
Estimate the firm’s stock price, if there are 100 shares
outstanding. Stock price = ?
Can you please show me how you got to the final answer in
Excel?
Here are the recent financial statements for Lynn Industries: 2017 Income Statement Sales 2,000...
X Data Table November 30, 2018 2017 16,500 $ Current assets: Cash and cash equivalents Accounts...
X Data Table November 30, 2018 2017 16,500 $ Current assets: Cash and cash equivalents Accounts receivable Inventories Prepaid expenses Current liabilities: Accounts payable Accrued liabilities Income tax payable 14,100 63,900 13,600 17,000 21,900 60,500 2,800 55,300 $ 57,800 $ 57,000 9,000 37,000 10,100 Х More Info Acquisition of land by issuing note payable Amortization expense Payment of cash dividend Cash purchase of equipment Issuance of long-term note payable to borrow cash Proceeds from sale of long- $ 118,000 term...
Comment on both Kelloggs’ cash flows (review the statement of cash flows). Cash Flow All numbers...
Comment on both Kelloggs’ cash flows (review the
statement of cash flows).
Cash Flow All numbers in thousands Period Ending 12/29/2018 12/30/2017 1,254,000 Net Income 1,336,000 Operating Activities, Cash Flows Provided By or Used In Depreciation 516,000 481,000 Adjustments To Net Income -267,000 -292,000 Changes in Accounts Receivables 76,000 -1,300,000 Changes In Liabilities 115,000 193,000 Changes In Inventories -86,000 80,000 Changes in Other Operating Activities - 154,000 1,536,000 -13,000 403,000 Total Cash Flow From Operating Activities Investing Activities, Cash Flows...
The comparative balance sheets for 2018 and 2017 and the statement of Income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of Income for 2018 are given below for Wright Company. Additional Information from Wright's accounting records Is provided also. WRIGHT COMPANY Comparative Balance Sheets Decenber 31, 2018 and 2017 (S in eees) 2018 2017 Assets Cash $ 114 $ 100 142 Accounts receivable Short-term investment Inventory Land Buildings and equipnent Less: Accumulated depreciation 145 16 140 50 145 106 130 710 540 (199) (145) $1,068 926 Liabilities Accounts payable...
Suppose Dansko Integrated had the following cash flow results for 2018: Net Cash Flow from Operating...
Suppose Dansko Integrated had the following cash flow results for 2018: Net Cash Flow from Operating Activities of $5,700,000 Net Cash Flow from Investing Activities of -$4,100,000 Net Cash Flow from Financing Activities of $3,900,000 Create a statement of cash flows with amounts in thousands. What is the Net Cash Flow? Please specify your answer in the same units as the statement of cash flows.
Go to the Quiz 5 Spreadsheet. Compute the free cash flow to invested capital for the year ended January 31, 2018. thousands. (e.g. 2 billion, 851 million would be expressed as 2,851,000). Assume a tax rate of 30.70 % . Use the Walmart Income Stmt and Walmart Cash Flow tabs to Express your answer in compute this result. All Numbers in Thousands 1/31/2019 1/31/2018 1/31/2016 1/31/2017 Revenue 514,405,000 385,301,000 129,104,000 Total Revenue 500,343,000 373,396,000 126,947,000 482,130,000 360,984,000 121,146,000 485,873,000 361,256,000...
Compute the Coca-Cola's free cash flow in
2019 using the Coca-Cola's cash flow statement in 2019. Assume that
only "Investments in property, plant and equipment" item in the
investing activities section is operating-related. (Submit the
number in million dollars
E G H J K L M N o Р Q R A B с D 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non...
Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 Panel A Balance Sheet: DEBIT CREDIT 12/31/2018 Cash Accounts Receivable 15,300 4,330 14,600 (500) 33,730 19,800 5,330 16,300 (700) Plant Assets 1,700 Accumulated Depreciation 40,730 Total Assets Accounts Payable 6,700 5,400 Common Stock, no par 5,300 28,130 22,830 4,200 33,730 5,500 Retained Earnings 7,200 40,730 Total Liabilities and Stockholders' Equity Panel B_Statement of Cash Flows: 200 Cash Flows from Operating Activities: Net Income Adjustments...
A.) Assume that future free cash flow will grow at 4% per year
and their cost of capital is 14%, and estimate the fair market
value (i.e., the enterprise value) as of year-end 2017. Enterprise
value = ?
B.) Estimate the firm’s stock price, if there are 100 shares
outstanding. Stock price = ?
Here are the recent financial statements for Lynn Industries: 2017 Income Statement Sales 2,000 1,500 COGS EBIT 500 Interest expense Taxable income Taxes 20 480 192...
i Data Table 2018 2017 Current Assets: Cash $ 86,800 $ 64,200 87,000 17,000 69,000 82,000 Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable Income Tax Payable 58,000 14,700 55,600 16,500 i Data Table Transaction Data for 2018: Issuance of common stock for cash Depreciation expense Purchase of equipment with cash Acquisition of land by issuing long-term notes payable Book value of building sold $ 46,000 Payment of notes payable 17,000 Payment of cash dividends 69,000 Issuance of notes payable...
Assume that future free cash flow will grow at 4% per year and
their cost of capital is 14%, and estimate the fair market value
(i.e., the enterprise value) as of year-end 2017. Enterprise value
= ?
Estimate the firm’s stock price, if there are 100 shares
outstanding. Stock price = ?
Can you please show me how you got to the final answer in
Excel?
Here are the recent financial statements for Lynn Industries: 2017 Income Statement Sales 2,000...
X Data Table November 30, 2018 2017 16,500 $ Current assets: Cash and cash equivalents Accounts receivable Inventories Prepaid expenses Current liabilities: Accounts payable Accrued liabilities Income tax payable 14,100 63,900 13,600 17,000 21,900 60,500 2,800 55,300 $ 57,800 $ 57,000 9,000 37,000 10,100 Х More Info Acquisition of land by issuing note payable Amortization expense Payment of cash dividend Cash purchase of equipment Issuance of long-term note payable to borrow cash Proceeds from sale of long- $ 118,000 term...
Comment on both Kelloggs’ cash flows (review the
statement of cash flows).
Cash Flow All numbers in thousands Period Ending 12/29/2018 12/30/2017 1,254,000 Net Income 1,336,000 Operating Activities, Cash Flows Provided By or Used In Depreciation 516,000 481,000 Adjustments To Net Income -267,000 -292,000 Changes in Accounts Receivables 76,000 -1,300,000 Changes In Liabilities 115,000 193,000 Changes In Inventories -86,000 80,000 Changes in Other Operating Activities - 154,000 1,536,000 -13,000 403,000 Total Cash Flow From Operating Activities Investing Activities, Cash Flows...
The comparative balance sheets for 2018 and 2017 and the statement of Income for 2018 are given below for Wright Company. Additional Information from Wright's accounting records Is provided also. WRIGHT COMPANY Comparative Balance Sheets Decenber 31, 2018 and 2017 (S in eees) 2018 2017 Assets Cash $ 114 $ 100 142 Accounts receivable Short-term investment Inventory Land Buildings and equipnent Less: Accumulated depreciation 145 16 140 50 145 106 130 710 540 (199) (145) $1,068 926 Liabilities Accounts payable...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago