1. The amount of the annual repayment is:
It is given in the question that loan is repaid equally at the end of every year.
Loan = $ 2400000
Interest rate = 8.6%
Year |
borrowing and repayment |
0 |
2400000.00 |
1 |
-610631.2849 |
2 |
-610631.2849 |
3 |
-610631.2849 |
4 |
-610631.2849 |
5 |
-610631.2849 |
2.NPV = PV of CI – Initial outlay
Year |
net cash inflow after interest |
discount rate |
present value |
0 |
-$ 24,00,000.00 |
-$ 24,00,000.00 |
|
1 |
$ 14,69,368.72 |
0.138 |
$ 12,91,185.16 |
2 |
$ 5,89,368.72 |
$ 4,55,095.51 |
|
3 |
$ 13,19,368.72 |
$ 8,95,239.83 |
|
4 |
$ 4,94,368.72 |
$ 2,94,769.08 |
|
5 |
$ 6,34,368.72 |
$ 3,32,376.60 |
|
NPV |
$ 8,68,666.19 |
3. IRR = PV of CI = PV of CO
IRR = 31%
Refer to the excel sheet
4. PBP
Year |
net cash inflow after interest |
cumulative cash flow |
0 |
-$ 24,00,000.00 |
-$ 24,00,000.00 |
1 |
$ 14,69,368.72 |
-9,30,631.28 |
2 |
$ 5,89,368.72 |
-3,41,262.57 |
3 |
$ 13,19,368.72 |
9,78,106.15 |
4 |
$ 4,94,368.72 |
|
5 |
$ 6,34,368.72 |
PBP = 2 + 341262.57/1319368.72 = 2.26 years
5. ARR = Average net income/initial outlay
ARR = 901368.72/2400000
ARR = 38%
6. PI = PV of CI/ initial outlay
PI = 3268666.19/2400000
PI = 1.36
7. Yes, the project should be acceptable.
- NPV method is most used method for the investment decisions. It is used to analyse the projected earnings from projected investment. It is calculated by subtracting the PV of the estimated cost of the projected investment from the PV of the estimated earnings from that investment. Further this method accounts for time value of money concept by using discounted cash flows. Thus, it is to be noted that if the NPV is more than zero then accept the project otherwise rejected. In addition to this, in case of competing projects accept the project with higher NPV (Shapiro, 2005).
As per NPV method, the answer is: project should be acceptable.
- Some firms also use IRR method for the investment proposals. In this method, discount rate makes the NPV zero that means Present value of all cash flows both positive and negative is equal. This metric is used to evaluate the earnings through projected capital investments. Thus, the project should be acceptable only if IRR is greater than required rate of return. Also, when there are competing projects then with higher IRR making it seem to be an outstanding investment than the lower IRR (Shapiro, 2005).
As per IRR method, the answer is: project should be acceptable.
- Payback period states about the length of time required in order to recoup the monies spent in the investment. This method for the investment decision is simplest and it is widely used by the small business firms because it gives the rough scheduled time to the company get back the initial investment amount. Thus taken the PBP for the investment appraisal, accept the project only if pay-back period is less than the target period. Further, the project with higher PBP should be selected in case of competing projects (Kaplan and Garrick, 1981).
As per PBP method, the answer is: project should be acceptable.
- ARR states about the estimated profit earned from the projected investment. It is calculated by dividing the average net income to the initial cash outlay. It is expressed in percentage form. Further it is advisable to accept the project only if the project ARR is greater than project’s required rate of return. Higher ARR is accepted in case of mutually exclusive projects.
As per IRR method, the answer is: project should be acceptable.
- PI index is a relative degree of the NPV method. It is computed by dividing PV of CI to the Initial investment. PI is calculated in ratio form. Thus, company should move towards the project only if PI is greater than 1 otherwise rejected. Thus, for mutually exclusive projects, project with higher PI should be selected (Bierman and Smidt, 2012).
As per PI method, the answer is: project should be acceptable.
Treatment of Loan repayment: It is given in the question that loan repayment is made at the end of every year. So the amount of interest is deducted in the operating cash flows.
Treatment of salvage amount: Salvage means the amount which is expected to receive at the end of the life of the asset. In capital budgeting, the salvage value is sum up with terminal year operating cash flow of the project.
Year |
price |
quantity |
growth |
Investment |
sale of machine |
sales revenue |
cash ope exp |
head office exp |
sales and Mkt exp |
inflation |
working capital |
cost of capital |
dep rate |
book value |
depreciation |
profit on machine sale |
tax |
PBT |
tax |
PAT |
|
0 |
165 |
- |
1.05 |
-100,00,000 |
- |
- |
1.01 |
- 3,00,000 |
0.1 |
0.4 |
10000000 |
0.33 |
- |
- |
|||||||
1 |
165 |
1,02,000 |
1.05 |
168,30,000 |
119,49,300 |
1,30,000 |
2,51,000 |
1.01 |
- |
0.4 |
6000000 |
4000000 |
0.33 |
4,99,700 |
- |
4,99,700 |
|||||
2 |
165 |
1,07,100 |
1.05 |
176,71,500 |
125,46,765 |
1,30,000 |
2,53,510 |
1.01 |
- |
0.4 |
3600000 |
2400000 |
0.33 |
23,41,225 |
7,72,604 |
15,68,621 |
|||||
3 |
165 |
1,12,455 |
1.05 |
185,55,075 |
131,74,103 |
1,30,000 |
2,56,045 |
1.01 |
- |
0.4 |
2160000 |
1440000 |
0.33 |
35,54,927 |
11,73,126 |
23,81,801 |
|||||
4 |
165 |
1,18,078 |
1.05 |
9,00,000 |
194,82,829 |
138,32,808 |
1,30,000 |
2,58,606 |
1.01 |
3,00,000 |
0.4 |
1296000 |
864000 |
36,000 |
0.33 |
44,33,415 |
14,63,027 |
29,70,388 |
2.
Years |
0 |
1 |
2 |
3 |
4 |
CF |
- 100,00,000 |
44,99,700 |
39,68,621 |
38,21,801 |
38,34,388 |
PVIF @ 10% |
1 |
0.90909091 |
0.82644628 |
0.7513148 |
0.683013455 |
PV |
-10000000 |
4090636.36 |
3279851.86 |
2871375.55 |
2618938.534 |
NPV |
2860802 |
NPV represents the earnings from the projected investment. Yes, Multitakks limited should accept the project because NPV is positive.
3. Managerial options:
Availability of managerial options increases the investment’s value. The value can be seen as its NPV composed with the options value if any.
Project’s value = NPV + value of options.
With higher uncertainty, the chances of options value are also greater (Dayananda, D., 2002).
Varieties of Managerial options are:
Option to Expand: In manufacturing business, the management seeks to make the investment and initially investment outlay represents the negative NPV and so the management finds the option to expand till the offset of the negative NPV. Thus, the project should be accepted.
Option to abandon: In this option, the project should be restraint if their economic use is not justified. In this option, the resources should be either diverted to another department or to sell the resources. Thus, when the option to abandon the project is available then, the value of investment is increased.
Option to postpone: In this option, the option to wait is available in some cases. In other words, project is not undertaken now. This is very advantageous for the company because company can gather information from external sources about prices, cost etc. and thus can take firmly decisions. Thus, it can be said that higher risks mean the higher value of option to postpone.
In fact, financial options are more easy to value than managerial options.
References
Bierman Jr, H. and Smidt, S.,2012, the capital budgeting decision: economic analysis of investment projects, Routledge.
Dayananda, D., Harrison, S., Irons, R., Herbohn, J. and Rowland, P., 2002, Capital budgeting: Financial appraisal of investment projects, Cambridge University Press: UK.
Kaplan, S. and Garrick, B.J., 1981, On the quantitative definition of risk, Risk analysis. Vol.1, no.1, pp. 11-27.
Shapiro, A.C., 2005, Capital budgeting and investment analysis, Prentice hall.
Weingartner, H.M.,1969, ‘some new views on the payback period and capital budgeting decisions,’ management science, vol.15, no.12, pp. B-594.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2022). Capital Budgeting Analysis For A Proposed Project Essay.. Retrieved from https://myassignmenthelp.com/free-samples/corpfin1002-business-finance/the-manufacturing-business-file-A88EB2.html.
"Capital Budgeting Analysis For A Proposed Project Essay.." My Assignment Help, 2022, https://myassignmenthelp.com/free-samples/corpfin1002-business-finance/the-manufacturing-business-file-A88EB2.html.
My Assignment Help (2022) Capital Budgeting Analysis For A Proposed Project Essay. [Online]. Available from: https://myassignmenthelp.com/free-samples/corpfin1002-business-finance/the-manufacturing-business-file-A88EB2.html
[Accessed 12 November 2024].
My Assignment Help. 'Capital Budgeting Analysis For A Proposed Project Essay.' (My Assignment Help, 2022) <https://myassignmenthelp.com/free-samples/corpfin1002-business-finance/the-manufacturing-business-file-A88EB2.html> accessed 12 November 2024.
My Assignment Help. Capital Budgeting Analysis For A Proposed Project Essay. [Internet]. My Assignment Help. 2022 [cited 12 November 2024]. Available from: https://myassignmenthelp.com/free-samples/corpfin1002-business-finance/the-manufacturing-business-file-A88EB2.html.