COMPUTER APPLICATIONS IN FINANCE FIN 3450 ASSIGNMENT 2 INDIVIDUAL ASSIGNMENT DUE MAY 19, 2020 [Total Points 25) ALL SUBMISSIONS SHOULD BE IN EXCEL WORKSHEET Problem 1: (a) What is the future value of $600 (lump sum) invested today at 10% for five years? (b) Calculate the present value of $900 to be received at the end of six years using a discount rate of 11%. Problem 2: (a) Calculate the future value of $1,250, 7- year annuity invested at 9% APR. (b) What would be the future value of an equivalent annuity due payments? (c) Calculate the present value of $1,750, 5-year annuity using a discount rate of 12% APR. (d) What would be the present value of an equivalent annuity due payments ? 2 5 Problem 3: (a) What is the future value of the following unequal cash flows using 9% interest rate? YEAR 1 3 4 CASH FLOW $600 $800 $500 $400 $900 (b) What would be an annuity payment (PMT) that would give the same future value using the same interest rate and same number of years? (c) What is the present value of the following unequal cash flows using 7.5% interest rate? YEAR 2 3 CASH FLOW $950 $860 $520 $770 (d) What would be the an annuity payment (PMT) that would give the same present value using the same interest rate and same number of years? ced States) Focus MacBook Pro