Question: Example Comparing Two Projects Using Net Present Value Method table [ [ , A , B , C , D , E , F

Example Comparing Two Projects Using Net Present Value Method
\table[[,A,B,C,D,E,F,G,H,1,J,K,L,M],[1,,,,,,,,,,,,,],[2,,,,Exhibit 2.38,,,,,,,],[3,,,,,,,,,,,,,],[4,,,,Example Comparing Iwo Projects Using NPV,,,Formulas,],[\table[[5],[6]],\table[[Project A],[Reguired]],,Year 0,Year 1,Year 2,Year 3,Year 4,Year 5,Total,,],[\table[[6],[7]],\table[[Required],[Outflows]],15%,$700,000,,,,,,$700,000,,,,],[8,Inflows,,,$225,000,$275,000,$2275,000,$225,000,$225,000,$1,125,000,,,,],[9,Net inflows,,$2225,000,$225,000,5225,000,$2225,000,$225,000,$425,000,Project A:,= C7+NPV(B6,09:H9),],[10,NPV,554,235,,,,,,,,,],[11,,,,,,,,,,,,,],[12 Pueleat],[13,Project B,,,,,,,,,,,,],[14,Required,15%,,,,,,,,,,,],[15,Outflows,,$400,000,,,,,,$400,000,,,,],[16,Inflows,,,$110,000,$110,000,5110,000,$110,000,$110,000,$550,000,,,,],[17,Net inflows,,$110,000,$110,000,$110,000,5110,000,$110,000,$150,000,Project B:,= C15+NPV,V{B14,017:,7:H17)],[18,NPV,531,263,,,,,,,,,,,],[19,,,,,,,,,,,,,],[20,,,,,,,,,,,,,],[21,,,,,,,,,,,,,],[22,NPV comparison: Accept Project A..NPV is positive.,,,,,,,],[23,Reject Proj,ject B.N,IPV is nega,ative.,,,,,,,,,]]
Can you please solve how to get NPV without doing it like excel way because I don't understand the excel formula clearly?
 Example Comparing Two Projects Using Net Present Value Method \table[[,A,B,C,D,E,F,G,H,1,J,K,L,M],[1,,,,,,,,,,,,,],[2,,,,Exhibit 2.38,,,,,,,],[3,,,,,,,,,,,,,],[4,,,,Example

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!