Question: PLEASE ANSWER AND GIVE FORMULAS TO ENTER INTO EXCEL!!!!! Find the: Value at end of first set of contributions- Value at end of second set

PLEASE ANSWER AND GIVE FORMULAS TO ENTER INTO EXCEL!!!!!

Find the:

Value at end of first set of contributions-

Value at end of second set of contributions-PLEASE ANSWER AND GIVE FORMULAS TO ENTER INTO EXCEL!!!!! Find the: Value

1. Calculate the value of your retirement plan. Future Value of Multiple Annuities - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In a X Calibri 11 AA % aste BIU Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles ipboard Font 1 fx B D E F G H Assume that you contribute $330 per month to a retirement plan for 15 years. Then you are able to increase the contribution to $530 per month for the next 25 years. Given an 8 percent interest rate. What is the value of your retirement plan after the 40 years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Initial monthly contribution Number of years Subsequent monthly contribution Number of years Interest rate earned 330 15 530 25 8.00%

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!