Create the 2018 statement of cash flows, and it should be created on the appropriate tab of the Excel. Also finish the last picture of the all totals and sub totals.
Cash Flow Statement: | |
Amount $ | |
Cash from operating activities: | |
Net Income | 7639 |
Add:Depreciation | 2550 |
Add:Amortization | 45 |
Less:Gain on sale of Property & eq. | -169 |
Less: increase in AR | -10 |
Less:Increase in MI | -215 |
Add:decrease in other current assets | 43 |
Less:decrease in AP | -260 |
add:increase in AL | 46 |
add:increase in ITP | 52 |
add:current LTD | 17 |
Net cash from operating activities | 9738 |
Cash from investing activities: | |
less: purchase of equip | -2091 |
add:sale of equip | 476 |
Net cash outflow of Investing act. | -1615 |
Cash from financing activities: | |
less:treasury stock purchased | -970 |
add:issued CS | 204 |
less:dividend paid | -16 |
add:debt added | 417 |
Net Cash outflow of financing act. | -365 |
Net Cash inflow of all activities | 7758 |
add:opening cash and cash equivalent | 1407 |
Closing cash and cash equivalents | 9165 |
RATIOS | Formula | Calculations | Result |
Current ratio | CA/CL | 15120/2714 | 5.57 |
Acid Test ratio | (CA-Inv.)/CL | (15120-4029)/2714 | 4.09 |
AR Turnover | Sales / Avg AR | (44452*2)/(1600+16100) | 5.02 |
Days sale uncollected | 365 / AR t/o | 365/5.02 | 72.71 |
Inventory turnover | COGS/ Avg Inv. | (24969*2)/(4029+3814) | 6.37 |
Days sales in Inventory | 365/ Inv. T/o | 365/6.37 | 57.30 |
Total Asset Turnover | Sales /Avg TA | (44452*2)/(23062+15933) | 2.28 |
Debt to equity | T. Debt/ Sh. Eq. | 8614/23062 | 0.37 |
Times interest earned | EBIT / Int exp. | 9706/205 | 47.35 |
profit margin | NP/ Sales | 7639/44452 | 0.17 |
return on total Assets | NP / TA | 7639/23062 | 0.33 |
return on stockholders' equity | NP / SH. Eq. | 7639/14448 | 0.53 |
EPS | NP / Number of O/s shares | 7639/370 | 20.65 |
Create the 2018 statement of cash flows, and it should be created on the appropriate tab...
Use the information in the provided Income Statement and Balance Sheet to create the 2017 Statement of Cash Flows and ratio calculations for 2017. Income Statement For the Years Ended December 31, 2017 and 2016 $ in millions 2016 2017 Revenue Net sales Cost of merchandise sold $27,528 37,043 20,807 16,236 16,099 11,429 Gross Profit Operating Expenses Selling, general and administrative Depreciation Amortization 5,757 1,223 124 4,449 5,985 2,499 124 7,752 Operating income Interest expense, net Gain/(Loss) on sale of...
Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...
Using the income statement and balance sheets shown above, create an appropriate cash flow statement including the required disclosures. Thank you. (Dollars in Millions) 2017 2016 $1,074 3,795 378 5,247 8,103 224 $13, 574 $707 4,038 331 5,076 8, 308 222 $13, 606 $1,507 1,200 24 112 $1,251 1,180 26 130 Assets Current assets: Cash and cash equivalents Merchandise inventories Prepaid expenses Total current assets Property and equipment, net Other assets Total assets Liabilities and Shareholders Equity Current liabilities: Accounts...
Using the income statement and balance sheets shown above, create an appropriate cash flow statement including the required disclosures. Thank you. (Dollars in Millions) 2017 2016 Assets Current assets: Cagh and cash equivalents Merchandise inventories Prepaid expenses Total current assets Property and equipment, net Other assets Total assets $1,074 3,795 378 5,247 8,103 224 $13, 574 $707 4,038 331 5,076 8, 308 222 $13, 606 $1,507 1,200 24 112 $1,251 1,180 26 130 134 127 All current portion paid Liabilities...
Prepare the 2018 statement of cash flows for Smolira Golf Corp. (A negative answer should be indicated by a minus sign.) Some recent financial statements for Smolira Golf Corp. follow. Assets 2017 2018 Current assets Cash Accounts receivable Inventory $ 34,385 17.801 36,310 SMOLIRA GOLF CORP 2017 and 2018 Balance Sheets Liabilities and Owners' Equity 2018 2017 Current liabilities $ 37,837 Accounts payable $36,722 27.766 Notes payable 19,008 42,632 Other 19,864 $108.235 Total $ 75,594 Long-term debt $115.000 $ 42,582...
Create a statement of cash flows for the year 2019 2019 2018 Sales 11,000 10,000 COGS 9,322 8,448 Gross Profit 1,678 1,552 Depreciation and amortization 380 360 Selling & Admin. Expense 290 280 Earnings before interest and taxes 1,008 912 Interest expense 120 100 Earnings Before taxes 888 812 Taxes 222 203 Net income 666 609 Note: Tax rate 25% 2019 2018 Assets Cash 550 500 Short-term Investments 110 100 Accounts Receivable 2,750 2,500 Inventories 1,650 1,500 Total current assets...
Prepare a forecasted statement of cash flows for 2017 using the indirect method. Assume the following: • Operating expenses for 2017 (such as general and administrative) include depreciation and amortization expense of $522 million. • The company did not dispose of or write-down any long-term assets during the year. • The company paid dividends of $159 million in 2017 P11-47. Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Whole Foods Market Inc., for...
Prepare a statement of cash flows based on the following financial statements: Balance Sheet 2017 2018 Assets Current assets Cash $5,000 $6,500 Accounts receivable $31,500 30,000 $42,000 Inventory 40,000 Total $75,000 $80,000 Fixed assets Net plant and equipment $393,750 375,000 $450,000 Total assets $473,750 Liabilities and Owners Equity Current liabilities Accounts payable $50,000 $53,750 Notes payable 25,000 $26,250 Total $75,000 $80,000 Long-term debt Owners' equity $85,000 $89,250 Common stock $60,000 $63,000 Accumulated retained 241,500 230,000 earnings Total $290,000 $304,500 Total...
Create a Spreadsheet for Statement of Cash Flows for the below ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses): Interest Revenue Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income 141,200 94,400 11,500 (24,400) (12,900) 81,500...
ASSIGNMENT 2 BUSINESS FINANCE FIN 3200 10 Points KUIPERS ENTERPRISES 2018 Income Statement ($ in millions Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes (34%) Net income Addition to retained earnings $1,512 Dividends $9,000 4,500 700 $3,800 $2,112 600 2018 KUIPERS ENTERPRISES Balance Sheets as of December 31, 2017 and 2018 {$ in millions) Assets 2017 2018 Liabilities and Owners' Equity 2017 Current assets Current liabilities Cash $ 404 $ 247 Accounts payable Receivables 1,115 1.616...