General Information Regarding Solution of this Problem: The Present Value of Money to be received in the future is calculated by the formula: PRESENT VALUE - FUTURE VALUE X PRESENT VALUE FACTOR or PVFVXPVF or PV-FV x [1/(1+1) " Interest Rate * Number of Investment Periods Net Present Value (NPV) is the present value of future cash flows related to an investment minus the cost of the initial investment Discount Rate (also known as Cost of Capital or Hurdle Rate) is the return rate that is required to undertake a project. Net Operating Cash Flow is defined as the result of subtracting the cash outflows from the cash inflows. If you compare this problem to the example from page 312 of the text, you will note that we are skipping line A-I since we have been given the Net Operating Cash Flow, we are not required to calculate it. Steps in Completing this Exercise: Note you will have to follow each of these steps for both 20% and 10% for each of the project. Present Value Interest Factor You can find the Present Value Factors (PVF) on pages 296- 297 (Table B.3) of your textbook. Locate the YEAR and the PERCENTAGE - Where these two intersect, is the PVF. You must find the PVF for both 20% and 10% for each year and enter into the appropriate block. Annual Present Value (PV) of Cash Flows I have given you the formula for calculating the Present Value of Money to be received in the future: PV=FVXPVF. . In the GIVENS, you were provided with the Future Value (FV) for each of the coming 5 years Net Cash Flows. Here is how the calculation for the 15 year of Project A would be completed with 20% Discount Rate/ Cost of Capital: PV = FV x PVF PV = 2500 x 0.8333 PV = 2083 . Here is how the calculation for the 1" year of Project A would be completed with 10% Discount Rate/ Cost of Capital: PV=FVPVF PV = 2500 x 0.9091 PV = 2273 This is the TOTAL of the Annual Present Value of Cash Flows. This is the Present Value of Cash Flow (Total) minus the initial investment. esent Value of Cash Flows (Total) et Present Value of Cash Flows WLER 5 PRACTICAL EXERCISE YEAR 3 YEAR 4 YEAR PROJECT A YEAR O YEAR 1 YEAR 2 (3500) 2500 2000 20% 20% 0.8333 2083 1500 20% 1000 20% GIVENS (IN THOUSANDS) Initial Investment Net Operating Cash Flow for PROJECT A Discount Rate/ Cost of Capital Present Value Interest Factor at 20% Annual Present Value (PV) of Cash Flows at 20% Present Value of shows (Total) at 20% Net Present Value (NPV)of Cash at 20% Discount Rate/Cost of Capital Present Value Interest Factor at 10% Annual Present Value (PV) of Cash Flows at 10% Present Value of Cash Flows (Total) at 10% Net Present Value (NPV)of Cash at 10% 600 20% 10% 10% 10% 10% 10% 0.9091 2,273 YEAR 3 YEAR YEAR 4 PROJECT B YEAR O YEAR 1 YEAR 2 (3500) 600 1000 20% 20% 1500 20% 2000 20% 2500 20% GIVENS (IN THOUSANDS) Initial Investment Net Operating Cash Flow for PROJECT B Discount Rate/Cost of Capital Present Value Interest Factor at 20% Annual Present Value (PV) of Cash Flows at 20% Present Value of Cash Flows (Total) at 20% Net Present Value (NPV)of Cash at 20% Discount Rate/Cost of Capital Present Value Interest Factor at 10% Annual Present Value (PV) of Cash Flows at 10% Present Value of Cash Flows (Total) at 10% Net Present Value (NPV) of Cash at 10% 10% 10% 10% 10% 10% Your goal is to determine the Net Present Value (NPV) for Projects A and B using a 20% and a 10% Discount Rate, then determine which project should be selected at each Discount Rate. GRAY BLOCKS WILL CONTAIN NO DATA. Project A NPV at a 20% Discount Rate is Project B NPV at a 20% Discount Rate is The Project that should be selected at 20% is Project A NPV at a 10% Discount Rate is Project B NPV at a 10% Discount Rate is The Project that should be selected at 10% is OPTIONAL BONUS POINTS (4): Calculate IRR using EXCEL and simply enter results here. IRR for Project A at 20% is at 10% is IRR for Project B at 20% is ; at 10% is
