Intermediate Financial Reporting

This document provides an overview of ratio analysis for profitability, liquidity, management, solvency, and investment in intermediate financial reporting. It covers concepts such as ROCE, ROE, net profit margin, asset turnover, gross profit margin, current ratio, quick assets ratio, inventory turnover, trade receivables collection period, trade payables payment period, debt to equity ratio, debt to capital employed ratio, interest cover, earnings per share, price to earnings ratio, earning yields, and dividend cover.

INTERMEDIATE FINANCIAL
REPORTING

Table of Contents
Introduction......................................................................................................................................3
1. Profitability..................................................................................................................................4
2. Liquidity......................................................................................................................................6
3. Management................................................................................................................................7
4. Solvency......................................................................................................................................8
5. Investment....................................................................................................................................9
6. Cash flow movement.................................................................................................................11
7. Share price movement and performance over the period..........................................................12
References......................................................................................................................................13

Introduction
Ratio analysis is a technique and tool for decision makers. Quota analysis is used to evaluate
various issues based on content, such as its liquidity, asset productivity, and profitability. This
type of study is particularly valuable to experts outside of the industry, as their tax reports are
their essential source of company data. A rational study is less useful for physical psychologists,
who have better access to more detailed operational data about society.
This measure shows Marks and Spencer's total worldwide revenue from 2010 to 2020. In the
year ending March 28, 2020, the UK retailer generated approximately £ 10.2 billion. of revenues
both in the United Kingdom (UK) and in the world. This is a decrease of around 2% compared to
the previous year.
Imprints and Spencer has been established in the UK since 1884. The retailer offers its customers
a wide range of items, from food items to general merchandise such as clothing, luxury and
individual items and home decor. There are currently over 1,000 Marks and Spencer stores
located in the UK, with 444 active worldwide.

1. Profitability
Profit ratios are a type of cash measures used to assess a company's ability to generate revenue in
terms of revenue, operating expenses, accounting ratio resources, or investor value over the long
term, using time-specific information as would be expected.
Return on capital employed
Return on capital employed (ROCE) is a proportion of cash that can be used to measure an
organization’s capital return and capacity. Overall, a contribution can help see what an
organization is benefiting from its capital. The ROCE ratio is one of the few productivity ratios
that money managers, partners, and speculators can use when analyzing an organization for each
company
2018 2019 2020
A. Net Profit before tax 25 36 44
B. Capital employed 180 224 325
ROCE (A/B) 14% 16% 14%
Return on equity
ROE is the rate articulation of an organization's overall gain, as it is returned as an incentive to
investors. This equation permits financial specialists and experts an elective proportion of the
organization's productivity and ascertains the proficiency with which an organization creates
benefit, utilizing the assets that investors have contributed.
2018 2019 2020
A. Net Profit before tax 25 36 44
B. Total equity 125 124 145
Return on equity (A/B) 20% 29% 30%
Net Profit margin
Net profit margin is equal to the amount of total compensation or benefit generated as an income
level. Total net income is the proportion of net benefits to income for an organization or business
assignment. Net profit is usually translated as a rate, but it can be discussed the same way in a

decimal structure. Total net income is defined as the amount of every dollar of income an
organization collects is transformed into profit.
2018 2019 2020
A. Net profit 25 36 44
B. Net Sales 212 235 312
Net Profit margin (A/B) 12% 15% 14%
Asset Turnover
The asset turnover ratio measures an organization's resource productivity for generating revenue
or contracts. Consider the amount of contract dollars or revenues for all outsourced facilities. The
resource turnover ratio reflects the net contracts in proportion to its total resources.
2018 2019 2020
A. Net Sales 212 235 312
B. Total assets 200 215 223
Asset Turnover (A/B) 1.06
1.09302
3
1.39910
3
Gross profit margin
Gross profit margin is what metric analysts use to analyze the financial well-being of an
organization by determining the amount of money left over from item contracts after deducting
the cost of goods sales (COGS). From time to time referred to as the gross margin contribution,
the net income of most of the time is reported as a condition of contracts.
2018 2019 2020
A. Gross Profit 98 86 112
B. Net Sales 212 235 312
Gross profit margin (A/B) 46% 37% 36%
2. Liquidity
Liquidity ratios are a critical class of money related estimations used to choose an obliged
individual's ability to deal with current commitment responsibilities without raising external
capital. Liquidity extents measure an association's ability to pay commitment responsibilities and

