In: Accounting
Question: What is the ending inventory balance?
Softbyte Inc.
Balance Sheet
December 31, 2017
Assets
Cash $500,000
Accounts Receivable 700,000
Inventory 300,000
Property, Plant & Equipment 900,000
Accumulated Depreciation (100,000) 800,000
Total Assets $2,300,000
Liabilities & Equity
Accounts Payable $300,000
Notes Payable 1,000,000
Common Stock 500,000
Retained Earnings 500,000
Total Liabilities & Equity $2,300,000
Instructions:
Open the balances in the ledger accounts.
Post the journal entries to the general ledger.
Prepare an income statement, statement of retained earnings, balance sheet, and statement of cash flows-indirect method.
Journal Entries for January 2013
Transaction 1: Services Provided for Cash
Description: Receives $155,000 cash from customers for programming services it has provided.
Journal Entry: Dr. Cr.
Cash 155,000
Sales 155,000
Transaction 2: Receipt of Cash on Account
Description: Receives $28,000 in cash from customers who had been billed for services.
Journal Entry: Dr. Cr.
Cash 28,000
Accounts
Receivable
28,000
Transaction 3: Cost Flow Assumption: LIFO
Description: Recorded $45,000 in cost of goods sold under the LIFO cost flow assumption.
Journal Entry: Dr. Cr.
Cost of Goods Sold 45,000
Inventory 45,000
Transaction 4: Recording Depreciation Expense
Description: Recorded depreciation expense under the straight-line method.
Journal Entry: Dr. Cr.
Depreciation Expense 9,000
Accumulated Depreciation 9,000
Transaction 5: Sale of Plant Asset
Description: Sale of plant asset for cash. The cash received was equal to the book value.
Journal Entry: Dr. Cr.
Cash 3,000
Accumulated Depreciation 16,000
Equipment 19,000
Transaction 6: Gain on Sale of Plant Asset
Description: Sale of plant asset for cash. The cash received was $2,000 more than the book value resulting in a gain.
Journal Entry: Dr. Cr.
Cash 5,000
Accumulated Depreciation 16,000
Gain 2,000
Equipment 19,000
Transaction 7: Loss on Sale of Plant Asset
Description: Sale of plant asset for cash. The cash received was $500 less than the book value resulting in a loss.
Journal Entry: Dr. Cr.
Cash 2,500
Loss 500
Accumulated Depreciation 13,000
Equipment 16,000
Transaction 8: Note Given to Borrow from Bank
Description: Borrowed $2,000 cash with a 60-day, 12%, $2,000 note.
Journal Entry: Dr. Cr.
Cash 2,000
Notes Payable 2,000
Transaction 9: Payment of Note
Description: Paid the principal and interest on the note in Transaction 8.
Journal Entry: Dr. Cr.
Notes Payable 2,000
Interest Expense 40
Cash 2,040
Transaction 10: Bond Issue
Description: Issued a $100,000 Par Value Bond at a Discount
Journal Entry: Dr. Cr.
Cash 96,454
Bonds Payable 96,454
Transaction 11: Effective Interest Amortization
Description: Recorded bond interest expense under the effective interest method.
Journal Entry: Dr. Cr.
Bond Interest Expense 4,823
Bonds Payable 823
Cash 4,000
Transaction 12: Issuing Par Value Stock at a Premium
Description: Issued common stock and received cash of $50,000 in excess of par value.
Journal Entry: Dr. Cr.
Cash 350,000
Common Stock , $10 Par Value 300,000
Paid-in Capital in Excess of Par Value, Common Stock 50,000
Transaction 13: Dividend
Description: The corporation pays a dividend of $3,800 in cash to the stockholders of Softbyte.
Journal Entry: Dr. Cr.
Dividends 3,800
Cash 3,800
Cash:
| Beginning balance | 500,000 | Note Payable | 2,000 |
| Sales | 155,000 | Interest Expense | 40 |
| Accounts Receivable | 28,000 | Bond Interest Expense | 4,000 |
| Asset Disposal | 3,000 | Dividends | 3,800 |
| Asset Disposal | 5,000 | ||
| Asset Disposal | 2,500 | ||
| Notes Payable | 2,000 | ||
| Bond Payable | 96,454 | ||
| Common Stock | 300,000 | ||
| Paid-in Capital in Excess of Par | 50,000 | ||
| Ending balance | 1,132,114 |
Accounts Receivable
| Beginning balance | 700,000 | Cash | 28,000 |
| Ending balance | 672,000 |
Inventory
| Beginning Balance | 300,000 | Cost of Goods Sold | 45,000 |
| Ending balance | 255,000 |
Property, Plant and Equipment
| Beginning balance | 900,000 | Asset Disposal | 19,000 |
| Asset Disposal | 19,000 | ||
| Asset Disposal | 16,000 | ||
| Ending balance | 846,000 |
Accumulated Depreciation
| Asset Disposal | 16,000 | Beginning balance | 100,000 |
| Asset Disposal | 16,000 | Depreciation Expense | 9,000 |
| Asset Disposal | 13,000 | ||
| Ending balance | 64,000 |
Accounts Payable
| Beginning balance | 300,000 | ||
| Ending balance | 300,000 |
Notes Payable
| Cash | 2,000 | Beginning balance | 1,000,000 |
| Cash | 2,000 | ||
| Ending balance | 1,000,000 |
Bond Payable
| Cash | 96,454 | ||
| Discount on Bonds Payable | 823 | ||
| Ending balance | 97,277 |
Common Stock
| Beginning balance | 500,000 | ||
| Cash | 300,000 | ||
| Ending balance | 800,000 |
Paid-in Capital in Excess of Par: Common Stock
| Cash | 50,000 | ||
| Ending balance | 50,000 |
Retained Earnings
| Beginning balance | 500,000 | ||
Sales:
| Cash | 155,000 | ||
Cost of Goods Sold:
| Inventory | 45,000 | ||
Depreciation Expense:
| Accumulated Depreciation | 9,000 | ||
Gain on Disposal of Equipment:
| Asset Disposal | 2,000 | ||
Loss on Disposal of Equipment:
| Asset Disposal | 500 | ||
Interest Expense:
| Cash | 40 | ||
Softbyte Inc.
Trial Balance
January 31, 2018
| Account Titles | Debit | Credit |
| $ | $ | |
| Cash | 1,132,114 | |
| Accounts Receivable | 672,000 | |
| Inventory | 255,000 | |
| Property Plant and Equipment | 846,000 | |
| Accumulated Depreciation | 64,000 | |
| Accounts Payable | 300,000 | |
| Notes Payable | 1,000,000 | |
| Bonds Payable | 97,277 | |
| Dividends | 3,800 | |
| Common Stock | 800,000 | |
| Paid-in Capital in Excess of Par | 50,000 | |
| Retained Earnings | 500,000 | |
| Sales | 155,000 | |
| Gain on Disposall of Asset | 2,000 | |
| Cost of Goods Sold | 45,000 | |
| Depreciation Expense | 9,000 | |
| Loss on Disposal of Asset | 500 | |
| Interest Expense | 4,863 | |
| Totals | 2,968,277 | 2,968,277 |
Softbyte Inc.
Income Statement
For the month ended January 31, 2018
| Sales | $ 155,000 | |
| Cost of Goods Sold | 45,000 | |
| Gross Profit | 110,000 | |
| Depreciation Expense | 9,000 | |
| Operating Profit | 101,000 | |
| Other Income ( Loss / Expense) | ||
| Gain on Sale of Plant | 2,000 | |
| Loss on Sale of Plant | (500) | |
| Interest Expense | (4,863) | (3,363) |
| Net Income | 97,637 |
Softbyte Inc.
Statement of Retained Earnings
For the month ended January 31, 2018
| Balance, January 1 | 500,000 |
| Net Income | 97,637 |
| Dividends | (3,800) |
| Balance, January 31 | 593,837 |
Softbyte Inc.
Balance Sheet
January 31, 2018
| Assets | $ | Liabilities and Equity | $ |
| Cash | 1,132,114 | Accounts Payable | 300,000 |
| Accounts Receivable | 672,000 | Notes Payable | 1,000,000 |
| Inventory | 255,000 | Bonds Payable | 97,277 |
| Property, Plant and Equipment, net | 782,000 | Common Stock | 800,000 |
| Paid-in Capital in Excess of Par: Common Stock | 50,000 | ||
| Retained Earnings | 593,837 | ||
| Total Assets | 2,841,114 | Total Liabilities and Equity | 2,841,114 |
Softbyte Inc.
Statement of Cash Flows
For the month ended January 31, 2018
| $ | $ | |
| Cash Flows from Operating Activities | ||
| Net Income | 97,637 | |
| Adjustments to reconcile net income to net cash flows from operations | ||
| Depreciation Expense | 9,000 | |
| Interest Expense | 4,863 | |
| Loss on disposal of plant | 500 | |
| Gain on disposal of plant | (2,000) | |
| Decrease in accounts receivable | 28,000 | |
| Decrease in inventory | 45,000 | 85,363 |
| Net Cash Flows From Operations | 183,000 | |
| Cash Flows from Investing Activities | ||
| Proceeds from Sale of Plant | 10,500 | |
| Net Cash Flows from Investing Activities | 10,500 | |
| Cash Flows from Financing Activities | ||
| Cash received from issuance of Common Stock | 350,000 | |
| Cash received from issuance of Bonds | 96,454 | |
| Interest Paid | (4,040) | |
| Dividend paid | (3,800) | |
| Net Cash Flows from Financing Activities | 438,614 | |
| Net Increase ( decrease) in Cash | 632,114 | |
| Cash Balance, December 31 2017 | 500,000 | |
| Cash Balance, January 31, 2018 | 1,132,114 |