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
- Prepare a Comparative Income statement for years ending December 31, 2016 and 2017.
- Prepare a statement of Retained Earnings for the year ending December 31, 2017.
- Prepare a Comparative Balance Sheet for years ending December 31, 2016 and 2017.
- 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 | |||
ekkarill92 answered 2 months agoRelated 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 0275,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
Latest Questions
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
ADVERTISEMENT