Question: Perform the following tasks: 1. Save the file using the file name SC_EX_4_Calculator. 2. Identify a home for sale in your local housing market that

 Perform the following tasks: 1. Save the file using the filename SC_EX_4_Calculator. 2. Identify a home for sale in your local housingmarket that you would consider buying. Use the asking price for that

Perform the following tasks: 1. Save the file using the file name SC_EX_4_Calculator. 2. Identify a home for sale in your local housing market that you would consider buying. Use the asking price for that home as the current value of the house, or use an online tool such as Zillow.com to find the current estimated value of the home. Enter this value in your Down Payment Calculator, and calculate the needed down payment. 3. Determine the amount you consider reasonable as a monthly savings toward a down payment, and enter this in your down payment calculator. 4. Use the Future Value function to calculate how much you could save, using the rate of return and years to save in the worksheet. Remember to use a minus sign before the function so that the calculation will appear positive. 5. Create a two-input data table that calculates the future value of savings. You can decide which two inputs you would like to use for your data table. 6. Format the worksheet using techniques you have learned to present the worksheet content in a visually appealing form (Figure 4-68). Expand Your World continued 7. If requested by your instructor, save the file on OneDrive. 8. Submit the workbook as specified by your instructor. 9. Why did you select the two inputs used in your data table? How useful are they for evaluating down payment savings options? Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me Comments Share

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 Databases Questions!