palese solve it in excel!

Discounted cash flow analysis - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri % M A A Paste BIU. Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font X fr . B D E F G H I J K 1 2 3 If the appropriate discount rate for the following cash flows is 6.18 percent per year, what is the present value of the cash flows? 4 5 6 Discount rate 6.18% 7 8 9 10 11 12 Year 1 $ 2 3 4 Cash flow 2,480 0 3,920 2,170 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 16 17 18 Present value 19