4. Suppose the Robinson Company had a cost of goods sold of $1,000,000 in 2016 and $1,200,000 in 2017. a. Calculate the inventory turnover for each year. Comment on your findings. b. What would have been the amount of inventories in 2017 if the 2016 turnover ratio had been maintained?
Homework Answers
Add Answer to:
4. Suppose the Robinson Company had a cost of goods sold of
$1,000,000 in 2016 and...
Calculate the accounts receivable turnover, average collection period (days), inventory turnover, fixed asset turnover, and total...
Calculate the accounts receivable turnover, average collection
period (days), inventory turnover, fixed asset turnover, and total
asset turnover for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME...
2016 Current Assets 2017
2016 Current Assets 2017 Sources Uses Cash 30,000 40,000 Accounts Receivable 190,000 225,000 Inventory 30,000 35,000 TOTAL CURRENT ASSETS 250,000 300,000 Fixed Assets Property and Equipment 1,400,000 1,500,000 Other Assets 200,000 100,000 Total Assets 1,850,000 1,900,000 Current Liabilities Accounts Payable 140,000 135,000 Rent Payable 50,000 50,000 Wages Payable 10,000 15,000 Notes Payable 1,000,000 1,000,000 Total Liabilities 1,200,000 1,200,000 Owner’s Equity 650,000 700,000 Total Sources and Uses of Funds...
Calculate the current ratio, quick ratio, long-term debt/total assets, times interest earned, and fixed cost coverage...
Calculate the current ratio, quick ratio, long-term debt/total
assets, times interest earned, and fixed cost coverage using the
picture below.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS...
The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000...
The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000 and paid $10,000 in taxes in 2017. Following are the Company’s balance sheets for 2016 and 2017. C&B CASTILLO COMPANY 2016 2017 Cash $50,000 $5,000 Accounts Receivables 200,000 300,000 Inventories 400,000 480,000 Total Current Assets 650,000 785,000 Gross Fixed Assets 450,000 570,000 Accumulated Depreciation -100,000 -140,000 Net Fixed Assets ...
3) The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 2016...
3) The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 2016 Sales $4,000,000 $3,500,000 Cost of Goods Sold 2,500,000 2,400,000 Gross Profit 1,500,000 1,100,000 Selling Expense 600,000 700,000 Administrative Expense 200,000 150,000 Total Operating Expense 800,000 850,000 Income from Operations 700,000 250,000 Income Tax Expense 50,000 20,000 Net Income 650,000 230,000 Instructions: Using the above comparative income statement, prepare a horizontal analysis for ABC Company. (10 points)
Find the profit margin, ROA, and ROE for each period. X2 X3 X4 $2,500,000 3.200,000 3,500,000...
Find the profit margin, ROA, and ROE for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS RETAINED EARNINGS 125,000 87,000 56,550 7,850 50,000 40,000 CASH ACCOUNTS...
Kapow, Inc. Comparative Balance Sheet December 31, 2017 and 2016 2017 2016 $ 200,000 550,000 50,000...
Kapow, Inc. Comparative Balance Sheet December 31, 2017 and 2016 2017 2016 $ 200,000 550,000 50,000 $800,000 $100,000 500,000 50,000 $650,000 Assets Total Current Assets Property, Plant, and Equipment, Net Other Assets Total Assets Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Stockholders' Equity $150,000 350,000 500,000 $100,000 250,000 350,000 300,000 $800,000 300,000 $650,000 Perform a vertical analysis of Kapow's balance sheet for each year. (Round to one decimal plac
Help with #8 please? quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets...
Help with #8 please?
quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2017. C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, Novem ber, and December 2017. D. Describe your findings and indicate the maximum amount of bank borrowing that is needed & Cash Conversion Cycle Two years of financial statement data for the Munich Export Corpor shown below. A. Calculate...
Please refer to Table 4−1 for the following questions. Stewart Company Balance Sheet Assets: ...
Please refer to Table 4−1 for the following questions. Stewart Company Balance Sheet Assets: Cash and marketable securities $600,000 Accounts receivable 900,000 Inventories 1,500,000 Prepaid expenses 75,000 Total current assets $3,075,000 Fixed assets 8,000,000 Less: accum. depr. (2,075,000) Net fixed assets $5,925,000 Total assets $9,000,000 Liabilities: Accounts payable $800,000 Notes payable 700,000 Accrued taxes 50,000 Total current liabilities $1,550,000 Longminus−term debt...
Balance Sheets Liabilities R.A Ltd. A.R Ltd. Assets R.A Ltd. A.R Ltd. Share Capital £ 600,000...
Balance Sheets Liabilities R.A Ltd. A.R Ltd. Assets R.A Ltd. A.R Ltd. Share Capital £ 600,000 £ 800,000 Land and Building £ 500,000 £ 800,000 Reseve and Surplus £ 150,000 £ 350,000 Plant and Machinery £ 300,000 £ 700,000 14% Debentures £ 400,000 £ 1,000,000 Furniture £ 200,000 £ 400,000 Mortgaged Loan £ 100,000 £ 500,000 Office Equipments £ 110,000 £ 230,000 Sundry Creditors £ 200,000 £ 300,000 Stock £ 300,000 £ 500,000 Bills Payable £ 100,000 £ 250,000 Sundry...
Calculate the accounts receivable turnover, average collection
period (days), inventory turnover, fixed asset turnover, and total
asset turnover for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME...
Calculate the current ratio, quick ratio, long-term debt/total
assets, times interest earned, and fixed cost coverage using the
picture below.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS...
Find the profit margin, ROA, and ROE for each period.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS RETAINED EARNINGS 125,000 87,000 56,550 7,850 50,000 40,000 CASH ACCOUNTS...
Kapow, Inc. Comparative Balance Sheet December 31, 2017 and 2016 2017 2016 $ 200,000 550,000 50,000 $800,000 $100,000 500,000 50,000 $650,000 Assets Total Current Assets Property, Plant, and Equipment, Net Other Assets Total Assets Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Stockholders' Equity $150,000 350,000 500,000 $100,000 250,000 350,000 300,000 $800,000 300,000 $650,000 Perform a vertical analysis of Kapow's balance sheet for each year. (Round to one decimal plac
Help with #8 please?
quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2017. C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, Novem ber, and December 2017. D. Describe your findings and indicate the maximum amount of bank borrowing that is needed & Cash Conversion Cycle Two years of financial statement data for the Munich Export Corpor shown below. A. Calculate...
Most questions answered within 3 hours.
-
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 34 minutes ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 36 minutes ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 41 minutes ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 45 minutes ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 55 minutes ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 1 hour ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 1 hour ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 1 hour ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 1 hour ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 1 hour ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 1 hour ago -
Inheritance pattern in BRCA 1
Describe the inheritance pattern of BRCA 1 Is it recessive or...
asked 1 hour ago