SUM ? X OBS FILE Calculating present values. Excel FORMULAS DATA REVIEW VIEW Sign In HOME INSERT PAGE LAYOUT Anal 12 A A M 96 Cells Paste Editing BIU- A Alignment Number Conditional Format as Cell Formatting" Table Styles Styles Clipboard Font D14 =pv(d8.d7.09.06) A B D E F G H ! 1 2 An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent compounded daily, what is the present value? 4 5 $ 7 Future value of investment Number of years Discount rate Times compounded per year 65,000 10 7% 365 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. Present value of investment * =pv(dB,d7,09, 14 15 16 17 18 Sheet1 100% Step 1011 Cated in red have been filled automatically as they are partially attempted, left blank, incorrect responses (or Schausted). Cells highlighted in green are the correct responses 7 Calculating loan payments - Excel FORMULAS DATA REVIEW VIEW PAGE LAYOUT INSERT HOME % AA Calor 11 Cells Editing Alignment Number Paste BIU- Conditional Format as Cell Formatting Table* Styles Styles d Font Clipboard D E F G H I J A K B You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? 4 5 6 $ Cost of Car Discount rate # of years # of times compounded per year 79,500 5.8% 5 12 11 12 3 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Payment X =pmt(d7/d9,0 14. 15 16 Effective interest rate 17 x =pmt(d7/09,64 Sheet1 POLE lighted in red have been filled automatically as they are partially attempted, left blank, incorrect respo exhausted). Cells highlighted in green are the correct responses E L