Accounting and Finance Report: Breakeven Analysis and Appraisal

This report provides a comprehensive overview of accounting and finance principles, focusing on breakeven analysis and investment appraisal techniques. Part A presents an income statement analysis for Dexter Plc. Part B delves into breakeven analysis, calculating contribution per unit, evaluating breakeven points and the margin of safety, and calculating profits under different scenarios. It also identifies and explains the assumptions of the breakeven analysis model and its usefulness. Part C examines capital budgeting, including the computation of cash inflows and outflows, the payback period, net present value (NPV), and average rate of return (ARR). The report analyzes the benefits and limitations of NPV, ARR, and payback period. Additionally, it discusses the advantages and disadvantages of various planning tools. Practical implications and interpretations are included throughout the analysis, providing a well-rounded understanding of financial concepts and their application in business decision-making.

Accounting and finance

INTRODUCTION...........................................................................................................................4
PART A...........................................................................................................................................4
PART B...........................................................................................................................................5
A. Calculation of contribution per unit........................................................................................5
B. Evaluation of breakeven analysis and the margin of safety....................................................6
C. calculation of profits if the company produces and sells more number of units at same
selling price per unit....................................................................................................................6
D Computation of the net profits after increasing the sales units and per unit price...................6
E Identifying and explaining the assumptions of the breakeven analysis model and its
usefulness.....................................................................................................................................7
PART C...........................................................................................................................................8
b. Analyzing the benefits and the limitations of the different capital or investment appraisal
technique....................................................................................................................................10
c. Explaining and evaluating the advantages and disadvantages of various planning tools......12
CONCLUSION..............................................................................................................................15
REFERENCES..............................................................................................................................16

INTRODUCTION
Accounting and finance means the amount of money and the credit invested in the
business. It includes the procurement, allocation and utilization of the funds for smooth
functioning of the operations of the organization. The present report is based on the different
aspects of the accounting concepts and the business finance. The study provides the deep insights
on the breakeven analysis and various investment appraisal techniques with their pros and cons.
Furthermore it describes the benefits and the limitations of different budgets. Several practical
implications are also included in the study.
PART A
Dexter Plc
Income statement for the year ended 31st December
2018
Particulars Amount Net figures
sales revenue 504000+129000 633000

less: cost of sales 243000+54000 297000
gross profit 633000-297000 336000
less: operating expense-
rent 112500
depreciation on motor
van 57600
wages 117000
electricity bill 5700
van running expenses 33600
bad debts 1500 327900
Operating profit before tax 8100
less: tax 4500-2400*3/12 525
Net profit 7575
PART B
A. Calculation of contribution per unit
Particulars
Figures
(in £)
Fixed cost
Production 59,000
Selling etc. 47600
Total fixed cost 106,600
Variable cost per unit
Materials 5.25
Labor 2.95
Variable overheads 1.85
Total variable cost per unit 10.05
Particulars
Figures
(in £)
Selling price per unit 13
Less: Total variable cost per unit 10.05
Contribution (per unit) 2.95

B. Evaluation of breakeven analysis and the margin of safety
Particulars Formulas
Figures
(in £)
Total fixed
cost 106,600
Contribution
(per unit) 2.95
BEP (in
units) Fixed cost / contribution per unit 36136
BEP (in £) BEP (in units) * selling price per unit 469763
Particulars In units
Selling
price
per unit
In
Figure
s (in £)
Actual sales 53000 13 689000
BEP sales 36136 13 469763
Margin of
safety
(actual sales
- BEP sales) 16864 219237
C. calculation of profits if the company produces and sells more number of units at same selling
price per unit
Particulars
Units
of
sales
Selling
price
per
unit
Figure
s (in £)
Sales 48000 13 624000
BEP sales 36136 13 469763
Profit 154237
D Computation of the net profits after increasing the sales units and per unit price
particula
rs units
per
price
Amoun
t

Sales 56160 14.17
795787.
2
variable
cost 56160 10 561600
contribution 4.17
234187.
2
less: revised fixed cost 45000
Profits
189187.
2
Interpretation- From the above analysis it has been analyzed that revised selling price
and the sales unit provides better results of profits after paying off the increased fixed cost
because the margin of the sales increases and the units also rises. Thus, this strategy of Philly
limited is considered as good as it earns higher profits by adopting this strategy.
Working note-
Particulars formula
selling price per
unit(rises by 9%)
old selling price 13
Revised selling
price 13+9% 14.17
Particulars formula
unit sales(raised by
17%)
Old sales (in units) 48000
Revised sales (in
units)
48000+17
% 56160
E Identifying and explaining the assumptions of the breakeven analysis model and its usefulness
Breakeven analysis is the most important model that is applied by every type of organization in
order to determine the practical implications of the cost functions. Majorly it includes three
factors that are sales, profit and the cost (Cools, Stouthuysen and Van den Abbeele, 2017). This
analysis mainly aims at categorising the dynamic relationship that exists in between the total cost
and the sales volume of an entity. It is also known as cost volume profit analysis as it helps in
knowing or determining the operating condition of the company at which the sales reaches the
point equates with that of all the expenses that are incurred in respect of attaining the sales level.
Assumptions of breakeven model-
 All the cost in relation to the production, selling could be segregated into the variable and
