Business, 24.04.2020 22:02, jackieanguiano3700

The 2021 income statement of Adrian Express reports sales of $19,310,000, cost of goods sold of $12,250,000, and net income of $1,700,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 700,000 $ 860,000 Accounts receivable 1,600,000 1,100,000 Inventory 2,000,000 1,500,000 Long-term assets 4,900,000 4,340,000 Total assets $ 9,200,000 $ 7,800,000 Liabilities and Stockholders' Equity Current liabilities $ 1,920,000 $ 1,760,000 Long-term liabilities 2,400,000 2,500,000 Common stock 1,900,000 1,900,000 Retained earnings 2,980,000 1,640,000 Total liabilities and stockholders' equity $ 9,200,000 $ 7,800,000 Industry averages for the following four risk ratios are as follows: Average collection period 25 days Average days in inventory 60 days Current ratio 2 to 1 Debt to equity ratio 50% Required: 1. Calculate the four risk ratios listed above for Adrian Express in 2021. (Use 365 days in a year. Round your answers to 1 decimal place.) 2. Do you think the company is more risky or less risky than the industry average

Answers: 1

Show answers

Answers

answered: fhishy11

1. The Calculation of the four risk ratios for Adrian Express in 2021 is as follows:

a. Average Collection Period = Average Accounts Receivable/Net Sales x 365

= $1,350,000/$19,310,000 x 365

= 25.5 days

b. Average Days in Inventory = Cost of Goods Sold/Average Inventory

= 365 / 9.1

= 40.1 days

c. Current Ratio = Current Assets/Current Liabilities

= $4,300,000/$1,920,000

= 2.2 : 1

d. Debt to Equity Ratio = Total liabilities/Total Equity x 100

= 88.5% ($4,320,000 /$4,880,000 x 100)

2. Adrian Express is riskier than the industry average, especially with respect to its Debt to Equity Ratio because it appears highly leveraged.

Industry Averages Adrian Express

Average collection period 25 days 25.5 days

Average days in inventory 60 days 40.1 days

Current ratio 2 : 1 2.2 : 1

Debt to equity ratio 50% 88.5%

Data and Calculations:

Adrian Express

Income Statement

Sales Revenue $19,310,000

Cost of goods sold 12,250,000

Net income $1,700,000

ADRIAN EXPRESS

Balance Sheets

December 31, 2021 and 2020

2021 2020

Assets

Current assets: Cash $ 700,000 $ 860,000

Accounts receivable 1,600,000 1,100,000

Inventory 2,000,000 1,500,000

Current Assets $4,300,000 $3,460,000

Long-term assets 4,900,000 4,340,000

Total assets $ 9,200,000 $ 7,800,000

Liabilities and Stockholders' Equity

Current liabilities $ 1,920,000 $ 1,760,000

Long-term liabilities 2,400,000 2,500,000

Total liabilities $4,320,000 $4,250,000

Common stock 1,900,000 1,900,000

Retained earnings 2,980,000 1,640,000

Total Equity $4,880,000 $3,540,000

Total Liabilities & Equity $ 9,200,000 $ 7,800,000

Average Accounts Receivable = $1,350,000 ($1,600,000 + $1,100,000)

Average Inventory = $1,750 ($2,000,000 + $1,500,000)

Inventory Turnover = 9.1 times ($12,250,000/$1,350,000)

Learn more: link

answered: snicklegirlp4isqr

Average Collection Period = 25.2 Days

Average Days In Inventory = 52.1 days

Current Ratio = 2.2 to 1

Debt to Equity Ratio = 88.5%

The above ratios shows that Adrian Express is more risky than the Industry Average due to Debt to Equity Ratio which is worse than 50% of Industry Average, although the rest 3 ratios are much closer to industry average.

Explanation:

$Average Collection Period =\frac{365}{Accounts Receivables Turnover Ratio}$

$Accounts Receivables Turnover Ratio = \frac{Net Credit Sales}{Average Accounts Receivables}\\\\Net Credit Sales = 19,310,000\\Accounts Receivables In 2021 = 1,600,000\\Accounts Receivables In 2020 = 1,100,000$

