Option #1: The Accounting Cycle and Stockholders Equity Analysis

Portfolio Project Option #1 is for accounting students who are sensing learners, and learn best from concrete materials and examples. If this is your learning style preference, you are practical and careful with detail. For this assignment, you are required to complete all three accounting cases: Arizona Consultants Inc., Power and Demolition Company, and Warnerwood. You will then present Parts 1, 2, and 3 of the Portfolio Project in Excel as journal entries, following the exact instructions that accompany each part.

Assignment Template attached below

Part 1:

Arizona Consultants, Inc. opened in March and completed the following transactions:

March 1: Arizona Consultants Inc. issued 17,200 shares of $10 par value capital stock for $150,000 cash and equipment with fair market value of $22,000.

March 2: Arizona Consultants Inc. pre-paid $6,000 cash or six months rent for their office.

March 3: Arizona Consultants Inc. made credit purchases for office equipment for $3,000 and office supplies for $1,200. Payment is due within 10 days.

March 6: Arizona Consultants Inc. completed services for a client and immediately received $4,000 cash.

March 9: Arizona Consultants Inc. completed a $7,500 project for a client who must pay within 30 days.

March 12: Arizona Consultants Inc. paid $4,200 cash to settle the account payable created on March 3.

March 19: Arizona Consultants Inc. paid a $5,000 cash premium on a 12-month insurance policy.

March 22: Arizona Consultants Inc. received $3,500 cash as a partial payment for the work completed on March 9.

March 25: Arizona Consultants Inc. completed work for another client for $3,820 on credit.

March 29: Arizona Consultants Inc. declared dividends of $5,000 to its shareholders on record. Dividends were paid in cash the following day.

March 30: Arizona Consultants Inc. purchased $600 of additional office supplies on credit.

March 31: Arizona Consultants Inc. paid $500 cash for this months utility bill.

Instructions:

Using the following template, prepare journal entries for the above economic transactions. Enter your journals to the general ledger using the same file name. The following accounts should be used in recording your transactions: cash, accounts receivable, prepaid rent, office equipment, capital stock, prepaid insurance, office supplies, accounts payable, consulting revenue, dividends, and utility expense.

Journal Entries Template for Arizona Consultants Inc.

*Note: To edit the template, you have two options:

Edit in Google docs 1) Click "File" > "Make a Copy" Download as an Excel file 1) Click "File" > "Download as" > Microsoft Excel (.xlsx)

Part 2:

The following unadjusted trial balance is for Montana Construction Company as of year-end for the December 31, 20x7 fiscal year. The December 31, 20x6 credit balance of the stockholders equity account is $46,900, and the stockholders invested $40,000 cash in the company during 20x7.

NO. Account Title Debit Credit

101 Cash $7,000

126 Supplies $16,000

128 Pre-paid insurance $12,600

167 Equipment $200,000

168 Accumulated depreciation equipment $14,000

201 Accounts payable $6,800

251 Long-term notes payable $30,000

301 Stockholders equity $86,900

302 Dividends $12,000

401 Demolition fees earned $187,000

623 Wage expense $41,400

633 Interest expense $3,300

640 Rent expense $13,200

683 Property tax expense $9,700

684 Repairs expense $4,700

690 Utilities expense $4,800

TOTALS $324,700 $324,700

Instructions:

a) Journalize the following adjusting entries as of fiscal year-end December 31, 20x7.

b) Using the worksheet, post the adjusting entries using the adjustments column and prepare the adjusted trial balance.

c) Create financial statements. Namely, i) the income statement, ii) statement of stockholders equity, and iii) the balance sheet for 20x7.

Adjustments needed:

The supplies available at the end of fiscal 20x7 year are at a cost of $7,900.

The cost of expired insurance for the fiscal year is $10,600.

Annual depreciation on equipment is $7,000; no other depreciation adjustment was made in 20x7.

The December utilities expense of $800 is not included in the adjusted trial balance because the bill arrived after the trial balance was prepared. The $800 amount owed needs to be recorded.

The company's employees have earned $2000 in accrued wages for the fiscal year.

The rent expense not yet paid or recorded in the fiscal year is $3000.

Additional property taxes of $550 have been assessed for the fiscal year, but have not yet been paid or recorded in the accounts.

The $300 accrued interest for December has not yet been paid and reported.

	Montana Construction Co, Adjustment December 31, 20X7
Adjust #	Account Names			Debit	Credit
1
2
3
4
5
6
7
8
	Montana Construction Co, Adjustment December 31, 20X7					Continued
			UTB		ADJUSTMENT		ATB
Acct #	Account Names		Debit	Credit	Debit	Credit	Debit	Credit
	TOTALS
BE SURE TO CREATE A FINANCIAL STATEMENT FROM THE ABOVE ATB

ACT300 Principles of Accounting I
Module 8: Portfolio Project Template Option #1, Part 2											BE SURE TO CREATE A FINANCIAL STATEMENTS FROM THE ADJUSTED TRIAL BALANCE
Montana Construction Company
Montana Construction Co, Adjustments December 31, 20X7											[Company Name]
Adjust #	Account Names		Debit	Credit							Income Statement
1											[date]
2
											Revenues:
3											List names								$ -
4											Expenses:
											List names				0
5															0
															0
6															0
															0
7															0
															0
8											Total expenses								$ -
											Net income								-
Montana Construction Co, Adjustments December 31, 20X7
		Unadjusted Trial Balance		Adjustments		Adjusted Trial Balance
Acct #	Account Names	Debit	Credit	Debit	Credit	Debit	Credit
101	Cash	$7,000
126	Supplies	$16,000
128	Prepaid insurance	$12,600									[Company Name]
167	Equipment	$200,000									Statement of Stockholders' Equity
168	Accumulated depreciation - equipment		$14,000								[date]
201	Accounts payable		$6,800
251	Long-term notes payable		$30,000
301	Stockholders' equity		$86,900
302	Dividends	$12,000									Stockholders' Equity, [date]								$ -
401	Demolition fees earned		$187,000								Plus: Additional shareholder investment						0
623	Wage expense	$41,400									Net income						0
633	Interest expense	$3,300
640	Rent expense	$13,200									Less: Dividends								$ -
683	Property tax expense	$9,700									Stockholders' Equity, [date]								$ -
684	Repair expense	$4,700
690	Utilities expense	$4,800
											[Company Name]
											Balance Sheet
	TOTALS	$324,700	$324,700	$0	$0	$0	$0				[Date]
												Assets						Liabilities & Stockholders' Equity
														$ -								$ -
														-								-
														-								-
														-			Total Liabilities					-
														-
																						$ -
																						-
																	Total stockholders' equity					$ -
											Total Assets			$ -			Total liabilities and stockholders' equity					$ -