Can you please answer showing how to use excel formulas Can

Wainright 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? What is the present value at 18 percent? At 24 percent? Discount rate Discount rate Discount rate 10% 18% 24% Year Cash flow 1 S 720 930 1.190 1:275 Complete the following analysis. Do not hard code values in your answers. Value today at 10%

Solution

1. =720/1.1+930/1.1^2+1190/1.1^3+1275/1.1^4=3188.047

2. =720/1.18+930/1.18^2+1190/1.18^3+1275/1.18^4=2659.982

3. =720/1.24+930/1.24^2+1190/1.24^3+1275/1.24^4=2348.915