Question: Please help me solve this on VBA, help me make a code! Question # 4 - A better NPV Create a function called NPV 2

Please help me solve this on VBA, help me make a code! Question #4- A better NPV
Create a function called NPV2(cf as range, rt)
Use the following code to count the number of cash flows
x=cf.count
The function should allow the user to include time zero and should calculate the net present value. The function should also return the decision (Accept/Reject) to the right of the NPV value.
Use your function to solve for NPV on this worksheet.
 Please help me solve this on VBA, help me make a

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 Databases Questions!