eBook Show Me How

Question Content Area

Financial Statements from the End$-$of$-$Period Spreadsheet

Demo Consulting is a consulting firm owned and operated by Jesse Flatt. The following end$-$of$-$period spreadsheet was prepared for the year ended August $31,20$Y$9$:

Demo Consulting

End$-$of$-$Period Spreadsheet

For the Year Ended March $31,20$Y$9$

Account Title Unadjusted

Trial Balance

Dr$.$ Unadjusted

Trial Balance

Cr$.$ Adjustments

Dr$.$ Adjustments

Cr$.$ Adjusted

Trial Balance

Dr$.$ Adjusted

Trial Balance

Cr$.$

Cash $8,9208,920$

Accounts Receivable $21,23021,230$

Supplies $2,2501,890360$

Land $18,26018,260$

Office Equipment $17,20017,200$

Accumulated Depreciation $2,3601,1303,490$

Accounts Payable $5,7305,730$

Salaries Payable $280280$

Common Stock $7,1007,100$

Retained Earnings $14,55014,550$

Dividends $2,7602,760$

Fees Earned $58,08058,080$

Salary Expense $15,50028015,780$

Supplies Expense $1,8901,890$

Depreciation Expense $1,1301,130$

Miscellaneous Expense $1,7001,700$

$87,82087,8203,3003,30089,23089,230$

Question Content Area

Based on the preceding spreadsheet, prepare an income statement for Demo Consulting.

Demo Consulting

Income Statement

For the Year Ended August $31,20$Y$9$

$$-$ Select $-$

Expenses:

$$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

Total expenses fill in the blank ad$781$cfecf$8$aff$5\_11$

$$-$ Select $-$

Question Content Area

Based on the preceding spreadsheet, prepare a statement of stockholders$$ equity for Demo Consulting. During the year ended August $31,20$Y$9,$ $$2,800$ of additional common stock was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign.

Demo Consulting

Statement of Stockholders$$ Equity

For the Year Ended August $31,20$Y$9$

blank Common Stock Retained Earnings Total

$$-$ Select $-$

$$-$ Select $-$

$$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$-$ Select $-$

$$-$ Select $-$

$$-$ Select $-$

$$-$ Select $-$

Question Content Area

Based on the preceding spreadsheet, prepare a balance sheet for Demo Consulting.

Demo Consulting

Balance Sheet

August $31,20$Y$9$

Assets

Current assets: blank

blank $$-$ Select $-$

blank $-$ Select $-$

blank $-$ Select $-$

Total current assets blank $fill in the blank ae$80220$e$2054$fdb$\_7$

Property, plant, and equipment: blank

blank $$-$ Select $-$

blank

$$-$ Select $-$

blank

$-$ Select $-$

blank

blank $-$ Select $-$

blank

Total property, plant, and equipment blank fill in the blank ae$80220$e$2054$fdb$\_16$

Total assets blank $fill in the blank ae$80220$e$2054$fdb$\_17$

Liabilities

Current liabilities: blank

blank $$-$ Select $-$

blank $-$ Select $-$

Total liabilities blank $fill in the blank ae$80220$e$2054$fdb$\_22$

Stockholders' Equity

blank $$-$ Select $-$

blank $-$ Select $-$

Total stockholders' equity blank fill in the blank ae$80220$e$2054$fdb$\_27$

Total liabilities and stockholders' equity blank $fill in the blank ae$80220$e$2054$fdb$\_28$