Question

In: Accounting

Financial statement data for years ending December 31for Depuy company follow

Financial statement data for years ending December 31for Depuy company follow

ParticularsYear 2Year 1
Sales $5,510,000$4,880,000
Fixed assets :  
Beginning of year16,00,00014,50,000
End of year2,200,00016,00,000

(a) Determine the fixed asset turnover ratio for year 1 and year 2

(b)Does the change in the fixed asset turnover from year 1 to year 2 indicate a favorable or an unfavourable change?

 

 

Solutions

Expert Solution

Fixed asset turnover : It is a ratio that assesses the fixed assets' productive potential to create sales income for the firm. As a result, it demonstrates the link between net sales and average total fixed assets. The formula for calculating the ratio is as follows.

Fixed asset turnover = Sales / Average total fixed assets

Calculation of fixed asset turnover ratio for year 1

Fixed assets turnover = Sales / Average Fixed assets

                                   = $4,880,000 / $1,525,000

                                   = 3.2 times

Calculation of Average total fixed assets

Average total fixed assets = Total beginning fixed assets + Total ending fixed assets

=$14,50,000 + $16,00,000

=$15,25,000

Calculation of fixed asset turnover ratio for year 2

Fixed assets turnover = Sales / average fixed assets

                                   = $5,510,000 / $1,900,000

                                   =  2.9 times

Calculation of average total fixed assets

Average total fixed assets = Total beginning fixed assets + Total Ending fixed assets 

=$1,600,000 + $2,200,000 / 2

=$1,900,000

 

 

 


(a)Therefore, the fixed assets turnover for year 1 is 3.2 times and for year 2 is 2.9 times

(b)The change in the fixed asset turnover ratio from Year 1 to Year 2 is unfavourable , with the ratio decreasing from 3.2 to 2.9 times. This is due to the company's poor use of fixed assets, which resulted in lesser revenue creation.

Related Solutions

