Question

In: Accounting

Select information from Patel Sales and Services financial statements are listed below: 2020 2019 Cash 60,100...

Select information from Patel Sales and Services financial statements are listed below:

2020

2019

Cash

60,100

64,200

Held-for-trading investment

74,000

50,000

Accounts receivable

117,800

102,800

Merchandise Inventory

126,000

115,500

Property, plant and equipment (net)

649,000

520,300

Accounts payable

160,000

145,400

Income taxes payable

43,500

42,000

Bonds payable (20,000 due each year)

220,000

200,000

Net sales

1,890,540

1,750,500

Cost of goods sold

1,058,540

1,006,000

Part A                                                                                                                                     

Calculate the following ratios in the table below for 2020.  Show your calculations to receive full marks).  Results should be rounded to 2 decimal places.

The 2019 results for those ratios are shown in the table below.  In the Conclusion column, indicate whether Patel has improved or deteriorated in 2020 as compared to 2019.

2020

2019

Conclusion

Current Ratio

1.5:1

Inventory Turnover

12 times

Part B                                                                                                                                      Marks

Discuss Patel’s overall financial position in 2020 compared to 2019 using your results from above.

Solutions

Expert Solution

Current Ratio

It is a liquidity ratio that measures company ability to pay short term obligation are those due within one year. This ratio is used globally as way to measure the overall financial health of a company , this ratio is derived by dividing current assets to the current liabilities

Ratio between 1.5 to 3 is basically considered healthy and ratio lower than 1 indicate liquidity problem

Inventory Turnover Ratio

In accounting the inventory turnover is a measure of the number of times inventory is sold or used in a time period such as year , it is calculated by dividing the cost of good sold to the average inventory.

As higher the inventory turnover , it is better.

Part A working

Table showing Summary of Current Assets and Current Liabilities

Current Assets Amount Current Liabilities Amount
Cash $60,100 Account Payable $160,000
Held for trading investment $74,000 Income tax payable $43,500
Accounts Receivable $117,800
Merchandise Inventory $126,000
Total Current Assets $377,900 Total Current Liabilities $203,500

Table showing current ratio and the inventory turnover ratio for the year 2020

Currrent Ratio = Current Asssets / Current Liabilities

= $377,900 / $203,500

1.86:1

Inventory Turnover Ratio = Cost of goods sold / Average inventory

= $1,058,540 / $120,750

8.77 Times

Cost of goods sold is given in the requirement but Average stock is the sum of opening merchandise inventory and the closing merchandise inventory and then divide by 2.

To obtain Average inventory which is calculated as: $120,750 ($115,500 + $126,000) / 2

Part B

COMPARISON OF TWO RATIO FOR THE YEAR 2019 AND 2020

Ratio 2020 2019 Conclusion
Currrent Ratio 1.86:1 1.5:1

As compared to 2019 , the ratio is higher and increased which shows a good sign, increasing ratio shows company's ability to pay short term obligation very quickly

And also indicate investor to analyse how company maximise the current assets. A healthy ratio is considered to be 2:1

Inventory Turnover Ratio 8.77 times 12 times

As compared to 2019 , this ratio decline which is not a good sign as lower inventory turnover ratio would indicate weaker sale and decline in demand for a company's product.

Company must take steps to improve their ratio and also increases demand in the market


Related Solutions

