Concept explainers
1.
Prepare a spreadsheet to support the statement of
1.
Explanation of Solution
Statement of cash flows: This statement reports all the cash transactions which are responsible for inflow and outflow of cash, and result of these transactions is reported as ending balance of cash at the end of reported period. Statement of cash flows includes the changes in cash balance due to operating, investing, and financing activities.
Worksheet: A worksheet is a spreadsheet used while preparing a financial statement. It is a type of form having multiple columns and it is used in the adjustment process. The use of a worksheet is optional for any organization. A worksheet can neither be considered as a journal nor a part of the general ledger.
Direct method: Under direct method, cash receipts from customers (
Prepare a spreadsheet to support the statement of cash flows under direct method.
Table (1)
Table (2)
Working notes:
a) Net sales for the year is $1,950,000.
b) Cost of goods sold is $1,150,000.
c) Other operating expenses is $505,000.
f) Interest expense is $15,000.
h) Loss on sale of equipment is $5,000.
i) Income tax expense is $90,000.
j) Calculate the accounts receivable.
k) Calculate the increase in inventory.
l) Calculate the accounts payable.
m) Calculate the
n) Calculate proceeds from sale of common stock.
o) Calculate proceeds from sale of
p) Calculate the payment to retire bonds.
q) Purchase of equipment is $63,000.
r-1) Issuance of long-term note is $150,000.
r-2) Calculate issuance of long-term note to purchase land.
s) Payment of cash dividends is $43,000.
t) Calculate net increase in cash.
Therefore, net increase in cash is $45,000.
2.
Prepare a statement of cash flows of F Company for the year 2016.
2.
Explanation of Solution
Prepare a statement of cash flows of F Company for the year 2016.
F Company | ||
Statement of cash flows | ||
For Year Ended December 31, 2016 | ||
Particulars | Amount($) | Amount($) |
Operating Activities: | ||
Cash inflows: | ||
Collections from customers | 1,960,000 | |
Cash inflows from operating activities | 1,960,000 | |
Cash outflows: | ||
Payments to suppliers | (1,227,000) | |
Other operating payments | (505,000) | |
Payments of interest | (15,000) | |
Payments of income taxes | (79,000) | |
Cash outflows from operating activities | (1,826,000) | |
Net cash provided by operating activities | 134,000 | |
Investing Activities: | ||
Proceeds from sale of equipment | 19,000 | |
Payment for purchase of equipment | (63,000) | |
Net cash used for investing activities | (44,000) | |
Financing Activities: | ||
Proceeds from sale of common stock | 23,000 | |
Proceeds from sale of treasury stock | 25,000 | |
Payment to retire bonds | (50,000) | |
Payment of cash dividend | (43,000) | |
Net cash used for financing activities | (45,000) | |
Net increase in cash (see Schedule 1) | 45,000 | |
Cash, January 1, 2016 | 180,000 | |
Cash, December 31,2016 | 225,000 | |
Schedule 1: Investing and Financing Activities Not Affecting Cash | ||
Investing Activities: | ||
Purchase of land by issuance of long-term note | (150,000) | |
Financing Activities: | ||
Issuance of long-term note to purchase land | 150,000 |
Table (3)
Therefore, the net increase in cash is $45,000.
Want to see more full solutions like this?
Chapter 21 Solutions
EBK INTERMEDIATE ACCOUNTING: REPORTING
- Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1,000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50,000 to retire bonds with a face value (and book value) of 50,000. e. On July 2, 2019, Farrell purchased equipment for 63,000 cash. f. On December 31, 2019. land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows.arrow_forwardStatement of Retained Earnings Landon Corporation was organized on January 2, 2014, with the investment of $100,000 by each of its two stockholders. Net income for its first year of business was $85,200. Net income increased during 2015 to $125,320 and to $145,480 during 2016. Landon paid $20,000 in dividends to each of the two stockholders in each of the three years. Required Prepare a statement of retained earnings for the year ended December 31, 2016.arrow_forwardThe comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.arrow_forward
- Income Statement Ratio The income statement of Holly Enterprises shows operating revenues of $134,800, selling expenses of $38,310, general and administrative expenses of $36,990, interest expense of $580, and income tax expense of $13,920. Hollys stockholders equity was $280,000 at the beginning of the year and $320,000 at the end of the year. The company has 20,000 shares of stock outstanding at the end of the year. Required Compute Hollys profit margin. What other information would you need in order to comment on whether this ratio is favorable?arrow_forwardStatement of Retained Earnings for Brunswick Corporation Brunswick Corporation reported the following amounts in various statements included in its Form 10-K for the year ended December 31, 2013. (All amounts are stated in millions of dollars.) Required Prepare a statement of retained earnings for Brunswick Corporation for the year ended December 31, 2013. Brunswick does not actually present a statement of retained earnings in its annual report. Instead, it presents a broader statement of shareholders equity. Describe the information that would be included on this statement that is not included on a statement of retained earnings.arrow_forwardThe following selected accounts appear in the ledger of EJ Construction Inc. at the beginning of the current fiscal year: During the year, the corporation completed a number of transactions affecting the stockholders equity. They are summarized as follows: a. Issued 500,000 shares of common stock at 8, receiving cash. b. Issued 10,000 shares of preferred 1% stock at 60. c. Purchased 50,000 shares of treasury common for 7 per share. d. Sold 20,000 shares of treasury common for 9 per share. e. Sold 5,000 shares of treasury common for 6 per share. f. Declared cash dividends of 0.50 per share on preferred stock and 0.08 per share on common stock. g. Paid the cash dividends. Instructions Journalize the entries to record the transactions. Identify each entry by letter.arrow_forward
- The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.arrow_forwardSelected transactions completed by Equinox Products Inc. during the fiscal year ended December 31, 2016, were as follows: a. Issued 15,000 shares of 20 par common stock at 30, receiving cash. b. Issued 4,000 shares of 80 par preferred 5% stock at 100, receiving cash. c. Issued 500,000 of 10-year, 5% bonds at 104, with interest payable semiannually. d. Declared a quarterly dividend of 0.50 per share on common stock and 1.00 per share on preferred stock. On the date of record, 100,000 shares of common stock were outstanding, no treasury shares were held, and 20,000 shares of preferred stock were outstanding. e. Paid the cash dividends declared in (d). f. Purchased 7,500 shares of Solstice Corp. at 40 per share, plus a 150 brokerage commission. The investment is classified as an available-for-sale investment. g. Purchased 8,000 shares of treasury common stock at 33 per share. h. Purchased 40,000 shares of Pinkberry Co. stock directly from the founders for 24 per share. Pinkberry has 125,000 shares issued and outstanding. Equinox Products Inc. treated the investment as an equity method investment. i. Declared a 1.00 quarterly cash dividend per share on preferred stock. On the date of record, 20,000 shares of preferred stock had been issued. j. Paid the cash dividends to the preferred stockholders. k. Received 27,500 dividend from Pinkberry Co. investment in (h). l. Purchased 90,000 of Dream Inc. 10-year, 5% bonds, directly from the issuing company, at their face amount plus accrued interest of 375. The bonds are classified as a heldtomaturity long-term investment. m. Sold, at 38 per share, 2,600 shares of treasury common stock purchased in (g). n. Received a dividend of 0.60 per share from the Solstice Corp. investment in (f). o. Sold 1,000 shares of Solstice Corp. at 45, including commission. p. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for six months. The amortization is determined using the straight-line method. q. Accrued interest for three months on the Dream Inc. bonds purchased in (l). r. Pinkberry Co. recorded total earnings of 240,000. Equinox Products recorded equity earnings for its share of Pinkberry Co. net income. s. The fair value for Solstice Corp. stock was 39.02 per share on December 31, 2016. The investment is adjusted to fair value, using a valuation allowance account. Assume Valuation Allowance for Available-for-Sale Investments had a beginning balance of zero. Instructions 1. Journalize the selected transactions. 2. After all of the transactions for the year ended December 31, 2016, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows were taken from the records of Equinox Products Inc. a. Prepare a multiple-step income statement for the year ended December 31, 2016, concluding with earnings per share. In computing earnings per share, assume that the average number of common shares outstanding was 100,000 and preferred dividends were 100,000. (Round earnings per share to the nearest cent.) b. Prepare a retained earnings statement for the year ended December 31, 2016. c. Prepare a balance sheet in report form as of December 31, 2016.arrow_forwardComprehensive: Income Statement and Supporting Schedules The following s a partial list of the account balances, after adjustments, of Silvoso Company on December 31, 2019: The following information is also available: 1. The company declared and paid a 0.60 per share cash dividend on its common stock. The stock was outstanding the entire year. 2. A physical count determined that the December 31, 2019, ending inventory is 34,100. 3. A tornado destroyed a warehouse, resulting in a pretax loss of 12,000. The last tornado in this area had occurred 10 years earlier. 4. On May 1, 2019, the company sold an unprofitable division (R). From January through April, Division R (a major component of the company) had incurred a pretax operating loss of 8,700. Division R was sold at a pretax gain of 10,000. 5. The company is subject to a 30% income tax rate. Its income tax expense for 2019 totals 4,230. The breakdown is as follows: 6. The company had average shareholders equity of 150,000 during 2019. Required: 1. As supporting documents for Requirement 2, prepare separate supporting schedules for cost of goods sold, selling expenses, general and administrative expenses, and depreciation expense. 2. Prepare a 2019 multiple-step income statement for Silvoso. Include any related note to the financial statements. 3. Prepare a 2019 retained earnings statement. 4. Next Level What was Silvosos return on common equity for 2019? What is your evaluation of Silvosos return on common equity if last year it was 10%?arrow_forward
- Assume that as of January 1, 20Y8, Sylvester Con- suiting has total assets of $500,000 and total assets of $150,000. As of December 31, 20Y8, Sylvester has total liabilities of $200,000 and total stockholders’ equity of $400,000. (a) What was Sylvester’s stockholders’ equity as of January 1, 20Y8? (b) Assume that Sylvester did not pay any dividends during 20Y8. What was the amount of net income for 20Y8?arrow_forwardSelected transactions completed by Equinox Products Inc. during the fiscal year ended December 31, 2016, were as follows: a. Issued 15,000 shares of 0 par common stock at 0, receiving cash. b. Issued 4,000 shares of 80 par preferred 5% stock at 100, receiving cash. c. Issued 500,000 of 10-year, 5% bonds at 104, with interest payable semiannually. d. Declared a quarterly dividend of 0.50 per share on common stock and 1.00 per share on preferred stock. On the date of record, 100,000 shares of common stock were outstanding, no treasury shares were held, and 20,000 shares of preferred stock were outstanding. e. Paid the cash dividends declared in (d). f. Purchased 7,500 shares of Solstice Corp. at 40 per share, plus a 150 brokerage commission. The investment is classified as an available-for-sale investment. g. Purchased 8,000 shares of treasury common stock at 33 per share. h. Purchased 40,000 shares of Pinkberry Co. stock directly from the founders for 24 per share. Pinkberry has 125,000 shares issued and outstanding. Equinox Products Inc. treated the investment as an equity method investment. i. Declared a 1.00 quarterly cash dividend per share on preferred stock. On the date of record, 20,000 shares of preferred stock had been issued. j. Paid the cash dividends to the preferred stockholders. k. Received 27,500 dividend from Pinkberry Co. investment in (h). l. Purchased 90,000 of Dream Inc. 10-year, 5% bonds, directly from the issuing company, at their face amount plus accrued interest of 375. The bonds are classified as a held- to-maturitv long-term investment. m. Sold, at 38 per share, 2,600 shares of treasury common stock purchased in (g). n. Received a dividend of 0.60 per share from the Solstice Corp. investment in (f). o. Sold 1,000 shares of Solstice Corp. at 545, including commission. p. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for six months. The amortization is determined using the straight-line method, q. Accrued interest for three months on the Dream Inc. bonds purchased in (1). r. Pinkberry Co. recorded total earnings of 240,000. Equinox Products recorded equity earnings for its share of Pinkberry Co. net income. s. The fair value for Solstice Corp. stock was 39.02 per share on December 31, 2016. The investment is adjusted to fair value, using a valuation allowance account. Assume Valuation Allowance for Available-for-Sale Investments had a beginning balance of zero. Instructions Journalize the selected transactions. After all of the transactions for the year ended December 31, 2016, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows were taken from the records of Equinox Products Inc. a. Prepare a multiple-step income statement for the year ended December 31, 2016, concluding with earnings per share. In computing earnings per share, assume that the average number of common shares outstanding was 100,000 and preferred dividends were 100,000. (Round earnings per share to the nearest cent.) b. Prepare a retained earnings statement for the year ended December 31, 2016. c. Prepare a balance sheet in report form as of December 31, 2016. Income statement data: Advertising expense 150,000 Cost of merchandise sold 3,700,000 Delivery expense 30,000 Depreciation expense -office buildings and equipment 30,000 Depreciation expensestore buildings and equipment 100,000 Dividend revenue 4,500 Gain on sale of investment 4,980 Income from Pinkberry Co. investment 76,800 Income tax expense 140,500 Interest expense 21,000 Interest revenue 2,720 Miscellaneous administrative expense 7.500 Miscellaneous selling expense 14,000 Office rent expense 50,000 Office salaries expense 170,000 Office supplies expense 10,000 Sales 5,254,000 Sales commissions 185,000 Sales salaries expense 385,000 Store supplies expense 21,000 Retained earnings and balance sheet data: Accounts payable 194,300 Accounts receivable 545,000 Accumulated depreciationoffice buildings and equipment 1,580,000 Accumulated depreciationstore buildings and equipment 4,126,000 Allowance for doubtful accounts 8,450 Available for sale investments (at cost) 260,130 Bonds payable. 5%. due 2024 500,000 Cash 246,000 Common stock, 20 par (400,000 shares authorized; 100,000 shares issued. 94,600 outstanding) 2,000,000 Dividends: Cash dividends for common stock 155,120 Cash dividends for preferred stock 100,000 Goodwill 500,000 Income tax payable 44,000 Interest receivable 1,125 Investment in Pinkberry Co. stock (equity method) 1,009,300 Investment in Dream Inc. bonds (long term) 90,000 Merchandise inventory [December 31, 2016). at lower of cost (FIFO) or market 778,000 Office buildings and equipment 4.320,000 Paid-in capital from sale of treasury stock 13,000 Excess of issue price over parcommon stock 886,800 Excess of issue price over parpreferred stock 150,000 Preferred 5% stock. 80 par (30,000 shares authorized; 20,000 shares issued] 1,600,000 Premium on bonds payable 19,000 Prepaid expenses 27,400 Retained earnings, January 1, 2016 9,319,725 Store buildings and equipment 12,560,000 Treasury stock (5,400 shares of common stock at cost of 33 per share) 178,200 Unrealized gain (loss) on available for sale investments (6,500) Valuation allowance for available for sale investments (6,500)arrow_forwardErrol Corporation earned net income of $200,000 this year. The company began the year with 10,000 shares of common stock and issued 5,000 more on April 1. They issued $7,500 in preferred dividends for the year. What is the numerator of the EPS calculation for Errol?arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT