Accounting Exam: Income Statement, Financial Position, Payback Period, Break-Even Analysis
Verified
Added on 2023/06/18
|12
|1842
|108
AI Summary
This exam covers topics such as income statement, financial position, payback period, and break-even analysis. It includes calculations and analysis of profitability and financial viability of proposals.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Accounting for Business
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
SECTION A Question 1 Income Statement Sales20000 Less: Cost of good sold Opening stock2000 Purchase15200 Closing stock(2500)(14700) Gross profit5300 Less: Selling expense700 Administrative cost300 (400 – 100) Distribution expense200 Audit fees70 Salaries and wages930 (900 + 30) Director remuneration300 Interest paid80 (60 + 20) Interim dividend paid50 Machinery depreciation500 (2500 * 20%) Depreciation on building120 (2400 * 5%)(3250) Less:2050 Tax liability(200) Net profit1850 Statement of financial position AssetAmount Current asset Closing stock2500
Debtors1370 (1400 – 30) Cash50 Bank130 Advancedadministrative expense 1004150 Long term asset Freehold premises6000 Building2400 Machinery300011400 15550 LiabilityAmount Current liability Creditors1000 Accrue salary30 Debenture interest accrue20 Provision for tax liability2001250 Long term liability Accumulated depreciation on building 520 Accumulated depreciation on machinery 1000 5% Debenture16003120 £1 Ordinary shares8000 Retained profit1390 Current year profit185011240 15610 Income statement is the financial statement which shows the total income and expenses of the organization for a given financial year. This statement shows that the company is generating net profit of 1850. With the help of this statement the financial health of the
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
organization is understood which in this income statement shows that the business is generating profit which is very low in comparison to its revenue generated. In a income statement the different expenses and income of the organization is calculated and noted for being analysed as in the preparation of the future budget (Li and et.al., 2018). The revenue is the sales which is shown in the income statement. There are two types of expenses in the income statement, direct andindirectexpenses.Thisstatementcalculatedboththegrossandnetprofitforthe organization. The statement of financial position also known as the balance sheet is the report which shows the company’s assets, liabilities and shareholder’s equity. Balance sheet preparation is one of the three most core financial statements which are used for the evaluation of the business. It helps in the analysation financial position of the company which shows. The three components of the balance sheet which shows the financial position are the assets, liabilities and equity. The assets of the organization are equal to the liabilities of the organization when this financial position report is finalized. SECTON B Question 3 Payback period YearCash inflowsCumulative cash inflows 1600000600000 27000001300000 38000002100000 45000002600000 52000002800000 63000003100000 Initial investment2000000 Payback period0.9 Payback period2 year and 9 months Net present value Computation of NPV
YearCash inflowsPV factor @ 10 % Discounted cash inflows 16000000.909545454.5455 27000000.826578512.3967 38000000.751601051.8407 45000000.683341506.7277 52000000.621124184.2646 63000000.564169342.179 Total discounted cash inflow2360052 Initial investment2000000 NPV (Total discounted cash inflows - initial investment)360052 Advising on financial viability of project Five non- financial factors to be considered by J Ltd Commenting on internal rate of return and its benefits in capital budgeting decision IRR= 17% The payback period helps in the calculation of the time take by the organization to recover the investment amount through the cash inflow. For the given scenario the payback period is 2 years and 9 months. This shows that this business will take this much amount of time for recovering its total investment. The NPV of this organization is one of the capital budgeting tools which helps the business in the analysation of the profitability for a projected year of investment. This method considers the time money value thus, calculates the present value of the cash flow over the time period (Patil and Mohanthy, 2017). For this organization the calculated net present value is 360052. Some non-financial factors which J Ltd needs to consider are, Making sure that the business legislation requirements are met by the operations. Establishing the standards of the goods and other business practices. Motivation of the employees and other HR practices such as recruiting and retaining employees. Development of relationships with suppliers and customers.
The internal rate of return is a financial analysis which helps in the estimation of the profitability of the organization which is the potential investments of the organization. The IRR is a discount rate which makes the net present value of all the cash flows which for this organization is 17% in the discounted cash flow analysis. Question 4 a) Calculating Profit ParticularsAmount (£) 1. Total sales100000 units @ 160 = 16000000 2. Total cost a) fixed cost3500000 b) variables cost145000 * 100 = 14500000 Total profitTotal sales – total cost =16000000 – 18000000 =2000000 (loss) In the above statement the calculation of profit/loss has been shown with the help of deducting the total sales with the total cost which consists of variable and fixed cost. For the given statement the organization is suffering loss of 2000000 as its total cost is higher than the sales. b) Calculating break-even point for original budget ParticularsFormulaFigures Selling price per unit160 Variable cost per unit100 Contribution per unitSelling price per unit - variable cost per unit 60 Fixed cost3500000 BEP (in units)Fixed cost / contribution per unit58333 BEP (in value or monetary terms)BEP (in units) * selling price per9333333.3
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
unit Break-even point is the situation in which the company suffers no profit or loss, at this number of units the total revenue of the business is equal to the total costs (Lessambo, 2018). In the given statement the break-even point is calculated at 9333333.3, where as the unit of break even point is 58333. c) Calculating break-even for Proposal 1 Selling price = 160 + (160*10%) =£176 Variable cost =£104 Sales = 130000 units ParticularsAmount (£) 1. Total sales130000 units @ 176 = 22880000 2. Total cost a) fixed cost3500000 b) variables cost145000 * 103 = 14935000 Total profitTotal sales – total cost =22880000 – 18435000 =4445000 Break-even analysis ParticularsFormulaFigures Selling price per unit176 Variable cost per unit103 Contribution per unit Selling price per unit - variable cost per unit73 Fixed cost3500000 BEP (in units)Fixed cost / contribution per unit47945
BEP (in value or monetary terms) BEP (in units) * selling price per unit8438356.2 Calculating break-even for Proposal 2 Selling price =£155 Variable cost =£100 Sales = 140000 units Profit calculation ParticularsAmount (£) 1. Total sales140000 units @ 155 = 21700000 2. Total cost a) fixed cost3500000 b) variables cost145000 * 100 = 14500000 Total profitTotal sales – total cost =21700000 – 18000000 =3700000 Break even analysis ParticularsFormulaFigures Selling price per unit155 Variable cost per unit100 Contribution per unitSelling price per unit - variable cost per unit 55 Fixed cost3500000 BEP (in units)Fixed cost / contribution per unit63636 BEP (in value or monetary terms)BEP (in units) * selling price per9863636.4
unit Calculating break-even for Proposal 3 Selling price = 180 Fixed cost = 3500000 + 250000 = 3750000 Total sales (units) = 115000 Profit calculation: ParticularsAmount (£) 1. Total sales115000 units @ 180 = 20700000 2. Total cost a) fixed cost3750000 b) variables cost145000 * 100 = 14500000 Total profitTotal sales – total cost =20700000– 18250000 =2450000 Break even analysis ParticularsFormulaFigures Selling price per unit180 Variable cost per unit100 Contribution per unitSelling price per unit - variable cost per unit 80 Fixed cost3750000 BEP (in units)Fixed cost / contribution per unit46875 BEP (in value or monetary terms)BEP (in units) * selling price per8437500
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
unit For the given statement the with the help of the marginal costing method firstly the profit of the proposal has been calculated at 4445000. This is done by deducting the total cost with the total revenue (Krishna, Pandey and Thimmalapura, 2017). Thereafter, the break-even analysis is calculated for the same proposal in which the fixed cost is divided with the contribution per unit for the calculation of the Break-even unit of 47945 which is valued at 8438356.2. In the above statement the calculation of the profit of the proposal 2 has been with the help of deducting the cost from the total revenue which is generated by the organization. This shows that the proposal 1 was much more profitable for the organization. The break-even analysis of the proposal shows the break-even unit in proposal 2 which is 63636 is higher than that of proposal 1 thus, it shows lack of efficiency of the business. In the above statement the profit of the organization has been calculated for the proposal 3. This shows that the organization is able to generate the most profit in the proposal 1 and the it has the lowest break even point in the proposal 1 which makes the proposal 1 the most financially viable option for the organization.
REFERENCES Books and Journals Krishna, K.M., Pandey, N.K. and Thimmalapura, S., 2017, December. Break-even analysis and economic viability of powertrain electrification—An analytical approach. In 2017 IEEE Transportation Electrification Conference (ITEC-India) (pp. 1-6). IEEE. Lessambo, F.I., 2018. Forecasting Financial Statements’ Analysis. In Financial Statements (pp. 251-258). Palgrave Macmillan, Cham. Li, J., and et.al., 2018. Financial statements based bank risk aggregation. Review of Quantitative Finance and Accounting, 50(3), pp.673-694. Patil, D. and Mohanthy, J.N., 2017. Analysis of Financial Statements in the Sugar Industry. Available at SSRN 2962855.