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: CalculatePlease 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!