1. Capital budgeting related functions What functions are used to calculate values for data used in capital budgeting? Capital budgeting decisions require you to evaluate the acceptability of investment projects through the use of technques as the Net Present Value (WPV) method, Internal Rate of Retum (IRR) method, Modified Internal Rate of Return (MIRR) method etc. While these methods sound complex, Excel makes it really easy to calculate the numbers that are used in anaiysis of evaluating investment projects. The NPV method compares the present value of cash inflows in a project with the present values cash outflows of the project. The value of the difference is called the net present value (NPV). The NPV of a given proyect is compared with the NPV of other grojects. The general rule of thumb is to consider further a mutually exclusive or independent project if its NPV is , and accept the project with the NPV, Consider the data from a possible project that you are evaluating and calculate the project's NPW: (Hint: Round all calculatie: lecimal places. Also, be wure to enter a minus sign if the answer is negative.) IMPORTANT NOTE: The NPY function in Excel does not include the initial imvestment value in its arguments. You have to manuatly add this value to your calculabons to derive the correct value. Since the initial investment is a cash , the NPV calculation would involve adding a value. Some other commonly used capital budgeting techniques are the 1RR and the MIRR methods. You will learn more about them during your finance course. For the purpose of this module you should be able to understand how Excel functions can be used to calculate the values. For MIRR calculations use 4% as the rate at which the investment is financed and assume that the cash flows from the project can be reinvested at the rate of 5\%. (Hint: Round all calculations to two decimal places.) The NPV function in Excel does not include the initial investment value in its arguments. You have to manually add this value to your calculations to derive the correct value. Since the initial investment is a cash , the NPV calculation would involve adding a value. Some other commonly used capital budgeting techniques are the tRR and the MIRR methods. You will leam more about them during your finance course. For the purpose of this module you should be able to understand how Excel functions can be used to calculate the values. For MIRR. calculations use 4% as the rate at which the investment is financed and assume that the cash flows from the project can be reinvested at the rate of 5\%. (Hint: Round all calculations to two decimal places.)
