8. Excel (take-home 1) Create a two-minute screencapture video demonstrating the savings plan functions discussed in class, using the problems below. 1. Create a new Excel worksheet. 2. Enter the variables necessary for the problems. 3. Enter the appropriate formulas to calculate the solutions. Daniel is planning to save $2,500 for a vacation in 2 years. Suppose that he makes monthly deposits into an account that carns 4% per year. a) What are Daniel's monthly payments? b) How much is Daniel depositing in total? c) How much is Daniel receiving in interest? 9. Excel (take-home 2) Create a two-minute screencapture video demonstrating the loan functions discussed in class, using the problems below 1. Create a new Excel worksheet. 2. Enter the variables necessary for the problem 3. Enter the appropriate formulas to calculate the solutions. Diana makes more money than your instructor fand can afford $3,100 per month to buy a house. She found a 25-year mortgage with an APR of 5.3%. a) How much could she borrow with that loan? b) How much would Diana pay in total for the loan? c) How much would Diana pay in interest? 10. Excel (take-home 3) Create a two-minute screencapture video demonstrating the conversion method discussed in class, using the problems below. 8. Excel (take-home 1) Create a two-minute screencapture video demonstrating the savings plan functions discussed in class, using the problems below. 1. Create a new Excel worksheet. 2. Enter the variables necessary for the problems. 3. Enter the appropriate formulas to calculate the solutions. Daniel is planning to save $2,500 for a vacation in 2 years. Suppose that he makes monthly deposits into an account that carns 4% per year. a) What are Daniel's monthly payments? b) How much is Daniel depositing in total? c) How much is Daniel receiving in interest? 9. Excel (take-home 2) Create a two-minute screencapture video demonstrating the loan functions discussed in class, using the problems below 1. Create a new Excel worksheet. 2. Enter the variables necessary for the problem 3. Enter the appropriate formulas to calculate the solutions. Diana makes more money than your instructor fand can afford $3,100 per month to buy a house. She found a 25-year mortgage with an APR of 5.3%. a) How much could she borrow with that loan? b) How much would Diana pay in total for the loan? c) How much would Diana pay in interest? 10. Excel (take-home 3) Create a two-minute screencapture video demonstrating the conversion method discussed in class, using the problems below