Question: Kindly show all formula used when solved in excel Consider that you are evaluting the following projects to undertake as per your capital budgeting activity

 Kindly show all formula used when solved in excel Consider that

Kindly show all formula used when solved in excel

Consider that you are evaluting the following projects to undertake as per your capital budgeting activity You have capital budget constarin of 10,000 Project #3 and Project#4 are mutually exclusive You have extimated your WACC as 12% Clearly show your calculations and do not copy paste your values Rank your projects accordingly with reasons and mention the project(s) you are going to consider #3 #4 Project Initial Investment -5000 -5000 Year 1 0 #1 #2 -5000 2000 1253.5528 2000 2000 -5000 300 4500 1500 2 0 3 0 -750 -300 3000 1800 500 5500 4 0 450 5 0 350 0 6 7 0 8 0 9 0 10 17018.9301 7253.55 17018.93 7100.00 9750.00 Sum of the Cash flows Excess Cash Flows 2253.55 12018.93 2100.00 4750.00

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!