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

Answer from: 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

Answer from: 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.

Answer from: Quest

I’m not sure i’m actually really sorry

Answer from: Quest

The buyers because if they don't like it, it won't be made anymore

Another question on Business

Business, 22.06.2019 07:10

Refer to the payoff matrix. suppose that speedy bike and power bike are the only two bicycle manufacturing firms serving the market. both can choose large or small advertising budgets. is there a nash equilibrium solution to this game?

Answers: 1

Answer

Business, 22.06.2019 10:00

University car wash built a deluxe car wash across the street from campus. the new machines cost $219,000 including installation. the company estimates that the equipment will have a residual value of $19,500. university car wash also estimates it will use the machine for six years or about 12,500 total hours. actual use per year was as follows: year hours used 1 3,100 2 1,100 3 1,200 4 2,800 5 2,600 6 1,200 prepare a depreciation schedule for six years using the following methods: 1. straight-line. 2. double-declining-balance. 3. activity-based.

Answers: 1

Answer

Business, 22.06.2019 11:10

Your team has identified the risks on the project and determined their risk score. the team is in the midst of determining what strategies to put in place should the risks occur. after some discussion, the team members have determined that the risk of losing their network administrator is a risk they'll just deal with if and when it occurs. although they think it's a possibility and the impact would be significant, they've decided to simply deal with it after the fact. which of the following is true regarding this question? a. this is a positive response strategy.b. this is a negative response strategy.c. this is a response strategy for either positive or negative risk known as contingency planning.d. this is a response strategy for either positive or negative risks known as passive acceptance.

Answers: 2

Answer

Business, 22.06.2019 19:10

Pam is a low-risk careful driver and fran is a high-risk aggressive driver. to reveal their driver types, an auto-insurance company a. refuses to insure high-risk drivers b. charges a higher premium to owners of newer cars than to owners of older cars c. offers policies that enable drivers to reveal their private information d. uses a pooling equilibrium e. requires drivers to categorize themselves as high-risk or low-risk on the application form

Answers: 3

Answer

You know the right answer?

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

Questions