Business Finance Homework Help

California State University Northridge Business Personal Budget Worksheet

 

Your job is to create a personal budget from scratch. This should include all income and all expense that you currently have, and should be for 12 months. It should show the differences in income and expenses, based on seasonality and expectations regarding COVID 19.

Some expenses to consider are:

FIXED EXPENSES like

 Rent/Mortgage (payment per month)

 Renters Insurance (payment per month)

 Automobile (monthly payment)

 Auto Insurance (monthly payment)  Health insurance (monthly payment)

 Credit Card

 Student loans (monthly payment if applicable)

 Long Term Savings

 Emergency

VARIABLE EXPENSES like

 Food (groceries, restaurants, snacks)

 phone

 cell phone

 electricity

 clothing

 entertainment (movies, video rental, sporting events)

 haircuts

 vacations

 gas (car)

 cable tv

 vacation

INCOME like

 money from work

 money from interest or investments

 money from your parents

 money from school loans

This should be calculated in a spreadsheet like Microsoft Excel or Google sheets. Simple formulas must be created to find total fixed expenses, total variable expenses, total expenses, and total income. You must upload a pdf file for submission.

*Please note that it should be very detailed and show seasonality and variances month to month to reflect real life.