day sales receivable | accounts receivable / average sales per day |
2017 ($) | |
accounts receivable | 171201 |
average sales per day | annual sales / 365 |
annul sales | 156776 |
average sales per day | 430 |
average receivables | (opening receivable + closing receivable)/2 |
2017 ($) | |
opening receivables | 153558 |
closing receivables | 171201 |
average receivables | 162379.50 |
accounts receivable turnover | credit sales / average receivables |
2017 ($) | |
credit sales | 156776 |
average receivables | 162379.5 |
accounts receivable turnover | 0.97 |
accounts receivable turnover in days | 365 / accounts receivable turnover |
2017 | |
accounts receivable turnover | 0.97 |
accounts receivable turnover in days | 376.29 |
average inventory | (opening inventory + closing inventory) / 2 |
2017 ($) | |
opening inventory | 8898 |
closing inventory | 10277 |
average inventory | 9587.50 |
inventory turnover | cost of goods sold / average inventory |
2017 ($) | |
cost of goods sold | 131332 |
average inventory | 9587.50 |
inventory turnover | 13.70 |
inventory turnover in days | 365 / inventory turnover |
2017 | |
inventory turnover | 13.70 |
inventory turnover in days | 26.65 |
working capital | current assets - current liabilities |
2017 ($) | |
total current assets | 115902 |
total current liabilities | 108461 |
working capital | 7441 |
current ratio | current assets / current liabilities |
2017 ($) | |
total current assets | 115902 |
total current liabilities | 94600 |
current ratio | 1.23 |
acid test ratio | (total current assets - inventory) / total current liabilities |
2017 ($) | |
total current assets | 115902 |
less:inventory | -10277 |
quick assets | 105625 |
total current liabilities | 94600 |
acid test ratio | 1.12 |
cash ratio | cash and cash equivalent + marketable security / total current liabilities |
2017 ($) | |
cash and cash equivalent | 18492 |
short term marketable security | 20435 |
total | 38927 |
total current liabilities | 94600 |
cash ratio | 0.41 |
average working capital | (opening working capital + closing working capital) / 2 |
2017 ($) | |
working capital | total current assets - total current liabilities |
opening working capital | |
total current assets | 108461 |
total current liabilities | 90281 |
opening working capital | 18180 |
closing working capital | |
total current assets | 115902 |
total current liabilities | 94600 |
closing working capital | 21302 |
average working capital | 19741 |
sales to working capital | net sales / average working capital |
2017 ($) | |
net sales | 156776 |
average working capital | 19741 |
sales to working capital | 7.94 |
046 x fx 1 Ford Motor Company CONSOLIDATID NALANCES SI 492 22,922 Galerie 2015 171,201 115.902...
D. Ford Motor Company CONSOLIDATED BALANCE SHEET- USD (SI S in Millions Dec. 31, 2017 Dec. 31, 2016 ASSETS Cash and cash equivalents Short term Marketable securities (Note 9) Accounts receivables, (less allowances of $392 for 2017 and $412 for $ 18,492 $ 15,905 Calculate Gross Recievables 20,435 22.922 171,201 153,558 2016) Inventories (Note 12) Other assets Total current assets olFinancial Services finance receivables, net (Note 10) Net investment in operating leases 2Net property (Note 14) BEquity in net assets...
Current ratio Quick ratio Debt to equity ratio Times interest earned ratio Receivables turnover ratio Average collection period Inventory turnover ratio Average days inventory held Payables turnover ratio Average days payables outstanding Asset turnover ratio Profit margin on sales Return on assets (ROA) Return on shareholders' equity (ROE) To calculate the above statement using the following material: FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET (in millions) December 31 2018 December 31 2017 ASSETS Cash and cash equivalents (Note 9)...
Consolidated Balance Sheets USD (S) S in Millions Dec. 31, 2016 Dec. 31, 2017 2 Current Assets 3 Cash and cash equivalents $15.512 $12,574 11,841 Marketable securities (Note 4) 4 8,313 Calculate Gross Recievables S Accounts and notes receivable (net of allowance of $278 for 2017 and S212 for 2016) 6 nventories (Note 6) 7 Equipment on operating leases, net (Note 7) 8 Other current assets (Note 4; Note 12 at VIES) 9 Current assets held for sale (Note 3)...
212,482 Consolidated Balance Sheets - USD $ $ In Mill 2 Current Assets Cash and cash equivalents Martable securities Note 4) Accounts and notes receivable et of lowance of $278 for 2017 id $212 for 2016) Inventaries Note 6) Equipment on operating l o te 7) 8 Other current N ote 4 Note 12 at VE 9. Current held for sale Note 3) 10 Total currentes 11 Non-current Assets 12 Equity in news of nonconsolidated affiliates Note 8) 13 Property,...
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...
Can this question please be answered? 1) Using the formulas in Table 4.1 and Urban Outfitters’s financial statement starting on page 117, calculate the following measures of financial performance. Be sure to report items (a) through (e) in percentages (i.e., multiply your result x 100). a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders’ equity f. Return on assets g. Debt-to-equity ratio h. Days of inventory i. Inventory...
5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...
Using the following information: Calculate the following ratios for Urban Outfitters for both 2016 and 2017 (show calculations): a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times interest earned coverage e. Return on shareholders’ equity f. Return on assets g. Debt-to-equity ratio h. Days of inventory i. Inventory turnover ratio j. Average collection period Consolidated Income Statements for Urban ters, Inc. 2016 2017 $3.545.794 $3,445,134 Net sales (total revenue) 2,301,181 2,243,232 Cost of sales 906,086...
Using the formulas in Table 4.1 and Urban Outfitters’s financial statement starting on page 117, calculate the following measures of financial performance. Be sure to report items (a) through (e) in percentages (i.e., multiply your result x 100). a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders’ equity f. Return on assets g. Debt-to-equity ratio h. Days of inventory i. Inventory turnover ratio j. Average collection period From...
Oriole Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) Net sales Cost of goods sold Selling and administrative expenses Nonrecurring expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Earnings before interest and taxes (EBIT) Interest expense Earnings before taxes (EBT) Taxes (35%) Net income $2,110,000 1,460,000 317,000 27,000 $306,000 113,000 193,000 118,000 $75,000 26,250 $48,750 Oriole Supply Company Balance Sheet as of June 30, 2017($ thousands) Assets: Liabilities and Equity: Cash and marketable...