The directors of Avengers wish to compare the company’s most recent financial statement with those of...

The directors of Avengers wish to compare the company’s most recent financial statement with those of the previous year. The company’s financial statements are given below:
Statement of profit and loss
		Year ended 31st March
		2017	2016

Sales revenue (80% credit, 20% cash)		2500000	1800000
Cost of Sales		-1800000	-1200000
		700000	600000
Distribution costs		-250000	-200000
Administrative expenses		-200000	-200000
Profit from operations		250000	240000
Finance costs		-50000	-50000
Profit before tax		200000	190000
Income tax		-46000	-44000
Profit for the year		154000	146000
Note: cost of sales figures are made up as follows:
Opening inventory		200000	180000
Purchases (all on credit)		1960000	1220000
Less Closing inventory		-360000	-200000
Cost of sales		1800000	1200000

Statement of financial position
	31/02/2017		31/02/2016

Assets
Non-current assets	3674000		3100000
Acc Depn	-1422000	2252000	-1214000	1886000
Current Assets
Inventory	360000		200000
Trade receivable	750000		400000
Cash at bank	120000	1230000	100000	700000
Current liabilities
Trade payables	380000		210000
Sundry payables	430000		260000
Income tax )	50000	-860000	48000	-518000
Non-current assets
10% Loan notes		-500000		-500000
		2122000		1568000
Equity
Issued ordinary SC		1200000		1000000
Share premium		600000		400000
Retained earnings		322000		168000
		2122000		1568000


Notes: additional share capital was issued on 1st April 2017
Required

(a) Calculate, for each of the 2 years, eight accounting ratios which should assist the directors in their comparison, using closing figures for items in the statement of financial position
(b) Suggest possible reasons for the changes in the ratios between the 2 years

Solutions

Expert Solution

Sol :

a) Accounting Ratio

