Question: 2 . what excel formula can i use, that would result in net cash flow from the investment, considering cost and future cash flows, using

2. what excel formula can i use, that would result in net cash flow from the investment, considering cost and future cash flows, using this data: desired return %, cost, cash inflows for each of the 10 years, residual value, total cash flows, pv net cash flows (everything is in row 4, desired return % is c, cost is d, year 1-10 is e-n, residual value is o, total cash flows is p, pv net cash flows is q)

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