*Please post excel formula*

1 Mendez Co, has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows? 2 What is the present value at 18 percent? At 24 percent? 3 4 Input area: 5 6 Discount rate 10% 7 Discount rate 18% 8 Discount rate 24% 9 10 Year Cash flow 11 $470 12 2 610 13 3 735 14 920 15 16 (Use cells A6 to B14 from the given information to complete this question. Your answers should be positive values.) 17 18 Output areo: 19 20 Value today at 10% 21 Value today at 18% 22 Value today at 24% 23 24 25 A Graded Worksheet 4