the fixed components.

 As per this model, it has been assumed that behaviour of the cost is considered as linear
that means straight line in case the cost data are been plotted on the graph.
 The total of the fixed cost amount will remains same at every level of the output and the
variable cost will be fluctuating in relation to the direct proportion of the output.
 Selling price will also remain constant at every sales level which means selling price will
not be changing with the change in the supply of the product in accordance with the
assumption of this model.
 The price incurred on the input factors like the raw material, rent, wages; advertisement
etc. will also remain at the constant level.
 No changes will be assumed in the technological techniques and the efficiency of the
machine and the human resources.
 The model assumes that comparison between the cost and the revenue on the basis of the
common activity (de Campos and Rodrigues, 2016). For instance- sales value of products
and units produced.
 Sales volume and the output is been assumed as the relevant factor that affects the cost.
Usefulness of this model in varying business-
It is most useful tool for those businesses has been witnessed with several business decisions and
in dealing with the uncertainty. It enables the manufacturing organization in determining its sales
volume and also in forecasting the profits by anticipating the revenues and the cost (Hazır,
2015). This model assists the enterprise in appraising the changing effects on the sales volume
and the production cost. It helps in making the intra firm comparisons in terms of their
profitability.
PART C
Computation of cash inflow
Ye
ar
Cash
inflow
(in £)
Cash
outflo
w(in
£)
Less:
depreciati
on(in £)
Total
cash
outflo
w(in
£)
EBIT
/
EAT(
in £)
Add:
depreciati
on(in £)
Cash
inflow
(in £)
Add:
Scrap
value(
in £)
Net
cash
inflow
(in £)
1
17,000
,000
6,400,
000 7000000
13,400
,000
3,600,
000 7000000
10,600
,000
10,600
,000
2
17,000
,000
6,400,
000 7000000
13,400
,000
3,600,
000 7000000
10,600
,000
10,600
,000
3 17,000 6,400, 7000000 13,400 3,600, 7000000 10,600 10,600

,000 000 ,000 000 ,000 ,000
4
17,000
,000
6,400,
000 7000000
13,400
,000
3,600,
000 7000000
10,600
,000
10,600
,000
5
17,000
,000
6,400,
000 7000000
13,400
,000
3,600,
000 7000000
10,600
,000
5,000,
000
15,600
,000
Payback period
Year
Net cash
inflow(in
£)
Cumulativ
e cash
inflow(in
£)
1 10600000 10600000
2 10600000 21200000
3 10600000 31800000
4 10600000 42400000
5 15600000 58000000
Paybac
k period
3
0.8
(40,000,000
–
31800000) /
10600000 =
3.8 years
Calculation of depreciation
Particulars Figures (in £)
Initial investment 40,000,000
Scrap value 5,000,000
Years 5
Calculation of net present value
Year
Net cash
inflow(in £)
PV factor @
7%
Discounted cash
inflow (in £)
1 10600000 0.935 9906542.06
2 10600000 0.873 9258450.52

3 10600000 0.816 8652757.50
4 10600000 0.763 8086689.25
5 15600000 0.713 11122584.40
Total discounted cash inflow 47027023.72
Less: initial investment 40,000,000
NPV 7027024
Average rate of return
Year
Earnings
after tax
1 3,600,000
2 3,600,000
3 3,600,000
4 3,600,000
5 3,600,000
Average EAT 18,000,000
Average investment
(40,000,000 +
5,000,000) / 2
= 22500000
ARR
18,000,000 /
22500000 *
100 = 80%
b. Analyzing the benefits and the limitations of the different capital or investment appraisal
technique.
Net present value- It is value that is present in between present value of the cash inflows
and outflows for a specific period. This tool is used by the organization for investment planning
and in order to analyze profitability for a specific investment or the project (Maher, Fakhar and
Karimi, 2018). The positive resultant net present value reflects that project will be generating
higher profits while negative net present value states that the proposal will provide for a net loss.
Benefits Limitations
 Net present value method considers the
time value concept which states that
 It involves complex calculations as an
entity by using this method has to

