business HW

chap02_spreadsheet.xls

Home >Business & Finance homework help >Management homework help >business HW

CashFlow

Type Your Name Here	Cash Flow Statement
INCOME	Monthly	Annually
Employment	$ 2,500	$ 30,000
Other Income	500	6,000
Gross Income	$ 3,000	$ 36,000
EXPENSES			Note: There are two required sheets, this sheet,
			the cash flow statement, and the next sheet, the
Income Taxes (Fed & CA)	$ 350	$ 4,200	net worth statement. Do not just submit the cash
			cash flow statement! Look at the bottom of the
Household			page. Do you see the tab marked [NetWorth]?
Rent/Mortgage	650	7,800	Click on it after you are done with the cash flow
Gas/Electric	35	420	statement on this sheet. Submit both the cash
Phone	65	780	statement and the net worth statement.
Cable	35	420
Food	400	4,800	It is common for
Clothing	50	600	many students to simply submit the cash flow
Medical	25	300	statement without the net worth statement.
Other 1 (overwrite name)	25	300
Miscellaneous	100	1,200	The [Monthly] and [Yearly] sheets are for your own
Total Household	$ 1,385	$ 16,620	usage. They are not required. Again, please watch
			the presentation as it will explain everything about
Automobile			how to use this spreadsheet.
Car	175	2,100
Gas	125	1,500
Insurance	80	960
Maintenance	100	1,200
Other 1	10	120
Registration	15	180
Total Automobile	$ 505	$ 6,060
Liabilities
Loan 1 Payment (overwrite name of loan)	50	600
Credit Card 1 Payment (overwrite name)	30	360
Other Loan 1 Payment (overwrite name)	50	600
Total Liabilities	$ 130	$ 1,560
Personal
Personal 1 (example: Gym, overwrite name)	25	300
Personal 2 (overwrite name)	25	300
Hair Care	20	240
Beauty	20	240
Entertainment	80	960
Total Personal	170	2,040
Insurance
Life	25	300
Disability	25	300
Medical	25	300
Renter's / Homeowner's	25	300
Total Insurance	$ 100	$ 1,200
Savings	$ 25	$ 300
Retirement
Social Security / Medicare	230	2,754
Retirement 1 (example: 401k, overwrite name)	50	600
Retirement 2 (example: Roth IRA, overwrite name)	50	600
Total Retirement	$ 330	$ 3,954
Total Income	$ 3,000	$ 36,000
Total Expenses	2,995	35,934
Discretionary / (Shortfall)	$ 6	$ 66

NetWorth

Type Your Name Here	Net Worth Statement
Assets
Real Estate
Condominium or House	$ 215,000
Total Real Estate	215,000	215,000
Autos
Auto 1 Market Value (overwrite name of car)	9,000
Auto 2 Market Value (overwrite name of car)	5,500
Total Autos	14,500	14,500
Other
Furniture Market Value	4,000
Computers	1,000
Other 1 (overwrite name of other asset)	900
Other 2 (overwrite name of other asset)	- 0
Miscellaneous	4,000
Total Other	9,900	9,900
Cash and Investments
Checking Account	600
Savings Account	1,200
Investment 1 (overwrite name of investment)	- 0
Investment 2 (overwrite name of investment)	- 0
Total Investments	1,800	1,800
Retirement
Retirement 1 (example: 401k, overwrite name)	2,300
Retirement 2 (example: Roth IRA, overwrite name)	1,450
Retirement 3 (example: Pension plan, overwrite name)	- 0
Total Retirement	3,750	3,750
	Total Assets	$ 244,950	$ 244,950
Liabilities
Mortgages
1st Mortgage on Condominum or House	185,000
2nd Mortgage (a.k.a. HELOC)	15,000
Total Mortgages	200,000	200,000
Personal
Credit Card 1 Balance (enter name of card)	3,200
Credit Card 2 Balance (enter name of card)	1,200
Student Loan Balance	1,200
Furniture Loan Balance	- 0
Total Personal	5,600	5,600
Auto Loans
Auto 1 Balance (overwrite name of car)	11,000
Auto 2 Balance (overwrite name of car)	2,000
Total Auto Loans	13,000	13,000
	Total Liabilities	$ 218,600	$ 218,600
Assets - Liabilities = Net Worth			$ 26,350

Monthly

Type Your Name Here	Monthly Budget			Month/Year: ____________
INCOME	Budgeted	Actual	Variance	Notes:
Employment	$ 2,500		$ (2,500)
Other Income	500		(500)
Gross Income	$ 3,000	$ - 0	$ (3,000)
EXPENSES
Income Taxes (Fed & CA)	$ 350		$ (350)
Household
Rent/Mortgage	650		(650)
Gas/Electric	35		(35)
Phone	65		(65)
Cable	35		(35)
Food	400		(400)
Clothing	50		(50)
Medical	25		(25)
Other 1	25		(25)
Miscellaneous	100		(100)
Total Household	$ 1,385	$ - 0	$ (1,385)
Automobile
Car	175		(175)
Gas	125		(125)
Insurance	80		(80)
Maintenance	100		(100)
Other 1	10		(10)
Registration	15		(15)
Total Automobile	$ 505	$ - 0	$ (505)
Liabilities
Loan 1 Payment	50		(50)
Credit Card 1 Payment	30		(30)
Other Loan 1 Payment	50		(50)
Total Liabilities	$ 130	$ - 0	$ (130)
Personal
Personal 1	25		(25)
Personal 2	25		(25)
Hair Care	20		(20)
Beauty	20		(20)
Entertainment	80		(80)
Total Personal	170	- 0	(170)
Insurance
Life	25		(25)
Disability	25		(25)
Medical	25		(25)
Renter's / Homeowner's	25		(25)
Total Insurance	$ 100	$ - 0	$ (100)
Savings	$ 25		$ - 0
Retirement
Social Security / Medicare	224		(224)
Retirement 1 (401k)	50		(50)
Retirement 2 (Roth IRA)	50		(50)
Total Retirement	$ 324	$ - 0	$ (324)
Total Income	$ 3,000	$ - 0	$ (3,000)
Total Expenses	2,989	- 0	(2,989)
Discretionary / (Shortfall)	$ 12	$ - 0	$ (12)

Yearly

Type Your Name Here	Yearly Budget						Year: ________
INCOME	Budget	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Employment	$ 2,500	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Income	500	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Gross Income	$ 3,000	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EXPENSES
Income Taxes (Fed & CA)	$ 350	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Household
Rent/Mortgage	650	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Gas/Electric	35	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Phone	65	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Cable	35	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Food	400	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Clothing	50	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Medical	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other 1	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Miscellaneous	100	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Household	$ 1,385	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Automobile
Car	175	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Gas	125	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Insurance	80	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Maintenance	100	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other 1	10	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Registration	15	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Automobile	$ 505	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Liabilities
Loan 1 Payment	50	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Credit Card 1 Payment	30	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Loan 1 Payment	50	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Liabilities	$ 130	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Personal
Personal 1	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Personal 2	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Hair Care	20	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Beauty	20	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Entertainment	80	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Personal	$ 170	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Insurance
Life	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Disability	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Medical	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Renter's / Homeowner's	25	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Insurance	$ 100	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Savings	$ 25	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Retirement
Social Security / Medicare	224	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Retirement 1	50	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Retirement 2	50	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Retirement	$ 324	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Income	$ 3,000	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Expenses	2,989	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Discretionary / (Shortfall)	$ 12	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0