Accounting for Business: Income Statement, Financial Position, Ratios, and Investment Analysis
Verified
Added on  2023/06/04
|10
|1738
|251
AI Summary
This article covers accounting for business including income statement, financial position, ratio analysis, and investment analysis. It also includes advising the company on investment, factors to be considered, and IRR advantages.
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.
TABLE OF CONTENTS SECTION A.....................................................................................................................................3 QUESTION 1...................................................................................................................................3 a. Income statement.....................................................................................................................3 b. Statement of financial position...............................................................................................4 SECTION B.....................................................................................................................................5 QUESTION 3...................................................................................................................................5 a. Calculating the different ratios................................................................................................5 b. Commenting on the performance of company........................................................................6 QUESTION 4...................................................................................................................................6 a. Relevant annual profit and cash flow......................................................................................6 b. ARR, NPV and payback period..............................................................................................7 c. Advising company...................................................................................................................8 d. Five other factors to be considered.........................................................................................8 e. IRR and its advantages............................................................................................................9 REFERENCES..............................................................................................................................10
SECTION A QUESTION 1 a. Income statement Particulars Sales1100 Cost of sales Opening inventory100 Purchases650 Closing inventory[90][660] GP440 Expenses Rent,rates& insurance [40–5+1]36 Selling& distributionexpenses [50–4]46 Advertising20 Gas & electricity [25+2]27 Audit fee [10+1]11 Depreciation of Equipment [130–30]x0.220 Depreciation of furniture & fittings [100x0.2]20 Staff Salaries100 Directors’ remuneration34 Bad debt4 Interest on bank loan7 Debenture interest [10+1]11[336] PBT104 Provision for taxation[25] PAT79 Dividends – interim --final[350x£0.08] 20 28[48] Retained profit for the year31 Retained profit b/f70
b. Statement of financial position Non-current assetsCostAccumulated Depreciation NBV Premises600---600 Equipment13030+ 20= 5080 Furniture’s & fittings10060+ 20= 8020 830130700 Current assets Inventory90 Receivables87 Prepayments [5 + 4]9 Bank9 Cash4199 Total assets899 Share capital £1Ordinaryshares350 Reserves Share premium120 Retained profits101 Shareholders’ funds571 Non- current liabilities 7%Longterm bank loan100 11%Debentures100200 Current liabilities Accruals [1+ 2+1]4 Debenture interest1 Payables70 Provision for taxation25 Proposed dividends28128 Shareholders’ funds & liabilities899
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
SECTION B QUESTION 3 a. Calculating the different ratios ParticularsFormula20222021 (in 000s) (in 000s) Profitability ratio analysis 20222021 Gross Profit5045 Net profit1012 Sales revenue120105 GP ratioGross profit / sales * 10042%43% NP ratioNet profit / sales * 1008%11% Liquidity ratio analysis 20222021 Current assets3234 Current liabilities2729 Inventory1410 Current ratioCurrent assets / current liabilities1.191.17 Quick ratio (Current assets- Inventory)/ Current Liabilities0.670.83 Efficiency ratio analysis 20222021 Average Inventory1410 Turnover or sales revenue120105 Receivables or debtors1621 Creditors or payables1213 Cost of good sold7070 Receivables or debtors turnover ratio (in days)(Debtors * 365) / Credit sales4973 Creditors turnover ratio (in days)(Creditors * 365) / COGS6368 Inventory Holding Days RatioSales / Inventory*3654335
b. Commenting on the performance of company With evaluation of the calculator ratios it is clear that has compared to pass theory performance of company has reduced. The profitability ratio of the company has declined from 2021 to the current year that is 2022. The gross profit ratio was 43% where is currently it is 42% and the net profit ratio was 11% earlier and currently 8%. This simply implies that the profitability of the company has reduced even though gross profit has increased from last year. Further with help of the liquidity ratio it is clear that the liquidity position of the company has improved the little bit in case of current ratio. On the other and the quick ratio has decline which is not good for the company. The current ratio is 1.19 times that is there is 1.19 time the current asset for paying of a single current liability. In addition to this the efficiency ratio has improved which is good for the company. Earlier the receivable turnover ratio was 73 days where as in the current year it is 49 days. This simply means that the amount receivable will be received in less time as compared to last year. On the other hand the creditor turnover ratio was 68 earlier and currently it is 63 days. This is also good as company can pay of it that in very less period of time that is 63 days. Along with this inventory holding period has increased which is not good for the company as the company take lot of time in converting the inventory into sales. Over all it can be stated that performance of the company is not as good as it need to be (Zavadskas and et.al., 2018). Thus for this company need to work on improving the sales and for this day can do affected marketing of the product and services. QUESTION 4 a. Relevant annual profit and cash flow Selling price per unit is 30 and variable cost per unit is 20 YearSales (units) Total cash inflow Total VC Total FC Profit/ Net cash flow 1110003300002200007500035000 2130003900002600007500055000 3140004200002800007500065000 4150004500003000007500075000 5100003000002000007500025000
b. ARR, NPV and payback period Net present value Computation of NPV Machine A YearCash inflowsPV factor @ 10 % Discounted cash inflows 1350000.90931818.18 2550000.82645454.55 3650000.75148835.46 4750000.68351226.01 5250000.62115523.03 Total discounted cash inflow192857 Initial investment160000 NPV (Total discounted cash inflows - initial investment)32857 ARR Computation of Average rate of return YearCash inflows 135000 255000 365000 475000 525000 Average profit or cash inflow51000 Average initial investment80000 average initial investment [(initial investment + scrap value) / 2] ARR64% Payback period Computation of Payback period YearCash inflowsCumulative cash inflows
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
13500035000 25500090000 365000155000 475000230000 525000255000 Initial investment160000 Payback period3 0.1 Payback period3 year and 1 month c. Advising company With the help of the above calculation relating to the different capital visiting techniques it is advisable to company that they must invest within the project. This is particularly because of the reasons that the npv that is the net present value of the project is positive with employees that the current value of the future cash and flow is high. Along with this average rate of return which the project will 64% which is very good. In addition to this payback period is 3.1 year which implies that the interested amount will be recovered within the time duration of 3 years and one month. The company expects the payback period to be three years and the investment is near to it only. Hence it is advisable to the company that they must invest within the new machinery as the requirement of companies being met with in the 5 years forecast. d. Five other factors to be considered The five other different factors to be considered by the company before making the final decision as follows- ï‚·The first factor to be considered in mind is the risk be involved within the investment. In case the risk is high then it is not worth investment. ï‚·Along with this another factor involves the liquidity of the project for the investment option. The investment must be liquid so that in case of any emergency it can be converted into cash easily. ï‚·For the more another factor to be considered is the inflation rate. In case the inflation is very high than in that situation it is not advisable to the company that they must invest in that project. ï‚·In addition to this another factor to be considered by company is to analyse the volatility of the market and the fluctuations taking place within the investment market (Al-Mutairi, Naser
and Saeid, 2018). This study is very essential in order to ensure that the interested amount will be yielding a good amount of profit. ï‚·Along with this another factor to be considered while deciding the investment is the budget that is the budget to be used while investment. In case the budget set is high then the investment option need to be good. e. IRR and its advantages The IRR that is the internal rate of return is a capital budgeting tool which assist the company in analysing the net present value of the project will stop this helps the company analysing the backpack how much return the company will be earning with the investment being done (Hazen and Magni, 2021). In case the IRR is higher than it is good for the company and the investment is worth. The benefit of using IRR is follows- ï‚·The first benefit of using this technique is that it under takes the time value of money which provide the exact profitability of the project which is good. ï‚·In addition to this another benefit is that it is easy and simple to use and understand it.
REFERENCES Books and Journals Al-Mutairi, A., Naser, K. and Saeid, M., 2018. Capital budgeting practices by non-financial companieslistedonKuwaitStockExchange(KSE).CogentEconomics& Finance.6(1). p.1468232. Hazen, G. and Magni, C. A., 2021. Average internal rate of return for risky projects.The Engineering Economist.66(2). pp.90-120. Zavadskas, E. K. and et.al., 2018. A novel multicriteria approach–rough step-wise weight assessment ratio analysis method (R-SWARA) and its application in logistics.Studies in Informatics and Control.27(1). pp.97-106.