Comprehensive Financial Analysis and Budgeting for Max Spray Ltd

This report provides a comprehensive financial analysis of Max Spray Ltd, including an examination of its financial statements, calculation and analysis of financial ratios, determination of the weighted average cost of capital (WACC), project evaluation using Net Present Value (NPV), and an overview of budgeting techniques. The analysis includes a balance sheet for 2017 and 2018, a profit and loss account for 2018, and a cash flow statement for 2018. The financial ratio analysis assesses the company's return on equity, gross profit margin, efficiency ratios (inventory turnover, receivable settlement period, payable settlement period), current ratio, acid test ratio, leverage ratio, dividend payout ratio, and earnings per share (EPS), comparing them to industry averages. The project evaluation uses NPV to determine the viability of an investment, and the report also outlines various budgeting techniques relevant to the company's financial planning.

Running head: ACCOUNTING PRINCIPLES
Accounting Principles
Name of the Student:
Name of the University:
Author’s Note

1
ACCOUNTING PRINCIPLES
Table of Contents
Financial Statements of Max Spray Ltd..........................................................................................2
Financial Ratio Calculation and Analysis........................................................................................5
Weighted Average Cost of Capital..................................................................................................8
Project Evaluation............................................................................................................................9
Budgeting Techniques.....................................................................................................................9
Reference.......................................................................................................................................12

2
ACCOUNTING PRINCIPLES
Financial Statements of Max Spray Ltd
Balance Sheet for the year 2017
Profit and Loss Account for the year 2018

3
ACCOUNTING PRINCIPLES
Balance Sheet for the year 2018

4
ACCOUNTING PRINCIPLES
Cash flow Statement for the year 2018

5
ACCOUNTING PRINCIPLES
Financial Ratio Calculation and Analysis

6
ACCOUNTING PRINCIPLES
As per the table which is shown above, the significant ratios which are very useful for the
purpose of determining the performance of the business. The return on equity shows that the it
has increased from previous year and the same is shown to be 24% in 2021 which is a positive
sign, however it is still lower than the industry average which signifies that the return on equity
of the competitors of the company is still more. The gross profit margin of the company has
decreased significantly from previous year. The gross profit margin is shown to be 51.6% for the
year 2019 and the same has reduced to 40.5% in the year 2021. This may be due to the increase
in the overall cost of good sold of the business and also due to the fall in the sales of the business
(Petruzzo et al., 2015). In addition to this, the profitability is lower than the industry average
which shows that the business is underperforming in comparison to its competitors.
The efficiency ratio of the company shows significant ratios such as inventory turnover
period, receivable settlement period and payables settlement period. The inventory turnover
period has increased from 2019 which was 77.6 days and the same is shown to be 80.4 days in
2021. This has increased which is not a favorable sign and the management is taking more time
to sell off the inventory of the business (Damjibhai, 2016). In the case of debtor settlement
period, the number of days has increased which means that the debtors of the business will be
taking more time to settle the debts of the business. The payable settlement days has reduced and
the same is showing as 28.7 days as per the above figure which is a favorable sign for the
business and the same is also lower than the industry average which is shown to be 36.4 days
which is a good sign.
The current ratio of the business has increased from previous year and the same is shown
to be 2.81 which means that the liquidity position has improved from previous years even though
the estimate is lower than the industry average which signifies that there are companies which

7
ACCOUNTING PRINCIPLES
has a better liquidity than Max Spray ltd (Babalola & Abiola, 2013). The acid test ratio also
shows liquidity position of the business.
The leverage ratio shows the amount of debt which a business applies in the capital mix
of the company and the level of debt applied by the company has reduced which is evident from
the decrease in the gearing ratio of the business which is shown as 63.4 % in 2021 (Kiema &
Jokivuolle, 2014).
The dividend payout ratio of the company has fallen which may be attributed to the fall in
the profits of the business as shown. The EPS of the business is shown to be 0.22 which has
increased and is comparatively higher than industry average.

8
ACCOUNTING PRINCIPLES
Weighted Average Cost of Capital

9
ACCOUNTING PRINCIPLES
Project Evaluation
As per the table which is shown above, the calculation of NPV is undertaken for the
purpose of taking decision whether the business needs to undertake the investment or not. As per
the calculations, the NPV of the project is shown to be 1.5. This means that the net cash inflows
is greater than cash outflows of the business and thus the project should be accepted.
Budgeting Techniques
Part A

10
ACCOUNTING PRINCIPLES

11
ACCOUNTING PRINCIPLES