PART B Excel Refresher template provided 1. Create a 12-month family projected budget that reflex income and expenses. 2. Add totals, For the first total it should include B2B5 total should be placed to B6. Do the same for C with totals C6 up to M6 3. Income 13 should be 2,000 each for all months 4. Expenses should be the same for all months 5. Calculate totals for B8-B12 total should be placed in B13 do the same for February expenses up to December. 6. Calculate subtotal variable mandatory cost B19M19 using cost of B15 through B18. All cost should be the same for now. 7. Calculate subtotal variable msic cost for January expenses B27 use B22-B26 to calculate total for B27 do the same for February - December 8. Calculate ending balance by adding total expenses and total income. 9. Beginning balance starting February each month beginning balance should be the previous month ending balance. 10. Prepare a 12-month cash flow spreadsheet to record actual income and expense budget. Part C 1. Assume gas cost is going up 1% every month starting February 2. Assume electrical cost is going up 2% every month starting March 3. Assume income goes up in July by 25% 4. Assume other travel supplies etc goes down 3% starting July Answer the below questions after making the changes above by highlighting in yellow on the spreadsheet and answering it below. 5. What is the ending balance at the end of December? 6. In what month does ending balance become positive 7. What month is the lowest ending balance? 8. Which month shows the highest positive begging balance PART B Excel Refresher template provided 1. Create a 12-month family projected budget that reflex income and expenses. 2. Add totals, For the first total it should include B2B5 total should be placed to B6. Do the same for C with totals C6 up to M6 3. Income 13 should be 2,000 each for all months 4. Expenses should be the same for all months 5. Calculate totals for B8-B12 total should be placed in B13 do the same for February expenses up to December. 6. Calculate subtotal variable mandatory cost B19M19 using cost of B15 through B18. All cost should be the same for now. 7. Calculate subtotal variable msic cost for January expenses B27 use B22-B26 to calculate total for B27 do the same for February - December 8. Calculate ending balance by adding total expenses and total income. 9. Beginning balance starting February each month beginning balance should be the previous month ending balance. 10. Prepare a 12-month cash flow spreadsheet to record actual income and expense budget. Part C 1. Assume gas cost is going up 1% every month starting February 2. Assume electrical cost is going up 2% every month starting March 3. Assume income goes up in July by 25% 4. Assume other travel supplies etc goes down 3% starting July Answer the below questions after making the changes above by highlighting in yellow on the spreadsheet and answering it below. 5. What is the ending balance at the end of December? 6. In what month does ending balance become positive 7. What month is the lowest ending balance? 8. Which month shows the highest positive begging balance