Managing Financial Resources and Development Editing - Assignment Example

Task 1 a) Cash Budget For June-2009 through Sept-2009 June July August September Total Beginning Cash Balance £ 118,000.00 £ 137,000.00 £ 214,000.00 £ 196,000.00 £ 665,000.00 Cash from Sales £ 150,000.00 £ 156,000.00 £ 135,000.00 £ 190,000.00 £ 631,000.00 Total Available Cash £ 268,000.00 £ 293,000.00 £ 349,000.00 £ 386,000.00 £ 1,296,000.00 Less Purchases £ 55,000.00 £ 46,000.00 £ 86,000.00 £ 74,000.00 £ 261,000.00 Credit Purchase £ - £ - £ 28,000.00 £ 36,000.00 £ 64,000.00 Rent £ 45,000.00 £ - £ - £ 45,000.00 £ 90,000.00 Other Expenses £ 22,000.00 £ 24,000.00 £ 30,000.00 £ 38,000.00 £ 114,000.00 Bank Loan £ 9,000.00 £ 9,000.00 £ 9,000.00 £ - £ 27,000.00 Total Disbursement £ 131,000.00 £ 79,000.00 £ 153,000.00 £ 193,000.00 £ 556,000.00 Cash Balance £ 137,000.00 £ 214,000.00 £ 196,000.00 £ 193,000.00 £ 740,000.00 Ending Cash Balance £ 137,000.00 £ 214,000.00 £ 196,000.00 £ 193,000.00 £ 740,000.00 b) The manager of Caledonian Limited should know that ‘surplus’ means that the total receipts were more than the total payments, hence the company made some profits. On the other hand, ‘deficits’ to the company means that the total payments or expenses are more than the total amount that the company is making (total receipts), hence the company will be making losses since it uses more than it receives or makes. The manager should therefore reduce its expenses by reducing the payments or cutting down on the amount they pay out in the case of ‘deficits’ so that at least their expenses can be met by their receipts. The company can also increase or improve on its sales so that however much the payments are, the receipts will still be more in order to for the company to meet its current liabilities Task 2 a) b) i) ii) Task 3 Project Alpha (initial cost = 120,000) Year Cash Flow (£) 10% PV Factors Present Value (£) 1 60,000 0.909 54,540 2 60,0000 0.826 49,560 3 30,000 0.751 22,530 4 15,000 0.683 10,245 5 15,000 0.621 9,315 Total 146,190 Investment (120,000) Net Present Value 26,190 Project Beta (Initial cost £150,000) Year Cash Flow (£) 10% PV Factor Net Present Value (£) 1 30,000 0.909 27,000 2 45,000 0.826 37,170 3 75,000 0.751 56,325 4 75,000 0.683 55,225 5 50,000 0.621 31,050 Total 206,770 Initial Investment (150,000) Net Present Value 56,770 Payback Period Project A Project B Year Net Cash Flow Cumulative Cash Inflow Discount Factor Net Cash Flow Cumulative Cash Inflow Discount Factor 0 -£ 260,000.00 -£ 320,000.00 1 £ 140,000.00 £ 140,000.00 0.87 £ 80,000.00 £ 80,000.00 0.87 2 £ 120,000.00 £ 260,000.00 0.756 £ 110,000.00 £ 190,000.00 0.756 3 £ 80,000.00 £ 340,000.00 0.658 £ 130,000.00 £ 320,000.00 0.658 4 £ 50,000.00 £ 390,000.00 0.572 £ 190,000.00 £ 510,000.00 0.572 5 £ 50,000.00 £ 440,000.00 0.497 £ 140,000.00 £ 650,000.00 0.497 Payback Period 2 Years Payback Period 3 years Report to the CEO of Ace Corporation Net Present Value is the difference between the present value of the cash inflows and the present value of the net outflows. Project cash flows are discounted using an appropriate rate, which is the minimum rate of return required by the investor. In the case of these two projects; Alpha and Beta projects, the discounting rate is 10% which is used to calculate the discounting factors with the formula 1/(1 + r)n where r is the discounting rate and n is the number of years. The appropriate cash flows are the after tax cash flows, therefore the net cash flows should be estimated on the after tax basis. However, in these projects, there was no tax involved and no project had a residual value after the completion period of 5 years. Computation of cash flows requires a special treatment of non-cash expenses such as depreciation though in these projects, there is no depreciation considered. However, in case of depreciation, it has an indirect effect on the cash flow since it is a tax deduction expense. The general criteria for Net Present Value is that the project with a negative net present value should be undertaken since it increases the wealth of the shareholders and a project with a negative net present value should not be undertaken since it reduces the wealth of the shareholders. In a case where the manager is faced with several projects and would like to choose one to implement, then the net present values of all the projects will be calculated and compared. The project with the highest net present value should be preferred to the others with low net present value. Considering these two projects: the project Alpha and project Beta, both the projects will last for 5 years and will have a discounting rate of 10% each. The cost of project Alpha is £120,000 and the cost of project Beta is £150,000. When the net present values of these two projects are calculated, it is evident that project Alpha will have a net present value of £26,190 while project Beta will have a net present value of £56,770 by the end of the fifth year. Both the net present values are positive, so according to the net present value criteria, both projects can be undertaken since they increase the wealth of the shareholders. However, if only one project was to be selected for implementation, then the project with the highest net present value should be selected. In this case, project Beta has a higher net present value of £56,770 than project Alpha with a net present value of £26,190. It therefore follows that project Beta should be preferred and selected for implementation since it will have more benefits in terms of net present value than project Alpha. Payback period on the other hand, refers to the number of years or periods taken by a project to generate cash inflows sufficient to recover its initial cost. If the project under consideration is expected to generate equal annual net cash inflows, its payback period will be calculated as follows: Payback Period = (cost of the investment / Annual cash input) in years. The general criteria for Payback period method is that, the project with a payback period shorter than the other projects should be accepted by the management. This means that, the project with the shortest payback period will be ranked first among the alternatives. Considering the two projects we have here; project Alpha and project Beta, project Alpha has a payback period of 2 years and 8 months, while project Beta has a payback period of 3 years, 6 months. This shows clearly, according to the general criterion, that project Alpha will be ranked first between the two. This is because it takes the shortest period to payback the initial investment cost; just 2 years and 8 months, unlike project Beta which takes 3 years and 6 months. The decision on which project to implement then becomes a tricky act to the manager. This is because, according to the net present value, project Beta should be implemented unlike according to payback period where it is project Alpha that should be accepted. However, it is very evident that the manager will be required to use more investment cost to execute project Beta than the amount he will require to execute project Alpha. In addition, being that project Alpha also pays back this investment cost faster in just 2 years 8 months, the manager will then have a reason to choose project Alpha instead of project Beta. Project Beta gives better net present value but it takes longer to repay the initial investment cost and also the initial investment cost is high, hence it does not become the more favorable to invest in. it is also advisable to take the project with the shortest payback period to minimize the risks associated with the returns in the future. Again, the choice of the project with the shortest payback period improves the liquidity position of the company. Task 4 A financial statement is important because it provides information about the annual outflows and inflows of cash of a company. Therefore, statements are crucial because it helps in identifying the cash inflow’s sources and its utilization. Additionally, the statement is important because it helps in management for cash planning and maintenance of proper matching between the cash outflows and inflows. The financial statement also report the cash used in various investing activities like purchasing fixed assets. Companies report the received cash through various financial activities like debentures, issuing of shares, and raising loans. Failing to provide the financial statement, the company will lack the proper information on telling the sources of cash and its use. Additionally, the company will not have adequate planning tool for its business success in the long term. In a small enterprise, the format normally differs from the how it looks in a well-established business. In small enterprises, we only have the sales, cost of sales, gross profit, and net profits. On the other hand, we have a well-detailed income statement in a well-established enterprise with varied sources of income and total income for the period, and well-detailed items of expenses in the expense side. There is also the gross profit, overheads and the net profit. The other main financial statement is a balance sheet. Balance sheet is also known as a statement of the financial position of a business. The creditors and some interested invested can possibly use the balance sheet to show the financial position of the enterprise so that they can decide to either invest in the business or give credit to the business. The balance sheet actually lists both what the company owns and what it owes. It contains the company’s assets (what it owns), and its liabilities (the debt it has). When the company’s liabilities are subtracted from the assets, what is left is the shareholders’ equity, which is the share of the shareholders in the business[ CITATION Lau14 \l 1033 ]. Therefore the purpose of a balance sheet is to allow creditors to evaluate the business and assess whether it is liable for a loan and for the investors to evaluate whether the company is worth investing in. the difference in the format of a balance sheet of a small business and a well-established business is in the size of accounts and the diversity of operating system[ CITATION Mar141 \l 1033 ]. a) Information needs of users of financial statement: i) Managers; they require financial statement information in order to manage the affairs of the business by assessing and evaluating the financial position of the company and making certain financial decisions out of the financial position. ii) Shareholders: they use the financial statements to assess the risk and return associated with their investment, which allow them to take investment decisions based on their analysis. iii) Investors: they use the information from the financial statements to assess the viability of investing in the company. The investors may foresee future dividends associated with investing in the company and the risk that might be associated with it. For instance, if the financial statements are full of fluctuating profits, this indicates a higher risk of investing in the business. Therefore, the statements are used to make investing decisions in by investors. iv) Financial institutions: these institutions such as banks normally use financial information from the financial statements to gauge whether to offer loans to a business or not. Any decision to lend must always be supported by sufficient asset base or liquidity. v) Suppliers; these use financial information from the financial statements to ascertain the credit worthiness of a business in order to supply goods in credit. vi) Customers; they use the financial information from the statements to assess whether a supplier has the required resources for a steady supply of goods to the business in the future. vii) General public: this uses the information to assess the effects of the business to the environment, economy and to the local community. viii) Government: they use the financial statements to ascertain the amount of taxes that the business should pay to the local government authority. b) Ratios i) Gross Profit Margin = (gross profit / sales) x 100 For MKTG; = 4,100/ 30,570 0.13 x 100 = 13% This means that 87% of sales revenue was taken up by the cost of sales while 13% was the gross profit. This is not good enough as the cost of sales has taken up a bigger percentage of sales. For FSA: = 7,170/16,280 = 0.44 x 100 = 44% This also shows that 56% of the total sales were taken up by the cost of sales, leaving only 44% to the gross profit. ii) Net Profit Margin = (net profit/sales) / 100% For MKTG; = 440/30,570 = 0.014 x 100 = 1.4% This indicates that 98.6% of the sales were taken up by the cost of sales, operating and financial expenses while only 1.4% remained as net profit. For FSA; = 690/16,280 = 0.042 x 100 = 4.2% This shows that 95.8% of the sales went to the cost of sales, operating and financial expenses while only 4.2% were left as the net profit. iii) Current Ratio = Current Assets/Current Liabilities For MKTG; = 2510/1950 = 1.29 This shows that current assets are 1.29 times the current liabilities as this ratio measures the number of times the current liabilities can be paid by the current assets. For FSA; = 5070/2950 = 1.72 This shows that the current Assets are 1.72 times the current liabilities. iv) Quick Ratio = (Current Assets – Stock) / Current Liabilities For MKTG; = (2510 – 2420) / 1950 = 0.046 This ratio indicates the firm’s ability to pay its current liabilities from the more liquids of the firm. In this case however, it is very hard for the firm to pay its current liabilities since the quick ratio is less than one. For FSA; = (5070 -2370) / 2950 = 0.95 This is almost one hence the firm’s current liabilities can easily be paid by the current assets without the stock. v) Gearing Hotel is highly geared compare to beauty salon. Therefore, a high gearing ratio for a hotel means that it will pay interest annually higher than that the salon beauty will pay. Hotel is more risky, this is because the increased gearing ratios are too risky and when the hotel fails to pay the debt, it can easily be bankrupt. On the other hand, beauty salon has a low gearing ratio, this is not ideal since the debt cost is low that the equity cost. The debt cost is associated with the fact that the debt holder and shareholder differ in security, whereby the debt holders are secure compared to shareholders. Task 5 a) i) The sources of finance available for this business include: Personal savings Depending on the agreement of the partnership, equal partners will contribute an equal percentage of capital into the partnership while other unequal partners will contribute according to the agreement in the partnership. Small Business Loans A partnership can also approach a bank of a financial institution to apply for a loan[ CITATION Kri14 \l 1033 ]. Sometime each partner may approach a bank where they have an account. Where this happens, each partner will be responsible for the repayment of the loan, which they borrowed. ii) In the case of personal savings, which each person contributed to the business, each partner will be entitled to ownership of the business up to the extent of their contributions. For the loans, each partner will have to be responsible for the repayment of the amount of loan, which they borrowed from the specific banks. In this case also, these loans determine the percentage by which the profits of the business are shared amongst the partners. iii) The cost of personal savings may be determined by the agreement of the partners. However, generally, personal contributions from personal savings normally do not have any cost. Instead, the percentage of contribution by each partner is normally used to share the profits of the business among the partners. However, the loans borrowed from bank are normally given at a certain interest charge. Therefore when repaying the loan, we normally pay even the interest. iv) The decisions of a firm’s capital structure are important since the puzzle arises when there is capital optimal mix and debts that the company needs to achieve. If the company looks in obtaining the debt capital, the company needs to realize many profits to cater for the interest charges before availing the balance for equity. Conversely, when the borrowed money is invested in projects that offer returns higher that the debt capital, the shareholders are likely to enjoy the rising equity return. Conventionally, the debt capitals are attractive finance sources since the interest charges lower the chargeable profit to the corporate tax. Shares can be availed to the company’s public whose stock is traded on stock market. In such scenarios, their financial statements need to comply with IASs, and other rules that govern the firms. v) Either the creditors or the owners provide the capital of a business. This finance can be categorized as either long term or short term. Short-term fund have a maturity of less than one year while the long term have maturity of greater than one year. Therefore, financial planning is crucial for the managers since the manager has to match the inflow from the asset with the source of financing assets. Therefore, the long term and medium term investment in the enterprise need to be financed from the sources that are either long term or medium. The fixed assets investment like equipment, land, building, and plant generate benefit during their period of effective economic life. Therefore, the funds attached to the assets will be paid over a long period. Thus, the long-term assets need not be financed from short-term sources. Hence, financial planning is important lest the company incurs losses or even goes to bankruptcy. Bibliography CITATION Lau14 \l 1033 : , (Laurie, 2014), CITATION Mar141 \l 1033 : , (Marquis, 2014), CITATION Kri14 \l 1033 : , (Kristie, 2014), Read More