accounting project

CH9BAliM.Excel.xlsx

Home >Business & Finance homework help >Accounting homework help >accounting project

Decisions

Decision Entry - All decisions are effective January 1st of the current year
	YEAR 1				YEAR 2				YEAR 3				YEAR 4				YEAR 5
Period =			Monthly	Annual			Monthly	Annual			Monthly	Annual			Monthly	Annual			Monthly	Annual
		Annual Salary		14		Annual Salary		14		Annual Salary		15		Annual Salary		15		Annual Salary		15
	Apartment Rental				Apartment Rental
	Sq. Ft.	813			Sq. Ft.	813
	Rent @1.25/sf		1,016	12,195	Rent		1,037	12,439
	Insurance		12	146	Insurance		12	149
	Utilities		163	1,951	Utilities		166	1,990
	Furniture Purchase 1				Furniture Purchase 1				Furniture Purchase 1				Furniture Purchase 1				Furniture Purchase 1
	Price		1,000		Balance		895		Balance		702		Balance		490		Balance		257
	Sales Tax		70
					Down Pmnt				Down Pmnt				Down Pmnt				Down Pmnt
	IR		10%		IR		10%		IR		10%		IR		10%		IR		10%
	Years		5		Years		5		Years		5		Years		5		Years		5
	PMT			282	PMT			282	PMT			282	PMT			282	PMT		63	282
	Year 1 Principal Balance				Year 2 Principal Balance				Year 3 Principal Balance				Year 4 Principal Balance				Year 5 Principal Balance
		Pd	175			Pd	193			Pd	212			Pd	233			Pd	257
		Bal	895			Bal	702			Bal	490			Bal	257			Bal	0
					Auto Purchase				Auto Purchase				Auto Purchase				Auto Purchase
					Price				Balance		0		Balance		0		Balance		0
					Tax, Title, Reg.		0
					Down Pmnt				Down Pmnt				Down Pmnt				Down Pmnt
					IR		6.5%		IR		6.5%		IR		6.5%		IR		6.5%
					Years		5		Years		5		Years		5		Years		5
					PMT			0	PMT			0	PMT			0	PMT			0
					Year 1 Principal Balance				Year 2 Principal Balance				Year 3 Principal Balance				Year 4 Principal Balance
						Pd	0			Pd	0			Pd	0			Pd	0
						Bal	0			Bal	0			Bal	0			Bal	0
									Home Purchase				Home Purchase				Home Purchase
									Price				Balance		0		Balance		0
									Sq. Ft.
									Down Payment @ 3%		0
									Closing Costs @ 1.5%		0		Down Pmnt				Down Pmnt
									PMT (30 [email protected]%)		0	0	PMT		0	0	PMT		0	0
									Year 1 Interest Paid		0		Year 2 Interest Paid		0		Year 3 Interest Paid		0
									Year 1 Principal Balance				Year 2 Principal Balance				Year 3 Principal Balance
										Pd	0			Pd	0			Pd	0
										Bal	0			Bal	0			Bal	0
									Furniture Purchase 2				Furniture Purchase 2				Furniture Purchase 2
									Price				Balance		0		Balance		0
									Sales Tax		0
													Down Pmnt				Down Pmnt
									IR		10%		IR		10%		IR		10%
						`			Years		5		Years		5		Years		5
									PMT			0	PMT			0	PMT			0
									Year 1 Principal Balance				Year 2 Principal Balance				Year 3 Principal Balance
										Pd	0			Pd	0			Pd	0
										Bal	0			Bal	0			Bal	0

Income Statements

Income Statement Year 1						Year 2			Year 3			Year 4			Year 5
Income Statements in U.S. Dollars as of December 31st
Revenue
	Salary/Wages			$ 14			$ 14			$ 15			$ 15			$ 15
	Gross Income				$ 14			$ 14			$ 15			$ 15			$ 15
Expenses
	Payroll Taxes
		SSA @ 6.2%		$ 1			$ 1			$ 1			$ 1			$ 1
		Medicare @ 1.4%		$ 0			$ 0			$ 0			$ 0			$ 0
	Transportation:
	Public/Uber/Other (Monthly)			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
	Car Purchase:	Payment					$ - 0			$ - 0			$ - 0			$ - 0
		Insurance (Monthly)					$ - 0			$ - 0			$ - 0			$ - 0
		Maintenance/Gas/Repairs					$ - 0			$ - 0			$ - 0			$ - 0
	401K Savings			$ 1			$ 1			$ 1			$ 1			$ 1
	Medical Insurance			$ 1			$ 1			$ 1			$ 1			$ 1
	Furnishings 1 Payment			$ 282			$ 282			$ 282			$ 282			$ 282
	Furnishings 2 Payment									$ - 0			$ - 0			$ - 0
	Rent/Mortgage Payment			$ 12,195			$ 12,439			$ - 0			$ - 0			$ - 0
	Renters'/Homeowner's Insurance			$ 488			$ 498			$ - 0			$ - 0			$ - 0
	Property Tax									$ - 0			$ - 0			$ - 0
	Food/Household Supplies (Monthly)			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
	Telephone/Wifi/Cable		$ 150	$ 1,800			$ 1,836			$ 1,873			$ 1,910			$ 1,948
	Travel/Entertainment									$ - 0
	Utilities			$ 2,033			$ 2,073			$ - 0			$ - 0			$ - 0
	Down Payment/Principal Payments						$ - 0			$ - 0			$ - 0			$ - 0
	Federal Income Tax																	`
		Gross Income	$ 14			$ 14			$ 15			$ 15			$ 15
		Standard Deduction	$ 6,350			$ 6,477			$ 6,607			$ 6,739			$ 6,873
		Mortgage Int. Ded.							$ - 0			$ - 0			$ - 0
		Prop. Tax Deduction							$ - 0			$ - 0			$ - 0
		401 K Savings Deduction	$ 1			$ 1			$ 1			$ 1			$ 1
		Adjusted Gross Income	$ (6,337)			$ (6,463)			$ (6,592)			$ (6,724)			$ (6,859)
		Net Tax	$ (5,845)	$ (5,845)		$ (5,995)	$ (5,995)		$ (6,028)	$ (6,028)		$ (6,061)	$ (6,061)		$ (6,095)	$ (6,095)
	Total Expenses				$ 10,955			$ 11,136			$ (3,870)			$ (3,866)			$ (3,862)
	Net Income				$ (10,941)			$ (11,122)			$ 3,885			$ 3,881			$ 3,877
Other Income
	Employer 401K Match			$ 1			$ 1			$ 1			$ 1			$ 1
	Total Other Income				$ 1			$ 1			$ 1			$ 1			$ 1
	Net Income (Loss)				$ (10,940)			$ (11,121)			$ 3,885			$ 3,882			$ 3,878

Balance Sheet

Balance Sheets
Balance Sheets as of December 31st	Year 1	Year 2	Year 3	Year 4	Year 5
Current Assets
Cash Balance	$ (10,941)	$ (22,062)	$ (18,178)	$ (14,297)	$ (10,419)
401K Balance	$ 1	$ 3	$ 3	$ 4	$ 5
Total	$ (10,940)	$ (22,059)	$ (18,174)	$ (14,293)	$ (10,414)
Fixed Assets
Home			$ - 0	$ - 0	$ - 0
Car		$ - 0	$ - 0	$ - 0	$ - 0
Furniture	$ 1,000	$ 1,000	$ 1,000	$ 1,000	$ 1,000
Less accumulated depreciation (Negative Value)	$ (100)	$ (150)	$ (150)	$ (150)	$ (150)
Total	$ 900	$ 850	$ 850	$ 850	$ 850
Total Assets	$ (10,040)	$ (21,209)	$ (17,324)	$ (13,443)	$ (9,564)
Current Liabilities (Next 12 Months)
Current Portion of Long Term Debt	$ 282	$ 282	$ 282	$ 282	$ - 0
Other
Total Current Liabilities	$ 282	$ 282	$ 282	$ 282	$ - 0
Long-term Liabilities
Mortgage payable	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Auto	$ 175	$ - 0	$ - 0	$ - 0	$ - 0
Furniture	$ 895	$ 702	$ 490	$ 257	$ - 0
Total Long-term Liabilities	$ 1,070	$ 702	$ 490	$ 257	$ - 0
Total Liabilities	$ 1,352	$ 984	$ 772	$ 539	$ - 0
Owner's Net Worth	$ (11,392)	$ (22,194)	$ (18,097)	$ (13,982)	$ (9,564)

Variables

_Example	FALSE
_Shading	FALSE
_Series	OfficeReady 3.0
_Look	1