1. How much would you be willing to pay today for an investment that would return $800 each year at the end of each of the next 6 years? Assume an annual interest rate of 5%. Show your work in excel using the excel functions. Show your answer to 2 decimal points. Please post the image not the file.
2. Assume that you purchase a 6 year, 8% savings certificate for $1,000. What is the difference between the ending value of the savings certificate if it were compounded semiannually and if it were compounded annually? Please fill in the blanks and choose more or less The semiannual is worth $__________ (more or less) than the annual. Show your work in excel using the excel functions. Show your answer to 2 decimal points. Please post the image not the file.