Question

Instruction:

Prepare a classified balance sheet, multi-step income statement and statement of

Cash flows for the year ending 12/31/2018

The trial balances for the beginning of the year and End of the year, as well as

Additional information, are provided below.

The name of the company is: Rockford Plumbing Supply, Inc.

	Final (Ending) Trial Balance - 12/31/2018
	Account	Name	Debit	Credit
	101	Cash	431,794
	105	Petty Cash	150
	112	Accounts Receivable	464,550
	113	Allowance for Doubtful Accounts		40,178
	115	Notes Receivable	0
	120	Inventory	569,671
	126	Supplies	3,680
	130	Prepaid Insurance	11,020
	131	Prepaid Rent	25,410
	135	Other Assets	145,000
	140	Land	43,000
	145	Buildings	306,000
	146	Accum. Depr. Buildings		78,040
	151	Equipment	63,900
	152	Accum. Depr. Equipment		21,200
	163	Trucks	60,400
	164	Accum. Depr. Trucks		41,540
	200	Bank Line of Credit		15,000
	201	Accounts Payable		357,600
	214	FICA Taxes Payable		1,530
	215	Income Taxes Payable		125,000
	216	Federal Withholding Taxes Payable		1,967
	218	State Withholding Taxes Payable		2,901
	224	FUTA Taxes Payable		400
	226	SUTA Taxes Payable		2,600
	230	Interest Payable		23,261
	268	Dividends Payable		0
	270	Notes Payable		417,606
	273	Bonds Payable		275,000
	311	Discount on Bonds Payable	6,400
	317	Common Stock		189,000
	320	Paid-in Capital in Excess of Stated Value		256,400
	330	Retained Earnings		362,748
	332	Treasury Stock
	401	Dividends	50,000
	412	Sales Revenue		5,433,396
	414	Sales Returns and Allowances	14,060
	505	Sales Discounts	115,459
	610	Cost of Goods Sold	3,995,710
	612	Advertising Expense	7,178
	631	Bad Debt Expense	1,120
	644	Supplies Expense	1,540
	711	Freight-out	18,542
	726	Depreciation Expense	23,000
	730	Salaries and Wages Expense	943,752
	732	Payroll Tax Expense	83,681
	820	Utilities Expense	16,669
	905	Interest Revenue		3,150
	921	Interest Expense	47,831
	999	Loss on Disposal of Plant Assets	2,000
		Income Tax Expense	197,000
	Total
			7,648,517	7,648,517
	Additional information: A truck was sold for cash proceed of $ 8,000
	The increase in equipment was due to purchase of equipment.
	The decrease in debt is due to re-payments.
	The portion of the notes and Bonds payable that will become due next year is $ 10,000.

Beginning Trial Balance - post closing 12/31/2017
Account		Name	Debit	Credit
101		Cash	279,930
105		Petty Cash	150
112		Accounts Receivable	317,420
113		Allowance for Doubtful Accounts		4,580
115		Notes Receivable	-
120		Inventory	531,960
126		Supplies	2,320
130		Prepaid Insurance	11,020
131		Prepaid Rent	25,410
135		Other Assets	145,000
140		Land	43,000
145		Buildings	306,000
146		Accum. Depr. Buildings		73,040
151		Equipment	32,800
152		Accum. Depr. Equipment		13,200
163		Trucks	78,400
164		Accum. Depr. Trucks		39,540
200		Bank Line of Credit		-
201		Accounts Payable		126,850
212		FICA Taxes Payable		1,787
214		Income taxes payable		-
215		Federal Withholding Taxes Payable		9,573
216		State Withholding Taxes Payable		2,486
218		FUTA Taxes Payable		400
224		SUTA Taxes Payable		2,600
226		Interest Payable		-
230		Dividends Payable		-
250		Notes Payable		422,606
268		Bonds Payable		275,000
270		Discount on Bonds Payable	6,400
273		Common Stock		189,000
311		Paid-in Capital in Excess of Stated Value		256,400
317		Retained Earnings		362,748
320		Treasury Stock	-
		Total	1,779,810	1,779,810

Answer 1

