Personal Budgeting and Cash Flow Assignment: Financial Accounting Applications

Personal Budgeting and Cash Flow Assignment

Introduction

This assignment simulates a real-world scenario where you, as a recent college graduate, must create a personal budget and cash flow statement for your first six months of employment. The exercise integrates key financial accounting concepts such as income calculation, expense estimation, and cash flow management, providing practical experience in personal financial planning.

Assumptions and Scenario Details

• Employment and Salary: You are employed in Houston, TX, with a starting salary of $70,000 per year before taxes.

• Tax Deductions: Federal Income Tax is 15% and Social Security + Medicare is 7.65%, both deducted from your salary.

• Initial Savings: You have $1,000 in your bank account at the start.

• Housing: You will rent an apartment of your choice for at least 6 months, with rent due on the 1st of each month. You may need to pay a security deposit and other move-in costs.

• Credit Card: You have a credit line of $2,000 with a 19% APR. The minimum monthly payment is $150. You may use the card for purchases but must manage payments responsibly.

• Car Financing: If you purchase a car, you must include the minimum monthly payment in your budget.

• Cash Support: Any cash support from family/friends must be treated as a loan, bearing 6% interest, with monthly interest payments required.

• Other Expenses: You must account for all other living expenses, including food, utilities, insurance, and discretionary spending.

Budgeting Requirements

Cash Inflows and Outflows

• Cash Inflows: Include net salary (after taxes), any loans, and other sources of income.

• Cash Outflows: Include rent, utilities, food, transportation, insurance, credit card payments, and discretionary expenses.

• Budget Table: Prepare a table with 6 months of projected cash inflows and outflows, showing the net cash flow for each month and the cumulative cash balance.

Major Expense Categories

• Housing: Rent, security deposit, renter’s insurance, utilities.

• Transportation: Car payment or public transit, insurance, gas, maintenance.

• Food: Groceries, dining out.

• Personal Items: Furniture, clothing, cleaning supplies.

• Communication: Cell phone, internet.

• Entertainment: Subscriptions, outings, travel.

• Other: Gifts, charitable contributions, miscellaneous.

Sample Budget Table Structure

Month	Cash Inflows	Cash Outflows	Net Cash Flow	Cumulative Cash Balance
1	$X	$Y	$X -$Y	Previous Balance + Net Cash Flow
2	$X	$Y	$X -$Y	Previous Balance + Net Cash Flow

Additional info: Actual values to be calculated based on your assumptions and research.

Key Financial Accounting Concepts

Net Income Calculation

• Gross Salary: $70,000 per year.

• Federal Income Tax: 15% of gross salary.

• Social Security & Medicare: 7.65% of gross salary.

• Net Salary Formula:

$\text{Net Salary} = \text{Gross Salary} - (\text{Federal Income Tax} + \text{Social Security and Medicare})$

Example: For a $70,000 salary: Federal Income Tax = $70,000 \times 0.15 = $10,500$ Social Security & Medicare = $70,000 \times 0.0765 = $5,355$ Net Salary = $70,000 - $10,500 - $5,355 = $54,145$ per year, or $4,512.08 per month.

Credit Card Payments

• Minimum Payment: $150 per month.

• Interest Rate: 19% APR, applied to outstanding balance.

• Interest Calculation Formula:

$\text{Monthly Interest} = \text{Outstanding Balance} \times \frac{19\%}{12}$

Loan Payments

• Interest Rate: 6% per annum for family/friend loans.

• Monthly Interest Formula:

$\text{Monthly Interest} = \text{Loan Amount} \times \frac{6\%}{12}$

Budgeting Process and Documentation

1. Prepare a 6-month cash budget table as described above.

2. List and total all liabilities and assets at the end of the 6th month.

3. Document all assumptions, sources, and rationale for each budgeted item.

4. Provide supporting documentation for major purchases (e.g., price quotes, advertisements).

5. Answer reflective questions about your budgeting process, priorities, and insights.

Reflective Questions

• What were your priorities when allocating your budget?

• How did you determine the amounts for each item?

• What would you do if you had a $2,500 bill due in 30 days?

• What insights or conclusions did you draw from this budgeting exercise?

Summary Table: Major Budget Categories and Examples

Category	Examples
Housing	Rent, Security Deposit, Utilities, Renter’s Insurance
Transportation	Car Payment, Insurance, Gas, Public Transit
Food	Groceries, Dining Out
Personal Items	Furniture, Clothing, Cleaning Supplies
Communication	Cell Phone, Internet
Entertainment	Streaming Services, Outings, Travel
Other	Gifts, Charitable Contributions, Miscellaneous

Conclusion

This assignment provides hands-on experience in applying financial accounting principles to personal budgeting. By preparing a detailed cash budget, documenting assumptions, and reflecting on financial decisions, students gain practical skills essential for both personal and professional financial management.