Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 B2-B5 total should be placed to B6. Do the same for C with totals C6 up to M6 3. Income 1-3 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 B19-M19 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started