Calculating the NPV for each of the given projects

Use MS Excel for your calculations.

The following is a list of four projects that Capital Corporation must choose from for the coming year:

Project Project Price Annual Net In?ows
A 700,000 118,861
B 670,000 109,039
C 184,000 32,549
D 273,000 48,305

(a) Given a uniform rate of interest of 9% and a uniform life of the projects of 10 years each, calculate the NPVs of each Project.

(b) Should we choose Projects A, C, D or Projects A, B, D. Explain

Solution Preview

Please refer attached file for better clarity of functions in MS Excel.

a)
Project A
Cost of project=Co=$700,000
Annual inflows=PMT=-$118,861
No. of periods=NPER=10
Rate of interest=RATE=9%
Type of payment=TYPE=0 assume year end cash flows
Future Value=FV=0

We can use PV function in MS Excel to get PV of cash inflows..

PV of cash inflows=PV=$762,809.21 =PV(C29,C28,C27,C31,C30)

NPV =-Co+PV=$62,809.21

Project B
Cost of ...

Solution Summary

Solution describes the steps to calculate NPV for the given projects. Calculations are carried out the with the help of functions in MS Excel.

... Solution describes the steps in calculating NPV of cash flows ... for making capital budgeting decisions - IRR or NPV? ... We will calculate Present Value of Each Cash ...

Please calculate the net present value (NPV) for the coffee ... The solution assists with calculating the net present value... PV factor at 5% has been calculated as 1 ...

Calculating NPV and IRR for the given project. Janes, Inc. ... (b) Calculate the IRR for this project. ... Solution calculates NPV and IRR in the given case. Solution. ...

... 1-c). Assuming a 10% discount rate, calculate the NPV of the four projects and rank the projects in ... The expert calculates payback, IRR and NPV for four ...

... Step by step method is demonstrated to calculate NPV, PI, IRR or Payback period. ... IRR is the discount rate at which NPV is 0 IRR can be found by using ...

... be read from tables or calculated using the ... subtract the initial outlay to calculate NPV n= 5 r ...Calculates Net Present Value of the initial project, Net Present...

Calculating project IRR, NPV and depreciation. ... tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. ...

... What is the net present value of the project? ...NPV = FORMULA. ... b. Calculate the expected rate of return and standard deviation for each investment. Stocks Bonds. ...

...NPV is calculated by finding the present value of each ...Calculating for IRR is a trial and error procedure. ... it is easier to use financial calculator to compute ...