Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?)

image text in transcribed

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 Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation Division Department Of Commerce Report On Preliminary Performance Audit Survey

Authors: Montana. Legislature. Office Of The Legi

1st Edition

1245445294, 978-1245445290

More Books

Students also viewed these Accounting questions