Question

Please prepare a cash flow statement for this current month for your client Julia using Excel spreadsheet.

Total income - 2 points

Total expenses - 2.5 points

Net cash flow - 0.5 point

Julia, a 26-year-old graduate student in Visual Arts and Design major, has been paying off her bills on time. She owns a condo with down payment paid off using the inherited money from her grandparents. Her uncle helped her with some investments in stocks and mutual funds. Julia starts worrying about her financial situation, because she will graduate next year and needs to save for her doctoral studies in France. You, as one of her best friends in town and just learned financial statement analysis, were asked to help Julia check her current financial position. After a short discussion, Julia provided the following information for her last month's income and expenses.

Income As a Graduate Assistant	$1800
Income As A Painting Teacher	$800
Investment Income	$200
Utility	$265
Clothing	$120
Auto Insurance Premium	$25
Homeowners Insurance Premium	$25
Netflix	$10
Spotify	$10
Food/Groceries	$250
Dining Out	$120
Gym Membership	$25
Medical Expenses (Out of Pocket)	$40
Friends Birthday Gift	$50
Car Maintenance	$40
Gas	$40
On Campus Parking	$21

Answer 1

We shall calculate the Net cash flow as below .

Particulars	Amount
Income
Income As a Graduate Assistant	$1,800
Income As A Painting Teacher	$800
Investment Income	$200
Total Income	$2,800
Expenses
Utility	$265
Clothing	$120
Auto Insurance Premium	$25
Homeowners Insurance Premium	$25
Netflix	$10
Spotify	$10
Food/Groceries	$250
Dining Out	$120
Gym Membership	$25
Medical Expenses (Out of Pocket)	$40
Friends Birthday Gift	$50
Car Maintenance	$40
Gas	$40
On Campus Parking	$21
Total Expenses	$1,041
Net cash flow ( Total Income - Total cash flow)	$1,759