$Accounts Receivables Turnover Ratio = \frac{19310000}{\frac{1600000 + 1100000}{2} }\\Accounts Receivables Turnover Ratio = \frac{19310000}{1350000}\\Accounts Receivables Turnover Ratio = 14.30 times$

$Average Collection Period =\frac{365}{14.30 times}\\Average Collection Period = 25.52 days$

The Average Collection Period is greater than the market average hence worse.

$Average Days In Inventory = \frac{365}{Inventory Turnover}$

$Inventory Turnover = \frac{CostOfGoodsSold}{Average Inventories}$

$Inventory Turnover = \frac{12250000}{\frac{2000000 + 1500000}{2}}$

$Inventory Turnover = \frac{12250000}{1750000}$

Inventory Turnover = 7 times

$Average Days In Inventory = \frac{365}{7 times}$

Average Days In Inventory = 52.14 days

The Average Days in Inventory is less than the Industry average hence good.

$Current Ratio = \frac{Current Assets}{Current Liabilities}$

Current Assets = Cash + Accounts Receivable + Inventory

Current Assets = 700,000 + 1,600,000 + 2,000,000

Current Assets = 4,300,000

Current Liabilities = 1,920,000

$Current Ratio = \frac{4300000}{1920000}$

Current Ratio = 2.24 to 1

Current Ratio is greater than Industry Average hence the Adrian Express is risky.

$Debt To Equity Ratio = \frac{Total Liabilities}{Total Equity}$

$Total Liabilities = Current Liabilities + Long Term Liabilities\\Total Liabilities = 1,920,000 + 2,400,000\\Total Liabilities = 4,320,000$

$Total Equity = Common Stock + Retained Earnings\\Total Equity = 1,900,000 + 2,980,000\\Total Equity = 4,880,000$

$Debt To Equity Ratio = \frac{4320000}{4880000}$

Debt To Equity Ratio = 88.5 %

Debt To Equity Ratio is greater than Industry Average, hence Adrian Express is risky as compared to Industry Average.

answered: Guest

the clients (funders) and customers (individual nonprofit staff) are great to work with. that i can be open about being a person of faith when appropriate. the variety of my tasks each day.

answered: Guest

What’s the question exactly? i’d love to ! : )

Other questions on the subject: Business

Business, 21.06.2019 20:20, alkaline27

Jing-sheng facilitated a hiring committee for his advertising company. six employees (including two managers) met together to discuss applicants and select the finalists for a copywriter position in the public relations department. although the head of public relations would have the final nod on the candidate that would ultimately be hired, the evaluative work of the committee was very important because this group would send forward those persons they believed would be good work colleagues. in setting up this type of hiring process, the head of public relations was utilizing a(n) style of leadership. a. autocraticb. free-reinc. contingentd. participative

Answers: 3

continue

Business, 22.06.2019 07:50, sis212

Connors academy reported inventory in the 2017 year-end balance sheet, using the fifo method, as $154,000. in 2018, the company decided to change its inventory method to lifo. if the company had used the lifo method in 2017, the company estimates that ending inventory would have been in the range $130,000-$135,000. what adjustment would connors make for this change in inventory method?

Answers: 1

continue

Business, 22.06.2019 20:00, tvoalicea

Harry is 25 years old with a 1.55 rating factor for his auto insurance. if his annual base premium is $1,012, what is his total premium? $1,568.60 $2,530 $1,582.55 $1,842.25

Answers: 1

continue

Business, 22.06.2019 22:20, ciara180

Which of the following is correct? a. a tax burden falls more heavily on the side of the market that is more elastic. b. a tax burden falls more heavily on the side of the market that is less elastic. c. a tax burden falls more heavily on the side of the market that is closer to unit elastic. d. a tax burden is distributed independently of the relative elasticities of supply and demand.

Answers: 1

continue

Do you know the correct answer?

The 2021 income statement of Adrian Express reports sales of $19,310,000, cost of goods sold of $12,...