![Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)](https://www.bartleby.com/isbn_cover_images/9780133851731/9780133851731_largeCoverImage.gif)
Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780133851731
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.38AP
To determine
Statement of cash flow – Spreadsheet method
Statement of
Spreadsheet method:
- The statement of cash flows also can be prepared as a spreadsheet.
- The spreadsheet for the statement of cash flow starts with the beginning balance and ends with the ending balances of accounts of the balances sheet.
- The spread includes two extra columns between the ending and beginning balance columns. One column is for debit and other for credit balance.
To Prepare: Statement of cash flows using the spreadsheet in indirect method.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
Chapter 15 Homework
13
Saved
Help
Save & Exit Submit
Part 1 of 2
0.83
points
eBook
Ask
Required information
Use the following information to answer questions. (Algo)
[The following information applies to the questions displayed below.]
Information on Kwon Manufacturing's activities for its first month of operations follows:
a. Purchased $100,800 of raw materials on credit.
b. Materials requisitions show the following materials used for the month.
Job 201
Job 202
Total direct materials
Indirect materials
Total materials used
$ 49,000
24,400
73,400
9,420
$ 82,820
c. Time tickets show the following labor used for the month.
Print
References
Job 201
$ 40,000
Job 202
13,400
Total direct labor
53,400
25,000
$ 78,400
Indirect labor
Total labor used
d. Applied overhead to Job 201 and to Job 202 using a predetermined overhead rate of 80% of direct materials cost.
e. Transferred Job 201 to Finished Goods Inventory.
f. Sold Job 201 for $166,160 on credit.
g. Incurred the following actual other…
quesrion 2
Anti-Pandemic Pharma Co. Ltd. reports the following information in
its income statement:
Sales = $5,250,000;
Costs = $2, 173,000;
Other expenses = $187,400;
Depreciation expense = $79,000;
Interest expense= $53,555;
Taxes $76,000;
Dividends $69,000.
$136,700 worth of new shares were also issued during the year and
long-term debt worth $65,300 was redeemed.
a) Compute the cash flow from assets
b) Compute the net change in working capital
(325 marks)
Chapter 14 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)
Ch. 14 - The purposes of the statement of cash flows are to...Ch. 14 - The main categories of cash flow activities are a....Ch. 14 - Operating activities are most closely related to...Ch. 14 - Which item does not appear on a statement of cash...Ch. 14 - Leather Shop earned net income of 57,000 after...Ch. 14 - The Plant Assets account and Accumulated...Ch. 14 - Mountain Water Corp. issued common stock of 28,000...Ch. 14 - Prob. 8QCCh. 14 - Prob. 9AQCCh. 14 - If accrued liabilities increased during the year,...
Ch. 14 - Prob. 1RQCh. 14 - How does the statement of cash flows help users of...Ch. 14 - Describe the three basic types of cash flow...Ch. 14 - What types of transactions are reported in the...Ch. 14 - Prob. 5RQCh. 14 - Prob. 6RQCh. 14 - Explain why depreciation expense, depletion...Ch. 14 - Prob. 8RQCh. 14 - If current assets other than cash increase, what...Ch. 14 - If current liabilities increase, what is the...Ch. 14 - Prob. 11RQCh. 14 - Prob. 12RQCh. 14 - Prob. 13RQCh. 14 - Prob. 14RQCh. 14 - Prob. 15ARQCh. 14 - Prob. 16BRQCh. 14 - Describing the purposes of the statement of cash...Ch. 14 - Prob. 14.2SECh. 14 - Classifying items on the indirect statement of...Ch. 14 - Computing cash flows from operating...Ch. 14 - Prob. 14.5SECh. 14 - Prob. 14.6SECh. 14 - Prob. 14.7SECh. 14 - Prob. 14.8SECh. 14 - Prob. 14.9SECh. 14 - Prob. 14.10SECh. 14 - Preparing a statement of cash flows using the...Ch. 14 - Prob. 14.12SECh. 14 - Preparing the direct method statement of cash...Ch. 14 - Prob. 14.14SECh. 14 - Prob. 14.15SECh. 14 - Classifying cash flow items Consider the following...Ch. 14 - Prob. 14.17ECh. 14 - Prob. 14.18ECh. 14 - Prob. 14.19ECh. 14 - Prob. 14.20ECh. 14 - Prob. 14.21ECh. 14 - Prob. 14.22ECh. 14 - Prob. 14.23ECh. 14 - Prob. 14.24ECh. 14 - Prob. 14.25ECh. 14 - Prob. 14.26ECh. 14 - Prob. 14.27ECh. 14 - Prob. 14.28ECh. 14 - Prob. 14.29ECh. 14 - Prob. 14.30ECh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.32APCh. 14 - Prob. 14.33APCh. 14 - Prob. 14.34APCh. 14 - Prob. 14.35APCh. 14 - Preparing the statement of cash flows----direct...Ch. 14 - Prob. 14.37APCh. 14 - Prob. 14.38APCh. 14 - Prob. 14.39BPCh. 14 - Prob. 14.40BPCh. 14 - Prob. 14.41BPCh. 14 - Prob. 14.42BPCh. 14 - Prob. 14.43BPCh. 14 - Prob. 14.44BPCh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.46CPCh. 14 - Prob. 14.1CTDCCh. 14 - Moss Exports is having a bad year. Net income is...Ch. 14 - Details about a company's cash flows appear in a...
Knowledge Booster
Similar questions
- QS 15-18 (Algo) Computing and recording over- or underapplied overhead LO P4 A company applies overhead at a rate of 170% of direct labor cost. Actual overhead cost for the current period is $1,081,900, and direct labor cost is $627,000. 1. Compute the under- or overapplied overhead. 2. Prepare the journal entry to close over- or underapplied overhead to Cost of Goods Sold. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the under- or overapplied overhead.arrow_forwardQuestion 6 During 2019, Bitsincoins Corporation had EBIT of $100,000, a change in net fixed assets of $400,000, an increase in net current assets of $100,000, an increase in spontaneous current liabilities of $400,000, a depreciation expense of $50,000, and a tax rate of 30%. Based on this information, what is Bitsincoin's free cash flow? (3 marks)arrow_forwardQuestion 4 Waterfront Inc. wishes to borrow on a short-term basis without reducing its current ratio below 1.25. At present its current assets and current liabilities are $1,600 and $1,000 respectively. How much can Waterfront Inc. borrow? (5 marks)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305088436/9781305088436_smallCoverImage.gif)
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub