Financial Analysis and Management Techniques

Verified

Added on  2020/10/22

|20
|4629
|62
AI Summary
This assignment provides an in-depth analysis of financial management techniques and tools. It explores how organizations can effectively manage their finances and make better decisions using various financial statements, cost analysis, investment appraisal, and budgeting. The document is a valuable resource for students and professionals looking to improve their understanding of financial management principles.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
Accounting and
Finance
Table of Contents

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
A) Prepare an Income Statement and Statement of Financial Position for organisation.......3
TASK 2............................................................................................................................................5
b) Calculation of various types of cost...................................................................................5
a) Calculation of fixed cost.....................................................................................................5
b). Calculation of Marginal Safety.........................................................................................6
c) Calculation of profit...........................................................................................................7
d) Calculations fir selling price..............................................................................................7
e) Identify and explain the underpinning assumptions to break even model.........................8
TASK 3............................................................................................................................................9
C) Calculation of payback period, accounting rate of return and net present value..............9
a)Calculations of different methods.......................................................................................9
b) Key merits and limitations of investment appraisal techniques.......................................10
C) Identifies and explains the key benefits and limitations of using budgets as a tool for
strategic planning..................................................................................................................13
CONCLUSION..............................................................................................................................15
REFERENCES..............................................................................................................................17
Document Page
INTRODUCTION
Accounting and finance are the tools and techniques which is used by an organisation to
summarise, record and interpretation of data and financial information. It helps the company to
know the financial position of it through which it can take future investment decision. In this
report financial statements are prepared such as balance sheet and profit & loss account. Payback
period, accounting rare of return and net present value are also analysed. Apart from this various
types of costs are calculated that are break even & margin of safety.
TASK 1
A) Prepare an Income Statement and Statement of Financial Position for organisation
Income statement is a part of financial statement which shows that a company is
earning profits or not. Profit and loss account is the part of this statement and it is essential to
prepare because it reflects the profitability of organisation during a particular time period. It can
varies form corporation to corporation and it can prepare on the basis of monthly, quarterly and
early basis. In debit side of profit and loss account all expenses are recorded and in credit side
Income statement of Gravepals for the year ended 2017
Statement of profit and loss
Continuing operations £
Sales
Credit 504000.00
Cash 129000.00 633000.00
Cost of sales of goods 297000.00
Gross Profit 336000.00
Operating Expenses
Wages 117000.00
Operating Profits 219000.00
Other Expenses
Document Page
Rent 90000.00
Rates 5775.00
Van running expenses 33600.00
Electricity 7725.00
Depreciation 9600.00
Bad debt 1500.00
Profit before income tax 70800.00
Interpretation: Gross profit is 336000 and from it indirect expenses are deducted such as rent,
rates, electricity, depreciation etc. After that profit before income tax is calculated which is
70800. As a result organisation can know its profits through it.
Financial statement: It records the financial activities and conditions of a business entity of an
organisation. It represents the financial information of the organisation. It involves cash flow,
balance sheet etc. and these are audited by accounting firms or government agencies. In debit
side of balance sheet all liabilities are recorded and credit side all assets are recorded (Financial
statements. 2018).
Financial Statement of Gravepals for the year ended 2017
Financial Statement
Assets £
Van 60000.00
Less: Depreciation 9600.00 50400.00
Total non-current assets 50400.00
Inventories 525000
Accounts receivable 66000
Prepaid Expenses 23625.00
Short-term investments
Cash and cash equivalents
(Balancing Figure) 168300.00
Total current assets 782925.00

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Total assets 833325.00
Equity and liabilities
Equity
Equity share capital 180000.00
Retained Earning 70800.00
Total non-current
liabilities 250800.00
Provision for bad debt 1500.00
Accounts payable 579000.00
Outstanding Expenses 2025.00
Total current liabilities 582525.00
Interpretation: After reducing the depreciation non-current assets are come up which is 50400.
Current assets are 782925 which includes inventories, account receivable, prepaid expenses,
short term equivalents and cash & cash equivalents. At the end total assets are 833325. In
liability side total non-current liabilities are 250800 which includes equity share capital and
retained earnings. Total current liabilities are 582525 which includes provisions for bad debts,
accounts payable and outstanding expenses (Vanderhoof and Altman, 2013).
TASK 2
b) Calculation of various types of cost
a) Calculation of fixed cost
Particulars £
Sales per unit 13
(B) Less: Variable costs
Materials 5.25
Document Page
Labour 2.95
Variable o/h 1.85 10.05
[A-B] Contribution per unit 2.95
Particulars
Sales per unit 13.00
Variable costs 10.05
(A) Contribution per unit 2.95
(B) Fixed Cost
Production 59000
Selling 47600 106600.00
[B/A] Break even in unit terms 36136
Break even in revenue term( Break even units* Sale price per
unit) 469763
b). Calculation of Marginal Safety
Margin of safety
No. of unit produced 70000
(A) Sales per unit 13
(B) Total revenue 910000
( C) Break even sales 469762.71
[B-C] Actual sales – Break even sales 440237.29
Margin of safety [B-C]/(B)*100 48.38%
Margin of safety in unit term [B-C]/(A) 33864
Document Page
c) Calculation of profit
Particulars £
per unit rate Units
Sales per unit 13 48000 624000
Less: Variable costs
Materials 5.25
Labour 2.95
Variable o/h 1.85
10.05 48000 482400
Contribution 141600
Fixed Cost
Production 59000
Selling 47600 106600
Profit for the year 35000
d) Calculations fir selling price
d) Particulars Current Proposal £ Proposed £
per unit
rate units
per unit
rate Units
Sales (increased by 17%) 13 53000 689000 15.21 53000 806130
Less: Variable costs
Materials 5.25 5.25

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Labour 2.95 2.95
Variable o/h 1.85 1.85
10.05 53000 532650 10.05 53000 532650
Contribution 156350 273480
Fixed Cost
Production 59000 59000
Selling 47600 47600
Marketing and advertising 106600 45000 151600
Profit for the year 49750 121880
More profit in new strategy hence new strategy is profitable
e) Identify and explain the underpinning assumptions to break even model
Break even is the no profit and no loss situation for the company. It is important to
analysing the practical applications of cost functions. It focuses on mainly three functions which
are profit, cost and sales volume. It develops the relation between sale and total cost volume of
organisation. Operating conditions can be know through it when a corporation’ break- even’,
that is point when sales reach equal to all expenditures incurred in attaining that sales level.
Assumptions of break even analysis are as follows:
Semi variable cost does not consider by it only fixed and variable costs are analysed.
Revenue and cost functions remain linear.
Product price is supposed to be fixed (TrujilloPonce, 2013).
Volume of production and volume of sales are identical.
Incremental in variable cost is supposed to be fixed.
Fixed expenses remain unchanged over the volume.
Assumes that efficiency of labour and technology are same.
Price of factor remains unchanged.
Fluctuation in input price are lined out.
This model can be successfully utilised by range of differing businesses such as:
hospitality industry, aviation industry, textile industry, mining industry, chemical and energy
Document Page
industry etc. All types of organisations have to know where is the point at which no profit or no
loss situation has arises. After that point a company can earn profits. So that it is successfully
utilised by a range of differing business.
TASK 3
C) Calculation of payback period, accounting rate of return and net present value
a)Calculations of different methods
1 Purchase cost of the new machine 40000000
2 Expected annual cash inflow 17000000
3 Annual cash outflow 6400000
4 Incremental Cash flow 10600000
5 PVAF(7%,5 Year) 4.1002
6 PV of Incremental Cash Flow 43462120
7 Terminal Flow 5000000
8 PVIFA(7%.5th Year) 0.713
9 PV of Terminal Flow 3565000
10 Total Fair Value of Machine(6+9) 47027120
Less:Cost of Machine 40000000
11 Net Present Value 7027120
NPV is positive hence Machine should be Bought
12 Payback Period = Cost of investment 40000000
Net Annual Cash Inflow 10600000
3.77 Year
Document Page
13.IRR Calculation
Year Cash Flow
0 -40000000
1 10600000
2 10600000
3 10600000
4 10600000
5 10600000
IRR 10.18%
b) Key merits and limitations of investment appraisal techniques
Investment appraisal techniques helps to analysed the attractiveness of an investment. It
is an internal. There are various methods of this such as: internal rate of return, accounting rate
of return, net present value, payback period etc.
Internal rate of return: It is a percentage discount rate that is used by an organisation in capital
investment appraisals which brings cost of a project and its future cash inflows into equality. It
describes the rate in which net present value is zero. Formula to calculate IRR as follows:
IRR = A+ {( B-A)* Na/ Na- Nb}
Merits of IRR:
It helps to analyse the time value of money.
Total cash outflow and total cash inflow can be consider.
Limitations of IRR:
It gives the rate of return which is declarative of profitableness of investment.
Complicated calculations and different types of rates is not easily understood.
A project which has greater internal rate of return does not essential to be profitable.
Project life cannot be appropriately analysed (Sun and Rahman, 2012).

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Accounting rate of return: It is also known as return on capital employed which compare the
profits which are expected by organisation from an investment to the money they invest.
Merits:
Calculations are not tough because it makes use of promptly available accounting
information.
In this method all years are not consider to analyse the life of a project.
It helps to take better decisions because investment are ranked according to their returns.
Demerits of accounting rate of return:
Accounting time value of money is not analysed.
It does not properly calculate the rate of return of a project even if cash flows are higher
than the life of project (Schneider and Gaunt, 2012).
ARR is not effective to differentiate the value of investment needed for individual
projects.
Net present value: NPV shows the difference between present value of cash outflow and present
value of cash inflows over a specific period of time. An organisation can consider the
profitability of a project through it.
Merits:
It is depends upon estimation of cash flow so dividends, analyse shareholder's wealth.
Time value of money can be consider through it.
It is more suitable for the selection of mutually exclusive investments or projects.
Limitation net present value:
It is not easy to understand as compare to the ARR method.
When two investments are measured than this method is favourable to that project which
has more NPV.
It does not give satisfactory results because value and life of two projects are different
from each other.
Payback period: This method helps to the organisation to know that in how much time its cost
on investment can be covered. Shorter pay back period is good for the purpose of investment
decision.
Merits:
It is not complicated and easily to understand.
Document Page
Organisation can invest in that projects which have shorter payback period.
This method develops insights in a persons so that it can analysed when its money get to
be repaid (Moulang, 2015).
Limitations of payback period:
It does not consider cash generation beyond the payback period.
This method fails to consider timing of returns and cost of capital.
Profitability index method: It consider the capital expenditure opportunities in the profitability
index. In this method present value of estimated future cash inflows divided by the initial outlay.
It is calculated by the following formula:
Profitability index= Present value of cash inflows/ Present value of cash outflow.
Merits:
It is used by most of organisation so that it can analyse various investment proposals.
With the help of this method an organisation can consider appropriate investment project.
By this method a company can analyse profitability through its investment project.
Limitations profitability index method
It is not easy to determine cost of capital and interest rate in this method.
Due to the differences in estimated working life of project so that comparison can not be
satisfactory.
Terminal value method: In this method estimated cash flow is reinvested in another project at a
predetermined interest rate. Reinvested process is going on until the termination of project.
Merits of this method are as follows:
In this method cash flow has reinvested after once they received.
It is easy to calculate (Mala and Chand, 2012).
Limitations of terminal value method:
It is not satisfactory because after a certain period of time it is difficult to understand the
principal amount of money which is invested by investor.
C) Identifies and explains the key benefits and limitations of using budgets as a tool for strategic
planning
Budget is defined a financial plan which includes volumes and revenues, cost and
expenses, liabilities and cash flows etc. its involves strategic plans and activities which are
consider for measuring. It is a sum of money with is intended for the purpose along with
Document Page
expenditures. The surplus budget is made for providing money which is used for future purpose.
By using, it is exceeded by incomes from deficit. Plans are re-evaluated on periodic basis by a
person, family, group of people, government, country, business and organisation. It’s help in
strategic planning also. There benefits and limitations are consider as below:
Master budget: Master budget is that budget which aggregates of an organisation's individual
budgets and it is prepare so that it can show complete picture of financial activity and position. It
consist of various factors such as: operating expenditure, sales, assets etc. Mostly it is used in big
companies so that all individual managers can aligned and it helps in strategic planning so that
effective results can come up by it (Gippel and Zhu, 2015).
Key benefits:
It is interrelated with the budgets of various departments.
It supports other types of plan of the company.
Limitation master budget:
Due to insufficient information it can influence the other budgets of an organisation.
It is complicated to prepare and understand.
Operational budget: It is that budget which help to analyse the expenses and revenues for day
to day operational activity. Revenue can be generated by maximize the sales and expenditure
refers to the cost of goods sold and other overheads which are associated with the production of
goods. It can be made for monthly or weekly basis. It provides help in operational strategies so
that planning can be done in effective manner and according to its budget can prepare and it can
be use as a planning tool (Faff, 2015).
Key benefits:
It provides helps to manage current expenses in the organisation.
Future expenditures can be consider through it.
It helps the company to earn more revenues from its operational activities.
Limitations of operational budget
It cannot be useful for long term planning because it prepare for weekly or monthly basis.
Due to the unappropriated information and data.
Cash flow budget: Cash flow budget is prepare to analyse the inflows and outflows of cash on
day to day basis. It shows the ability of an organisation that how it can generates more amount of
money and minimize the outflow of fund. It helps the company to control the cash related

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
activities so that it does not need to face the problem of shortage of funds. As a result it can
perform its operational activities effectively. It provides help in strategies related to financial
activities so that money related problems can be minimize or solve (Cotter and Wee, 2012).
Key benefits:
It helps the corporation to avoid or reduce the debt.
Company can become more resourceful.
Potential deficits can be quickly identify.
Financial position can be disclose.
Limitations of Cash flow budget:
It can restrict the spending power.
It relies the meet anticipated future needs.
Financial budget: This budget made by company to control the excess spending of funds in the
organisation. It helps company to generates more amount of money so that it can take easily
investment decisions for future. It manage the expenses on building, equipments, property etc. so
that financial health of corporation can maximize. Financial strategies can be make so that
effective planning can be done.
Key benefits:
Financial awareness can increase.
It provides help to analyse the opportunities in the market so that it can expand its business.
This budget help to disclose assets and liabilities of company so according to it corporation
can take financial planing decision (Bolton, 2014).
Limitations of Financial budget:
Absence of proper data it cannot provide accurate information to the management.
Static budget: This budget includes the elements where expenses remain unchanged in relation
to sales levels. Expenditure of overhead shows one type of this budget, it does not shut-in
traditional overhead cost. Departments of corporation has set a standard and according to it they
have to spend money. It is based on the expected level of output and income at the beginning of
accounting period. It can be used as a strategic tool so that overheads expenses can be control.
Key benefits:
It is easy to implement and follow in the business of company.
Document Page
This method develops insights into a organisation's cost and revenues when a variance
analysis is performed (Birt and Song, 2013).
Limitations of Static budget
It is not flexible because it is based on the certain levels of sales volume and when it
maximize than allocation of resources cannot be done.
It is based on the previous year information so for a new organisation it is difficult to work
according to it.
Sales budgets: It anticipates the earnings from the sales units in the organisation. It is prepared
by sales department so that it can establish objectives of department and predict production
requirements. It can influence master budget as well as operating budget of the organisation. It
can be used as strategic planning tool so that sales can be increase as a result company can earn
more profits.
Key benefits:
It helps to maximize the revenues and sales.
Unnecessary selling expenses can be control (Allen and Faff, 2012).
Limitations of Sales budgets:
It is prepare to meet future expectations which does not predict accurately.
If demand does not analysed properly than it cannot produce satisfactory results.
CONCLUSION
As from the above report, it has been analysed that by applying financial and tools an
organisation can effectively manage its finance and take better decisions. Income statement and
financial position statement can help to a company to know its profit and losses as well as its
wealth. Various types of cost analysis can help to minimize the expenses in production process.
Through investment appraisal techniques organisation can analyse at how time their investments
can give positive returns. Budget can help in strategic planning so that can take important
decision and improves its management.
Document Page

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
REFERENCES
Books and Journals
Allen, D. and Faff, R., 2012. The Global Financial Crisis: some attributes and
responses. Accounting & Finance. 52(1). pp.1-7.
Birt, J., Rankin, M. and Song, C .L., 2013. Derivatives use and financial instrument disclosure in
the extractives industry. Accounting & Finance. 53(1). pp.55-83.
Bolton, B., 2014. Audit committee performance: ownership vs. independence–Did SOX get it
wrong?. Accounting & Finance. 54(1). pp.83-112.
Cotter, J., Tarca, A. and Wee, M., 2012. IFRS adoption and analysts’ earnings forecasts:
Australian evidence. Accounting & Finance. 52(2). pp.395-419.
Faff, R.W., 2015. A simple template for pitching research. Accounting & Finance, 55(2), pp.311-
336.
Gippel, J., Smith, T. and Zhu, Y., 2015. Endogeneity in accounting and finance research: natural
experiments as a stateoftheart solution. Abacus. 51(2). pp.143-168.
Mala, R. and Chand, P., 2012. Effect of the global financial crisis on accounting
convergence. Accounting & Finance. 52(1). pp.21-46.
Moulang, C., 2015. Performance measurement system use in generating psychological
empowerment and individual creativity. Accounting & Finance. 55(2). pp.519-544.
Schneider, P. and Gaunt, C., 2012. Price and earnings momentum in Australian stock
returns. Accounting & Finance. 52(2). pp.495-517.
Sun, Q., Yung, K. and Rahman, H., 2012. Earnings quality and corporate cash
holdings. Accounting & Finance. 52(2). pp.543-571.
TrujilloPonce, A., 2013. What determines the profitability of banks? Evidence from
Spain. Accounting & Finance. 53(2). pp.561-586.
Vanderhoof, I.T. and Altman, E. eds., 2013. The fair value of insurance liabilities (Vol. 1).
Springer Science & Business Media.
Online
Financial statements. 2018. [Online]. Available Through:
< https://www.investopedia.com/terms/f/financial-statements.asp>
Document Page
10
Document Page

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
1 out of 20
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]