Question

046 x fx 1 Ford Motor Company CONSOLIDATID NALANCES SI 492 22,922 Galerie 2015 171,201 115.902 28.235 32.072 10,973 3.104 257
BE с ta 151,800 156,776 Marcar criceveres 40 Total Net Sales E 41 Costs and expenses Cost of Goods Sold Selling administrativ
I need the excel formula for the calculation for the yellow boxes.
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
046 x fx 1 Ford Motor Company CONSOLIDATID NALANCES SI 492 22,922 Galerie 2015 171,201 115.902...
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
  • D. Ford Motor Company CONSOLIDATED BALANCE SHEET- USD (SI S in Millions Dec. 31, 2017 Dec....

    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 rati...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

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