Case Problem 1 Data Rle needed for this Case Problem: Hernandez.xlsx Hernandez Family Juan and Olivia Hemandez are a recently married couple in Fort Wayne Indiana. Juan is currently in graduate school and Oliva is the manager at a local bakery. They want to use Excel to heip manage theirfamitly budget but they need help setting up the formulas and functions to project their montily expenses and belp them meet their financial goals. Complete the following 1, Open the Hemandez workbook located jn the Excel3 Casel folder included with your Data Files, and then save the workbook as Hemandez Budget in the location specified by your instructor 2. In the Documentation shee enter your hame and the date. 3. Go to the Budget worksheet. In celt 87, calculate the couple's total monthly income. 4. In row 23, use AjitorFillto repface the numbers 1 through 12 with the month abbreviations lan through De 5. In rows 24 and 25, enter the couple's monthly income by referencing the monthly income estimates in cells B5 and B6. Use an absolute cell reference 6. In row 26, calculate the couple's monthly income 7. In row 37, enter formulas to calculate the total estimated expenses for each month. 8. In row 38, calculate each month's net cash flow, which is equat to the total income minus the total expenses. 9, In row 39, calculate the running total of the net cash flow so that Olivia and Juan can see how their net cash flow changes as the year progresses 10. in the range B10B19, calculate the average monthly expenses by category based on the values previously entered in rows 27 through 36. 1. In cell 820, calculate the totaf average monthly expenses. 2. The couple currently has $7,350 in their savings account. Each month the couple will either take their savings account or deposit money. In row 41, calculate the end-of-month balance in their savings account by adding the value in cell E5 to the running total values of the net cash flow in row 39. Use an absolute cell reference for cell E5 In cell E6, enter a formula to display the value of the savings balance at the end of December. Juan and Olivia would like to have $15,000 in their savings account by the end of the year Olivia is planning to ask for a raise at her job. Use Goal Seek to determine the value of cell B6 that will achieve a final savings balance of $15,000 Save and close the workbook. PAGE Ex 18 4-185