You are going to create a spreadsheet that will have two functions: Allow a user to input a regular payment, an interest rate and a period of investment, and will output the future value, the total interest earned, the monthly contribution and the average interest earned per year Allow a user to input a desired future value, an interest rate and a period of investment, and will output the amount of regular contribution you would need to make, as well as total interest earned, the monthly contribution and the interest earned per year. The chart will end up looking like this: GIVEN OUPUT Interest Monthly FV: Earned Contribution 1.00 $1000 $0.00 $83.33 Interest Earned / Year $0.00 $1000 1.00% GIVEN OUTPUT Interest Earned Interest Monthly FVR : Earned Contribution 1.00 $1000 $1000 $0.00 $83.33 1.00% $0.00 The cells in blue and light blue are titles and don't get changed The white cells with black text are input cells, where the user inputs values The white cells with red text are output cells. They are calculated values. Note that the cells representing R, FV, Interest earned, monthly contribution and interest earned per year should be formatted as "accounting" cells; the cell representing i should be formatted as a percent; and the cell representing n should be formatted as a number. If you have completed the assignment properly, you will need to enter values into the input boxes to avoid "division by zero" errors in the output boxes (in particular, i can never be zero). You are going to create a spreadsheet that will have two functions: Allow a user to input a regular payment, an interest rate and a period of investment, and will output the future value, the total interest earned, the monthly contribution and the average interest earned per year Allow a user to input a desired future value, an interest rate and a period of investment, and will output the amount of regular contribution you would need to make, as well as total interest earned, the monthly contribution and the interest earned per year. The chart will end up looking like this: GIVEN OUPUT Interest Monthly FV: Earned Contribution 1.00 $1000 $0.00 $83.33 Interest Earned / Year $0.00 $1000 1.00% GIVEN OUTPUT Interest Earned Interest Monthly FVR : Earned Contribution 1.00 $1000 $1000 $0.00 $83.33 1.00% $0.00 The cells in blue and light blue are titles and don't get changed The white cells with black text are input cells, where the user inputs values The white cells with red text are output cells. They are calculated values. Note that the cells representing R, FV, Interest earned, monthly contribution and interest earned per year should be formatted as "accounting" cells; the cell representing i should be formatted as a percent; and the cell representing n should be formatted as a number. If you have completed the assignment properly, you will need to enter values into the input boxes to avoid "division by zero" errors in the output boxes (in particular, i can never be zero)