Assessment 1 is an individual assessment that provides a foundational tool in personal finance. It also allows you to reflect on your behaviour and provides an opportunity to comment on ways to improve. This exercise will cover over four weeks and students are encouraged to commence as soon as the semester begins.
Objective: Record personal expenses over four (4) weeks and prepare a cash flow statement (for the month) as a tool for reflective assessment of personal spending habits.
You are to record your daily expenses over four weeks in an excel spreadsheet or any relevant budgeting application. The categories must include the following:
Date | Item | Amount | Description | Classification |
01/02/2023 | Pizza | $6.95 | Meals | Discretionary |
03/02/2023 | Telstra | $49.95 | Phone bill | Non-discretionary |
You should have at least 10 different description categories (e.g. holidays, meals, Petrol, etc.) but no more than 20. More categories would provide better insight to your spending habits. Your expenses should be presented in a pie chart and summary table as follows (example),
Row Labels | Amt ($) | % |
Travel & Holidays | 19,823 | 33% |
House | 9,144 | 15% |
Insurance | 6,536 | 11% |
Car maintenance | 6,251 | 10% |
Groceries | 4,295 | 7% |
Meals & Alcohol | 3,399 | 6% |
Mobile & Phone | 3,169 | 5% |
Petrol | 2,648 | 4% |
Foxtel & iTunes | 1,223 | 2% |
Internet | 1,068 | 2% |
Work & Education | 730 | 1% |
Dental | 708 | 1% |
Recreation | 675 | 1% |
Taxi | 594 | 1% |
ATM Fees | 229 | 0% |
Grand Total | 60,491 |
Discretionary | 43% |
Non‐ discretionary | 57% |
You are only recording your expenses for the month. However, you may multiply this by 12 months to give you a projected spending for the year. This may make it easier for you to ascertain your surplus/deficit position.
You should include three components in your report. First, the pie chart and summary table as above (please attach your original expense record either from your excel spreadsheet or data collection tool as an appendix); Second, the personal cash flow statement (please refer to Lecture 3 for more details); Third, an analysis of your personal cash flow statement (500 words). Your analysis should cover a discussion of your surplus/deficit position, nature of your major expenses, your experience of the exercise and your strategy for improving your cash flow position.
You do not need to record your income. However, to determine your surplus/deficit position, you will need an estimation. For some students, this may be income from your job or for others, allowance from parents.
Our Academic Assistance: service is all about doing research and being good at it. The more research one will do, the better the paper will turn out.
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services