The following information is taken from Smith Corporation's financial statements: December 31 2020   2019 Cash $100,000...
The following information is taken from Smith Corporation's financial statements: December 31 2020   2019 Cash $100,000 $ 27,000 Accounts receivable 95,000 80,000 Allowance for doubtful accounts (4,500)        (3,100) Inventory 145,000 175,000 Prepaid expenses 7,500 6,800 Land 100,000 60,000 Buildings 287,000 244,000 Accumulated depreciation   (35,000)   (13,000) Patents     20,000    ————————       $715,000      35,000 ————————   $611,700 Accounts payable $ 90,000 $ 84,000 Accrued liabilities 54,000 63,000 Bonds payable 135,000 60,000 Common stock 100,000 100,000 Retained earnings——appropriated 80,000 10,000 Retained earnings——unappropriated 271,000 302,700...
Some financial information is extracted from financial statements of Global Co. as follows: 2020 2019 £000...
Some financial information is extracted from financial statements of Global Co. as follows: 2020 2019 £000 £000 Sales 21,000 17,500 Current assets 5,000 3,500 Current liabilities 3,800 1,900 Overdraft 1,500 200 Non-current liabilities 6,300 6,000 Operating profit margin 24% 30% Inventory days 70 60 Receivable days 50 70 Payable days 100 90 Quick ratio 0.6:1 0.7:1 The credit controller of the company considers a new credit policy introduced in 2020 has effectively reduced the receivable days, which provides customers a...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets Ratio (Correct your answer to 0.01%) b)    Comment on the...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 Required: Answer the following questions in the spaces provided below: a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 250,000...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 250,000 Costs 175,000 EBIT $ 75,000 Interest expense 15,000 Taxable income $ 60,000 Taxes (at 21%) 12,600 Net income $ 47,400 Dividends $ 28,440 Addition to retained earnings $ 18,960    BALANCE SHEET, YEAR-END, 2019 Assets Liabilities Current assets Current liabilities Cash $ 8,000 Accounts payable $ 15,000 Accounts receivable 13,000 Total current liabilities $ 15,000 Inventories 29,000 Long-term debt 150,000 Total current assets $...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 300,000...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 300,000 Costs 200,000 EBIT $ 100,000 Interest expense 20,000 Taxable income $ 80,000 Taxes (at 21%) 16,800 Net income $ 63,200 Dividends $ 18,960 Addition to retained earnings $ 44,240    BALANCE SHEET, YEAR-END, 2019 Assets Liabilities Current assets Current liabilities Cash $ 6,000 Accounts payable $ 13,000 Accounts receivable 11,000 Total current liabilities $ 13,000 Inventories 33,000 Long-term debt 200,000 Total current assets $...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 390,000...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 390,000 Costs 245,000 EBIT $ 145,000 Interest expense 29,000 Taxable income $ 116,000 Taxes (at 21%) 24,360 Net income $ 91,640 Dividends $ 36,656 Addition to retained earnings $ 54,984    BALANCE SHEET, YEAR-END, 2019 Assets Liabilities Current assets Current liabilities Cash $ 8,000 Accounts payable $ 15,000 Accounts receivable 13,000 Total current liabilities $ 15,000 Inventories 29,000 Long-term debt 290,000 Total current assets $...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 300,000...
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales $ 300,000 Costs 200,000 EBIT $ 100,000 Interest expense 20,000 Taxable income $ 80,000 Taxes (at 21%) 16,800 Net income $ 63,200 Dividends $ 18,960 Addition to retained earnings $ 44,240    BALANCE SHEET, YEAR-END, 2019 Assets Liabilities Current assets Current liabilities Cash $ 6,000 Accounts payable $ 13,000 Accounts receivable 11,000 Total current liabilities $ 13,000 Inventories 33,000 Long-term debt 200,000 Total current assets $...
The following information is taken from Lisa Corporation's financial statements: December 31 2021 2020 Cash $...
The following information is taken from Lisa Corporation's financial statements: December 31 2021 2020 Cash $ 75,600 $ 32,400 Accounts receivable 122,400 96,000 Allowance for doubtful accounts (5,400) (3,720) Inventory 192,000 210,000 Prepaid expenses 9,000 8,160 Land 120,000 72,000 Buildings 352,800 292,800 Accumulated depreciation (38,400) (15,600) Patents 24,000 42,000 $852,000 $734,040 Accounts payable $ 108,000 $ 100,800 Accrued liabilities 64,800 75,600 Bonds payable 150,000 72,000 Common stock 120,000 120,000 Retained earnings―appropriated 96,000 12,000 Retained earnings―unappropriated 331,200 363,240 Treasury stock, at...
The following information was extracted from the 2020 financial statements of Arigato LLC:
The following information was extracted from the 2020 financial statements of Arigato LLC:Income from continuing operations before income tax           $755,123Selling and administrative expenses                                            480,357Income from continuing operations                                            495,951Gross profit                                                                                           1,357,530The amount reported for Other Revenue/Gains and Other Expenses/Losses is: $  Blank 1. Fill in the blank, read surrounding text.Use “-“ sign for negative amount, as needed. Use commas, as needed.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT