On the income statement worksheet but below or to the side

Reference no: EM13588106

Creating A Multiple-Step Income Statement and A Balance Sheet

Special Requirements:

1. All numerical cells on statements need to pull from the given info tabs.

2. On the income statement worksheet (but below or to the side of the actual income statement), you need to show EPS and have it be formula driven. Assume no dividends of any kind were paid and that 500 shares of common stock exist.

3. Retained earnings on the balance sheet needs to be formula driven based on the given beginning balance and net income.

5. Your statements will be graded on accuracy as well as formatting! Pretend you are turning this in to a boss.

Here it is:

	Debit Balance	Credit Balance
Cash	$8,600
Accounts receivable	$7,800
Inventory	$530
Prepaid rent	$1,290
Equipment	$64,500
Accumulated depreciation		$12,900
Accounts payable		$6,000
Salaries payable		$1,250
Interest payable		$345
Utilities payable		$300
Notes payable		$11,500
Common stock		$28,000
Retained earnings (beginning balance)		$13,300
Sales Revenue		$44,160
Cost of Goods Sold	$24,050
Interest expense	$345
Rent expense	$3,870
Income Tax Expense	$620
Utilities expense	$1,850
Depreciation expense	$4,300
Totals	$117,755	$117,755

Reference no: EM13588106

Questions Cloud

The gray corporation makes t-shirts and had the following : the gray corporation makes t-shirts and had the following costs related to the production of 1000 shirts direct

Prepare the lower portion of the 2013 income statement : the following are partial income statement account balances taken from the december 31 2013 year-end trial balance of

No animal is able to digest cellulose reconcile this : question no animal is able to digest cellulose. reconcile this statement with the fact that many animals are herbivores

A 01967 g sample of pure ascorbic acid is weighed out and : 1 a 0.1967 g sample of pure ascorbic acid is weighed out and dissolved in 50 ml of distilled water in an erlenmeyer

On the income statement worksheet but below or to the side : creating a multiple-step income statement and a balance sheetspecial requirements1. all numerical cells on statements

These units werefinished and an additional 5000 units were : at the beginning of the recent period there were 900 units ofproduct in a department one-third completed. these units

Deere manufactures heavy equipment it sells equipment to : identify and explain when each of the following companies should recognize revenue.a. the gap is a retailer of

When a 90 g sample of an alloy at 1000 oc is dropped into : question when a 90 g sample of an alloy at 100.0 oc is dropped into 90.0 g of water at 24.6 oc the final temperature is

X ltd purchased assets worth 220000 and also took over the : x ltd. purchased assets worth 220000 and also took over the liabilitescreditors of y ltd. for a purchase consideration

User Account

All Pages