Question

In: Accounting

Johnston Enterprises Balance Sheet and Income Statement Data December 31, 2017 2016 Accounts Payable 187,000 102,000...

Johnston Enterprises

Balance Sheet and Income Statement Data

December 31,

2017

2016

Accounts Payable

187,000

102,000

Accounts Receivable

238,000

306,000

Accumulated Depreciation

476,000

442,000

Bonds Payable

340,000

391,000

Cash

153,000

119,000

Common Stock

510,000

467,500

Cost of Goods Sold

751,000

731,000

Depreciation Expense

153,000

136,000

Income Tax Expense

110,000

102,000

Income Taxes Payable

85,000

76,500

Interest Expense

34,000

34,000

Inventory

391,000

340,000

Loss on Sale of Equipment

12,000

0

Notes Payable (current)

51,000

68,000

Property, Plant, and Equipment

1,241,000

1,122,000

Retained Earnings

?

340,000

Salaries and Wages Expense

391,000

357,000

Sales Revenue

1,615,000

1,513,000

Additional Information:

During the year, Johnston paid dividend of $130,000; sold equipment with an original cost of $153,000 and accumulated depreciation of $119,000; and purchased new equipment for $272,000.

Instruction

  1. Prepare a Comparative Income statement for years ending December 31, 2016 and 2017.
  2. Prepare a statement of Retained Earnings for the year ending December 31, 2017.
  3. Prepare a Comparative Balance Sheet for years ending December 31, 2016 and 2017.
  4. Prepare a statement of cash flows for the year ending December 31, 2017.

Solutions

Expert Solution

Comparative Income Statement
Particulars 2017 2016
Sales revenue $          1,615,000.00 $ 1,513,000.00
Less: COGS $             751,000.00 $      731,000.00
Gross Profit $             864,000.00 $      782,000.00
Less: Expenses
Depreciation $             153,000.00 $      136,000.00
Interest Expense $                34,000.00 $        34,000.00
Loss on sale $                12,000.00
Salaries and wages $             391,000.00 $      357,000.00
Tax Expense $             110,000.00 $      102,000.00
Net Income $             164,000.00 $      153,000.00
Retained Earning Statement
Opening Balance $    340,000.00
Add: Net income $    164,000.00
Less: Dividend Paid $ (130,000.00)
Closing Balance $    374,000.00
Comparative Balance Sheet
Assets 2017 2016 Liabilities 2017 2016
Accounts Receivable $      238,000.00 $      306,000.00 Accounts Payable $      187,000.00 $      102,000.00
Accumulated Dep $   (476,000.00) $   (442,000.00) Bonds Payable $      340,000.00 $      391,000.00
Cash $      153,000.00 $      119,000.00 Common Stock $      510,000.00 $      467,500.00
Inventory $      391,000.00 $      340,000.00 Income Tax Payable $        85,000.00 $        76,500.00
Property Plant $ 1,241,000.00 $ 1,122,000.00 Notes Payable $        51,000.00 $        68,000.00
Retained Earnings $      374,000.00 $      340,000.00
Total $ 1,547,000.00 $ 1,445,000.00 Total $ 1,547,000.00 $ 1,445,000.00
Cash Flow Statement
Particulars Amount
Net Profit $     164,000.00
Add: Depreciation $    153,000.00
Add: Income Tax $    110,000.00
Add: Loss on sale $      12,000.00 $     275,000.00
Adjsuted Net Profit $     439,000.00
Operating Activities
Add: Decrease in assets/ Increase in Liabilities
Accounts Receivable $      68,000.00
Accounts Payable $      85,000.00
$    153,000.00
Less: Increase in assets/ Decrease in Liabilities
Inventories $    (51,000.00)
Net Cash flow form Operating Activities $     102,000.00
$     541,000.00
Less: Income Tax paid $ (101,500.00)
$     439,500.00
Investing Activities
Sale of Equipment $      22,000.00
Purchased Equipment $ (272,000.00)
Net Cash flow form Investing Activities $ (250,000.00)
$     189,500.00
Financing Activities
Issue of common stock $      42,500.00
Repayment of Notes Payable $    (17,000.00)
Dividend Paid $ (130,000.00)
Repayment of Bonds Payable $    (51,000.00)
Net Cash flow form Financing Activities $ (155,500.00)
$       34,000.00
Add: Opening cash balance $     119,000.00
Closing cash balance $     153,000.00

