I got a copy of Apollo$$s $2017$ year$-$end trial balance $($attached$)$ from Sam Carboy, Apollo$$s Controller. I also got a copy of last year$$s $2016$ audited pre$-$closing trial balance from Karina. I$$ve attached copies of both to this e$-$mail and also posted them to the AOW intranet where you can also download them.

I received it a week after he promised it to me$,$ so apparently it wasn$$t as clean a year$-$end close as he expected. I want you to put the numbers into three spreadsheets $($one for the comparative $($i$.$e$.,$ two$-$year$)$ balance sheet $($A$-1),$ one for the comparative income statement $($A$-2),$ and one for the comparative statement of cash flows $($A$-3)).$ I know that everyone has a particular style of audit documentation formatting, but my preference is for the following columns for the income statement and balance sheet:

Acct # Acct Title W$/$P Ref Last year$$s $($Audited$)$ Current Year$($unaudited Adjustments Current Year $($Audited$)$

Apollo Shoes, Inc

Preclosing Trial Balance

$31-$Dec$-17$

Account Description Debit Amt Credit Amt

Cash on Hand $$2,275\mathrm{.}23$

Regular Checking Account $$557,125\mathrm{.}92$

Payroll Checking Account

Savings Account $$3,645,599\mathrm{.}15$

Accounts Receivable $$51,515,259\mathrm{.}98$

Other Receivables $$1,250,000\mathrm{.}00$

Allowance for Doubtful Accounts $$1,239,009\mathrm{.}75$

Inventory $$67,724,527\mathrm{.}50$

Reserve for Inventory Obsolescence $$846,000\mathrm{.}00$

Prepaid Insurance $$3,424,213\mathrm{.}78$

Prepaid Rent

Office Supplies $$8,540\mathrm{.}00$

Notes Receivable$-$Current

Other Current Assets

Land $$117,000\mathrm{.}00$

Buildings and Land Improvements $$674,313\mathrm{.}92$

Machinery, Equipment, Office Furniture $$2,929,097\mathrm{.}13$

Accum. Depreciation $$609,500\mathrm{.}00$

Investments $$1,998,780\mathrm{.}39$

Other Noncurrent Assets $$53,840\mathrm{.}59$

Accounts Payable $$1,922,095\mathrm{.}91$

Sales Tax Payable

Wages Payable

FICA Employee Withholding $$8,439\mathrm{.}65$

Medicare Withholding $$11,414\mathrm{.}99$

Federal Payroll Taxes Payable $$118,086\mathrm{.}12$

FUTA Tax Payable

State Payroll Taxes Payable $$55,106\mathrm{.}86$

SUTA Tax Payable

FICA Employer Withholding $$8,439\mathrm{.}65$

Medicare Employer Withholding $$11,414\mathrm{.}99$

Line of Credit $$44,403,000\mathrm{.}00$

Current Portion Long$-$Term Debt

Other Current Liabilities

Notes Payable$-$Noncurrent $$12,000,000\mathrm{.}00$

Common Stock $$8,105,000\mathrm{.}00$

Paid$-$in Capital $$7,423,000\mathrm{.}00$

Retained Earnings $$6,590,983\mathrm{.}64$

Apollo Shoes, Inc

Preclosing Trial Balance $($Audited$)$

$31-$Dec$-16$

Account Description Debit Credit

Cash on Hand $$1,987\mathrm{.}28$

Regular Checking Account $$198,116\mathrm{.}52$

Payroll Checking Account $$0\mathrm{.}00$

Savings Account $$3,044,958\mathrm{.}13$

Accounts Receivable $$16,410,902\mathrm{.}71$

Allowance for Doubtful Accounts $$1,262,819\mathrm{.}88$

Inventory $-$ Spotlight $$18,825,205\mathrm{.}24$

Reserve for Inventory Obsolescence $$3,012,000\mathrm{.}00$

Prepaid Insurance $$743,314\mathrm{.}38$

Prepaid Rent $$200,000\mathrm{.}00$

Office Supplies $$7,406\mathrm{.}82$

Notes Receivable$-$Current

Other Current Assets

Land $$117,000\mathrm{.}00$

Buildings and Land Improvements $$623,905\mathrm{.}92$

Machinery, Equipment, Office Furniture $$433,217\mathrm{.}10$

Accum. Depreciation $$163,500\mathrm{.}00$

Investments $$572,691\mathrm{.}08$

Other Noncurrent Assets $$53,840\mathrm{.}59$

Accounts Payable $$4,633,118\mathrm{.}09$

Sales Tax Payable $$0\mathrm{.}00$

Wages Payable $$29,470\mathrm{.}32$

FICA Employee Withholding $$1,318\mathrm{.}69$

Medicare Withholding $$583\mathrm{.}99$

Federal Payroll Taxes Payable $$6,033\mathrm{.}01$

FUTA Tax Payable

State Payroll Taxes Payable $$2,815\mathrm{.}47$

SUTA Tax Payable

FICA Employer Withholding $$1,318\mathrm{.}69$

Medicare Employer Withholding $$583\mathrm{.}99$

Line of Credit $$10,000,000\mathrm{.}00$

Current Portion Long$-$Term Debt

Other Current Liabilities

Notes Payable$-$Noncurrent

Common Stock $$8,105,000\mathrm{.}00$

Paid$-$in Capital $$7,423,000\mathrm{.}00$

Retained Earnings $$2,219,620\mathrm{.}65$