In: Accounting
Liz Raiborn Inc. has the following financial results for the years 2019 through 2021 for its three regional divisions:
2019 | 2020 | 2021 | |||||||
Revenue | |||||||||
Southwest | $ | 14,875 | $ | 21,975 | $ | 25,975 | |||
Midwest | 6,675 | 6,975 | 7,175 | ||||||
Southeast | 12,375 | 12,975 | 13,275 | ||||||
Total | $ | 33,925 | $ | 41,925 | $ | 46,425 | |||
Net Operating Income | |||||||||
Southwest | $ | 1,075 | $ | 1,175 | $ | 1,325 | |||
Midwest | 1,225 | 1,575 | 1,525 | ||||||
Southeast | 975 | 1,175 | 1,575 | ||||||
Total | $ | 3,275 | $ | 3,925 | $ | 4,425 | |||
Average Total Assets | |||||||||
Southwest | $ | 13,975 | $ | 14,175 | $ | 16,775 | |||
Midwest | 4,675 | 4,175 | 4,175 | ||||||
Southeast | 5,275 | 5,575 | 5,575 | ||||||
Total | $ | 23,925 | $ | 23,925 | $ | 26,525 | |||
Required:
Calculate return on sales (ROS), asset turnover (AT), and return on investment (ROI) for each division and also for the firm as a whole for each of the three years 2019, 2020, and 2021. (Note: Due to rounding your percentages, the totals for the firm might not be the actual total of the individual divisions.) (Round "Asset turnover (AT)" answers to 3 decimal places and other answers to 1 decimal place.)
As per the given Question
Answer | ||||||||||
2019 | 2020 | 2021 | 2019 | 2020 | 2021 | |||||
Revenue | Return on sales {ROS) | |||||||||
Southwest | $14,875.00 | $21,975.00 | $25,975.00 | Southwest | 7.2% | 5.3% | 5.1% | |||
Midwest | $6,675.00 | $6,975.00 | $7,175.00 | Midwest | 18.4% | 22.6% | 21.3% | |||
Southeast | $12,375.00 | $12,975.00 | $13,275.00 | Southeast | 7.9% | 9.1% | 11.9% | |||
Total | $33,925.00 | $41,925.00 | $46,425.00 | Firm | 9.7% | 9.4% | 9.5% | |||
Net Operating Income | ||||||||||
Southwest | $1,075.00 | $1,175.00 | $1,325.00 | Asset Turnover (AT) | ||||||
Midwest | $1,225.00 | $1,575.00 | $1,525.00 | Southwest | 1.064 | 1.550 | 1.548 | |||
Southeast | $975.00 | $1,175.00 | $1,575.00 | Midwest | 1.428 | 1.671 | 1.719 | |||
Total | $3,275.00 | $3,925.00 | $4,425.00 | Southeast | 2.346 | 2.327 | 2.381 | |||
Average Total Assets | Firm | 1.418 | 1.752 | 1.750 | ||||||
Southwest | $13,975.00 | $14,175.00 | $16,775.00 | |||||||
Midwest | $4,675.00 | $4,175.00 | $4,175.00 | Return On Investment (ROI) | ||||||
Southeast | $5,275.00 | $5,575.00 | $5,575.00 | Southwest | 7.7% | 8.3% | 7.9% | |||
Total | $23,925.00 | $23,925.00 | $26,525.00 | Midwest | 26.2% | 37.7% | 36.5% | |||
Southeast | 18.5% | 21.1% | 28.3% | |||||||
Return on sales = Net Operating Income / Revenue | Firm | 13.7% | 16.4% | 16.7% | ||||||
Asset Turnover = Revenue / Average Total assets | ||||||||||
Return on investment = Net operating Income / Average Total assets | ||||||||||
Thank you for the Question......kindly rate.........it helps me a lot