its edge of prosperity through the tally of estimations including the current extent, quick extent,
and working pay extent.
Current ratio
The current ratio is a liquidity extent that measures an association's ability to pay transient
responsibilities or those due inside one year. It tells theorists and analysts how an association can
extend the current assets on its bookkeeping report to satisfy its current commitment and various
payables.
2018 2019 2020
A. Current Assets 58 65 60
B. Current Liabilities 50 40 46
Current ratio (A/B) 1.16 1.625
1.30434
8
Quick assets ratio
Quick assets are those resources that can be changed over into money inside a brief timeframe.
The term is likewise used to allude to resources that are now in real money structure. Generally,
they are viewed as the most fluid resources that an organization claims.
2018 2019 2020
Current Assets 58 65 60
Less: Stock 12 18 17
A. Quick Assets 46 47 43
B. Current Liabilities 50 40 46
Quick assets ratio 0.92 1.175
0.93478
3
3. Management
Inventory turnover
Inventory turnover is the rate at which an organization replaces an inventory in a given period of
time as a result of bidding. Measuring investment turnover helps organizations develop
valuation, collection, advertising and purchasing options. Closely protected inventory rates
indicate that a group's business is unique and cost-controlled. Inventory conversion rate is a
proportion of how well an organization does business from its inventory.

2018 2019 2020
A. Net Sales 212 235 312
B. Inventory 12 18 17
Inventory turnover ratio
(A/B)
17.6666
7
13.0555
6
18.3529
4
Trade receivables collection period
The average collection period is a measure of the time it takes for a company to receive the
installments from their customers on the cash due (AR). Organizations measure the normal limit
time to make sure they have enough money to meet their financial commitments.
2018 2019 2020
A.Net Sales 212 235 312
B. Trade receivables 35 25 55
Trade receivables collection period ((B/A)*365)
60.2594
3
38.8297
9
64.3429
5
Trade Payables payment period
The Creditor (or payables) days is the same as the days of the debtor and suggests that a
company is taking advantage of the swap credit available to it. Loan days measure the average
amount of time it takes for a business to meet its obligations with foreign exchange providers.
Shares are a useful indicator when it comes to monitoring a company's liquidity position.
2018 2019 2020
A.COGS 185 190 255
B. Trade payables 25 45 39
Trade receivables collection period
((B/A)*365)
49.3243
2
86.4473
7
55.8235
3
4. Solvency
The solvency ratio is a key measure used to measure a guarantor's ability to meet outstanding
debt obligations, and corporate cash lenders use it constantly. A distributable benefit indicates
whether an organization's income is adequate to meet its liabilities and in this way a portion of its
financial well-being is derived. It can indicate likelihood that an organization will neglect its
responsibilities.

Debt to equity ratio
The debt / equity ratio (D / E) is determined by separating the total liabilities of an organization
by the value of the investment. These figures can be found in the tax minutes asset report. The
allowance is used to assess the financial impact of an organization. D / E is a large amount used
in corporate currencies. It is a proportion of what an organization funds its activities through
liability versus wholly owned assets. More clearly, it reflects an investor's value-added ability to
cover all specific liabilities in the event of a business fall.
2018 2019 2020
A. Debt 95 95 125
B. Equity 125 124 145
Debt Equity (A/B) 0.76
0.76612
9
0.86206
9
Debt to capital employed ratio
The debt-to-capital ratio is an estimation of an organization's monetary influence. The obligation
to-capital proportion is determined by taking the organization's advantage bearing obligation,
both short-and long haul liabilities and separating it by the complete capital. All out capital is all
interest-bearing obligations in addition to investors' value, which may incorporate things, for
example, normal stock, favored stock, and minority premium.
2018 2019 2020
A. Debt 95 95 125
B. Capital employed 180 224 325
Debt Equity (A/B)
0.52777
8
0.42410
7
0.38461
5
Interest cover
The interest coverage ratio is a debt ratio and profitability ratio used to decide how effectively an
organization can pay interest on its exceptional obligation. The premium inclusion proportion
might be determined by partitioning an organization's income before interest and assessments
(EBIT) by its advantage cost during a given period by the organization's advantage installments
due inside a similar period. The Interest inclusion proportion is likewise called "times revenue

acquired." Lenders, speculators, and leasers regularly utilize this recipe to decide an
organization's danger comparative with its present obligation or for future getting.
2018 2019 2020
A. Net Profit before
interest 25 36 44
B. Interest expense 9.5 9.5 12.5
Debt Equity (A/B)
2.63157
9
3.78947
4 3.52
5. Investment
An investment is an asset or item acquired with the objective of creating pay or appreciation.
Thankfulness alludes to an expansion in the estimation of a resource over the long haul. At the
point when an individual buys a decent as a venture, the expectation isn't to burn-through the
great yet rather to utilize it later on to make abundance. A venture consistently concerns the
expense of some resource today—time, cash, or exertion—with expectations of a more
noteworthy result later on than what was initially placed in.
Earnings per share
Earnings per share (EPS) is determined by deciding an organization's net benefit and distributing
that to each exceptional portion of normal stock. EPS is one measure that can fill in as an
intermediary of an organization's monetary wellbeing. In the event that the entirety of an
organization’s benefits was paid out to its investors, EPS is the bit of an organization's overall
gain that would be assigned to each exceptional offer.
2018 2019 2020
A. Net Income - dividend 25 36 44
B. Weighted average shares
outstanding 70 55 60
EPS (A/B)
0.35714
3
0.65454
5
0.73333
3
Price to earnings ratio

