Expand Your World

Create a solution that uses cloud or web technologies by learning and investigating on

your own from general guidance.

Down Payment Options for a Home

Note: To complete this assignment, you will be required to use the Data Files. Please contact your

instructor for information about accessing the Data Files.

Instructions: You are planning to buy a home as soon as you can save enough to make a $15\%$ down

payment. Your task is to create a calculator that you can use to determine possible savings options,

and to share this calculator with family using OneDrive. Start Excel. Open the workbook called

SC$\_$EX$\_4-3.$xlsx$,$ which is located in the Data Files. This workbook you open contains a basic struc$-$

ture to create a down payment calculator. You are to create a two$-$input data table to help determine

the future value of savings.

Perform the following tasks:

Save the file using the file name SC$\_$EX$\_4\_$Calculator.

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.

Determine the amount you consider reasonable as a monthly savings toward a down payment,

and enter this in your down payment calculator.

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.

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.

Format the worksheet using techniques you have learned to present the worksheet content in a

visually appealing form $($Figure $4-68).$