Question

Randy is an accountant at XYZ Store Co. In January the store had $150,000 in sales, $35,000 in payroll, $20,000 in rent and utilities, and $20,000 in inventory purchased. In February it had $175,000 in sales, $39,000 in payroll, $25,000 in rent and utilities and $45,000 in inventory purchased. Randy has been asked to provide the net cash flow for each of the two months. He also needs to determine the percentage growth of cash flow from January to February. He has asked for your help in calculating these figures.

Starting hint: Determine the percentage growth from January to February by first identifying the net cash flow for each month. Divide the net cash flow in February by the net cash flow in January and subtract the result by 1.

--I know this probably isn't hard, but I've hit a wall and am just too tired, burned-out, and in need of a break to be able to do this. It's due tomorrow so please help! Thanks!

Answer 1

Net cash flow is basically the difference of the cash balance from the beginning of the period to the end of the period. For this instance, we take sales and subtract the listed expenses.

January = 150,000 - 35,000- 20,000 -20,000 = 75,000 net cash flow

February = 175,000 - 39,000 - 25,000 - 45,000 = 66,000 net cash flow

For the change you divide (February/January) -1 or (66,000/75,000)-1= -.12

The growth in cash flow was -12%