value of the money changes with the
passage of time specifically at inflation
and deflation time. This helps the firm
knowing the value of its investment on
the day it pays out and the day on
which it receives the return.
 This capital budgeting technique
contains the ranking capability. It has
the ability for comparing the projects so
that best project could be chosen
(Mathur, 2019). The proposal that
results highest value is been viewed as
highest yield will be ascertain to the
enterprise.
evaluate each and every cash
transaction which is associated with
project. Numeric tables and formula is
to be used for calculating the NPV of
each project so this involves huge time
and complex computations.
 Net present value method is based on
the assumption regarding amount of
dollar and the timing of the probable or
future cash related transactions attached
with project (O’Grady, Akroyd and
Scott, 2017). The enterprise also
anticipates its interest rate in relation to
duration of project. Inaccurate
estimations results in inaccurate
evaluation of NPV for a particular
project which in turn leads to loss for
the company.
Accounting rate of return- It is the appraisal technique that measures annual earnings
and the profits which is been expected to achieve from an investment made. It is also called as
average rate of the return. It helps the investors in analyzing the risk associated with the
investment made and helps in determining that earnings are greater over the acceptance of the
level of risk (Pellerin and Perrier, 2018). It computes the rate of return gained by the investor on
its investments.
Benefits Limitations
 This method is simple and easy to
understand as it considers savings or
the total of profits over entire period for
the economic life of project.
 Accounting rate of return method helps
 Different results are been evaluated in
respect of the return by applying the
return on investment method and the
ARR. This creates a problem for the
company in making the decision and

in recognizing concept of the net
earnings which is considered as the
vital aspect of the investment proposal.
 It facilitates comparison between the
new product proposal and the cost
reducing proposal or the other
competitive nature projects.
 This method provides the clear picture
relating to the profitability that will be
attaining from the project.
 For measuring the current performance,
this method is counted to be most
suitable.
develops ambiguity with respect to the
project yield.
 Time factor is ignored by this method
as it selects the alternative uses of the
funds which are considered as the
primary weakness of this method.
 Average rate of return method does not
take into account the external factors
which has the direct impact on the
profitability of project.
Payback period- It refers to the appraisal tool that states the amount of the time taken for
recovering the cost from an investment. In other words it is the time length where the investment
reaches the breakeven point. Desirability of the investment is directly related to the payback
period (Nemec and de Vries, 2019). The shorter the payback period, reflect the more investment
as more attractive. This method is used by the company in order to assess the cost of saving with
the application of the energy efficient technology.
Benefits Limitations
 Payback period method is the simplest
method as it requires few inputs and is
very easy in calculating in comparison
to other appraisal methods. This
enables the managers in making quick
decisions.
 It is most useful method in the case of
the uncertainty as the projects with the
shorter payback period assist in
reducing the possibility of the loss due
to the obsolescence.
 Payback period provides the useful
information relating to the liquidity of
the company which is crucial for the
company having limited resources. It
provides lower risk which in turn leads
 This method of capital budgeting
ignores the time value factor which is
very crucial concept of the business.
This results in distortion of the correct
value of cash flows.
 This method fails in considering all the
cash flows and only takes into account
the time in which the initial investment
is been recovered.
 Payback period does not consider the
normal scenarios that every business
faces (Nguyen, Weigel and Hiebl,
2018). This leads to an unrealistic
method as it requires further investment
in coming years and have irregular
inflow of cash.

to recovery of the cost for reinvesting
into the other profitable opportunities.
 It ignores the evaluation of the
profitability as it does not guarantee
that shorter payback period of the
project will result in earnings.
c. Explaining and evaluating the advantages and disadvantages of various planning tools.
Zero based budget- It is the technique of budgeting where all the expenses are justified
for every new period. It begins with the Zero Base and each function is identified for its cost and
the needs. This budget enables the organization in preparing the budget keeping in mind the
future perspectives and the coming period instead of comparing it with previous one.
Advantages Disadvantages
 This budgeting technique is useful
when the firm needs to evaluate its
activities from the scratch (Talib and
Ismail, 2017). Zero based budgets
facilitate efficient resource allocation in
each department as it does not consider
historical numbers but include the
actual numbers.
 It helps the firm in identifying the
opportunities and applying the effective
techniques of doing the things by
removing the redundant activities from
the business.
 As each and every item line is justified
under this budget so it enables the
Enterprise in overcoming the
weaknesses present in the incremental
budgeting of the budget inflation.
 It improves the coordination and the
communication within each department
and appraises the employees by
participating them in the decision-
making.
 Preparing an entire budget from the
zero based requires the high manpower
and it is resulted as the time intensive
technique as compared to the
incremental budgeting.
 Explaining or understanding each line
item and each cost is a complex task
which requires expertise and training to
the managers.