Question: Please list the excel functions needed for calculations Future Value Instruction: Calculate the amount of money using FV Function. All cells must contain formulas (i.e.,
Please list the excel functions needed for calculations Future Value Instruction: Calculate the amount of money using FV Function. All cells must contain formulas (i.e., typing the number directly into the cells will be graded as incorrect answers). 1.1 If John deposits $200 in the bank each month for 5 years where the annual interest rate is 7.5%, how much does he have in the bank at the end of the five years? 1.2 How much interest does John earn during the five years? 2.1 Rachel deposits $400 per month for 5 years into an account that pays 6% annual. How much is in Rachel's account at the end of the five years? 2.2 How much does Rachel actually deposit into the account? 2.3 How much interest does Rachel earn
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
