Question

In: Accounting

Aritelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2...

Aritelli Company has provided the following comparative information:

    Year 5     Year 4     Year 3     Year 2     Year 1
Net income $1,035,300 $892,500 $750,000 $641,000 $543,200
Interest expense 352,000 321,300 277,500 211,500 168,400
Income tax expense 331,296 249,900 210,000 166,660 130,368
Average total assets 6,901,990 6,099,497 5,215,736 4,440,104 3,785,106
Average stockholders' equity 2,347,619 2,109,929 1,851,852 1,647,815 1,448,533

You have been asked to evaluate the historical performance of the company over the last five years.

Selected industry ratios have remained relatively steady at the following levels for the last five years:

  Industry Ratios
Return on total assets 19.8 %
Return on stockholders' equity 40.9 %
Times interest earned 4.6

Instructions:

Calculate three ratios for Year 1 through Year 5. Round to one decimal place.

a. Return on total assets:

Year 5 ? %
Year 4 ? %
Year 3 ? %
Year 2 ? %
Year 1 ? %

b. Return on stockholders' equity:

Year 5 ? %
Year 4 ? %
Year 3 ? %
Year 2 ? %
Year 1 ? %

c. Times interest earned:

Year 5 ?
Year 4 ?
Year 3 ?
Year 2 ?
Year 1 ?

Solutions

Expert Solution

Return on Assets(Net Income / Average Total Assets)
Year 5 =($1,035,300 / $6,901,990)*100 15.0%
Year 4 =($892,500 / $6,099,497)*100 14.6%
Year 5 =($750,000 / $5,215,736)*100 14.4%
Year 5 =($641,000 / $4,440,104)*100 14.4%
Year 5 =($543,200 / $3,785,106)*100 14.4%
Return on Stockholder's Equiy(Net Income / Average Stockholder's Equiy)
Year 5 =($1,035,300 / $2,347,619)*100 44.1%
Year 4 =($892,500 / $2,109,929)*100 42.3%
Year 5 =($750,000 / $1,851,852)*100 40.5%
Year 5 =($641,000 / $1,647,815)*100 38.9%
Year 5 =($543,200 / $1,448,533)*100 37.5%
Times Interest earned ratio =Earning before interest & taxes / Interest expenses
Year 5 =[($1,035,300+$352,000+$331,296) / $352,000] 4.9
Year 4 =[($892,500+$321,300+$249,900) / $321,300] 4.6
Year 3 =[($750,000+$277,500+$210,000) / $277,500] 4.5
Year 2 =[($641,000+$211,500+$166,660) / $211,500] 4.8
Year 1 =[($543,200+$168,400+$130,368) / $168,400] 5.0

Related Solutions

Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,283,300 $1,106,300 $929,700 $794,600 $673,400 Interest expense 436,300 398,300 344,000 262,200 208,800 Income tax expense 410,656 309,764 260,316 206,596 161,616 Average total assets 7,676,786 6,777,477 5,789,545 4,915,349 4,181,043 Average stockholders' equity 2,629,713 2,353,830 2,056,858 1,822,477 1,595,735 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,052,000 $906,900 $762,100 $651,400 $552,000 Interest expense 357,700 326,500 282,000 215,000 171,100 Income tax expense 336,640 253,932 213,388 169,364 132,480 Average total assets 6,350,000 5,606,364 4,789,450 4,067,606 3,459,809 Average stockholders' equity 2,169,072 1,941,970 1,697,327 1,504,388 1,317,422 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
A sample of 5 months of sales data provided the following information: Month 1 2 3...
A sample of 5 months of sales data provided the following information: Month 1 2 3 4 5 Units Sold 96 110 85 96 93 Develop a point estimate of the population mean number of units sold per month (to 1 decimal). Develop a point estimate of the population standard deviation (to 2 decimals).
The 1-year, 2-year, 3-year and 4-year zero rates are 2%, 3%, 4% and 5% per annum...
The 1-year, 2-year, 3-year and 4-year zero rates are 2%, 3%, 4% and 5% per annum (APR) with quarterly compounding/payment. a) What are the corresponding per annum zero rates with continuous compounding? b) What is today’s forward rate for an investment initiated one year from today and maturing 3 years from today?  (Give your answer per annum with continuous compounding)? c) What is today’s forward rate for a one-year investment initiated three years from today?  (Give your answer per annum with continuous...
2. The following comparative data is provided for the Laventura Boating Company. It is stated that...
2. The following comparative data is provided for the Laventura Boating Company. It is stated that the company has more accurate product cost information using activity-based costing to allocate overhead. Laventura Boating Company (Direct Labour hours as allocation base) Fish Boat $ Luxury Boat $ Direct Materials 32,000 41,600 Direct Labour 19,200 24,000 Overhead* 40,960 51.200 Total Production cost per unit (a) 92,160 116,800 Sales Prices (b) 102,400 144,000 Profit = (b) – (a) 10,240 27,200 Activity Based Costing (Several...
5 + (3 * 4)^2 - 2 = 147             (5 + 3) * 4^2 -...
5 + (3 * 4)^2 - 2 = 147             (5 + 3) * 4^2 - 2 = 126             (5 + 3 )* (4^2 – 2) = 112             5 + (3 * 4^2) - 2 = 51 Which is the correct answer to using the "order of precedence" and why?
The Tanner Company has provided the following information after year-end adjustments:
The Tanner Company has provided the following information after year-end adjustments: Allowance for doubtful accounts increased $26,600.Accounts receivable increased $485,000 during the year.Accounts written off as uncollectible totaled $29,500.Sales totaled $2,690,000.Sales discounts were $119,000. What was the amount of Tanner’s net sales? Multiple Choice$2,056,500.$2,571,000.$2,541,500.$2,600,500.
Consider the following set of numbers: {3, 5, 2, 5, 5, 15, 2, 2, 4, 4,...
Consider the following set of numbers: {3, 5, 2, 5, 5, 15, 2, 2, 4, 4, 20, 4998, 4} 14. The Q3 of this set is: a. 4 b. 5 c. 2 d. 10 15. The Q1 of this set is: a. 4 b. 5 c. 2 d. 2.5 e. 3
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,014,300 $874,400 $734,800 $628,000 $532,200 Interest expense 344,900 314,800 271,900 207,200 165,000 Income tax expense 324,576 244,832 205,744 163,280 127,728 Total assets (ending balance) 7,358,917 7,827,675 5,609,613 5,895,529 4,470,776 Total stockholders' equity (ending balance) 2,291,128 2,818,696 1,795,552 2,275,362 1,365,218 Average total assets 7,593,296 6,718,644 5,752,571 4,912,941 4,200,000 Average stockholders' equity 2,554,912 2,307,124 2,035,457 1,820,290 1,607,855 You have been asked to...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,014,300 $874,400 $734,800 $628,000 $532,200 Interest expense 344,900 314,800 271,900 207,200 165,000 Income tax expense 324,576 244,832 205,744 163,280 127,728 Total assets (ending balance) 7,358,917 7,827,675 5,609,613 5,895,529 4,470,776 Total stockholders' equity (ending balance) 2,291,128 2,818,696 1,795,552 2,275,362 1,365,218 Average total assets 7,593,296 6,718,644 5,752,571 4,912,941 4,200,000 Average stockholders' equity 2,554,912 2,307,124 2,035,457 1,820,290 1,607,855 You have been asked to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT