Financial Statements Analysis and Interpretation

This assignment focuses on analyzing and interpreting financial statements. It requires students to calculate and explain the significance of various financial ratios, such as gross profit ratio, and apply them to understand a company's financial performance and position. The emphasis is on using these ratios to make informed business decisions.

FINANCE IN HOSPITALITY

TABLE OF CONTENTS
FINANCE IN HOSPITALITY.......................................................................................................1
INTRODUCTION ..........................................................................................................................3
TASK 1............................................................................................................................................3
1.1 Reviewing the sources of funding which are available to business or service industries.....3
1.2 Evaluating the range of methods of generating income within the service or business
operations....................................................................................................................................4
TASK 2............................................................................................................................................4
2.1 Elements of cost, gross profit percentages and selling prices...............................................4
2.2 Methods of controlling stock and cash..................................................................................5
TASK 3............................................................................................................................................6
3.4 Analyze of variance and appropriate suggestions.................................................................7
3.1 Sources and structure of trial balance...................................................................................7
3.2 Evaluation of business accounts, adjustments and notes......................................................9
4.1, 4.2 Calculation of various ratios and recommendation......................................................11
TASK 5..........................................................................................................................................12
5.1 Fixed, variable and semi-variable cost................................................................................12
5.2 Calculation of cost volume profit analysis..........................................................................13
5.3 Short term management decision based on break even calculation....................................14
CONCLUSION..............................................................................................................................15
REFERENCES .............................................................................................................................16
1

INTRODUCTION
Finance is the crucial element which plays a vital role in implementing strategies and
policies within the suitable time frame. In the present era, corporation can attain success only
when they have sufficient financial resources to conduct research and development activity
(Allen, Qian and Qian, 2005). In this, finance manager of the firm plays a significant role in
framing the competent strategies which facilitates effective utilization of financial resources to
the large extent. This project report is based on different scenario which helps in understanding
the sources of funding which are available to business and service industries. Besides this, it will
also develop an understanding about the relationship between cost, gross profit and selling price.
Further, the present report will discuss the purpose and process of budgetary control which helps
company in getting the desired output. In addition this, report will also examine the financial
health and performance of R. Riggs through ratio analysis.
TASK 1
1.1 Reviewing the sources of funding which are available to business or service industries
There are several internal and external sources of finance which are available to sole
trader in relation to the purchase of machinery worth of £50000 are as follows:
Internal source of finance: It refers to those sources which are available within the business
enterprise are as follows:
 Retained profit: Sole trader can fulfil financial need by making use of retained profit
which he kept with itself for the contingent situation or liability.
Advantages: By making use of retained profit, company can save the amount of tax to a
large extent. Moreover, the amount of tax is calculated on the profitability aspect of firm.
Disadvantages: When organization undertakes retained profit to fulfil its financial need
then it is unable to provide dividend to their shareholders. This aspect negatively affects the
image of firm.
 Sales of assets: Trader can also raise finance by selling non-performing assets of the firm.
It is the most effective source of finance which helps in small business in meeting its
monetary needs. Sole trader can easily fulfil his financial need by selling the assets which
have no further use in the productive activities of business unit. Through this, sole trader
is able to purchase machinery which helps him in enhancing the productivity and
profitability of firm.
2

Advantages: By replacing an old asset with the new one, company can increase its
productivity and profitability aspects.
Disadvantages: When firm sells its assets then it places a bad impact on it brand image.
Moreover, stakeholders think that financial health and performance of organization is sound and
so, it starts selling assets for meeting their financial requirements.
 Personal savings: Sole trader can also make use of his personal savings to meet out the
financial needs for the purchasing of machinery.
Advantages: Sole trader does not require making any payment of interest. Moreover,
interest charged by the institutions is always higher than the interest earned by the investor.
Disadvantages: In personal savings, business entity does not get interest for the money
which they use for the business purpose.
 Angel investors: Friends as well as family members act as an angel when their loved one
requires finance. Thus, business entity can easily enhance his fund by approaching their
relatives for financial assistance.
Advantages: In case if sole trader takes financial assistance from their relatives then they
make payment to them on the basis of their convenience.
Disadvantages: Interference of the angel investors are increased when sole trader takes
financial assistance from them. Moreover, business entity requires giving the right of ownership
to the friends and family members to an extent to which fund is provided by them.
External sources of finance: It includes the sources which are present outside the business
organization. They are as follows:
 Bank loan: Small business enterprise can purchase machinery by taking financial
assistance from bank on the basis of collateral security.
Advantages: Sole trade can enjoy tax benefits when he undertakes bank loan to meet
their needs.
Disadvantages: High interest amount is one of the main disadvantages of bank loan
which closely affects the profitability aspect of firm.
 Leasing: Company can also make use of machinery by taking assistance of leasing
aspect. By making payment of rent sole trader can use machinery in productive purpose
for the predetermined time period. If offers opportunity to sole trader to use machinery
without making huge investment on it (Andreff, 2007).
3

Advantages: Sole trader can manage his cash inflow and outflow in an effectual manner
by taking asset on lease rather than making investment on it.
Disadvantages: Leasing expense may reduce the net income aspect of firm without any
appreciation in the value.
 Bank overdraft: Individual can raise his financial need by approaching bank for the
overdraft facility. Usually, banks are ready to give financial assistance to business entity
that has good credit ratings.
Advantages: By making an effectual use of image, individual can easily raise finance to
some extent.
Disadvantages: Bank charges high interest on overdraft facility as compared to the bank
loan.
 Factoring: It is a financial transaction or debtor finance in which business unit sells its
receivable to the third party at discount. Through this, sole trader can receive the amount
of bills receivable before its due date. Thus, by discounting bills from financial
institution, individual is able to purchase the machinery worth of £50000. For such
facility, financial institution charges high monetary cost from the business organization in
terms of discount. By this, sole trader is able to meet his present or immediate cash
requirements. For instance, sole trader has receivable of £50000. In this, by discounting
such receivables from the financial institution, he can easily meet his needs. On the basis
of cited example, bank charges £500 as factor and give £49500 to sole trader after
discounting such receivable.
Advantages: Sole trader can mitigate the risk of bad debt by making use of factoring as a
tool.
Disadvantages: Financial institution charges high percentage on the amount of bills
receivable which imposes high financial cost in front of the organization.
Recommending sources: On the basis of all above mentioned benefits and drawbacks, it
is recommended to the sole trader to undertake bank overdraft and to do factoring for meeting his
financial requirement for the purchase of machinery. In addition to this, sole trader also needs to
sell his assets which are no further in use in the productive activities. Thus, by making use of all
these sources, sole trader can make balance in his capital structure.
4

1.2 Evaluating the range of methods of generating income within the service or business
operations
There are wide ranges of methods are available to large chain restaurant which helps it in
achieving success in the strategic business arena.
 Offering unique services: Restaurant can raise their revenue by offering the innovative
and unique services to their customers. This aspect helps restaurant in attracting large
number of customers and thereby maximize the sales and gross margin of the firm
(Atkinson, 2005).
 Expansion of restaurant chain: Large unit of restaurant needs to expand its business
operations and functions by opening up new restaurants at famous places of UK. It
enables restaurant to serve the wide segment of customers and increase their profitability
aspects.
 Charismatic ambiance: Restaurant needs to make focus upon the development of
attractive ambiance which helps them in encouraging the customers to make experience
of the restaurant chain. Thus, by taking into consideration all the above mentioned
aspects company is able to generate more income.
 Advertisement: Large chain of restaurant can easily influence the number of customers by
placing advertisement on social networking sites. Through this, business unit is able to
provide information to a large segment of customers about the services which are offered
by them.
 Recruiting skilled and efficient personnel: By hiring skilled and efficient personnel,
restaurant is able to deliver quality services to their customers. Moreover, in service
industry, personnel represent the business unit. Employees are the one who directly
interact with the customers. Thus, by greeting customers in a polite manner, restaurant
can evolve satisfaction among the customers. This is turn helps in raising the gross
revenue of firm.
 Research and development: Restaurant can also enhance its income by taking into
