A1 Calibri (Body) ab General .00 X fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 14. The required answers are in rows 20 through 22. P Q B C D E F G H J K L M N R S T U V W X Mendez Co. has identified an investment project with the following cash flows. 2 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? 3 4 Input area: 5 6 Discount rate 7 Discount rate 8 Discount rate 9 10 11 12 13 14 15 10% 18% 24% Year Cash flow 1 $470 2 610 3 4 735 920 16 (Use cells A6 to B14 from the given information to complete this question. Your answers should be positive values.) 17 18 Output area: 19 20 Value today at 10% 21 Value today at 18% 22 Value today at 24% 23 24 Y Z AA Calibri (Body) A1 A A B ab ab Wrap Merge v General .00 0 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 9. The required answer is in row 15. B C D E F G 1 What is the future value of $5,500 in 17 years at an APR of 8.4 percent 2 compounded semiannually? 3 4 Input area: 5 6 Deposit today 7 Number of years 8 APR 9 10 Compounding periods per year 11 (Use cells A6 to B9 from the given information to complete this question. Your answer should be a positive value.) $5,500 17 8.40% 2 12 13 Output area: 14 15 Future value 16 17 H | K L M N 0 P Q R S T U M V W X ab Wrap Merge v General 18 .00 > fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 9. The required answers are in rows 15 through 16. M Q B C D E F G H | J K L N P R S T U V W X Calibri (Body) A B DI ab You want to buy a new sports coupe for $84,500, and the finance office at the dealership has quoted you an APR of 4.7 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? Input area: Cost of car APR Number of months Compounding periods per year $84,500 4.70% 60 12 (Use cells A6 to B9 from the given information to complete this question. Your payment should be a positive value.) Output area: Payment Effective interest rate