how would I write the formulas needed?

Expand Your World Create a solution ution that uses cloud or wet technologies by learning and wri ur own from general guidance bawn Payment options for a Home ting on To complete this instructor for informa JeweYou are payment. Your task is blete this assignment, you will be required to the Data Files e t for information about accessing the Data ile You are planning to buy a home as soon as you can save enough to make 155 down ask is to create a calculator that you can use to determine pole savings option calculator with family using OneDrive. Start Excel. Open the workbook called which is located in the Data Files. This workbook you open contains a basic struc- down payment calculator. You are to create a two-input data table to help determine e Data Files. ThiStart Excel. Open the le savings option SC EX-3.xlsx, which rure to create a down the future value of savings. Flexform the following tasks: 1. Save the file usi 2. Identify a home for the asking price for that home Zillow.com to find the current Payment Calculator, and calculate 3. Determine the amount yo he file using the file name SC_EX_4_Calculator for home for sale in your local housing market that you would consider buying Use price for that home as the current value of the house, or use an online tool such as to find the current estimated value of the home. Enter this value in your Down ent Calculator, and calculate the needed down payment. in the amount you consider reasonable as a monthly savings toward a down payment and enter this in your down payment calculator. Gure Value function to calculate how much you could save, using the rate of return save in the worksheet. Remember to use a minus sion before the function so that 4. Use the Future Value function and years to save in the worksheet. the calculation will appear positive. 5. Create a two-input data tabl. 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). a two-input data table that calculates the future value of savings. You can decide which ETU. .A. - Down Payment Calculator 1 4 4 305 307 45 87 57.158.45 50 57 1.705 3 5 6 ULT TO 41442 TEMA T LEON L ES 13 155 15 1011 30 731425 1.50 414 . TL 14 5 DOM S 15LL STARS 5 1.70 Figure 4-68 87000 Down Payment Calculator Current value of house 15% down payment Monthly savings Rate of return Years to save Future value 87000 13050 500 4.25%