consideration the research and development activity. Through this, restaurant is able to
identify the needs, wants and expectations of customers. It enables the restaurant to serve
customers according to their needs which helps it in building loyalty among customers.
5

 Entry in the in new industry: Business unit can generate high income by entering in the
retail industry. This industry is continuously growing so; restaurant can expand its
business operations or functions and thereby, can take benefits from it.
TASK 2
2.1 Elements of cost, gross profit percentages and selling prices
Various elements of cost, gross profit and selling price are as follows:
Cost: Specifically two types of cost which business organization has to incur while
manufacturing the product or services. Material, labour and overheads are the main elements of
cost which are enumerated as below: Material: It includes the cost which is incurred by the firm on raw material for
manufacturing the product or services. Labour: Business organization also has to pay wages to their workers for the hours in
which work is performed by them. In addition to this, cost of employee benefits and
payroll taxes are also recognized as the labour cost. Overhead: It refers to all office and administration expenses as well as selling and
distribution expenses of the firm. Each organization has to incur overhead expenses for
smooth functioning of business operations and functions.
Direct cost: It is also known as prime cost which is directly attributable to the production
of goods and services. On the basis of cited case scenario direct cost incurred by Marks &
Spencer includes carrier bag, staffing cost etc.
Indirect cost: It many defined as those which not highly related to the production of a
product but organization has to incur such operation during their business operations. This kind
of expenses may be either fixed or variable depending upon the nature of expenses which are
incurred by them (Bhatt, Wening and Pai, 2006). Fixed cost includes rent of building and
machinery etc. which remain fixed at each level of output produced by the firm. However,
variable expenses are those which get changed in accordance with alteration made in the level of
output. Indirect cost also includes the following cost which is as follows:
6

a. Fixed cost: It may be defined as a periodic cost which does not get changed irrespective of the
changes which take place in the level of output produced by the firm. For instance, salaries of
employees, rent of building, etc.
b. Variable cost: This cost includes electricity, insurance, advertisement and other office
expenses which vary with the production. It increases when volume of units get rise and vice
versa.
Gross margin: It refers the percentage of profit which Marks & Spencer wishes to earn
by selling per unit of product or services.
Selling price: It may be defined as a summation of cost and gross margin which provides
opportunity to earn profit by recovering the cost of product (Blocher, Chen and Lin, 2008).
Relationship between the cost, gross margin and selling price are enumerated as below:
Selling price = cost + cost *profit%
For example: cost= 1000
Profit%= 10%
Selling price = 1000+ (1000*10%)
=1000+100= £1100
On the basis of the above mentioned aspect Marks & Spencer requires to sell its
per unit of product @£1100 if it wishes to earn £100 by selling per unit of product.
2.2 Methods of controlling stock and cash
Stock refers to the goods or merchandise which is available to the business organization
for selling and distribution. Usually, companies prefer to maintain the stock of raw material and
finished goods in its warehouses for effective functioning.
Stages of stock: There are mainly five stages of stocks which include raw material
purchase, warehousing, production and packaging as well as finished goods. On the basis of
these five stages, company primarily makes purchase of material and then procures it in
warehouse. Thereafter, business unit sends it to production department for the manufacturing of
goods. After this, organization makes packaging of the finished goods.
Ways to control stock: Marks & Spencer can control its stock by making use of inventory
control techniques namely just in time, economic order quantity etc. Just in time is the best
method which helps organization in reducing the holding and inventory cost. According to this
method organization needs to make order of inventory only when they are needed for the
7

production of goods or services. It enable firm to control the level of inventory by making
reducing the wastage. However, it is to be critically evaluated that in just in time method affects
the smooth functioning of the business operations and functions.
Moreover, in just time company place order only when they require the raw material for
the production. In this, production function of an organization is closely affected because they
have to wait until and unless the raw material is not received by it (Brealey, 2012). Thus, Marks
& Spencer needs to undertake economic order quantity method which helps them in preventing
the situation of waiting time. In economic order quantity method, company make assessment of
the units which they require to produce the predetermined level of output. Through this, Marks &
Spencer is able to save their holding and ordering cost. It also ensures smooth production of the
goods or services.
EOQ = Square root of 2D * K/ h
k= cost per order
h = Carrying cost per unit
In addition to this, stock taking methods also have high level of influence on the cost and
profitability aspect of firm which is as follows: First in first out (FIFO): Under this method, manager prefers to make use of the product
which firstly came in organization.
 Last in first out (LIFO): Unlike FIFO, business enterprise primarily prefers to make use
of its latest stock for production.
Marks & Spencer can also control its inventory level by adopting FIFO or LIFO method
according to their convenience.
Ways to control cash: Marks & Spencer can control cash related activities by making
internal audit of the financial statements. By assessing the income and cash flow statement
company can easily identify the areas of expenses in which they requires to make control.
Through this, organization is able to make optimum utilization of financial resources to the large
extent (DRURY, 2013). For instance: through internal audit it has been identifying that company
have incurred high electricity expenses due to the wastage of energy. In this, Marks & Spencer
can control the expenses by placing notice ion electricity board. This is the most effective way
through which Marks & Spencer can control cash and thereby increase money for further
investment. In addition this, company can also make control upon their monetary activities by
8

making assessment of their cash flow statement. Through this, firm is able to frame competent
strategies and policies which make helps them in making effective utilization of cash aspects.
Along with this, Marks & Spencer can also make control upon cash by preparing bank
reconciliation statement. This statement provides deeper insight to the organization about the
difference between balance shown in organizational bank's statement and the amount recorded in
the accounting records of firm. This statement contains information about all financial
transactions such as deposit or withdrawal which are made by the firm during accounting year. It
also provides opportunity to the business organization to make verification of transaction which
is made by them. Besides this, it also entails the position of cash at bank. Through this, firm is
able to make effectual decisions in relation to their cash related activities. Thus, by keeping all
the above mentioned aspects in the mind, business organization can make optimum utilization of
financial resources. Moreover, cash is the most crucial element upon which the implementation
of business plan is highly dependent. For instance, payment of £1000 is made to the creditor
through cheque but is not presented by him in bank for the withdrawal. In this, amount of the
bank account is declined by £1000. Whereas, in the bank statement, there are no changes that
took place as cheque is not presented by the creditor in bank. Thus, by making verification of the
cash book and pass book, Marks & Spencer can easily assess the actual cash position of firm.
TASK 3
Budgetary control is the process which helps an organization in comparing its actual
figures with that of budgetary figures. By comparing both these figures, company will be able to
analyze its actual performance and in regard to which certain necessary measures can be taken
into consideration.
Process of budgetary control
Communicating details of budget policy and guidelines to those people responsible for
the preparation of budgets: - The very first step which should be taken into consideration is that
the management should make efforts and need to communicate the necessary information related
to the budget to the members who are responsible for the preparation of budget so that a proper
budget can be prepared.
Determining the factors that restrict output and taking action to sort those out: - After
the entire necessary information is collected and communicated, factors that can affect the
9

preparation of budget or can restrict company to achieve its goal should be identified and then, it
can be eliminated.
Preparation of the sales budget: - Once all the unwanted factors are eliminated then sales
budget should be prepared in order to analyze the sales that can take place during a year.
Initial preparation of various budgets: - Further, when sales budget is prepared, other
necessary budget should be made in order to achieve the main aim of preparing sales budgets.
Negotiation of budgets with superiors: - Once different budget has been prepared then all
that should be compared in order to find out the superior budget.
Coordination and review of budgets: - After selection and implementation of superior
budget, functioning of the budget should be reviewed in order coordinate all the activities and to
find out whether there is any drawback of the budget or not.
Final acceptance of budgets: - At last, the final budget prepared should be accepted in
order to achieve the actual objectives of preparing budget.
Ongoing review of budgets: - Lastly, ongoing budget should be reviewed with an aim to
find out whether there are any faults of budget or not.
Thus, these are some of the steps which are required to be followed at the time of
preparation of budgets.
Purpose of budgetary control
Motivation: - Purpose of budgetary control is to motivate the staff members. If budget is
prepared then in that case, all the employees working will be able to know the extent to which
they are required to work. If employees know in advance what they are required to do then they
will give their best to achieve that particular target.
Control: - If budget is prepared then in that case, an organization will be able to know the
extent to which they should invest. They will be able to know the amount at which they should
make expenses. If the set limit is extended then in that case, they can control their expenses.
Evaluation: - Budget prepared will help company to evaluate the limit at which they
reached and level to which they are far from achieving their desired target.
Budgetary Control Cycle
Responsibilities: - An organization should first set the responsibilities which each and
every employee is required to perform in order to achieve the desired objectives.
10

Action plan: - After this, an action plan should be prepared in order to find out what the
company is actually required to achieve.
Adherence: - Once action plan has been prepared then in that case, an organization should
prepare various small plans in order to achieve the main desired target.
Monitoring: - After preparation of various attachments, working of this plan should be
monitored in order to analyze whether the plan prepared is going in a correct way or not.
Correction: - Furthermore, after monitoring the progress of plan, management should
make efforts to correct wrong factors that may affect the success of plan prepared.
Approval & Variances: - At last, when plan has been monitored and necessary changes
have been made then the final plan should be approved with an aim to achieve the desired target.
3.4 Analyze of variance and appropriate suggestions
Table 1: Comparison of budgeted performance with actual performance
Budgeted Actual Variance
Units sold 100000 75000 -25000
Material 15000 22500 -7500
Direct labor 22500 24375 -1875
Table 2: Variance of direct material and labor
Material labor
Price/rate variance -4500 3750
Usage/ efficiency variance -3000 -5625
Total variance -7500 -1875
Interpretation
On the basis of the above calculation, it can be concluded that company is not able to sell
out the required units as compared to that of desired figures. On the other hand, cost of material
and labour increase than its desired cost. The following condition may occur due to uincertain
economic conditions in Europe, growing rate of unemployment, increase in standard wages of
the labour. Due to the availability of these factors, demand of the products have started to
decline and in respect to this company is not able to achieve its desired target. On the other hand,
it is seen that cost of material purchase has increased as compared to that of desired cost. The
reason behind this could be the incorrect prediction of demand. Similarly, cost of labour also
11

increases due to incorrect reasoning. This in turn shows that the condition of negative variance
has occurred in case of material and labour. Likewise, efficiency variance also show the negative
variance. This in turn indicates that an organization is not able to properly utilize its available
human resource and material.
 Labour rate variance- It is a variance that reflects whether firm paid at higher rate to the
labours relative to the rate that was determined in the budget. This variance is negative
and it reflects that labors are paid at the higher rate that was decided in the budget.
Hence, firm needs to make proper estimate of the wage rates in order to make sure that
such variance will not come in existence.
 Labour efficiency- It is a variance that measures the extent to which firm is making
efficient use of labours. Negative variance reflects that firm is not making proper use of
its labours. Firm failure to make accurate anticipation of labor requirements leads to
negative variance. Thus, firm needs to review its past budgets in order to make sound
estimate of labor’s requirement at the workplace.
 Material price- It is a variance that reflects whether company purchase raw material at a
greater or less price relative to the price at which company wants to purchase raw
material. Materials are purchased at higher price then budgeted and this is reflected from
the negative value of variance. Company may buy material in huge quantity and by doing
same, it can keep cost in control.
 Material usage- It is a variance that indicates whether firm make overuse of raw material
or not. Here, value of the variance is negative and this reflects that firm overuse materials
for the production of goods in facility. Firm can review past budgets in order to make
accurate anticipation. If firm takes this action then there will be less chances of variance.
 Sales Volume- It is a variance that reflects the variance in units that firm sold in relation
to the units that were determined in the budget. This variance comes in existence because
firm makes a wrong anticipation of the demand for the product. Hence, company needs to
use good forecasting technique in order to make perfect decisions.
 Sales Price- In case of this, variance price in the budget and actual is same. Thus, there is
no issue on sales price of the product.
12

