Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Net sales, net income, and total asset figures for Vibrant Controls, Inc., for f

ID: 342390 • Letter: N

Question

Net sales, net income, and total asset figures for Vibrant Controls, Inc., for five consecutive years are given below (Vibrant manufactures pollution controls): Annual Amounts (Thousands of Dollars) Year 1 Year 2 Year 3 Year 4 Year 5 Net sales$71,500 $79,800 $85,275 $88,400 $94,700 Net income 3,200 3,650 3,900 4,250 4,790 Total assets 42,500 46,200 48,700 51,000 54,900 Required a. Calculate trend percentages, using Year 1 as the base year. b. Calculate the return on sales for each year. a. Round answers to one decimal point. Trend Percentages Year 2 Year 3 Year 4 Year 5 Net sales Net income Total assets

Explanation / Answer

Req a YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Net sales 71500 79800 85275 88400 94700 Net income 3200 3650 3900 4250 4790 Total assets 42500 46200 48700 51000 54900 TREND PERCENTAGE YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Net sales 100% 111.60% 119.27% 123.64% 132.45% Net income 100% 114.06% 121.88% 132.81% 149.69% Total Assets 100% 108.71% 114.59% 120% 129.18% Req b: RETURN ON SALES YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Net sales 71500 79800 85275 88400 94700 Net income 3200 3650 3900 4250 4790 Return on sales 4.48% 4.57% 4.57% 4.81% 5.06% (net income/Sales *100)