MC08. 9&10

Question 9 1pts What is the future value of $1,500 after 5 years if the annual return is 6%, compounded semiannually? Which formula in B23 will calculate the answer? =FV(B27/B25,B26B27,0,B24)=FV(B24/B27,B26B27,0,B25)=FV(B25)B27,B26B27,0,B24) none of the answers is correct Question 10 1 pts Rodrigo Sanchez is planning to buy a house in five years. He is looking to invest $25,000 today in an index mutual fund that will provide him a return of 12 percent annually. How much will he have at the end of five years? (Round to the nearest dollar.) Which formula in B12 will calculate the answer? none of the answers is correct =FV(B13,B15,0,B14)=PV(B14,B15,0,B13)=FV(B15,B14,0,B13) =FV(B14,B15,0,B13) Question 9 1pts What is the future value of $1,500 after 5 years if the annual return is 6%, compounded semiannually? Which formula in B23 will calculate the answer? =FV(B27/B25,B26B27,0,B24)=FV(B24/B27,B26B27,0,B25)=FV(B25)B27,B26B27,0,B24) none of the answers is correct Question 10 1 pts Rodrigo Sanchez is planning to buy a house in five years. He is looking to invest $25,000 today in an index mutual fund that will provide him a return of 12 percent annually. How much will he have at the end of five years? (Round to the nearest dollar.) Which formula in B12 will calculate the answer? none of the answers is correct =FV(B13,B15,0,B14)=PV(B14,B15,0,B13)=FV(B15,B14,0,B13) =FV(B14,B15,0,B13)