Please I need help to fill this sheet. You can create a new document with just your answers. 2. Your completed spreadsheet file containing TWO sheets - one with the family's current budget and one reflecting your recommendations. Step 1. Investigate the formula embedded in the spreadsheet. look at cell C18. What is the formula for this cell? what does it do.? look at cell 118. what is the formula for this cell? what does it do. look at cell 120. what is the formula for this cell? what does it do? Step 2. Complete the current Budget sheet. Step 3. Make a copy of the current budget sheet. Step 4. Make a new budget for the Jones family. 1. what was the cash flow for the Jones family before your recommended changes? 2. what percentage of their monthly income was dedicated to housing ( include mortgage, property taxes and homeowner insurance) 3. what percent of their monthly income was dedicated to transportation expenses ( include car payment, car taxes, gas, auto insurance) 4. what are your recommended changes to the Jones family budget? be specific, creative but realistic.

2/27/2021 CW3: Family Budgeting Activity - Google Sheets CW3: Family Budgeting Activity WA File Edit View Insert Format Deta Tools Add-ons Help Last edit was made 4 days ago by Heather Seeber 100% Villar only M2 a Jones Family Monthly Budget Monthly Monthly INCOME EXPENSES EXPENSES Miscellaneous Income Home Insurance Salary (D) Cable TV Auto Salary (L) Cellular telephone Health Income Total 0.00 Electricity Homeowner's Home Mortgage Life PAYROLL DEDUCTIONS County Property Taxes Insurance Total Federal Income Tax (D) Internet Transportation FICA Tax (D) Landline telephone Fuel State Income Tax (D) Natural Gas Maintenance/Repairs NP2 Federal Income Tax (L) Water/Sewer/Garbage VA Car Taxes FICA Tax (L) Home Total 0.00 Minivan Payment State Income Tax (L) Daily Living Transportation Total 401-k Retirement Plan Chantable Contributions Payroll Deductions Total 0.00 Clothing Total Expenses Credit Card Payment FAMILY SAVINGS Dining Out Net Monthly Cash Flow Emergency Entertainment Holiday Gifts Groceries Reminder. Medical Dental/Vision Health Club Dues Cash Flow = Income - Deductions - Savir Vacation Household Supplies Family Savings Total 0.00 Children's Activities Miscellaneous Pet Food / Vet bills Daily Living Total 0.00