2.5 points Skipped eBook Print References All answers must be entered as a formula Click OK to begin. OK Saved End of Chapter 6 Homework | HD FILE HOME Calculating future values - Excel ? X - Sign In INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 35 Calibri 11 % AA A, Alignment Number Paste B IU , P, Editing Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font 2.5 points A1 Skipped A B D E F G H I eBook What is the future value of $2,400 in 17 years assuming an interest rate of 7.9 percent compounded semiannually? Print References 2,400 17 Deposit Number of years Interest rate Times compounded per year 7.9% Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. Future value 2.5 points Skipped eBook Print References All answers must be entered as a formula Click OK to begin. OK ? X Discounted cash flow analysis - Excel FORMULAS DATA REVIEW - 2 Sign In FILE HOME INSERTPAGE LAYOUT VIEW 36 Paste B IU - A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font 2.5 points A1 Skipped D E F G H eBook 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? Print References Discount rate 6.18% Year Cash flow 2,480 AWN- 3,920 2,170 Complete the following analysis. Do not hard code values in your calculations. Present value