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 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
Get step-by-step solutions from verified subject matter experts
