The following is information for ABC-a publicly traded company Balance Sheet at end of 2020 (amounts...

Transcribed Image Text:

The following is information for ABC-a publicly traded company Balance Sheet at end of 2020 (amounts in thousands) Condensed Income Statement for 2020 Statement of Comprehensive Income Current Assets 2020 Cash Accounts Receivable ssss $ 4,650 Sales $ 265,320 Net Income $ 48,967 $ 18,260 Cost of Goods Sold $ 148,290 Inventory $ 21,275 Gross Profit $ 117,030 Prepaid insurance $ 5,700 Total Current Assets $ 49,885 Wages Expense $ 23,450 Property, Plant and Equipment $ 311,000 Depreciation Expense $ 15,220 Other Comprehensive Income Unrealized Gain on AFS Debt Securities $ 158 Income Tax Effect $ (33) Total Other Comprehensive Inc $ 125 Accumulated Depreciation Patent AFS Debt Securities Total Assets $ (103,500) Amortization Expense $ 1,500 $ 36,000 Insurance Expense $ 767 Comprehensive Income $49,125 $ 2,100 Interest Expense $ 10,150 $ 295,485 Other Expense $ 3,960 Current Liabilities Total Expenses $ 55,047 Accounts Payable $ 25,212 Income before Taxes $ 61,983 Interest Payable $ 650 Income Tax Expense $ 13,016 Wages Payable $ 1,085 Net Income $ 48,967 Unearned Revenue $ 1,600 Total Current Liabilities $ 28,547 Earnings Per Share $ 4.90 Note Payable $ 114,000 Bond Payable in 2022 $ 30,000 Statement of Changes in Stockholders Equity-2020 Equity Common Stock ($1 par, 10,000 shares is $ 10,000 CS APIC AOCI APIC $ 20,800 Beginning $ 10,000 $ 20,800 Retained Earnings $ 92,435 Total OCI $ (422) $ 125 Accumulated Other Comprehensive Los $ (297) Net Income Liabilities and Equity $ 295,485 Dividends Ending Balance $ 10,000 $ 20,800 $ (297) Results for 2021 Sales $ 281,300 All sales on credit Inventory Purchases on credit Depreciation expense $ 191,400 and ending inventory $56200 (you calculate COGS) 16,000 not including assets sold, bought or found Patent purchased in 2018 and determined to have remaining useful life of 10 years in 2021 Wages Expense $ 27,450 Paid in cash $ 2,194 additional owed at end of 2021 Insurance policy indicates that $5,700 was paid in May 2020 for 24 month coverage starting May 1 2020. During 2021 found an asset purchased and recorded in 2018 that had not been depreciated-cost 6,230 no salvage 10 year useful life (an error) Sold AFS Debt Securities that cost 400 for 390 in cash ($7 loss in AOCI recorded previously) Sold equipment that cost 3,000 with accumulated depreciation of 2,690 for $200 in cash. Purchased new equipment costing $6,975 with $2,000 down payment and 10% note payable on December 1, 2021 (first payment due January 1, 2022) 10 year useful life and no salvage Collections on A/R = 275,320 Payments on A/P = 176,500- all accounts payable deal with inventory All service agreements sold to customers in 2020 completed in 2021. New service agreements sold for $2460 in cash during 2021 - 40 percent of the services provided during 2021 Bond terms - interest only for 6.5% paid annually on September 1. Firm agreement with a bank signed on December 15 to refinance bond to a 5 year note in 2022 Note Payable - 4 payments of $3,300 made March 30, June 30, Sept 30 and December 31 interest of 8% per year (2% per quarter) Each note payment pays the interest since the last payment with any remaining amount going toward principle Fair value of remaining AFS Debt Securities $1,400 Other Information Tax rate is 21% (unlike 2020 income taxes have not been paid) Half year convention for depreciation The following is information for ABC-a publicly traded company Balance Sheet at end of 2020 (amounts in thousands) Condensed Income Statement for 2020 Statement of Comprehensive Income Current Assets 2020 Cash Accounts Receivable ssss $ 4,650 Sales $ 265,320 Net Income $ 48,967 $ 18,260 Cost of Goods Sold $ 148,290 Inventory $ 21,275 Gross Profit $ 117,030 Prepaid insurance $ 5,700 Total Current Assets $ 49,885 Wages Expense $ 23,450 Property, Plant and Equipment $ 311,000 Depreciation Expense $ 15,220 Other Comprehensive Income Unrealized Gain on AFS Debt Securities $ 158 Income Tax Effect $ (33) Total Other Comprehensive Inc $ 125 Accumulated Depreciation Patent AFS Debt Securities Total Assets $ (103,500) Amortization Expense $ 1,500 $ 36,000 Insurance Expense $ 767 Comprehensive Income $49,125 $ 2,100 Interest Expense $ 10,150 $ 295,485 Other Expense $ 3,960 Current Liabilities Total Expenses $ 55,047 Accounts Payable $ 25,212 Income before Taxes $ 61,983 Interest Payable $ 650 Income Tax Expense $ 13,016 Wages Payable $ 1,085 Net Income $ 48,967 Unearned Revenue $ 1,600 Total Current Liabilities $ 28,547 Earnings Per Share $ 4.90 Note Payable $ 114,000 Bond Payable in 2022 $ 30,000 Statement of Changes in Stockholders Equity-2020 Equity Common Stock ($1 par, 10,000 shares is $ 10,000 CS APIC AOCI APIC $ 20,800 Beginning $ 10,000 $ 20,800 Retained Earnings $ 92,435 Total OCI $ (422) $ 125 Accumulated Other Comprehensive Los $ (297) Net Income Liabilities and Equity $ 295,485 Dividends Ending Balance $ 10,000 $ 20,800 $ (297) Results for 2021 Sales $ 281,300 All sales on credit Inventory Purchases on credit Depreciation expense $ 191,400 and ending inventory $56200 (you calculate COGS) 16,000 not including assets sold, bought or found Patent purchased in 2018 and determined to have remaining useful life of 10 years in 2021 Wages Expense $ 27,450 Paid in cash $ 2,194 additional owed at end of 2021 Insurance policy indicates that $5,700 was paid in May 2020 for 24 month coverage starting May 1 2020. During 2021 found an asset purchased and recorded in 2018 that had not been depreciated-cost 6,230 no salvage 10 year useful life (an error) Sold AFS Debt Securities that cost 400 for 390 in cash ($7 loss in AOCI recorded previously) Sold equipment that cost 3,000 with accumulated depreciation of 2,690 for $200 in cash. Purchased new equipment costing $6,975 with $2,000 down payment and 10% note payable on December 1, 2021 (first payment due January 1, 2022) 10 year useful life and no salvage Collections on A/R = 275,320 Payments on A/P = 176,500- all accounts payable deal with inventory All service agreements sold to customers in 2020 completed in 2021. New service agreements sold for $2460 in cash during 2021 - 40 percent of the services provided during 2021 Bond terms - interest only for 6.5% paid annually on September 1. Firm agreement with a bank signed on December 15 to refinance bond to a 5 year note in 2022 Note Payable - 4 payments of $3,300 made March 30, June 30, Sept 30 and December 31 interest of 8% per year (2% per quarter) Each note payment pays the interest since the last payment with any remaining amount going toward principle Fair value of remaining AFS Debt Securities $1,400 Other Information Tax rate is 21% (unlike 2020 income taxes have not been paid) Half year convention for depreciation