Question: 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

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 spaced provided on the blank Statement of Cash Flows.
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 spaced provided on the blank Statement
of Cash Flows. Cash \& Equivalents APIC Excess of Par AOCI Unreal
G/L on MS APIC Stock Options Treasury Stock Retained Earnings \begin{tabular}{l|l} \hline
& 140,218 \\ & \\ \hline & 278,151 \end{tabular} \begin{tabular}{l|l} \hline+5 &
\\ & \\ & \\ & \\ & \\ & \end{tabular} Investing
Financing Accum Depr Note 6: The only long-term debt was issued January
1st2016 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 31tt. 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

Cash \& Equivalents APIC Excess of Par AOCI Unreal G/L on MS APIC Stock Options Treasury Stock Retained Earnings \begin{tabular}{l|l} \hline & 140,218 \\ & \\ \hline & 278,151 \end{tabular} \begin{tabular}{l|l} \hline+5 & \\ & \\ & \\ & \\ & \\ & \end{tabular} Investing Financing Accum Depr Note 6: The only long-term debt was issued January 1st2016 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 31tt. 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. Accts Pay and Accr Liab Long-Term Fin Lease Cap Deferred Tax Lia 131,576 Stockholders' Equity \begin{tabular}{lrr} Capital stock \$5 par (Note 7) & 313,000 & 292,000 \\ Additional Paid in Capital Excess of Par & 232,500 & 225,000 \\ Additional Paid in Capital Stock Options & 28,000 & 21,000 \\ Retained earnings & 278,151 & 140,218 \\ AOCI: Unrealized gain on securities available for sale (Note 2) & 1,500 & 1,750 \\ Less: Treasury Shares (Note 7) & (20,000) & 0 \\ \hline & 833,151 & 679,968 \\ \hline Total Liabilities and Shareholders' Equity & $956,092 & $811,544 \\ \hline \end{tabular} Year Ended Dec, 31 (SDollars) Note 1: Cash and cash equivalents are defined to be cash and all highly liquid investments with maturities of less than 30 days. 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: Note 3: The Company leased an asset in 2018. 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. (Continued on next page) Orpurt's Oats, Inc Consolidated Statement of Earnings Year Ended Dec. 31 (\$ Dollars) 2018 Net Sales Sales Revenues Costs and expenses Cost of Sales 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 $1,955,2851,678,09345,90019,1787,0003,109(500)(820)10,000$193,325 Orpurt's Oats, Inc Consolidated Statement of Cash Flows Year Ended Dec. 31 2018(Sollars) Operations Earnings Reconciling items (provide explanations): HINT: Here is the amortization table to help you determine the cash flows: (a) Lease payment as required by lease. (b) Four percent of the preceding balance of (d) except for 1/1/28; 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 mirus (c). Rounded by $0.09. Orpurt's Oats, Inc. Consolidated Balance Sheet As of Dec. 31 (SDollars) \begin{tabular}{lrr} & 2018 & 2017 \\ \hline Assets & & \\ Current assets & $45,000 & $30,000 \\ Cash (Note 1) & 62,500 & 31,800 \\ Accounts receivable, net & 60,997 & 90,994 \\ Inventories & 10,000 & 11,750 \\ Marketable securities-available for sale (Note 2) & 178,497 & 164,544 \\ \hline & 40,383 & 0 \\ Deferred tax asset & 76,712 & 0 \\ Right of Use Asset (Note 3) & 660,500 & 647,000 \\ Fixed assets (Note 4) & $956,092 & $811,544 \\ \hline Total Assets & & \\ Liabilities & & \\ Current Liabilities & $9,401 & $39,324 \\ Accounts payable and accrued charges & 20,711 & 0 \\ Obligation under finance lease (Note 5) & 0 & 8,000 \\ Dividends payable & 30,112 & 47,324 \\ \hline & 57,475 & 0 \\ Long-term obligation under finance lease (Note 5) & & 852 \\ & 854 & 83,400 \\ \hline Long-term debt (Note 6) & 34,500 & \\ Deferred tax liability & 122,941 & \\ \hline \end{tabular} Financing Activities Sources/Uses of cash (provide explanations): Cash from (used for) financing activities Increase (decrease) in cash and cash equivalents 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. 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. Inv Sol Cash \& Equivalents APIC Excess of Par AOCI Unreal G/L on MS APIC Stock Options Treasury Stock Retained Earnings \begin{tabular}{l|l} \hline & 140,218 \\ & \\ \hline & 278,151 \end{tabular} \begin{tabular}{l|l} \hline+5 & \\ & \\ & \\ & \\ & \\ & \end{tabular} Investing Financing Accum Depr Note 6: The only long-term debt was issued January 1st2016 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 31tt. 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. Accts Pay and Accr Liab Long-Term Fin Lease Cap Deferred Tax Lia 131,576 Stockholders' Equity \begin{tabular}{lrr} Capital stock \$5 par (Note 7) & 313,000 & 292,000 \\ Additional Paid in Capital Excess of Par & 232,500 & 225,000 \\ Additional Paid in Capital Stock Options & 28,000 & 21,000 \\ Retained earnings & 278,151 & 140,218 \\ AOCI: Unrealized gain on securities available for sale (Note 2) & 1,500 & 1,750 \\ Less: Treasury Shares (Note 7) & (20,000) & 0 \\ \hline & 833,151 & 679,968 \\ \hline Total Liabilities and Shareholders' Equity & $956,092 & $811,544 \\ \hline \end{tabular} Year Ended Dec, 31 (SDollars) Note 1: Cash and cash equivalents are defined to be cash and all highly liquid investments with maturities of less than 30 days. 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: Note 3: The Company leased an asset in 2018. 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. (Continued on next page) Orpurt's Oats, Inc Consolidated Statement of Earnings Year Ended Dec. 31 (\$ Dollars) 2018 Net Sales Sales Revenues Costs and expenses Cost of Sales 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 $1,955,2851,678,09345,90019,1787,0003,109(500)(820)10,000$193,325 Orpurt's Oats, Inc Consolidated Statement of Cash Flows Year Ended Dec. 31 2018(Sollars) Operations Earnings Reconciling items (provide explanations): HINT: Here is the amortization table to help you determine the cash flows: (a) Lease payment as required by lease. (b) Four percent of the preceding balance of (d) except for 1/1/28; 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 mirus (c). Rounded by $0.09. Orpurt's Oats, Inc. Consolidated Balance Sheet As of Dec. 31 (SDollars) \begin{tabular}{lrr} & 2018 & 2017 \\ \hline Assets & & \\ Current assets & $45,000 & $30,000 \\ Cash (Note 1) & 62,500 & 31,800 \\ Accounts receivable, net & 60,997 & 90,994 \\ Inventories & 10,000 & 11,750 \\ Marketable securities-available for sale (Note 2) & 178,497 & 164,544 \\ \hline & 40,383 & 0 \\ Deferred tax asset & 76,712 & 0 \\ Right of Use Asset (Note 3) & 660,500 & 647,000 \\ Fixed assets (Note 4) & $956,092 & $811,544 \\ \hline Total Assets & & \\ Liabilities & & \\ Current Liabilities & $9,401 & $39,324 \\ Accounts payable and accrued charges & 20,711 & 0 \\ Obligation under finance lease (Note 5) & 0 & 8,000 \\ Dividends payable & 30,112 & 47,324 \\ \hline & 57,475 & 0 \\ Long-term obligation under finance lease (Note 5) & & 852 \\ & 854 & 83,400 \\ \hline Long-term debt (Note 6) & 34,500 & \\ Deferred tax liability & 122,941 & \\ \hline \end{tabular} Financing Activities Sources/Uses of cash (provide explanations): Cash from (used for) financing activities Increase (decrease) in cash and cash equivalents 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. 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. Inv Sol

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!