Prepare an indirect method statement of cash flows for 2018. A T-account worksheet is provided to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare an indirect method statement of cash flows for 2018. A T-account worksheet is provided to assist you but you will only be rewarded for answering the question in the spaces provided on the blank Statement of Cash Flows. As of Dec. 31 Assets Current assets Cash (Note 1) Accounts receivable, net Inventories Marketable securities-available for sale (Note 2) Deferred tax asset Right of Use Asset (Note 3) Fixed assets (Note 4) Total Assets Liabilities Current Liabilities Orpurt's Oats, Inc. Consolidated Balance Sheet Accounts payable and accrued charges Obligation under finance lease (Note 5) Dividends payable Long-term obligation under finance lease (Note 5) Long-term debt (Note 6) Deferred tax liability Stockholders' Equity Capital stock $5 par (Note 7) Additional Paid in Capital Excess of Par Additional Paid in Capital Stock Options Retained earnings AOCI: Unrealized gain on securities available for sale (Note 2) Less: Treasury Shares (Note 7) Total Liabilities and Shareholders' Equity 2018 $ 45,000 62,500 60,997 10,000 178,497 40,383 76,712 660,500 $956,092 $ 9,401 20,711 0 30,112 57,475 854 34,500 122,941 313,000 232,500 28,000 278,151 1,500 (20,000) 833,151 $ 956,092 ($ Dollars) 2017 $30,000 31,800 90,994 11,750 164,544 0 0 647,000 $811,544 $39,324 0 8,000 47,324 0 852 83,400 131,576 292,000 225,000 21,000 140,218 1,750 0 679,968 $811,544 Year Ended Dec. 31 ($ Dollars) Net Sales Sales Revenues Costs and expenses Cost of Sales Orpurt's Oats, Inc Consolidated Statement of Earnings Depreciation expense Amortization expense (leased asset right of use) Incentive compensation expense Interest expense Loss (gain) on sales and retirement of equipment (Note 4) Realized loss (gain) on sale of available for sale securities (Note 2) Income Tax expense Net Earnings Year Ended Dec. 31 Orpurt's Oats, Inc Notes to Consolidated Financial Statements 2018 $ 1,955,285 ($ Dollars) Note 1: Cash and cash equivalents are defined to be cash and all highly liquid investments with maturities of less than 30 days. Balance, December 31, 2017 Realized (gain) loss on securities sold during the year Change in net unrealized gain (loss) on securities held at year end Balance, December 31 2018 1,678,093 45,900 19,178 7,000 3,109 (500) (820) 10,000 $193,325 Note 2: Securities on hand are classified as "securities available for sale" (SAFS). SAFS consist only of bonds acquired at par (face amount) (thus there is no premium or discount to amortize). SAFS on December 31, 2018 had an acquisition cost of $8,500 and a fair market value of $10,000. Gross unrealized gains total $1,600 and gross unrealized losses total $100. SAFS with a cost of $5,000 were sold during the year generating a realized gain of $820. SAFS were purchased during the year. The net unrealized holding gain on securities available for sale changed as follows during 2018: $1,750 (820) 570 $1,500 Note 3: The Company leased an asset in 2016. As a result, a right of use asset was initially recorded at $95,890 representing the present value of the lease payment and subsequently amortized (straight line). See Note 5. Note 4: Fixed assets consist of: Property, plant and equipment (at cost) Accumulated depreciation During 2018, the company made one purchase of equipment. It acquired a brand new Genetic Oat Modifier Machine worth $62,000 for cash. The machine is used to modify Oat flower genetics to create new Oats such as the "Quaker One Minute Oat" popular for its quick preparation time. The Company sold equipment during 2018 at a gain of $500. HINT: Here is the amortization table to help you determine the cash flows: Date Note 5: The Company leased an oat planter on January 1, 2018. The planter could have been purchased for $100,000. The lease term is five years. The lease is non-cancellable. It has a guaranteed residual of $5,000 and the Company expects the planter to be worth more at the end of the lease term. There are no renewal terms and the planter reverts to the lessor at termination of the lease. The implicit lease discount rate is 4%. Payments of $20,711 are made annually starting January 1, 2018 and the present value of the lease payments at inception of the lease was $95,890. 1/1/18 1/1/18 1/1/19 1/1/20 1/1/21 1/1/22 Annual Lease Payment (a) $ 20,711.11 20,711.11 20,711.11 20,711.11 20,711.11 $103,555.55 Orpurt's Oats, Inc. LEASE AMORTIZATION SCHEDULE ANNUITY-DUE BASIS Interest (4%) on Liability (b) 2018 $ 727,500 (67,000) $660,500 $ -0- 3,007.17 2,299.01 1,562.53 796.49* $7,665.20 Reduction of Lease Liability (C) 2017 $ 702,000 (55,000) $647,000 $20,711.11 17,703.94 18,412.10 19,148.58 19,914.62 $95,890.35 Lease Liability (d) $95,890.35 75,179.24 57,475.30 39,063.20 19,914.62 0.00 (a) Lease payment as required by lease. (b) Four percent of the preceding balance of (d) except for 1/1/18 since this is an annuity due, no time has elapsed at the date of the first payment and therefore no interest has accrued. (c) (a) minus (b). (d) Preceding balance minus (c). "Rounded by $0.09. Note 6: The only long-term debt was issued January 1st 2016 to yield 12%. The coupon rate on the debt is 10%, paid semi-annually. The face value of the debt outstanding is $1,000. The bonds are to be outstanding for twenty years with payments made each June 30th and December 31st. 2018 2017 Issue 10% coupon bonds due 12/31/2035 (Net of unamortized discount of $146 in 2018 and $148 in 2017) $ 854 $ 852 Note 7: Common stock has a par value of five dollars per share. The following equity transactions took place during 2018. One thousand shares were purchased for the treasury. There were no other treasury stock transactions. Shares were also issued on the open market (not from treasury) and this offering resulted in 4,200 shares issued (sold) for $28,500. The company declared and paid dividends to shareholders during 2018. Prepare an indirect method statement of cash flows for 2018. A T-account worksheet is provided to assist you but you will only be rewarded for answering the question in the spaces provided on the blank Statement of Cash Flows. As of Dec. 31 Assets Current assets Cash (Note 1) Accounts receivable, net Inventories Marketable securities-available for sale (Note 2) Deferred tax asset Right of Use Asset (Note 3) Fixed assets (Note 4) Total Assets Liabilities Current Liabilities Orpurt's Oats, Inc. Consolidated Balance Sheet Accounts payable and accrued charges Obligation under finance lease (Note 5) Dividends payable Long-term obligation under finance lease (Note 5) Long-term debt (Note 6) Deferred tax liability Stockholders' Equity Capital stock $5 par (Note 7) Additional Paid in Capital Excess of Par Additional Paid in Capital Stock Options Retained earnings AOCI: Unrealized gain on securities available for sale (Note 2) Less: Treasury Shares (Note 7) Total Liabilities and Shareholders' Equity 2018 $ 45,000 62,500 60,997 10,000 178,497 40,383 76,712 660,500 $956,092 $ 9,401 20,711 0 30,112 57,475 854 34,500 122,941 313,000 232,500 28,000 278,151 1,500 (20,000) 833,151 $ 956,092 ($ Dollars) 2017 $30,000 31,800 90,994 11,750 164,544 0 0 647,000 $811,544 $39,324 0 8,000 47,324 0 852 83,400 131,576 292,000 225,000 21,000 140,218 1,750 0 679,968 $811,544 Year Ended Dec. 31 ($ Dollars) Net Sales Sales Revenues Costs and expenses Cost of Sales Orpurt's Oats, Inc Consolidated Statement of Earnings Depreciation expense Amortization expense (leased asset right of use) Incentive compensation expense Interest expense Loss (gain) on sales and retirement of equipment (Note 4) Realized loss (gain) on sale of available for sale securities (Note 2) Income Tax expense Net Earnings Year Ended Dec. 31 Orpurt's Oats, Inc Notes to Consolidated Financial Statements 2018 $ 1,955,285 ($ Dollars) Note 1: Cash and cash equivalents are defined to be cash and all highly liquid investments with maturities of less than 30 days. Balance, December 31, 2017 Realized (gain) loss on securities sold during the year Change in net unrealized gain (loss) on securities held at year end Balance, December 31 2018 1,678,093 45,900 19,178 7,000 3,109 (500) (820) 10,000 $193,325 Note 2: Securities on hand are classified as "securities available for sale" (SAFS). SAFS consist only of bonds acquired at par (face amount) (thus there is no premium or discount to amortize). SAFS on December 31, 2018 had an acquisition cost of $8,500 and a fair market value of $10,000. Gross unrealized gains total $1,600 and gross unrealized losses total $100. SAFS with a cost of $5,000 were sold during the year generating a realized gain of $820. SAFS were purchased during the year. The net unrealized holding gain on securities available for sale changed as follows during 2018: $1,750 (820) 570 $1,500 Note 3: The Company leased an asset in 2016. As a result, a right of use asset was initially recorded at $95,890 representing the present value of the lease payment and subsequently amortized (straight line). See Note 5. Note 4: Fixed assets consist of: Property, plant and equipment (at cost) Accumulated depreciation During 2018, the company made one purchase of equipment. It acquired a brand new Genetic Oat Modifier Machine worth $62,000 for cash. The machine is used to modify Oat flower genetics to create new Oats such as the "Quaker One Minute Oat" popular for its quick preparation time. The Company sold equipment during 2018 at a gain of $500. HINT: Here is the amortization table to help you determine the cash flows: Date Note 5: The Company leased an oat planter on January 1, 2018. The planter could have been purchased for $100,000. The lease term is five years. The lease is non-cancellable. It has a guaranteed residual of $5,000 and the Company expects the planter to be worth more at the end of the lease term. There are no renewal terms and the planter reverts to the lessor at termination of the lease. The implicit lease discount rate is 4%. Payments of $20,711 are made annually starting January 1, 2018 and the present value of the lease payments at inception of the lease was $95,890. 1/1/18 1/1/18 1/1/19 1/1/20 1/1/21 1/1/22 Annual Lease Payment (a) $ 20,711.11 20,711.11 20,711.11 20,711.11 20,711.11 $103,555.55 Orpurt's Oats, Inc. LEASE AMORTIZATION SCHEDULE ANNUITY-DUE BASIS Interest (4%) on Liability (b) 2018 $ 727,500 (67,000) $660,500 $ -0- 3,007.17 2,299.01 1,562.53 796.49* $7,665.20 Reduction of Lease Liability (C) 2017 $ 702,000 (55,000) $647,000 $20,711.11 17,703.94 18,412.10 19,148.58 19,914.62 $95,890.35 Lease Liability (d) $95,890.35 75,179.24 57,475.30 39,063.20 19,914.62 0.00 (a) Lease payment as required by lease. (b) Four percent of the preceding balance of (d) except for 1/1/18 since this is an annuity due, no time has elapsed at the date of the first payment and therefore no interest has accrued. (c) (a) minus (b). (d) Preceding balance minus (c). "Rounded by $0.09. Note 6: The only long-term debt was issued January 1st 2016 to yield 12%. The coupon rate on the debt is 10%, paid semi-annually. The face value of the debt outstanding is $1,000. The bonds are to be outstanding for twenty years with payments made each June 30th and December 31st. 2018 2017 Issue 10% coupon bonds due 12/31/2035 (Net of unamortized discount of $146 in 2018 and $148 in 2017) $ 854 $ 852 Note 7: Common stock has a par value of five dollars per share. The following equity transactions took place during 2018. One thousand shares were purchased for the treasury. There were no other treasury stock transactions. Shares were also issued on the open market (not from treasury) and this offering resulted in 4,200 shares issued (sold) for $28,500. The company declared and paid dividends to shareholders during 2018.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Prepare a statement of cash flows for the Seagull Corporation. Follow the general procedures indicated in Table your textbook. SESAGULL CORPORATION Income statement For the year ended December 31,...
-
Prepare a statement of cash flows for Abrahams Manufacturing Company for the year ended December 31, 2012. Interpret your results. Abrahams Manufacturing Company Income Statement for the Year Ended...
-
Prepare a statement of cash flows for Nosker Company using the direct method: NOSKER COMPANY Comparative Balance Sheets December 31 Assets 2020 2019 Cash $37,300 $19,100 Accounts receivable 32,700...
-
The following data are from the accounting records of Niles Castings for year 2: Units produced and sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85,000 Total revenues and costs Sales...
-
What is the most important factor in a strategic alliance?
-
Why is accessing a disk block expensive? Discuss the time components involved in accessing a disk block.
-
Consider a random walk \(\left\{y_{t} ight\}\) as the partial sum of a white noise process \(\left\{c_{t} ight\}\). a. Show that the \(l\)-step forecast error is...
-
The Gannon Company has budgeted sales revenues as follows: Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the...
-
As Kelly gained approval for the project plan now, he has to get the security clearance from the IT administrator to access the site. To gain security clearance, you are required to write an email to...
-
Consider a building with 3200 ft 2 of walls. Assume the ceiling is well-insulated and compute the energy loss through the walls based on the following materials, assuming an indoor temperature of 70...
-
Chillman Motors, Inc., is an oligopolist and faces the following kinked demand curve: 200 180 MR 160 140 120 MC 100 80 60 40 20 10 20 30 40 50 60 70 80 90 100 Quantity Price and cost ($/Unit)
-
(Yield to maturity) You own a 22-year bond that pays 9 percent interest annually. The par value of the bond is $1,000 and the market price of the bond is $1,000. What is the yield to maturity of the...
-
Formulate but do not solve the problem. The management of Hartman Rent-A-Car has allocated $2.43 million to buy a fleet of new automobiles consisting of compact, intermediate-size, and full-size...
-
An electrical engineer purchases a new numerical controller. It costs $455,000.00 and the salvage value will be $65,000.00 at the end of four years. Calculate the sum-of-the-years digits book value...
-
When Oscar was reviewing the financial statements at the end of the year, he noticed that Sybil produced 1 0 , 0 0 0 units of inventory despite the fact that he told her throughout the year that they...
-
The financial statements of Cheyenne Ltd. include the following items at December 31, 2025. Accounts payable Accounts receivable Cash Accumulated depreciation-buildings 44,520 Accumulated...
-
A barrel of oil is leaking into a stream that is feeding into a lake. The barrel has been leaking for 6 hours and is found still containing 300 kg of oil. Measurement of the lake were taken when the...
-
As indicated by mutual fund flows, investors tend to beat the market seek safety invest in last year's winner invest in last years loser
-
The CPA Canada Handbook is available to most post-secondary students through their educational institutions subscription. Visit http://edu.knotia.ca to complete this exercise. (You may need to...
-
Chris Hacker Ltd. (CHL) is about to reconcile its bank statement for the month of September 2018. Pertinent information follows: Bank statement balance $6,627.87 General ledger balance $5,685.45. The...
-
Hinton Property Management Company (HPMC) owns several properties that it rents to major hotel chains such as The Westin and Holiday Inn. HPMC does not operate the hotels but instead simply provides...
-
Do an Internet search on "build operate transfer." Identify a BOT project, preferably from your home continent (e.g., AF, AS, EU, Pacific, NA, SA), and copy a small portion of what you find (a page...
-
True or False: Benefits and disbenefits must be converted to monetary values to use benefit-cost analysis.
-
Using an Internet-based search on 'build operate transfer," find an additional definition from a source other than used in Section 14.2. Copy and paste it, as well as any graphics, examples,...
Study smarter with the SolutionInn App