3.1 Sources and structure of trial balance
Trial balance is a statement that is sued to prepare final accounts for the company. Final
accounts refer to the income statement and balance sheet. In the trial balance all information are
taken from the ledger accounts (Fujiwara, 2005). These are specific type of accounts in which
real, nominal and personal accounts are included. In the trial balance there are two sides one is
debit and other is credit side. The balance of these two sides always remains same. Hence, by
using this method manipulation in accounts can be easily identified. It is trial balance by using
which final accounts are prepared in legitimate manner. Following is the format of trial balance.
13

14

It can be seen from the image that there are two sides and balance of both sides is equal to each
other. Hence, it can be said that this statement is very important for an organization because from
same information about all accounts is easily available to the business managers.
3.2 Evaluation of business accounts, adjustments and notes
Table 3: P&L statement of R.riggs
Particulars
Sales 157165
Less Cost of goods sold: 94520
Gross profit 62645
Discounts received 160
Interest received 50
15

GP 62855
Less Expenses:
Wages and salaries 31740
Rent 3170
Discounts allowed 820
Van running costs 687
Bad debts 730
Doubtful debt provision 91
Depreciation 1630
Accrued expenses 200
Net Profit 23787
Table 4: Balance sheet of Riggs
Fixed assets
Office furniture & Van 7175
Less depreciation 1630
5545
Current Assets
Stock 2400
Debtors 12316
Less provision for doubtful debts 496
11820
Prepaid expenses 230
Cash at bank & hand 4274
18724
Total Assets 24269
Current liabilities
Creditors 5770
Accruals 412
16

6182
Financed by:
Capital 11400
Add net profit 23787
Less drawings 17100
18087
24269
…..
Journal entries of R.Riggs with adjustments
Date Particulars Debit balance Credit balance
03/03/
12
Furniture a/c Dr.
To bank a/c
(furniture purchased on credit)
525
525
30/12/
12
Interest received a/c Dr.
To bank a/c
(interest received from bank)
50
50
04/06/
12
Accrued expenses a/c Dr.
To cash a/c
(Accrued interest paid)
200
200
Impact of entries on assets, liability and profit
 Furniture- Firm made a fresh purchase of the furniture. It is an asset and due to its
purchase firm asset side of the balance sheet get increased. It is not creating firm
liabilities from any angle and due to this reason firm liabilities remain unaffected from
this transaction. In income statement no impact on profit is observed.
 Interest- Similar to furniture in case of interest also only assets are increased and no
change is observed in the liability side of the balance sheet. Due to this transaction cash is
generated for the firm and because of this reason entry is made in the income statement of
the firm (Garrison, 2010). Hence due to this reason net profit of the firm increased by the
given amount.
17

 Accrued expenses- Accrued expenses are those expenses that are made before it become
due on the firm. Due to this reason accrued expenses are entered as income in the income
statement of the firm (Petersen, 2009). Two hundred pound is mentioned in the income
statement this is the reason due to which net profit get increased by mentioned amount in
the income statement of R. Riggs.
4.1, 4.2 Calculation of various ratios and recommendation
Table 5: Gross and net profit ratio
Gross profit 62645
Net sales 157165
Gross margin ratio 39.86
Net profit 23937
Net sales 157165
Net profit ratio 15.23
Gross profit ratio- It is a ratio that indicate the percentage of sales that is covered by the gross
profit. It also indicate the firm cost control capacity. If sales is increasing and expenses are grow
at slow pace then it means that firm have a good control on direct expenses (Gross profit ratio,
2015). Gross profit ratio of the firm is 39.86% and this can be considered good from the firm
point of view.
Net profit ratio- Net profit ratio indicate the percentage of sales that is covered by the firm net
profit. Net profit ratio of the firm is 15.23% and it can be considered good from the firm point of
view. This ratio also indicate the firm capability to control indirect expenses.
Table 6: Current and liquid ratio
Current assets 23894
Current liabilities 5657
Current ratio 4.22
Stock 2400
prepaid expenses 230
Liquid assets 21264
18

Current liabilities 5657
Liquid ratio 3.75
Interpretation
Current ratio- current ratio indicates the firm liquidity position. Current ratio of the firm is 4.22
and it means that for every one pound of current liability there is a 4.22 pound of current assets
with the firm. Hence, company is in position to pay its current assets on time.
Liquid ratio- This indicate the accurate liquidity position of the firm. Current liquidity ratio
value is 3.75 means that for every one pound of current liability there is a 3.75 pound of liquid
assets. There is a small gap between current and liquid ratio and this reflects that firm liquidity
position is good and small portion of the current assets is covered by the stock and prepaid
expenses. Hence, it can be said that firm is in good position.
Table 7: Debtor and creditor collection period
Debtor 12316
Sales turnover 157165
Debtor collection period 28.6
Creditors 5245
Cost of gods sold 94520
Creditor collection period 20.25
Interpretation
Debtor collection period- Debtor collection period indicate the days in which debt is collected
from the debtor (Howard, 2007). Here days are 28.6 means that firm is collecting debt amount
from debtors in 28 days. It is good or bad depends on the outcome of the comparison made with
the creditor turnover ratio.
Creditor turnover ratio- This ratio indicate the number of days in which firm is making payment
to its creditors (Miller and et.al., 2011). Creditor days are 20.25 which means that firm is making
payment in twenty days to its creditors. On comparison of both ratios it can be seen that there is
19

huge negative gap between both ratios values. Hence, firm needs to make improvement in values
of both ratios.
Table 8: Ratios of R.Riggs
Inventory turnover ratio COGS/ Inventory 94520/2400 39.38
Debt equity ratio Debt/equity 5245/11400 0.46
ROA Net income/Total assets 23937/5020 4.77
ROCE Net operating profit / Capital employed 23937/16645
142.81
%
Receivable turnover ratio Sales/Receivables 157165/11820 13.3
EPS Net income/Issue shares 23937/1140 20.99
Assets turnover ratio Net sales/ Total assets 157165/5020 31.31
Interpretations
 Inventory turnover ratio- This ratio reflects the number of times firm stock of goods get
converted into sales (Inventory turnover ratio, 2016). Here, stock turned into sales 39
times which reflects that firm gives a good performance.
 Debt equity ratio- Debt equity ratio is 0.46 and it means that for every one pound of
equity, there is a 0.46 pound of debt. Thus, it can be said that firm is in good position and
it is financially sound.
 ROA- It is a ratio that reflects the return that firm assets are generating in the business.
Value of this ratio is 4.77 and it is good return on assets. Hence, it can be said that firm is
making the best use of assets in business.
 ROCE- It is also known as the return on capital assets and ROCE of the firm is 143.81%.
This reflects that firm gives elegant performance in business and is earning good return
on the invested corpus.
20

 Receivable turnover ratio- Firm’s receivable ratio is 13.30 and this reflects that
organizations account receivables turned 13.30 times in a sale. Hence, it can be said that
there are less number of debtors of the firm that converted into bad debts.
 EPS- It is also known as earning per share and this indicates the earning of company that
every shareholder is receiving of the individual shares. EPS is 20 which can be said good
from the investor’s point of view.
 Assets turnover ratio- It is a ratio that reflects the number of times firm’s assets are used
to generate sales. The value of ratio is 31.31 which indicates that firm is making efficient
use of its assets. Hence, it can be said that firm is giving good performance.
4.2 Recommendations to management
To
The directors
Date- 29th February 2016
On the basis of above analysis, it can be reported that R. Riggs has good profitability and
liquidity position in the market. The reason behind this is that it is earning better amount of
profitability and better ability to discharge their short-term obligations. However, debtors
turnover ratio are comparatively higher than creditors payment period. It indicates that R. Riggs
is paying its suppliers earlier and generates delayed payments from debtors so that firm will
have lower availability of cash to support its operations. Thus, it can be recommended that
company should provide credit for a lower time period which will contribute to enhance cash
flows and operate successfully. Another, R. Riggs inventory turnover ratio indicated that
R.Riggs is managing its inventory efficiently. Furthermore, debt/equity ratio is little below from
the idle ratio henceforth, it can be said that capital structure is good and firm is managing its
financial risk. In addition to it, assets turnover ratio and receivable turnover ratio are 31.31 and
13.30 which indicated that R.Riggs is using its assets in an efficient way. Furthermore, ROA
and ROCE indicated that R.Riggs is generating good profitability on its assets and invested
capital. Thus, R.Riggs is performing better in the market and done its operations successfully.
Moreover, EPS to 20 indicated that R.Riggs is providing better profitability to the shareholders.
Thus, in turn, firm will be able to generate higher satisfaction from the shareholders. Therefore,
21