Financial statement data for the years ended December 31 for Dovetail Corporation follow :
Financial statement data for the years ended December 31 for Dovetail Corporation follow :Particulars20Y320Y2Net income$448,750$376,000Preferred Dividends$40,000$40,000Average number of common shares outstanding75,000 shares60,000 shares(a) Determine the earnings per share for 20Y3 and 20Y2(b) Does the change in the earnings per share from 20Y2 to 20Y3 indicate a favorable or unfavorable trend ?
Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December...
Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December 31 for Holland Company are shown below. 20Y4 20Y3 Cost of merchandise sold $1,778,280 $1,093,905 Inventories:   Beginning of year 347,480 243,820   End of year 499,320 347,480 a. Determine the inventory turnover for 20Y4 and 20Y3. Round to one decimal place. Inventory Turnover 20Y4 20Y3 b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and...
Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December...
Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Y7 20Y6 Cost of goods sold $3,791,255 $4,040,550 Inventories: Beginning of year 766,500 730,000 End of year 846,800 766,500 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Y7 20Y6 Inventory turnover b. Determine the number of days’ sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal...
Financial statement data for the years ended December 31 for Dovetail Corporation follow: 20Y3 20Y2 Net...
Financial statement data for the years ended December 31 for Dovetail Corporation follow: 20Y3 20Y2 Net income $1,099,000 $913,250 Preferred dividends $168,000 $168,000 Average number of common shares outstanding 70,000 shares 55,000 shares a. Determine the earnings per share for 20Y3 and 20Y2. Round your answers to two decimal places. 20Y3 $ per share 20Y2 $ per share b. Does the change in the earnings per share from 20Y2 to 20Y3 indicate a favorable or an unfavorable trend?
Financial statement information is provided for the three years ending December 31, 2015, 2016 and 2017....
Financial statement information is provided for the three years ending December 31, 2015, 2016 and 2017. 2017 2016 2015 Cash $443,550 $355,750 $142,800 Accounts Receivable $59,600 $62,500 $58,400 Merchandise Inventory $87,000 $90,100 $85,000 Prepaid Expenses $6,400 $5,800 $5,800 Notes Receivable, due in 2018 $5,000 $5,500 $5,000 Property, Plant & Equipment $580,175 $518,525 $528,950 Accumulated Depreciation $114,175 $96,525 $97,950 Accounts Payable $16,900 $17,800 $15,000 Unearned Sales $6,100 $6,500 $7,400 Notes Payable, due in 2017 $119,000 $126,000 $124,000 I.C. Rhodes, Capital $1,075,550...
Baxter Equipment Company - Income Statement for Years Ending December 31st Note: All figures add 3...
Baxter Equipment Company - Income Statement for Years Ending December 31st Note: All figures add 3 zeros ($000) 2019 2018 Net Sales $3,000 $2,850 Costs & Expenses Labor and Materials $2,544 $2,413 Depreciation $100 $90 Selling $22 $20 G & A $40 $35 Leases $28 $28 Total Costs $2,734 $2,586 Operating Profit $266 $264 Interest Expense $66 $47 Federal & State Taxes $80 $87 Net Income $120 $130 Preferred Dividends $8 $8 Earnings $112 $122 Baxter Equipment Company - Balance...
Condensed financial data of Ivanhoe Company follow. Ivanhoe Company Comparative Balance Sheets December 31 Assets 2017...
Condensed financial data of Ivanhoe Company follow. Ivanhoe Company Comparative Balance Sheets December 31 Assets 2017 2016 Cash $ 92,920 $ 55,660 Accounts receivable 100,970 43,700 Inventory 129,375 118,278 Prepaid expenses 32,660 29,900 Long-term investments 158,700 125,350 Plant assets 327,750 278,875 Accumulated depreciation (57,500 ) (59,800 ) Total $784,875 $591,963 Liabilities and Stockholders’ Equity Accounts payable $ 117,300 $ 77,395 Accrued expenses payable 18,975 24,150 Bonds payable 126,500 167,900 Common stock 253,000 201,250 Retained earnings 269,100 121,268 Total $784,875 $591,963...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash $ 8.50...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash $ 8.50 $ 16.00 Accounts receivable 54.00 47.00 Inventory 97.50 84.40 Total current assets 160.00 147.40 Property, plant, and equipment 237.00 198.00 Less accumulated depreciation 47.20 35.40 Net property, plant, and equipment 189.80 162.60 Total assets $ 349.80 $ 310.00 Liabilities and Stockholders’ Equity Accounts payable $ 58.50 $ 48.00 Common stock 126.00 97.00 Retained earnings 165.30 165.00 Total liabilities and stockholders’ equity $ 349.80 $...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash and cash...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash and cash equivalents $ 7.00 $ 13.00 Accounts receivable 48.00 41.00 Inventory 90.00 76.60 Total current assets 145.00 130.60 Property, plant, and equipment 228.00 192.00 Less accumulated depreciation 44.80 33.60 Net property, plant, and equipment 183.20 158.40 Total assets $ 328.20 $ 289.00 Liabilities and Stockholders’ Equity Accounts payable $ 54.00 $ 45.00 Common stock 114.00 88.00 Retained earnings 160.20 156.00 Total liabilities and stockholders’ equity...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash $ 8.50...
Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash $ 8.50 $ 16.00 Accounts receivable 54.00 47.00 Inventory 97.50 84.40 Total current assets 160.00 147.40 Property, plant, and equipment 237.00 198.00 Less accumulated depreciation 47.20 35.40 Net property, plant, and equipment 189.80 162.60 Total assets $ 349.80 $ 310.00 Liabilities and Stockholders’ Equity Accounts payable $ 58.50 $ 48.00 Common stock 126.00 97.00 Retained earnings 165.30 165.00 Total liabilities and stockholders’ equity $ 349.80 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT