1.
Prepare the worksheet to develop Company S’s financial statements for the first 6 months of 2016.
1.
Explanation of Solution
Worksheet: A worksheet is a tool that is used while preparing a financial statement. It is a type of form, having multiple columns and it is used in the adjustment process.
Prepare the worksheet to develop Company S’s financial statements for the first 6 months of 2016:
Table (1)
Working notes:
a. Calculate the amount of
b. Calculate the amount of interest revenue:
c. Calculate the amount of insurance expense:
d. Calculate the amount of depreciation expense:
e. Calculate the amount of rent revenue:
f. Calculate the amount of interest expense:
g. Calculate the amount of income tax expense for first 6 months:
Calculate estimated annual pre-tax income:
Calculate estimated effective income tax rate:
Calculate the amount of income tax expense for first 6 months:
2 (a)
Prepare the income statement for the first 6 months of 2016.
2 (a)
Explanation of Solution
Income statement: The financial statement which reports revenues and expenses from business operations and the result of those operations as net income or net loss for a particular time period is referred to as income statement.
Prepare the income statement for the first 6 months of 2016:
Company S | ||
Interim Income statement | ||
For the period ended June 30, 2016 | ||
Particulars | Amount ($) | Amount ($) |
Sales | 90,000 | |
Less: Cost of goods sold | (48,600) | |
Gross profit | 41,400 | |
Operating expenses: | ||
Selling expenses | 21,000 | |
Administrative expenses | 10,200 | |
Total operating expenses | (31,200) | |
Pre-tax operating income | 10,200 | |
Other items: | ||
Interest revenue | 160 | |
Rent revenue | 750 | |
Interest expense | (660) | |
Total other revenues and expenses | 250 | |
Income before income taxes | 10,450 | |
Less: Income tax expense | (1,714) | |
Net income | $8,736 | |
Earnings per share | $1.09 |
Table (2)
Working notes:
h. Calculate earnings per share for 6 months:
2 (b)
Prepare the income statement for the second quarter of 2016.
2 (b)
Explanation of Solution
Income statement: The financial statement which reports revenues and expenses from business operations and the result of those operations as net income or net loss for a particular time period is referred to as income statement.
Prepare the income statement for the second quarter of 2016:
Company S | ||
Interim Income statement | ||
For the period ended June 30, 2016 | ||
Particulars | Amount ($) | Amount ($) |
Sales | 50,000 | |
Less: Cost of goods sold | (25,600) | |
Gross profit | 24,400 | |
Operating expenses: | ||
Selling expenses | 12,200 | |
Administrative expenses | 5,990 | |
Total operating expenses | (18,190) | |
Pre-tax operating income | 6,210 | |
Other items: | ||
Interest revenue | 120 | |
Rent revenue | 450 | |
Interest expense | (330) | |
Total other revenues and expenses | 240 | |
Income before income taxes | 6,450 | |
Less: Income tax expense | (1,014) | |
Net income | $5,436 | |
Number of shares | 8,000 shares | |
Earnings per share | $0.68 |
Table (3)
Working notes:
i. Calculate the amount of sales for second quarter:
j. Calculate the amount of cost of goods sold for 3 months:
k. Calculate the amount of selling expenses for second quarter:
l. Calculate the amount of administrative expenses for second quarter:
m. Calculate the amount of interest revenue for second quarter:
n. Calculate the amount of rent revenue for second quarter:
o. Calculate the amount of interest expense for second quarter:
p. Calculate the amount of income tax expenses for second quarter:
q. Calculate earnings per share for second quarter:
3.
Prepare the statement of retained earnings for the first 6 months.
3.
Explanation of Solution
Statement of Retained Earnings: Statement of retained earnings shows, the changes in the retained earnings, and the income left in the company after payment of the dividends, for the accounting period.
Prepare the statement of retained earnings for the first 6 months:
Company S | ||
Statement of Retained Earnings | ||
For First 6 Months Ended June 30, 2016 | ||
Particulars | Amount ($) | Amount ($) |
Retained earnings, January 1, 2016 | 29,600 | |
Add: Net income | 8,736 | |
Subtotal | 38,336 | |
Less: Dividends | (3,200) | |
Retained earnings at June 30, 2016 | $35,136 |
Table (4)
Working note:
r. Calculate the amount of retained earnings, January 1, 2016:
4.
Prepare the
4.
Explanation of Solution
Balance Sheet: Balance Sheet is one of the financial statements which summarize the assets, the liabilities, and the Shareholder’s equity of a company at a given date. It is also known as the statement of financial status of the business.
Interim financial reports: these are the financial reports prepared by the company between the two annual reports.
Prepare the balance sheet as on June 30, 2016 of Company S:
Company S | ||
Balance Sheet | ||
As on June 30, 2016 | ||
Assets | ||
Current assets: | Amount ($) | Amount ($) |
Cash | 7,200 | |
Accounts receivable | 9,850 | |
Note receivable | 4,000 | |
Interest receivable | 160 | |
Inventory | 24,400 | |
Prepaid insurance | 480 | |
Total current assets | 46,090 | |
Property and equipment | 80,000 | |
(22,350) | ||
Net property, plant and equipment | 57,650 | |
Total assets | $103,740 | |
Liabilities | ||
Current liabilities: | ||
Accounts payable | 8,000 | |
Interest payable | 600 | |
Dividends payable | 3,200 | |
Income tax payable | 1,714 | |
Unearned rent | 1,050 | |
Bonds payable | 12,000 | |
Less: Discount on bonds payable | (540) | 11,460 |
Total liabilities | 26,024 | |
Shareholders’ Equity | ||
Contributed Capital: | ||
Common stock | 8,000 | |
Additional paid in capital on common stock | 34,580 | |
Retained earnings | 35,136 | |
Total shareholders’ equity | 77,716 | |
Total liabilities and shareholders’ equity | $103,740 |
Table (5)
Want to see more full solutions like this?
Chapter 5 Solutions
Cengagenowv2, 1 Term Printed Access Card For Wahlen/jones/pagach’s Intermediate Accounting: Reporting And Analysis, 2017 Update, 2nd
- Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2016 (unless otherwise indicated), are as follows: During May, the last month of the fiscal year, the following transactions were completed: Instructions 1. Enter the balances of each of the accounts in the appropriate balance column of a four-column account. Write Balance in the item section, and place a check mark () in the Posting Reference column. Journalize the transactions for July, starting on Page 20 of the journal. 2. Post the journal to the general ledger, extending the month-end balances to the appropriate balance columns after all posting is completed. In this problem, you are not required to update or post to the accounts receivable and accounts payable subsidiary ledgers. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete (5) and (6). 5. (Optional) Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 22 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owners equity, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 23 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. Insert the new balance in the owners capital account. 10. Prepare a post-closing trial balance.arrow_forwardOn June 30, 2019, the balances of the accounts appearing in the ledger of Simkins Company are as follows: Instructions 1. Does Simkins Company use a periodic or perpetual inventory system? Explain. 2. Prepare a multiple-step income statement for Simkins Company for the year ended June 30, 2019. The merchandise inventory as of June 30, 2019, was 508,000. The adjustment for estimated returns inventory for sales for the year ending December 31, 2019, was 33,000. 3. Prepare the closing entries for Simkins Company as of June 30, 2019. 4. What would the net income have been if the perpetual inventory system had been used?arrow_forwardOn December 31, 2019, the balances of the accounts appearing in the ledger of Wyman Company are as follows: Instructions 1. Does Wyman Company use a periodic or perpetual inventory system? Explain. 2. Prepare a multiple-step income statement for Wyman Company for the year ended December 31, 2019. The merchandise inventory as of December 31, 2019, was 305,000. The adjustment for estimated returns inventory for sales for the year ending December 31, 2019, was 30,000. 3. Prepare the closing entries for Wyman Company as of December 31, 2019. 4. What would the net income have been if the perpetual inventory system had been used?arrow_forward
- Cost of Goods Sold and Income Statement Schuch Company presents you with the following account balances taken from its December 31 adjusted trial balance: Additional data: 1. A physical count reveals an ending-inventory of 22,500 on December 31. 2. Twenty-five thousand shares of common stock have been outstanding the entire year. 3. The income tax rate is 30% on all items of income. Required: 1. As a supporting document for Requirements 2 and 3, prepare a separate schedule for Schuchs cost of goods sold. 2. Prepare a multiple-step income statement. 3. Prepare a single-step income statement.arrow_forwardOn September 30, 2013, the general ledger of Leons Golf Shop, which uses the calendar year as its accounting period, showed the following year-to-date account balances: The merchandise inventory account had a 48,000 balance on January 1, 2013. The historical gross profit percentage is 40%. Leon prepares quarterly financial statements and takes physical inventory once a yearat the end of the accounting period. In order to prepare the financial statements for the third quarter, the store needs to have an estimate of ending inventory. You have been asked to use the gross profit method to estimate the ending inventory. Review the worksheet called GP. Study it carefully because it may have a solution format somewhat different from the one shown in your textbook.arrow_forwardCurrent Attempt in Progress The ledger of Cullumber Company at the end of the current year shows Accounts Receivable $68,000, Credit Sales $810,000, and Sales Returns and Allowances $38,000. Prepare journal entries for each separate scenario below. If Cullumber Company uses the direct write-off method to account for uncollectible accounts, journalize the adjusting entry at December 31, assuming Cullumber Company determines that Matisse's $500 balance is uncollectible. (a) If Allowance for Doubtful Accounts has a credit balance of $900 in the trial balance, journalize the adjusting entry at December 31, assuming bad debts are expected to be 8% of accounts receivable. (b) If Allowance for Doubtful Accounts has a debit balance of $490 in the trial balance, journalize the adjusting entry at December 31, assuming bad debts are expected to be 7% of accounts receivable. (c) (Credit account titles are automatically indented when amount is entered. Do not indent manually.) No. Account Titles…arrow_forward
- The adjusted trial balance of Sarasota Corporation shows these data pertaining to sales at the end of its fiscal year, October 31, 2018: Sales $ 980,300; Freight-out $ 11,800; Sales Returns and Allowances $ 17,300; and Sales Discounts $ 14,500.Prepare the sales revenues section of the income statement.arrow_forwardTopic: SINGLE-ENTRY BOOKKEEPING HALSEY Company suspects that there is missing inventory in its warehouse at December 31, 2021. All sales and purchases were made on account. Also, the gross profit rate based on net sales is consistent every year. To aid in your investigation, you obtained the following: How much is the net sales revenue for the year?arrow_forwardRamir Alindogan Catering 's Inventory showed a balance of P100,000 before the year-end adjustments. The physical count of goods on hand totaled P97,000. What account would Ramir Alindigan close at the end of the year? Accounts Receivable Accounts Payable Inventory Cost of Goods Soldarrow_forward
- Vaughn Limited, which uses a perpetual inventory system, purchased inventory costing $22,000 on February 1 by issuing a 3-month note payable bearing interest at 6%, with interest and principal due on May 1. The company's year end is on March 31 and the company records adjusting entries only at that time. (a) Prepare the journal entry to record the purchase of inventory on February 1. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List debit entry before credit entry.) Date Account Titles Feb. 1 Debit Creditarrow_forwardPedia Company purchased inventory worth USD 60, 000 on July 1st and USD 90, 000 on July 16th under credit terms 2/15, n/30 during its first month of operations. On July 29, the payment for both purchases was made. What is the balance of the inventory account at the end of July if Pedia Company uses a periodic inventory system and prepares an adjusting entry at the end of the year? And by how much must cash be reduced for the month of July?arrow_forwardVaughn Limited, which uses a perpetual inventory system, purchased inventory costing $22,000 on February 1 by issuing a 3-month note payable bearing interest at 6%, with interest and principal due on May 1. The company's year end is on March 31 and the company records adjusting entries only at that time. (a) Prepare the journal entry to record the purchase of inventory on February 1. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List debit entry before credit entry.) Your answer is correct. Feb. 1 (b) Date Account Titles Inventory Notes Payable eTextbook and Media List of Accounts Your answer is incorrect. Mar. 31 Debit 22000 Debit Credit Prepare the journal entry to record the accrual of interest expense on March 31. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is…arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning