Question
1. 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
1. 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. (I wanted to check if I did this correctly, so please notify me if I did)
2. 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. (I need help with this, I don't know how to start this.)
3. In the range B10:B19, calculate the average monhly expenses by category based on the values previously entered in rows 27 through 36. (Do I use the command =average?)
1 Hernandez Family Budget 3Monthly Income Statement 4 Income 6 Olivia's Salar Caiounrautae $ 7,350 5.500 Expenses Food nsurance Tuition 17 Books & Supplie $ Miscellaneous $ 5.007 23 Income & Epenses 2,350 3 2,350 3 2,350 2,350 2,350 3 2,350 3 2,350 3 2,350 3 2,350 3 2,350 3 2,350 3 2,350 3 825 855 Car Payments 425 425 425 520 Books & S 2,450 625 320 1,200 420 10,557 Net Cash Flo -5,057 2,529 2,570 250 3,080 1,942 2,420 250 3.340 2,930 3,558 11,976 1,325 -6,476 3.347 3,735 1,765 3,890 Running TotalStep 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