The price / earnings ratio (P / E ratio) is the ratio to honor an organization that measures the
value of its current offering relative to per-share profit (EPS). The cost / profit ratio here and
there is called differential value or multiple revenue.
2018 2019 2020
A. Share Price 3 4 2
B. EPS
0.35714
3
0.65454
5
0.73333
3
Price to earnings ratio (A/B) 8.4
6.11111
1
2.72727
3
Earning yields
The earnings yield is the backwards of the P/E proportion. While the income yield tells an
investor the amount he has procured per share held, the P/E proportion tells the financial
specialist what amount of time it would require for the organization to support its profit to arrive
at the current offer cost. The profit yield additionally assists the investor with comprehension if
his offers are yielding him as much as different organizations in a similar industry. The P/E
proportion, then again, decides whether the stock is exchanging including some built-in costs or
markdown when contrasted with different organizations in a similar area.
2018 2019 2020
A. EPS
0.35714
3
0.65454
5
0.73333
3
B. Share Price 3 4 2
Earnings yield ratio (A/B)
0.11904
8
0.16363
6
0.36666
7
Dividend cover
The Dividend Coverage Ratio, also known as profit coverage, is a metric that measures the times
when an organization can make a profit for its investors. The profit inclusion rate is the
percentage of the organization’s total compensation separately from the profit paid to investors.
Dividend yield

Dividend yield is the cash portion that measures the quantum of cash profits paid to investors
against the market estimate per share. It is calculated by separating the earnings per share from
the market cost per share and increasing the yield by 100. An organization with a high profit
margin pays a significant portion of its profits as profits. The profit margin of an organization is
always compared to the business norm in which the organization operates.
6. Cash flow movement
The cash flow statement (CFS) measures how an organization is managing its cash position,
which means how well the organization is earning money to meet its commitments. to pay and
finance its operating costs. The revenue request completes the resource report and payment
definition.
2018 2019 2020
Operating Activities -12 -10 -14
Financing activities 55 68 60
Investing activities 12 18 22
7. Share price movement and performance over the period
The stock performance evaluation is very individual for each financial expert. Just as everyone
has different risk management methods, expansion plans and contribution methods, each
financial expert also has a set of standard rules for evaluating the stock's performance. One
financial expert expects a typical annual return of 10% or more, while another may hope to top
up their portfolio with unrelated stocks in general.
Food deals climbed 1.4 percent, while deals in the retailer's dress and home division fell by 2.7
percent to £1billion however fared in a way that is better than beforehand. All out gathering
income slipped 0.7 percent to £3.02billion and M&S said that while its standpoint for the year
stays unaltered, its edges were presently expected 'to be around the lower end of direction'. This
prompted the FTSE 250-recorded retailer falling pointedly in early morning securities exchange
exchanging, with M&S shares down 9 percent to 199p at 11am. M&S has been reducing the cost
of a portion of its staple items in an offer to win back clients and stay aware of its opponents.

Conclusion
Based on above analyses, it can be concluded that; Ratio analysis is a technique and tool for
decision makers. Quota analysis is used to evaluate various issues based on content, such as its
liquidity, asset productivity, and profitability. Return on capital employed (ROCE) is a
proportion of cash that can be used to measure an organization’s capital return and capacity.
Net profit margin is equal to the amount of total compensation or benefit generated as an income
level. Total net income is the proportion of net benefits to income for an organization or business
assignment. Liquidity ratios are a critical class of money related estimations used to choose an
obliged individual's ability to deal with current commitment responsibilities without raising
external capital.
Inventory turnover is the rate at which an organization replaces an inventory in a given period of
time as a result of bidding. Measuring investment turnover helps organizations develop
valuation, collection, advertising and purchasing options. Loan days measure the average amount
of time it takes for a business to meet its obligations with foreign exchange providers. Shares are
a useful indicator when it comes to monitoring a company's liquidity position.
The stock performance evaluation is very individual for each financial expert. Just as everyone
has different risk management methods, expansion plans and contribution methods, each
financial expert also has a set of standard rules for evaluating the stock's performance.

References
Shaikh, S., 2020. MCQ Ratio Analysis of Financial Statements.
Amanda, Y. and Riyanto, S., 2020. ANALYSIS Analysis Of Influence On Pt. Astra Agro Lestari
Tbk Financial Performance In Measuring Financial Statements In 2018-2019
Period. Journal of Sosial Science, 1(4), pp.178-184.
Easton, P.D., McAnally, M.L., Sommers, G.A. and Zhang, X.J., 2018. Financial statement
analysis & valuation. Boston, MA: Cambridge Business Publishers.
Williams, E.E. and Dobelman, J.A., 2017. Financial statement analysis. World Scientific Book
Chapters, pp.109-169.
Abernathy, J.L., Guo, F., Kubick, T.R. and Masli, A., 2019. Financial statement footnote
readability and corporate audit outcomes. Auditing: A Journal of Practice &
Theory, 38(2), pp.1-26.