Break Even Analysis and Its Applications

Verified

Added on  2021/02/21

|17
|5128
|72
AI Summary
The assignment is to analyze and write a report on the use of break-even analysis, accounting rate of return (ARR), and net present value (NPV) approaches in project viability assessment. The report should discuss the perspectives on strategic investment decision-making, and provide information to help companies make decisions about projects. It involves researching books and journals related to the topic, as well as online sources. Specific details to be included are: assumptions of break-even point, advantages and disadvantages of ARR method, and advantages and disadvantages of NPV.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
INTRODUCTION TO
ACCOUNTING AND
FINANCE

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
PART A -Yarnshaw Limited...........................................................................................................1
PART B – Reckturk Plc...................................................................................................................5
PART C............................................................................................................................................9
A. Calculation of investment appraisal techniques......................................................................9
B. Merits and demerits of different investment appraisal techniques........................................11
C. Explain the benefits and limitation of Budget.......................................................................12
CONCLUSION..............................................................................................................................13
REFERENCES..............................................................................................................................14
Document Page
INTRODUCTION
The report will provide for understanding of financial statements and how they are
prepared also about the fundamental concepts, models and techniques of financial accounting . It
will also cover illustration that will help to understand the model, techniques and concepts that
are used in management accounting. The report will provide understanding about the
importance of different techniques that help to check the viability of project.
PART A -Yarnshaw Limited
I) Income Statement
Income Statement
For the year ended
31 December 2018
Particulars £ £
Revenues:-
Sales(604800+154800) 759600
Other income 0
Total Revenues 759600
Expenses:-
Cost of goods sold or cost of sales 29160
0
64800 356400
Depreciation 11000
Wages paid 14040
0
Add Outstanding wages at the end of the year 2610 143010
Electricity Expenses 9270
Van running expenses 40320
Bad debts 1800
Rent paid 13500
0
Less:- prepaid rent at the end of the year 27000 108000
Total Expenses:- 669800
Net profit before tax 89800
1
Document Page
Less:- Tax paid 6930
Net profit after tax 82870
Working Notes
1 Total Sales
credit sales 604800
cash sales 154800
759600
2 Depreciation
Purchase Price of Van 72000
scarp value 6000
life in years 6
Depreciation 11000
3 Tax Computation
Tax upto 31 march 2018 2880
Add:- Tax from 1 april 2018 to 31 march 2019 5400
Less:- prepaid tax of 3 months
(from 1january 2019 to 31 march 2019) 1350
6930
4 Electricity Expenses:-
Expenses paid 6840
Add:- Outstanding expenses at the end of the year 2430
9270
II) Balance Sheet
Balance
Sheet
For the year
ended 31
December
2018
2

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Shareholder's Equity Fixed Assets
Equity share capital 216000 Delivery Van 61000
Reserves and surplus 82870
Long Term Liabilities
Current Liabilities Current Assets
Outstanding Wages 2610 Prepaid Rent 27000
Outstanding Electricity Expenses 2430 Closing Inventory 273600
Trade Payables 111600 Trade Receivables 77400
Bank Overdraft 132840 Prepaid Tax 1350
Cash 108000
Total Liabilities 548350 Total Assets 548350
3
Document Page
Add:- Cost of cash sales
Total Cost of sales
Credit Purchases
Cash Purchases
Total Purchases
Total Purchases
Less:- Total Cost of sales
Closing Inventory
10 Closing Bank balance
Issue of Equity
Reciepts from Trade Recievables
Total Reciepts
Less:- Rent paid
Tax paid(2880+5400)
Delivery van purchased
Wages paid
Electricity Expenses
Payment to Trade Payables
Van running expenses paid
Total Payments
Bank balance(cr.)
11 Cash Balance
Cash Sales
Less:- Cash Purchases
Cash at 31 December 2018
12 Closing Balance of Delivery Van
Delivery van purchased
Less:- Depreciation
PART B – Reckturk Plc
Given that
Particulars Figures (in £)
Selling price per unit 40
4
Document Page
Material 15.75
Labor 8.85
Variable overheads 5.55
Fixed cost
Production 177000
Selling etc 142800
a). Contribution towards covering fixed costs
Particulars Formula Figures (in £)
Selling price per unit 40
Total variable cost (per
unit)
(= Labor + variable o/h+
fixed cost) 30.15
Contribution per unit
(=selling price -variable
cost) 9.85
Interpretation
Contribution that wardrobe makes to cover fixed costs is 9.85 if sold at 40. Contribution
is calculated by subtracting all the variable production cost from the selling price. Variable cost
are labour, material, variable production overheads that are incurred for producing the product.
The contribution means the amount which is left with company for meeting further operational
expenses of company. Contribution should be high so that company is available with sufficient
profits .
b.Break even point and margin of safety
Break even is the level of production where total revenues are equal to total expenses
(Dupare, Sharma and Billore, 2019). In brief at break even point company produces revenues of
same amount as that of expenses either in production or in accounting periods (Break Even
Point, 2019).
Margin of safety is refers to the sales amount of company over its break even point.
Safety margin is sales amount that company could lose before it stops to make profits or lose
money (Chapman, Ferrisand Zachary, 2018). It is used by managers for analyzing the process
of production and the market demand for estimating the amount of units that would be sold by
them .
5

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Particulars Formula Figures (in £)
Total fixed cost
Production + selling
fixed cost
(177000+142800) 319800
Contribution per unit 9.85
BEP (in units)
BEP=Total Fixed Cost/
Contr. Per unit 32467
BEP (in £)
BEP in value = BEP
units*selling price 1298680
Actual sales (78000*40) 3120000
Margin of Safety
(actual sales - BEP
sales ) 1821320
Interpretation
In the above question break even pointy of company is calculated by dividing total fixed
divided by contribution per unit that comes to 32467 units and when calculated in value it is
coming at 1298680. The company's total sales is 78000 units so at breakeven point of 32467
units company will be able to cover its cost specifically its fixed costs. At this company is at no
loss no profit. Company is having high break even point as its fixed cost are high. The company
can reduce its break even point by controlling its fixed cost.
Margin of safety of company comes at 1821320 and it is calculated by subtracting BEP
point from actual sales of company. Safety margin of company is 45533 units. Safety margin of
company is high that means company has to enhance its production process so that it can reduce
the safety margin of company.
c.Profit of company at 54000 units at 40
Particulars Formula Figures (in £)
Sales (54000*40) 2160000
6
Document Page
Material (54000*15.75) 850500
Labor (54000*8.85) 477900
Variable
overheads (54000*5.55) 299700
Contributio
n 531900
Fixed cost
Production 177000
Selling etc 142800
Profit 212100
Interpretation
If the company is producing 54000 units of wardrobe it will be able to produce profits of
212100. The variable cost of the company will remain same for producing 54000 units as
variable remains constant and do not change with change in increase or decrease of production
units where fixed cost remains constant in total but changes per unit.
d).
7
Document Page
Particulars £
Sales(62100units@43.20) 26827
20
Les
s:- Variable cost(62100 units@32.562) 20221
00
Contribution 66061
9.8
Les
s:- Total Fixed Cost 31980
0
Marketing and advertising expenses 13500
0
Profit 20581
9.8
Round off 20582
0
e). Assumptions attached to break even model and analysis for successful implementation
Break even is used for investigating interrelations between sales revenue, profits and costs as
they are related with alternate output levels (Chibuzor, 2018). Initial objective of profit
maximizing company is covering cost that have been incurred for producing the products and of
reaching the break even point and to make profits thereafter. It is output level where total
revenue is equal to total cost of the production.
Assumptions of Break even model (Assumptions of Break Even Point, 2019).
Each and every cost could be categorized in variable and fixed cost.
Change in level of output will not change total fixed that means it remains constant.
Variable cost in total change with the change in output level but remains constant per
unit.
Selling price at every level of output remains constant.
In a relevant range linear behavior is seen between cost and revenue.
The analysis is related to production of 1 unit or constant product mix.
Production method, technology and efficiency level remains unchanged.
Inventory levels of company are assumed to remain constant for the year.
8

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
The model can be used by manufacturing companies for calculating per unit costs, break
even points and for analyzing whether company is able to produce required number of units for
covering its costs (Dillon and Casey, 2016). The model can be used different business that are
involved in production of goods where the method is not successful for service industry. In
service industry it is critical for company to come at break even point as it is difficult for those
company to bifurcate variable and fixed costs (Massol, Tchung-Ming and Banal-Estanol, 2018).
PART C
A. Calculation of investment appraisal techniques
Depreciation on the machine is calculated to identify the real value of asset. There are
various method for calculating depreciation such as straight line method, written down value,
sum of the year digit method etc. The SLM method can be calculated by subtracting the salvage
value from the asset value and divided by life of the asset.
Table 1: Depreciation calculation
Calculation for depreciation
Cost of machine 8000000
Salvage value 1000000
Life if asset 5
Depreciation 1400000
Depreciation formula =
Initial Investment – Salvage value / life of the asset
Cash flow statement: It is prepared to represent the total cash inflow and cash outflow of the
company. It helps to ascertain the position of the company in the market and calculate the
availability of the cash to meet day to day requirement (Rucker, Galinsky and Magee, 2018).
Salvage value is added back to the cash inflow in the last year of the life of the assets.
Table 2: Cash flow statement of last five-year of Roseville Plc.
Calculation for actual cash flow
1 year 2 year 3 year 4 year 5 year
Cash inflow 3400000 3400000 3400000 3400000 3400000
Add: Salvage value 0 0 0 0 1000000
Total cash inflow 3400000 3400000 3400000 3400000 4400000
Less: Cash outflow 1280000 1280000 1280000 1280000 1280000
Net cash flow 2120000 2120000 2120000 2120000 3120000
9
Document Page
Less: Depreciation 1400000 1400000 1400000 1400000 1400000
Actual cash flow 720000 720000 720000 720000 1720000
Add: Depreciation 1400000 1400000 1400000 1400000 1400000
Cash flow 2120000 2120000 2120000 2120000 3120000
Net present value
Table 3: Presentation of NPV
Computation of net present value
year Cash flow PV factor @ 9%
Discounted cash
inflows
1 2120000 0.9174311927 1944954.12844037
2 2120000 0.8416799933 1784361.58572511
3 2120000 0.7721834801 1637028.97772946
4 2120000 0.7084252111 1501861.44745822
5 3120000 0.6499313863 2027785.92525084
Total discounted cash
flow 8895992.06
Initial investment 8000000
Net present Value 895992.06
Interpretation: It can be interpreted from the above table that the NPV value of the
investment is positive which indicate that the investor has to invest in the asset. The investment
in the asset help them to gain higher profit.
Average rate of return
Table 4: Presentation of ARR method
Computation of average rate of return
Year Cash flow
1 2120000
2 2120000
3 2120000
4 2120000
5 3120000
Average cash flow 2320000
Average initial investment[initial investment
+ scrap value/2] 4500000
ARR 51.56
10
Document Page
Interpretation: As per the above calculation it can be interpreted that the ARR of the
investment is 51.56 which indicate that investment in the asset provide higher return.
Payback period
Table 5: Presentation of Payback period
Computation of Payback period
Year Cash inflows Cumulative cash inflows
1 2120000 2120000
2 2120000 4240000
3 2120000 6360000
4 2120000 8480000
5 3120000 11600000
Initial investment 8000000
Payback period 1.45
Interpretation: It can be interpreted that the payback period of asset is 1.45 which
indicate that Roseville Plc company cover the initial investment in 1.45 year.
Recommendation: It would be recommended to the Roseville Plc that they have to
invest in the asset. As per the investment appraisal techniques the NPV of the investment is
positive and ARR also higher which indicate that taking decision of purchasing asset for the
company would be beneficiary. The payback period of asset is 1.45 which also indicate that
Roseville Plc can easily cover the initial investment within the two year. It should be
recommended that they have to purchase the machinery for the future benefits and earning.
B. Merits and demerits of different investment appraisal techniques
Investment appraisal: The aim of investment appraisal is to identify that whether the
project is beneficial for the company or not. In other words it helps to understand that project is
feasible and earn profit in future operations or not (Harris, 2017). Different techniques are used
for investment appraisal such as net present value, accounting rate of return, internal rate of
return and payback period.
Accounting rate of return: It refers to the earning earned by the asset in its entire life. In
other words it presents the return rate of the project and machinery. The higher ARR refers to
higher earning and lower ARR refers to lower earning.
Merits
ARR method of investment appraisal helps to compare the efficiency of the new project
to the current or existing project.
It is easy to calculate and interpret that whether the project is beneficial for company or
11

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
not (Accounting Rate of Return (ARR) Method | Advantages | Disadvantages, 2019).
It helps to estimate the net earning of the project after adjusting the tax and depreciation.
Demerits
The calculation of ARR method does not involve the time value of money factor.
It is based on accounting profit and ignore the cash flow from the investment in project.
Net present value: It presents the variation between the present value of cash outflow
and present value of cash inflow. NPV method is mainly used in capital budgeting and
investment appraisal or planning (Alkaraan, 2015 ). It helps the company to determine the
profitability of the project and also helps to take the decision of investment.
Merits
NPV method consider the time value of money which helps to present the accurate
position of the project.
It helps the company to take the decision of investment by comparing the different
projects (Advantages and Disadvantages of NPV, 2019).
Demerits
It only helps to compare the project which are of same size but it ignores the project of
different size or investment.
It is calculated on the basis of cash outflow and inflow but NPV method ignores the other
hidden cost such as preliminary cost, sunk cost etc.
Internal rate of return: IRR method is used in capital budgeting and investment
appraisal of the project and helps to determine the efficiency of the project or machine.
Merits
IRR method consider the time value of money in the calculation and help to ascertain the
profitability of project.
It does not require to calculate the cost of capital (Johnson and et.al., 2019).
The higher IRR rate present the higher profitability to the shareholder and investors of the
project.
Demerits
IRR method is based on certain unrealistic assumption so it does not evaluate the accurate
position of the project.
It does not help to compare two mutually exclusive project and take the decision of
investment.
Payback period: It refers to the time period require by the company to cover the initial
investment in the machinery or project and estimate that whether the project is profitable or not.
Usually payback period is expressed in terms of year.
Merits
It is simple to calculate and interpret the investment appraisal.
Payback period helps to estimate the time required for covering the initial investment
(Bader, Al-Nawaiseh and Nawaiseh, 2018).
It helps to estimate the risk of the project i.e. if the PBP is shorter that means it includes
less risk and vice versa.
Demerits
The calculation of payback period does not consider the time value of money that's why
it's not appropriate to take the decision of investment in project or machine.
It does not include the cash flow which are received after the payback period.
It ignores the profitability of the project because some projects earn profit in initial year
12
Document Page
while some earn the profit in later year of payback period.
C. Explain the benefits and limitation of Budget
Strategic planning refers to the guideline which are used by the company to accomplish
the mission and vision of organization. While budget work as a support system by providing
money to accomplish the goal. Budgetary is an important part of strategic planning process. It
helps the company to prepare plan for acquisition and usage of resources and money. Budget
work as a benchmark in strategic planning process and help the company evaluate the
performance by comparing it to the benchmark.
Benefits of budget using as strategic planning tool
1. Performance standard: Budget helps to provide standard for comparing the
performance of the company of the various period and activities. The actual performance
of the company can be compared by the standard and identify the variances in the
performance (Driessen, 2017). It helps the strategic planning process to review the whole
performance.
2. Facilitate planning: The preparation of budget helps the company to assign the cost and
time for different activities and prepare the plan on the basis of assign cost and time.
Budget is the basis for the activities to analyse the changes in the process for the future
growth.
3. Coordinate the activities: Budget helps the organization to coordinate the activities such
as sales budget is coordinate with purchase budget and further it coordinated with master
budget. It helps the strategic planning process to monitor the activities on the basis of the
different budget and identify the problems in coordination.
4. Delegate authority: Budget helps to delegate the authority and specify the fund that who
invest them, monitor them and record them. It helps the strategic planning process to
monitor the activities that whether they run their business in desire direction or not.
Limitation of budget using as strategic planning tool
1. Based on past result: The budget is based on the past data and information so it did not
provide the accurate information for strategic planning (Crystal, 2016). Also, it is based
on future prediction so if the future prediction so if the future event does not happen as
predicted as they have to reallocate the budget which require additional time and cost.
2. Inflexibility:Budget of the company is setted for different activities and time period. The
investment in different activity require additional fund which affect the whole process of
strategic planning. It also diverts the attention of manager from the goal of the company.
So change budget seems to inflexible in some point of time.
CONCLUSION
Carrying out the above study conclusion can be made that financial accounting and
management accounting are very important for the businesses. Income statement and statement
of position are prepared under financial accounting that enables the outsiders and the company to
analyse its position and profits. Where as management accounting help the company to
determine the cost ate which it will be able to generate profits. Company is able to get per unit
cost of production. They can know their break even point so that they can know at how much
13
Document Page
units it has to produce for covering its cost. Company can use methods like pay back period,
accounting rate of return and NPV approach for knowing the viability of project . This gives the
company information to make decision about the project.
14

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
Alkaraan, F., 2015. Strategic investment decision-making perspectives. In Advances in mergers
and acquisitions (pp. 53-66). Emerald Group Publishing Limited.
Bader, A., Al-Nawaiseh, H. N. and Nawaiseh, M. E., 2018. Capital Investment Appraisal
Practices of Jordan Industrial Companies: A Survey of Current Usage. International
Research Journal of Applied Finance, 9(4). pp.146-161.
Chapman, L.W., Ferris, K. and Zachary, C., 2018. Utilizing break‐even analysis in a competitive
laser market. Lasers in surgery and medicine. 50(1). pp.10-11.
Chibuzor, O.A., 2018. Application of Break-Even Analysis In Industrial Development through
Flexible Manufacturing Systems (FMS). In Proceedings of the World Congress on
Engineering (Vol. 2).
Crystal, S., 2016. Late-life inequality in the second gilded age: Policy choices in a new
context. Public Policy & Aging Report, 26(2). pp.42-47.
Dillon, C.R. and Casey, J.E., 2016. Elasticity of breakeven prices between agricultural
enterprises. Texas Journal of Agriculture and Natural Resources. 4. pp.33-36.
Driessen, G., 2017. The Validity of Educational Disadvantage Policy Indicators. Educational
Policy Analysis and Strategic Research, 12(2). pp.93-110.
Dupare, B.U., Sharma, P. and Billore, S.D., 2019. Break even Soybean Yield Analysis under
Frontline Demonstrations. Indian Journal of Extension Education. 55(1). pp.103-108.
Harris, E., 2017. Strategic project risk appraisal and management. Routledge.
15
1 out of 17
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]