it can be concluded that overall performance of R.Riggs is very good in the market.
TASK 5
5.1 Fixed, variable and semi-variable cost
Following are the categories in which costs are divided.
 Fixed cost – Fixed cost is a cost that remains static during life time of the firm and never
gets changed. In order to reduce fixed cost per unit firm can increase its product
production (Knudtzon and Schmidling, 2006). Due to increase in production per unit
fixed cost will be reduced for the firm. For instance: Rent of building, salaries of
employees, etc.
 Variable cost – It is a cost that never remains static and keeps on changing steadily. By
generating economies of scale firm can reduce its variable cost (Irwin and Scott, 2011).
By doing this firm can reduce per unit cost. On the other hand, if variable cost is
increased then per unit variable cost will also decline. This will lead to increase in the
company profit. For example: Electricity expenditure, advertisement cost, etc.
 Semi variable cost – It is a cost whose some part remain fixed and some part remain
variable (Mayer, Schoors and Yafeh, 2005). Company cannot change fixed cost but it can
bring changes in the variable cost. Example of semi-variable expenses includes wages of
workers, insurance expenses, etc.
By doing so, firm can increase its profit.
5.2 Calculation of cost volume profit analysis
Table 9: Break even when sales price is reduced by 10%
Value in 000
Sales price 10
Percentage change as per proposal 10.00%
New sales price 9
Fixed cost 3
Sales 9
22

Variable cost 8
Contribution 1
Break even sales 3
Break even sales value 27
Number of units required to sell for achieving desired profit:
Desired profit = (Fixed cost + desired profit) / Contribution
Desired profit = (300000 + 20000) / 1 = 50000 units
Interpretation- In this option company reduce its sales price by 10% and this is the main reason
due to which only 1. In order to achieve target of profit of 20,000 firms needs to make sale of
50,000 units. This is computed by applying a formula which is fixed cost plus desired profit
divided by the contribution.
Table 10: Break even when sales increase by 10%
Value in 000
Sales price 10
Percentage change as per proposal 10.00%
New sales price 11
Fixed cost 3
Sales 11
Variable cost 8
Contribution 3
Break even sales 1
Break even sales value 11
Desired profit = (Fixed cost + desired profit) / Contribution
23

Desired profit = (30000 + 20000) / 3 = 16667 units
Interpretation- This case is different and in this sales price is increased by 10%. This is the
main reason due to which sales price become 11 per unit. If this case is compared with above
case then it can be find out that price of the product is increased. Elevation in sales price is
responsible for the increase in contribution up to 3. By applying an above given formula it is find
out that company requires to manufacture 16,667 units for earning a profit of 20,000.
Table 11: Break even when variable cost increase by 1.5
Value in 000
Sales price 10
Fixed cost 3
Sales 10
Variable cost 9
Contribution 1
Break even sales 3
Break even sales value 60
Desired profit = (Fixed cost + desired profit) / Contribution
Desired profit = (30000 + 20000) / .50 = 100000 units
Interpretation
In this case option is inverse and no change is made in the sales price instead changes are
done in the variable cost the company. This is the reason due to which, contribution is very low.
In this case company needs to produce 1,00,000 units in order to earn profit of 20,000. This is a
huge target and hence option is not viable for the firm. Due to this reason it is not recommended
to the company.
5.3 Short term management decision based on break even calculation
Cost volume profit is a technique that is also known as the break even analysis. It
indicate point of sales where firm does not make any profit or loss. This is the sales level above
which firm needs to make sale in order to earn profit (Kaplan and Atkinson, 2015). Up to break
even level firm can only cover its production cost. Of the business. By analysing all available
options it is find out that first alternative is viable for the firm. This is because sales price is
24