RATIO	FORMULAE	2017	2016
FIXED ASSETS TURNOVER RATIO	NET SALES / NET FIXED ASSETS	2500000/2252000 = 1.11	1800000/1886000=0.9544
CURRENT RATIO	CURRENT ASSETS / CURRENT LIABILITIES	1230000/860000=1.43	700000/518000=1.35
DEBT EQUITY RATIO	LONG TERM DEBT / SHAREHOLDER'S FUND	500000/2122000=0.24	500000/1568000=0.31
QUICK RATIO	QUICK ASSET/CURRENT LIABILITIES( QUICK ASSET =CASH+LIQUID SECURITIES + TRADE RECEIVABLES	(750000+120000)/860000 = 1.01	(400000+100000)/518000=0.96
GROSS PROFIT RATIO	GROSS PROFIT / NET SALES	(700000/2500000)*100=28%	(600000/1800000)*100 = 33.33%
RETURN ON CAPITAL EMPLOYED (ROCE)	(PAT-DIVIDEND )/SHAREHOLDERS FUND	154000/2122000=7.25%	106000/1568000=6.7%
NET PROFIT RATIO	NET PROFIT (PAT)/NET SALES	154000/2500000=6.16%	106000/1800000=5.89%
SOLVENCY RATIO	TOTAL ASSETS / TOTALS LIABILITIES	3482000/1360000=2.56	2586000/1018000=2.54

SL.NO	OBSERVATION	REASON
1	FIXED ASSETS TURNOVER RATION HAS IMPROVED FROM 0.95 TO 1.11	AS A RESULT OF INCREASE IN SALES IN 2017 , THOUGH ADDITION TO FIXED ASSETS HAD A LITTLE PULL BACK EFFECT .
2.	CURRENT RATIO HAS IMPROVED FROM 1.35 TO 1.43	AS A RESULT OF INCREASE IN TRADE RECEIVABLES AND CLOSING INVENTORY
3	DEBT EQUITY RATIO HAS IMPROVED FROM 0.31 TO 0.24	AS A RESULT OF INCREASE IN EQUITY BASE THE RATIO HAS DECREASES .
4	IMPROVEMENT IN QUICK RATIO	DUE TO INV=CREASE IN CASH BALANCE / AND INCREASE IN TRADE RECEIVABLES
5	DECREASE IN GP RATIO	AS A RESULT OF INCREASE IN SALES - RELAISATION MIGHT HAVVE GOT EFFECTED .
6	IMPROVEMENT IN ROCE	AS A RESULT OF IMPROVES NET PROFIT .
7	INCREASE IN NP RATIO	DUE TO REDUCTION IN OPRATING COST RATIO .
8	MINOR IMPROVEMENT IN SOLVENCY RATIO	NO COMMENTS

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Why it is sometimes misleading to compare a company’s financial ratios with those of other firms...

Why it is sometimes misleading to compare a company’s financial ratios with those of other firms that operate within the same industry?

Determine why it is sometimes misleading to compare a company’s financial ratios with those of other...

Determine why it is sometimes misleading to compare a company’s financial ratios with those of other firms that operate within the same industry. Support your response with an example

Why is it sometimes misleading to compare a company’s financial ratios with those of other firms...

Why is it sometimes misleading to compare a company’s financial ratios with those of other firms that operate within the same industry for several reasons.

A company’s contribution format income statement for the most recent month is given below: Sales...

A company’s contribution format income statement for the most recent month is given below: Sales (13,200 units × $30 per unit) $ 396,000 Variable expenses 198,000 Contribution margin 198,000 Fixed expenses 220,500 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,200 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result...

The most recent financial statements for Suncrest Inc. are shown here: Statement of Comprehensive Income Statement...

The most recent financial statements for Suncrest Inc. are shown here: Statement of Comprehensive Income Statement of Financial Position Sales $ 26,400 Assets $ 65,000 Debt $ 27,400 Costs 17,300 Equity 37,600 Taxable income $ 9,100 Total $ 65,000 Total $ 65,000 Taxes (40%) 3,640 Net income $ 5,460 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,300 was paid, and suncrest wishes to maintain a constant payout ratio. Next year’s sales are...

Hyrkas Corporation's most recent balance sheet and income statement appear below: Statement of Financial Position...

Hyrkas Corporation's most recent balance sheet and income statement appear below: Statement of Financial Position December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Asset: Current assets: Cash $ 100 $ 110 Accounts receivable 210 220 Inventory 110 120 Prepaid expenses 10 10 Total current assets 430 460 Plant and equipment, net 900 880 Total assets $ 1,330 $ 1,340 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 160 $ 170 Accrued...

Wish Inc. sells low-cost items online. Its most recent income statement and balance sheet are given...

Wish Inc. sells low-cost items online. Its most recent income statement and balance sheet are given below: Income statement ($ million) Balance sheet ($ million) Sales 29 Current assets 14 Debt 28 Costs 23.2 Fixed assets 56 Equity 42 Net income 5.8 Total assets 70 Total 70 Sales, assets and costs are expected to grow by 10% the following year. Attempt 2/10 for 7 pts. Part 1 If company expects to keep Debt-Equity ratio unchanged from year to year, based...

Miller Company’s contribution format income statement for the most recent month is shown below: Total Per...

Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (44,000 units) $ 396,000 $ 9.00 Variable expenses 264,000 6.00 Contribution margin 132,000 $ 3.00 Fixed expenses 47,000 Net operating income $ 85,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 13%? 2. What is the revised net operating income if the selling price decreases by $1.20 per unit and the number...

Miller Company’s contribution format income statement for the most recent month is shown below: Total Per...

Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (38,000 units) $ 342,000 $ 9.00 Variable expenses 228,000 6.00 Contribution margin 114,000 $ 3.00 Fixed expenses 47,000 Net operating income $ 67,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 19%? 2. What is the revised net operating income if the selling price decreases by $1.20 per unit and the number...

4. acct Miller Company’s contribution format income statement for the most recent month is shown below:...

4. acct Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (38,000 units) $ 304,000 $ 8.00 Variable expenses 190,000 5.00 Contribution margin 114,000 $ 3.00 Fixed expenses 49,000 Net operating income $ 65,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 17%? 2. What is the revised net operating income if the selling price decreases by $1.20 per unit and...

Subjects