Fill in the excel sheets

Consulting Company Inc.
Accounting Equation for 2016
	Statement of Cash Flows O = Operating I = Investing F = Financing	Assets						=	Liabilities					+	Stockholder's Equity			Income Statement
Event		Cash	Accounts Receivable	Prepaid Rent	Land	Building	Accum. Depreciation	=	Accounts Payable	Salaires Payable	Unearned Revenue	Accrued Interest Payable	Bank Note Payable	+	Common Stock	Retained Earnings		Consulting Revenue	Consulting Expenses	Other Operating Expense	Salary Expense	Interest Expense	Rent Expense	Depreciation Expense	Net Income
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13
14
15
16
17
Net Income																-
Totals		0	0	0	0	0	0		0	0	0	0	0		0	0		0	0	0	0	0	0	0	0
	Total Assets				$ -			Total Liabilities + Equity							$ -
													Tip: Remember to input expenses as positive numbers

ACCT 205 Horizontal Model - Spring 2017 Adjusting Entry Calculations
Calculation of Rent expense:
Prepaid Rent date				Prepaid Rent /12 = Monthly Rent
Financial Statement date 12/31/16				Monthly Rent x # months = Rent expense
Number of months of rent used = # months
Calculation of Depreciation expense & Accumulated depreciation:
Building Cost at beginning of year					Input Cost
Estimated Salvage value					-
Balance subject to depreciation					Balance
Depreciation expense = Balance / Years to depreciate = Annual Depreciation Expense per year
Calculation of Interest Expense on Note Payable:
Note Payable date				Principal x Interest Rate X months/12 months
Financial Statement date 12/31/16
Number of months of interest incurred

Required: Prepare an Income Statement, Statement of Retained Earnings, Balance Sheet and Statement of Cash Flows for 2016. Fill in statements with the amounts for the specificate acounts i.e. Salaries Expense or Cash.
Consulting Company Inc.
Financial Statements
For the Year Ended December 31, 2016
Income Statements
		2016
Revenues:
Consulting Revenue
Expenses:
Consulting Expenses
Other Operating Expense
Salary Expense
Interest Expense
Rent Expense
Depreciation Expense
Total Expenses		-
Net Income		$-
Statement of Changes in Stockholders Equity
		2016
Beginning Common Stock
Issued Common Stock
Ending Common Stock		-
Beginning Retained Earnings
Plus: Net Income
Less: Dividends
Ending Retained Earnings		-
Total Stockholders Equity		$-

Balance Sheet (Fill-in amounts)
		2016
Assets
Cash
Accounts Receivable
Prepaid Rent
Land
Building
Accum. Depreciation
Total Assets		-
Liabilities
Accounts Payable
Salaires Payable
Unearned Revenue
Accrued Interest Payable
Bank Note Payable
Total Liabilities		-
Stockholder's Equity
Common Stock
Retained Earnings
Total Stockholder's Equity		-
Total Liabilities & Stockholder's Equity		$-
Statements of Cash Flows
		2016
Cash Flows from Operating Activities
Cash Received from Customers
Cash Paid for Expenses
Net Cash Flow from Operating Activities		-
Cash Flows from Investing Activities
Cash Paid for Building
Cash Paid for Land
Net Cash Flows from Investing Activities		-
Cash Flows from Financing Activities
Cash from Sale of Stock
Cash from Bank Note
Cash paid for dividends
Net Cash Flows from Financing Activities		-
Net Change in Cash		-
Plus: Beginning Cash Balance
Ending Cash Balance		$-

Transactions: 1. Acquired cash of $154,300 from the issue of common stock. 2. Borrowed $148,000 cash from the bank on July 1, 2016. 3. Paid $160,000 cash to purchase fixed assets land that cost $40,000 and a building that cost $120,000. 4. Earned and recognized consulting revenue on account for $227,000 5. Collected $197,325 on the accounts receivable during the year 6. Incurred $100,000 of consulting expenses on account during the year. 7. Paid $95,000 on the accounts payable during the year. 8. Paid $72,450 cash for other operating expenses during the year. 9. Paid the company owners $4,775 of dividends 10. Received $15,570 cash for services to be performed in the future