Rockford Plumbing Supply, Inc.
Income Statement
For the Year Ended Dec 31, 2018
Sales Revenue
Sales	5,433,396.00
Less: Sales Return & Allowances	14,060.00
Less: Sales Discounts	115,459.00
Net Sales		5,303,877.00
Cost of Goods Sold		3,995,710.00
Gross Margin		1,308,167.00
Selling & Administrative Expenses
Bad Debts Expense	1,120.00
Supplies Expense	1,540.00
Freight Out	18,542.00
Depreciation Expense	23,000.00
Salaries and Wages Expense	943,752.00
Advertising expenses	7,178.00
Payroll Tax Expense	83,681.00
Utilities Expense	16,669.00	1,095,482.00
Net Operating Income		212,685.00
Other Income & Losses
Interest Expense	47,831.00
Interest Revenue	3,150.00
Loss on Disposal of Plant Assets	2,000.00	46,681.00
Net Income before Tax		166,004.00
Income Tax		197,000.00
Net Income (Loss)		(30,996.00)
Statement of Retained Earnigs
For the year Ending Dec 31, 2018
Beginning Balance	362,748.00
Net Income before Tax	(30,996.00)
Sub-total	331,752.00
Dividends	(50,000.00)
Ending Balance	281,752.00
Answer e.
Rockford Plumbing Supply, Inc.
Balance Sheet
At Dec 31, 2018
Assets
Current Assets
Cash		431,794.00
Petty Cash Fund		150.00
Accounts Receivable, Net of Allowance	464,550.00
Allowance for Doubtful Accounts	(40,178.00)	424,372.00
Inventory		569,671.00
Supplies		3,680.00
Prepaid Insurance		11,020.00
Prepaid Rent		25,410.00
Total Current Assets			1,466,097.00
Property, Plant & Equipment
Land		43,000.00
Buildings	306,000.00
Accumulated Depreciation - Building	(78,040.00)	227,960.00
Equipment	63,900.00
Accumulated Depreciation - Equipment	(21,200.00)	42,700.00
Trucks	60,400.00
Accumulated Depreciation - Truck	(41,540.00)	18,860.00
Total Property, Plant & Equipment			332,520.00
Other Asssets			145,000.00
Total Assets			1,943,617.00
Liabilities & Shareholders' Equity
Liabilities
Current Liabilities
Accounts Payable		357,600.00
Bank Line of Credit		15,000.00
FICA Taxes Payable		1,530.00
Income Taxes Payable		125,000.00
Federal Withholding Taxes Payable		1,967.00
State Withholding Taxes Payable		2,901.00
FUTA Taxes Payable		400.00
SUTA Tax Payable		2,600.00
Interest Payable		23,261.00
Notes Payable (Current Portion)		10,000.00
Total Current Liabilities			540,259.00
Long Term Liabilities
Notes Payable		407,606.00
Bonds Payable	275,000.00
Discount on Bonds Payable	(6,400.00)	268,600.00
Total Long Term Liabilities			676,206.00
Total Liabilities			1,216,465.00
Shareholders' Equity
Common Stock	189,000.00
Paid-in Capital in Excess of Stated Value	256,400.00
Paid-in Capital		445,400.00
Retained Earnings		281,752.00
Total Shareholders' Equity			727,152.00
Total Laibilities & Owners' Equity		-	1,943,617.00
Rockford Plumbing Supply, Inc.
Statement of Cash Flows (Indirect Method)
For the Year ended Dec 31, 2018
Cash Flow from opearating activities:
Net Income (Loss)		(30,996)
Add/(Less) non cash effects on operating activities
Depreciation expense	23,000
Loss on Disposal of Plant Assets	2000
Increase in Accounts Receivables	(111,532)
Increase in Inventory	(37,711)
Increase in Supplies	(1,360)
Increase in Accounts Payables	230,750
Decrease in FICA Tax Payable	(257)
Increase in Income Tax Payable	125,000
Decrease in Federal Withholding Taxes Payable	(7,606)
Incerase in State Withholding Taxes Payable	415
Increase in Interest Payable	23,261	245,960
Net Cash provided by operating activities		214,964
Cash flow from Investing Activities
Purchase of Equipment	(31,100)
Sale of Truck	8,000
Net Cash used by Investing activities		(23,100)
Cash Flow from Financing Activities
Proceeds from of Bank Line credits	15,000
Payment on Notes Payable	(5,000)
Dividend Paid	(50,000)
Net Cash used by Financing activities		(40,000)
Net Increase / (Decrease) in Cash		151,864
Cash & Cash Equivalents at the beginning - Dec 31, 2017		280,080
Cash & Cash Equivalents at the beginning - Dec 31, 2018		431,944