Workings:

Income Tax Payable Account
Cash $      101,500.00 Opening $        76,500.00
Closing $        85,000.00 P/L $      110,000.00
$      186,500.00 $      186,500.00
Equipment Account
Opening $ 1,122,000.00 Sale $      153,000.00
Purchase $      272,000.00 Closing $ 1,241,000.00
$ 1,394,000.00 $ 1,394,000.00
Sale of Equipment
Cost of Equipment sold $      153,000.00
Less: Accumulated Dep $      119,000.00
Book value $        34,000.00
Less: Loss on sale $        12,000.00
Sale price $        22,000.00

Related Solutions

Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $   ...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $    235,000 $    400,000 Accounts Receivable        367,200        325,000 Inventory        450,000        500,200 Prepaid Expenses        120,000        160,000 Long-term investment        100,000        300,000 Equiptment (Net)     1,050,000     1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $    421,000 $    411,000 Salary Payable        134,000        180,000 Interest Payable        110,000        112,000 Bonds Payable        550,000        560,000 Common Shares...
‏The comparative balance sheet of Four Seasons Enterprises Inc. for December ‏31, 2017 and​​​​ 2016, is...
‏The comparative balance sheet of Four Seasons Enterprises Inc. for December ‏31, 2017 and​​​​ 2016, is as follows: ‏Dec. 31, 2017​​​​ Dec. 31, 2016 ‏Assets Cash $ ​​​395,000 ​​​​$ 88,000 ‏Accounts receivable (net) ​​225,000 ​​​​242,000 ‏Inventories ​​​638,000 ​​​​576,000 ‏Prepaid expenses ​​20,500 ​​​​15,000 ‏Equipment ​​​895,000 ​​​​750,000 ‏Accumulated depreciation—equipment (175,000) ​​​(140,000) ‏Total assets ​​​$1,998,500 ​​​$1,531,000 ‏Accounts payable (merchandise creditors) $ 100,000​​​ $ 92,000 ‏Mortgage note payable ​​0​​​​275,000 ‏Common stock, $5 par ​​500,000 ​​​​250,000 ‏Paid-in capital: Excess of issue over par—common stock 250,000...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow.
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANYIncome StatementFor Year Ended December 31, 2017 Sales revenue $ 148,200 Expenses     Cost of goods sold   59,000 Depreciation expense   20,500 Salaries expense   35,000 Rent expense   10,700 Insurance expense   5,500 Interest expense   5,300 Utilities expense   4,500 Net income $ 7,700      LANSING COMPANYSelected Balance Sheet Accounts At...
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017...
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017 2016 Cash .................................... $   87,375 $   63,750 Available-for-sale securities (not cash equivalents) ......................... 17,250 105,000 Accounts receivable ..................... 90,000 86,250 Merchandise inventory ................... 187,500 163,500 Prepaid insurance ....................... 1,125 1,500 Land, buildings, and equipment ......... 1,378,875 1,087,500 Accumulated depreciation ................ (558,750) (498,750) Total ................................. $1,203,375 $1,008,750 Accounts payable ........................ $ 153,375 $ 236,250 Salaries payable ........................ 18,750 26,250 Notes payable--bank (current) ........... 37,500 150,000...
Blossom Co. Balance Sheet (Partial) As of December 31, 2017 Cash $19,100 Accounts payable $28,400 Accounts...
Blossom Co. Balance Sheet (Partial) As of December 31, 2017 Cash $19,100 Accounts payable $28,400 Accounts receivable $38,200 Notes payable 14,000     Less: Allowance for doubtful accounts 2,100 36,100 Unearned revenue 2,800 Inventory 61,500 Total current liabilities $45,200 Prepaid expenses 6,100 Total current assets $122,800 The following errors in the corporation’s accounting have been discovered: 1. Keane collected $4,700 on December 20, 2017 as a down payment for services to be performed in January, 2018. The company’s controller recorded the amount...
Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable...
Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable $7,200 Receivables 10,800 Notes payable 3,472 Inventories 12,600 Accrued liabilities 2,520 Total current assets $25,200 Total current liabilities $13,192 Mortgage bonds 5,000 Net fixed assets 21,600 Common stock 2,000 Retained earnings 26,608 Total assets $46,800 Total liabilities and equity $46,800 Krogh Lumber: Income Statement for December 31, 2016 (Thousands of Dollars) Sales $36,000 Operating costs including depreciation 30,783 Earnings before interest and taxes $5,217...
Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable...
Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable $7,200 Receivables 10,800 Notes payable 3,472 Inventories 12,600 Accrued liabilities 2,520 Total current assets $25,200 Total current liabilities $13,192 Mortgage bonds 5,000 Net fixed assets 21,600 Common stock 2,000 Retained earnings 26,608 Total assets $46,800 Total liabilities and equity $46,800 Krogh Lumber: Income Statement for December 31, 2016 (Thousands of Dollars) Sales $36,000 Operating costs including depreciation 30,783 Earnings before interest and taxes $5,217...
2. Ancy corporation’s balance sheet accounts as of December 31, 2017 and 2016 and information relating...
2. Ancy corporation’s balance sheet accounts as of December 31, 2017 and 2016 and information relating to 2015 activities are presented below. December 31,        2017     2016 Assets Cash $   440,000 $   200,000 Short-term investments 600,000 — Accounts receivable (net) 1,020,000 1,020,000 Inventory 1,380,000 1,200,000 Long-term investments 400,000 600,000 Plant assets 3,400,000 2,000,000 Accumulated depreciation (900,000) (900,000) Patent      180,000      200,000 Total assets $6,520,000 $4,320,000 Liabilities and Stockholders' Equity Accounts payable and accrued liabilities $1,660,000 $1,440,000 Notes...
The following are Sheridan Corp.’s comparative balance sheet accounts at December 31, 2017 and 2016, with...
The following are Sheridan Corp.’s comparative balance sheet accounts at December 31, 2017 and 2016, with a column showing the increase (decrease) from 2016 to 2017. COMPARATIVE BALANCE SHEETS 2017 2016 Increase (Decrease) Cash $814,600 $706,000 $108,600 Accounts receivable 1,129,100 1,176,600 (47,500 ) Inventory 1,861,900 1,719,500 142,400 Property, plant, and equipment 3,335,800 2,940,300 395,500 Accumulated depreciation (1,159,600 ) (1,046,100 ) (113,500 ) Investment in Myers Co. 313,100 277,300 35,800 Loan receivable 249,200 — 249,200    Total assets $6,544,100 $5,773,600 $770,500 Accounts...
The following are Ayayai Corp.’s comparative balance sheet accounts at December 31, 2017 and 2016, with...
The following are Ayayai Corp.’s comparative balance sheet accounts at December 31, 2017 and 2016, with a column showing the increase (decrease) from 2016 to 2017. COMPARATIVE BALANCE SHEETS 2017 2016 Increase (Decrease) Cash $821,300 $694,000 $127,300 Accounts receivable 1,124,400 1,158,200 (33,800 ) Inventory 1,852,600 1,702,600 150,000 Property, plant, and equipment 3,300,400 2,951,400 349,000 Accumulated depreciation (1,174,500 ) (1,048,100 ) (126,400 ) Investment in Myers Co. 312,300 273,800 38,500 Loan receivable 250,100 — 250,100    Total assets $6,486,600 $5,731,900 $754,700 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT