Current and Non-Current Assets
Complex Stuff Ltd. |
||
Balance Sheet |
||
as on 31 January 2021 |
||
Amount |
Amount |
|
Current assets: |
||
Cash |
£41,000 |
|
Receivables |
£18,000 |
|
Inventories |
£41,500 |
|
Total Current Assets |
£100,500 |
|
Non-Current Assets: |
||
Property, plant and equipment |
£88,100 |
|
Total Non-Current Assets |
£88,100 |
|
Total Assets |
£188,600 |
|
Current Liabilities: |
||
Payables |
£28,000 |
|
Total Current Liabilities |
£28,000 |
|
Total Non-Current Liabilities |
£0 |
|
Total Liabilities |
£28,000 |
|
Equity: |
||
Share Capital |
£2,500 |
|
Retained earnings |
£158,100 |
|
Total Shareholders' Equity |
£160,600 |
|
Total Liabilities & Shareholders' Equity |
£188,600 |
The company has used the conventional accounting method in which the accrual methods and the matching principle of accounting have been followed. While preparing the financial statements it has been considered that the equity and liabilities is equal to the value of the assets. All the items of the balance sheet are recorded as per the appropriate accounting standards and the accrued expenses and income are recorded in the assets and liability side of the balance sheet.
Workings: |
|
Amount |
|
Opening Cash Balance |
£35,000 |
Purchase of point-of-sale system |
-£24,000 |
Cash Purchase of Inventory |
-£9,000 |
Cash Sales |
£24,000 |
Cash Collected from customers |
£15,000 |
Opening Receivable Balance |
£25,000 |
Credit Sales |
£8,000 |
Cash Collected from customers |
-£15,000 |
Closing Receivables Balance |
£18,000 |
Amount |
|
Opening Inventories Balance |
£35,500 |
Total Purchase of Inventory |
£18,000 |
Cost of Goods Sold |
-£12,000 |
Opening Payables Balance |
£19,000 |
Credit Purchase |
£9,000 |
Opening PP&E Balance |
£74,500 |
Purchase of point-of-sale system |
£24,000 |
Depreciation of Beginning PP&E |
-£10,000 |
Depreciation on new system |
-£400 |
Closing PP&E Balance |
£88,100 |
Amount |
|
Total Sales |
£32,000 |
Cost of Goods Sold |
-£12,000 |
Gross Profit |
£20,000 |
Depreciation expense |
-£10,400 |
Net Profit |
£9,600 |
Opening Retained Earnings |
£148,500 |
Closing Retained Earnings |
£158,100 |
b) Requirement
Amount |
|
Current Assets |
£100,500 |
Less: Current Liabilities |
-£28,000 |
Working Capital |
£72,500 |
Operating Cash Flows: |
|
Amount |
|
Rent paid in advance |
-£4,500 |
Purchase of paint inventory |
-£30,000 |
Payment for shop opening event |
-£750 |
Cash Sales |
£30,000 |
Staff Salaries paid |
-£8,000 |
Net Operating Cash Flows |
-£13,250 |
Investing Cash Flows: |
|
Amount |
|
Purchase of point of sale equipment |
-£5,000 |
Net Investing Cash Flows |
-£5,000 |
Financing Cash Flows: |
|
Amount |
|
Cash received from owners |
£50,000 |
Bank Loan received |
£50,000 |
Interest on bank loan paid |
-£500 |
Interim dividend paid |
-£1,000 |
Net Financing Cash Flows |
£98,500 |
Amount |
|
Net Operating Cash Flows |
-£13,250 |
Net Investing Cash Flows |
-£5,000 |
Net Financing Cash Flows |
£98,500 |
Cash & Cash Equivalents |
£80,250 |
3. a) Requirement
Purchase |
Cost of Sales |
Balance |
|||||||
Date |
Unit |
Price p.u. |
Amount |
Unit |
Price p.u. |
Amount |
Unit |
Price p.u. |
Amount |
01/07/2021 |
150 |
£100 |
£15,000 |
||||||
04/07/2021 |
50 |
£110 |
£5,500 |
150 |
£100 |
£15,000 |
|||
50 |
£110 |
£5,500 |
|||||||
10/07/2021 |
120 |
£100 |
£12,000 |
30 |
£100 |
£3,000 |
|||
50 |
£110 |
£5,500 |
|||||||
18/07/2021 |
30 |
£100 |
£3,000 |
30 |
£110 |
£3,300 |
|||
20 |
£110 |
£2,200 |
|||||||
25/07/2021 |
50 |
£120 |
£6,000 |
30 |
£110 |
£3,300 |
|||
50 |
£120 |
£6,000 |
|||||||
28/07/2021 |
30 |
£110 |
£3,300 |
40 |
£120 |
£4,800 |
|||
10 |
£120 |
£1,200 |
|||||||
Value of Closing Inventory on 31st July 2021 |
£4,800 |
The FIFO method of inventory has been followed for which the gross profit of the company increases as when the FIFO method is used the value of the COGS decreased and for that reason the gross profit margin increases.
4.
Amount |
||
Machinery value on 1/1/20 |
a |
£50,000,000 |
Residual Value |
b |
£5,000,000 |
Depreciable Value |
c=a-b |
£45,000,000 |
Useful Life |
d |
5 |
Depreciation per annum |
e=c/d |
£9,000,000 |
Period (in years) |
f |
4 |
Accumulated Depreciation |
g=e*f |
£36,000,000 |
Net Book Value at 31st December 2023 |
h=a-g |
£14,000,000 |
The process of calculation of the minimum return that is essential to justify the reason to undertake a capital budgeting project is known as cost of capital. The term cost of capital is used in capital budgeting process to evaluate the potential return that is related with the cost of such invested amount and the risk associated with such investment that is made in a particular project. In general companies used a combination of equity and debt in order to finance the project. So the cost of capital is calculated as the weighted average cost of both the debt and equity. The concept of cost of capital in the capital budgeting process is important as from the evaluation of the cost of capital it can be possible to evaluate the amount of money required to be generated from the project so that the cost of undertaking such project can be compensated and beyond that margin the company will be able to generate profit from such projects. So the concept of corporate cost of raising capital is related actually means the cost that the corporates have to incur to raise fund that is essential for financing any project and based on the value of the cost of capital the companies evaluate the financial viability of any project that is whether such project can be accepted or rejected.
The concept of modified internal rate of return assumes that the positive cash flows of any project will be again used for investment purpose at the same cost of capital and that the initial cash outflows that are required for the project will be financed at the company’s financing cost. The MIRR gives a more accurate result of the cost and profitability of any project. MIRR is very useful in ranking of prices of different sizes as the MIRR gives the option to make changes in the predicted rate of reinvested growth from one stage to another stage of any project. The main advantage of the MIRR in investment appraisal process is that unlike the IRR method the MIRR does not provide multiple solution for the same project and instead of that MIRR provide single result for a single project. Another point for which MIRR is more effective in comparison to that IRR is that in case of IRR the reinvestment of positive cash flows is not practical in real projects but MIRR makes the reinvestment rate of positive cash flows with valid techniques that can be applied for the evaluation of the financial viability of the project.
There are several methods of investment appraisal some of these are payback method, net present value method, accounting rate of return and the internal rate of return methods, but among these methods most of the sophisticated managers use is the net present value method. As the net present value method gives the most appropriate result of the future cash generating capacity of the project and the growth prospect of the project so this method is widely used by most of the sophisticated managers.
The factors that are required to be considered from a strategic point if view for investment appraisal is the inflation rate. The inflation rate is very essential for appraising any project since it directly impacts the value of money over a specific period of time and to predict the future prospect of the project inflation rate should be considered while using any investment appraisal technique
The projects that have alternative positive and negative cash flows in such cases there can be more than one IRR and that often leads to confusion and ambiguity in capital budgeting process and proper decision cannot be taken from such projects.
If the project has both positive and negative cash flows then in such cases it can be said that such project should have more than one IRR, but where the cash flows are only in positive or in negative figures then there will be only one IRR. so simply by analysing the cash flows of the project it can be possible to find out the number of IRR of the project.
Amount |
||
Dividend per share |
a |
£12.00 |
Discount Rate |
b |
15% |
Value of Stock |
c=a/b |
£80.00 |
Amount |
||
Dividend paid per share |
a |
£4.00 |
Growth Rate |
b |
4% |
Expected Dividend per share |
c=a*(1+b) |
£4.16 |
Required rate of return |
d |
12% |
Value of Stock |
e=c/(d-b) |
£52.00 |
Amount |
||
Dividend paid per share |
a |
£3.00 |
Growth Rate |
b |
6% |
Expected Dividend per share |
c=a*(1+b) |
£3.18 |
Current share price |
d |
£35.00 |
Implied Rate of Return |
e=(c/d) + b |
15.09% |
The growth rate implies the amount in which the investment that is made in a specific project will increases in a given period of time. The growth rate provides the information related with the value of the investment and how such investment will grow or change in the future.
The major advantage of using the discounted cash flow method is that it considers the time value of money to evaluate the investment.
The major disadvantage of the discounted cash flow is that it does not consider excess amount of cash flows, generated by the project over the initial investment.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2022). Balance Sheet As On 31 Jan 2021 - Complex Stuff Ltd. (Essay). Retrieved from https://myassignmenthelp.com/free-samples/smm643-managerial-finance-and-accounting/the-fifo-method-of-inventory-file-A1D4FBB.html.
"Balance Sheet As On 31 Jan 2021 - Complex Stuff Ltd. (Essay)." My Assignment Help, 2022, https://myassignmenthelp.com/free-samples/smm643-managerial-finance-and-accounting/the-fifo-method-of-inventory-file-A1D4FBB.html.
My Assignment Help (2022) Balance Sheet As On 31 Jan 2021 - Complex Stuff Ltd. (Essay) [Online]. Available from: https://myassignmenthelp.com/free-samples/smm643-managerial-finance-and-accounting/the-fifo-method-of-inventory-file-A1D4FBB.html
[Accessed 26 November 2024].
My Assignment Help. 'Balance Sheet As On 31 Jan 2021 - Complex Stuff Ltd. (Essay)' (My Assignment Help, 2022) <https://myassignmenthelp.com/free-samples/smm643-managerial-finance-and-accounting/the-fifo-method-of-inventory-file-A1D4FBB.html> accessed 26 November 2024.
My Assignment Help. Balance Sheet As On 31 Jan 2021 - Complex Stuff Ltd. (Essay) [Internet]. My Assignment Help. 2022 [cited 26 November 2024]. Available from: https://myassignmenthelp.com/free-samples/smm643-managerial-finance-and-accounting/the-fifo-method-of-inventory-file-A1D4FBB.html.