Question: I need help with this homework problem with Excel. Let's evaluate saving money over a 10 year period. We want to have some coon headers

I need help with this homework problem with Excel.
I need help with this homework problem with
Let's evaluate saving money over a 10 year period. We want to have some coon headers to do the folowing In cell put the test Current Savings" (This is our present value In cell B1 put the text "APR incel CI put the lex"PER In cell D1 put the text "Savings Per Month in cell 61 put the testinal Savings Now below each cell let's put a value In cel A2 put the value 52000.00 and format the cells currency with two decimal places in cell 2 put the values and format the cell as a percentage In cell put the value 120 for the 10 years of saving each month wilde In cell 2 put the value 125000 and format the cell currency witwe decimal places. This is our payment at the end of the same period In cell 12 put a future value formula to calculate the total savings at the end of the 10 yeur perled. Now that you have done the calculation for 10 years and verified the number is 265 doek Using Goal Seek, find the savings per month eded to have at the end of the year period Record the Goal Seek with a buttatorit This is due by 11-15-2021 Let's evaluate saving money over a 10 year period. We want to have some coon headers to do the folowing In cell put the test Current Savings" (This is our present value In cell B1 put the text "APR incel CI put the lex"PER In cell D1 put the text "Savings Per Month in cell 61 put the testinal Savings Now below each cell let's put a value In cel A2 put the value 52000.00 and format the cells currency with two decimal places in cell 2 put the values and format the cell as a percentage In cell put the value 120 for the 10 years of saving each month wilde In cell 2 put the value 125000 and format the cell currency witwe decimal places. This is our payment at the end of the same period In cell 12 put a future value formula to calculate the total savings at the end of the 10 yeur perled. Now that you have done the calculation for 10 years and verified the number is 265 doek Using Goal Seek, find the savings per month eded to have at the end of the year period Record the Goal Seek with a buttatorit This is due by 11-15-2021

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 General Management Questions!