
1.
Prepare a spreadsheet to support the
1.

Explanation of Solution
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.
Statement of cash flows: Statement of cash flow 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.
Prepare a spreadsheet entry to support the cash flow statement.
Table (1)
Table (2)
Working notes:
a. Calculate the Changes in
b. Calculate the changes in inventory.
c. Calculate the change in prepaid item.
d. Calculate the changes in accounts payable.
e. Calculate the changes in salaries payable.
f. Calculate the changes in miscellaneous current payable.
g-1) Understated of depreciation expenses for the last year by $1,800.
g-2) Received income tax refund of $500.
h) Calculate the additional paid in capital received through treasury stock.
i). Calculate the premium on bonds payable.
j-1) Common stock issued to convert the preferred stock by $3,000.
j-2) Preferred stock converted into common stock for $3,000.
k) Calculate the Premium on common stock.
l) Cash dividend paid by $4,000.
m) Amortization of premium on bonds payable by $100.
n) Cash increased by $200.
2.
Prepare a cash flow statement under indirect method of B Company for the year 2019 and show operating cash flow in the separate schedule.
2.

Explanation of Solution
Operating activities: Operating activities include
Financing activities: Financing activities includes cash inflows and outflows from issuance of common stock and debt, payment of debt and dividends.
Investing activities: Investing activities includes cash inflows and
Prepare the cash flow statement under indirect method.
B company | ||
Statement of cash flow | ||
For the year end 2019 | ||
Particulars | Amount ($) | Amount ($) |
Operating activities: | ||
Net cash provided by operating activities ( schedule 1) | $22,950 | |
Investing activities: | ||
Proceeds from sale of land | $3,800 | |
Payment for loan on note receivable | (1,000) | |
Payment for purchase of land | (9,000) | |
Payment for purchase of equipment | (32,000) | |
Net cash used for investing activities | ($38,200) | |
Financing activities: | ||
Proceeds from sale of | $ 1,800 | |
Proceeds from issuance of 12% bonds payable | 7,750 | |
Proceeds from issuance of common stock | 9,900 | |
Payment of dividends | (4,000) | |
Net cash provided by financing activities | 15,450 | |
Net increase in cash (Schedule 2) | $200 | |
Cash, January 1, 2019 | 1,800 | |
Cash, December 31, 2019 | $2,000 | |
Schedule 1: Cash flows from operating activities | ||
Net income | $11,500 | |
Adjustment for non-cash income items: | ||
Add: | 6,000 | |
Patent amortization expense | 400 | |
Less: Amortization of bond premium | (100) | |
Gain on sale of equipment | (900) | |
Adjustment for cash flow effects from | ||
Increase in accounts receivable | (120) | |
Decrease in inventories | 2,300 | |
Decrease in prepaid items | 320 | |
Increase in accounts payable | 2,210 | |
Increase in salaries payable | 900 | |
Increase in interest payable | 140 | |
Decrease in miscellaneous current payables | (200) | |
Income tax refund | 500 | |
Net cash provided by operating activities | $22,950 | |
Schedule 2: Investing and Financing activities not affecting cash | ||
Financing activities: | ||
Conversion of | ($3,000) | |
Issuance of common stock to convert preferred stock | 3,000 |
Table (3)
Therefore cash balance as on December 31, 2019 is $2,000.
Want to see more full solutions like this?
Chapter 21 Solutions
Intermediate Accounting: Reporting And Analysis
- Last year, Jasmine Corporation earned an operating income of $34,600 with a contribution margin ratio of 0.35. Actual revenue was $320,000. Calculate the total fixed cost. Round your answer to the nearest dollar, if required.arrow_forwardPlease explain the correct approach for solving this general accounting question.arrow_forwardI am searching for the correct answer to this financial accounting problem with proper accounting rules.arrow_forward
- A company buys equipment for $10,000 with a useful life of 5 years and no salvage value. What is the annual depreciation expense using straight-line method?A. $1,000B. $2,000C. $2,500D. $5,000arrow_forwardPlease explain the solution to this general accounting problem using the correct accounting principles.arrow_forwardDirect materials:2.45, Direct labor:4.20arrow_forward
- Can you explain this general accounting question using accurate calculation methods?arrow_forwardWhat is the correct answer with accountingarrow_forwardTansen Industries bases its manufacturing overhead budget on budgeted machine-hours. The production budget indicates that 8,200 machine-hours will be required in July. The variable overhead rate is $6.75 per machine-hour. The company's budgeted fixed manufacturing overhead is $145,000 per month, which includes depreciation of $17,500. All other fixed manufacturing overhead costs represent current cash flows. What should be the July cash disbursements for manufacturing overhead on the manufacturing overhead budget?arrow_forward
- Financial accounting questionsarrow_forwardFor the year, Rochester Industries has a cost of goods manufactured of $850,000, beginning finished goods inventory of $210,000, and ending finished goods inventory of $185,000. What is the cost of goods sold? A. $620,000 B. $670,000 C. $700,000 D. $875,000arrow_forwardI need assistance with this general accounting question using appropriate principles.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,



