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.
-
Oakdale Fashions, Inc. had $245,000 in 2018 taxable income.
Using the tax schedule in Table 2.3...
asked 10 minutes ago -
The marketing class at CSUS had an average score of 150. An
educational analyst determined that...
asked 1 hour ago -
Justin Case has purchased a $250 000 home by putting 20 % down
and taking out...
asked 1 hour ago -
1. In a labor market, marginal cost for a firm is
____________.
a. recruiting cost
b....
asked 2 hours ago -
On January 1, 2019, ABC Company issued $60,000,000 of 20-year,
10.5% bonds when the market rate...
asked 2 hours ago -
39.4% of US homes continue to use a landline in addition to cell
phone service. 3...
asked 3 hours ago -
Starting with benzene, synthesize 1-phenyl-1-butyne.
Show intermediates and reagents.
asked 4 hours ago -
Create a 32-run crossed array design with six control factors
and two noise factors such that...
asked 5 hours ago -
A 500g sample of sand from source A has the following amounts
retained on each sieve....
asked 5 hours ago -
In
your own words, please explain the essay by John Keynes wrote "The
End of Laissez...
asked 5 hours ago -
How are the matrix and pixels related? Why are smaller
pixels better for diagnostic quality?
asked 5 hours ago -
2. An AC generator has 80 rectangular loops on
its armature. Each loop is 11 cm...
asked 5 hours ago