The income statement and additional data of Vitamins Plus, Inc. follow: E (Click the icon to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The income statement and additional data of Vitamins Plus, Inc. follow: E (Click the icon to view the income statement.) A (Click the icon to view the additional data.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. Use the transaction references in Panel B when selecting the transaction references in Panel A. (If a box is not used in the spreadsheet, leave the box empty, do not select a label or enter a zero. Do not check your answer until both Panel A a completed. Abbreviations used: Acquistion of Plant Assets by Issuing NP = Acquisition of Plant Assets by Issuing Note Payable.) Vitamins Plus, Inc. A Data Table %3 Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Balance Vitamins Plus, Inc. Panel A-Balance Sheet: 9/30/2017 DEBIT CREDIT 9/30/2018 Income Statement 27,000 57.000 Cash 37,000 Year Ended September 30, 2018 Accounts Receivable 46,000 Net Sales Revenue S 230.000 Merchandise Inventory 95,000 97,000 Cost of Goods Sold 92.000 Plant Assets 55,000 168,000 Gross Profit 138,000 Operating Expenses: (20,000) 83,000 Accumulated Depreciation-Plant Assets (44,000) Salaries Expense 55,000 Land 58,000 24.000 Depreciation Expense-Plant Assets $ 297,000 15 362,000 79,000 Total Assets Total Operating Expenses Net Income Before Income Taxes 59.000 Accounts Payable 29,000 39,000 Income Tax Expense 10,000 49,000 Net Income Choose from any list or enter any number in the input fields and then continue to the next question i More Info The income statement and additional data of Vitamins Plus, Inc. follow: E (Click the icon to view the income statement.) (Click the icon to view the additional data.) a. Acquisition of plant assets is $113,000. Of this amount, $101,000 is paid in cash and $12,000 by signing a note payable. b. Cash receipt from sale of land totals S25,000. There was no gain or loss. Cash receipts from issuance of common stock total $28,000 Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. 25,000 11,000 Accrued Llabilities 15,000 12,000 Notes Payable C. d. Payment of note payable is $11.000. e. Payment of dividends is $13,000. f. From the balance sheet Total Liabilities 65,000 66,000 Common Stock, no par 12,000 40,000 220,000 256,000 September 30 Retained Earnings 2018 2017 S 297,000 362,000 Total Liabilities and Stockholders' Equity Cash $ 37,000 S 27,000 Accounts Recelvable 46,000 57,000 Panel B-Statement of Cash Flows: Merchandise Inventory 97,000 95,000 Cash Flows from Operating Activities: Land 58,000 83,000 (a) Plant Assets 168,000 55,000 Adjustments to Reconcile Net Income Accumulated Depreciation (44,000) (20,000) to Net Cash Provided by Operating Activities: Accounts Payable 39,000 29,000 (b) Accrued Liabilities 15,000 25,000 (c) Notes Payable (long-term) 12,000 11,000 (d) Common Stock, no par 40,000 12,000 (e) Print Done Choose from any list or enter any number in the input fields and then continue to the next question. cash and $12,000 by signing a note payable. b. Cash receipt from sale of land totals $25,000. There was no gain or loss. c. Cash receipts from issuance of common stock total 528,000. d. Payment of note payable is $11.000. e. Payment of dividends is $13,000. f. From the balance sheet Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) September 30 (h) 2018 2017 Net Cash Used for Investing Activities Cash $ 37,000 $ 27,000 Cash Flows from Financing Activities: Accounts Receivable 46,000 57,000 Merchandise Inventory 97,000 95,000 () Land 58,000 83,000 (k) Plant Assets 168,000 55,000 Net Cash Used for Financing Activities Accumulated Depreciation (44,000) (20,000) (1) Accounts Payable 39,000 29,000 Accrued Liabilities 15,000 25,000 Non-cash Investing and Financing Activities: Notes Payable (long-term) 12,000 11,000 (g2) Common Stock, no par 40,000 12,000 Retained Earnings 256,000 220,000 Total Non-cash investing and Financing Activities (g2) Total Print Done Choose from any list or enter any number in the input fields and then continue to the next question. The income statement and additional data of Vitamins Plus, Inc. follow: E (Click the icon to view the income statement.) A (Click the icon to view the additional data.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. Use the transaction references in Panel B when selecting the transaction references in Panel A. (If a box is not used in the spreadsheet, leave the box empty, do not select a label or enter a zero. Do not check your answer until both Panel A a completed. Abbreviations used: Acquistion of Plant Assets by Issuing NP = Acquisition of Plant Assets by Issuing Note Payable.) Vitamins Plus, Inc. A Data Table %3 Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Balance Vitamins Plus, Inc. Panel A-Balance Sheet: 9/30/2017 DEBIT CREDIT 9/30/2018 Income Statement 27,000 57.000 Cash 37,000 Year Ended September 30, 2018 Accounts Receivable 46,000 Net Sales Revenue S 230.000 Merchandise Inventory 95,000 97,000 Cost of Goods Sold 92.000 Plant Assets 55,000 168,000 Gross Profit 138,000 Operating Expenses: (20,000) 83,000 Accumulated Depreciation-Plant Assets (44,000) Salaries Expense 55,000 Land 58,000 24.000 Depreciation Expense-Plant Assets $ 297,000 15 362,000 79,000 Total Assets Total Operating Expenses Net Income Before Income Taxes 59.000 Accounts Payable 29,000 39,000 Income Tax Expense 10,000 49,000 Net Income Choose from any list or enter any number in the input fields and then continue to the next question i More Info The income statement and additional data of Vitamins Plus, Inc. follow: E (Click the icon to view the income statement.) (Click the icon to view the additional data.) a. Acquisition of plant assets is $113,000. Of this amount, $101,000 is paid in cash and $12,000 by signing a note payable. b. Cash receipt from sale of land totals S25,000. There was no gain or loss. Cash receipts from issuance of common stock total $28,000 Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. 25,000 11,000 Accrued Llabilities 15,000 12,000 Notes Payable C. d. Payment of note payable is $11.000. e. Payment of dividends is $13,000. f. From the balance sheet Total Liabilities 65,000 66,000 Common Stock, no par 12,000 40,000 220,000 256,000 September 30 Retained Earnings 2018 2017 S 297,000 362,000 Total Liabilities and Stockholders' Equity Cash $ 37,000 S 27,000 Accounts Recelvable 46,000 57,000 Panel B-Statement of Cash Flows: Merchandise Inventory 97,000 95,000 Cash Flows from Operating Activities: Land 58,000 83,000 (a) Plant Assets 168,000 55,000 Adjustments to Reconcile Net Income Accumulated Depreciation (44,000) (20,000) to Net Cash Provided by Operating Activities: Accounts Payable 39,000 29,000 (b) Accrued Liabilities 15,000 25,000 (c) Notes Payable (long-term) 12,000 11,000 (d) Common Stock, no par 40,000 12,000 (e) Print Done Choose from any list or enter any number in the input fields and then continue to the next question. cash and $12,000 by signing a note payable. b. Cash receipt from sale of land totals $25,000. There was no gain or loss. c. Cash receipts from issuance of common stock total 528,000. d. Payment of note payable is $11.000. e. Payment of dividends is $13,000. f. From the balance sheet Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) September 30 (h) 2018 2017 Net Cash Used for Investing Activities Cash $ 37,000 $ 27,000 Cash Flows from Financing Activities: Accounts Receivable 46,000 57,000 Merchandise Inventory 97,000 95,000 () Land 58,000 83,000 (k) Plant Assets 168,000 55,000 Net Cash Used for Financing Activities Accumulated Depreciation (44,000) (20,000) (1) Accounts Payable 39,000 29,000 Accrued Liabilities 15,000 25,000 Non-cash Investing and Financing Activities: Notes Payable (long-term) 12,000 11,000 (g2) Common Stock, no par 40,000 12,000 Retained Earnings 256,000 220,000 Total Non-cash investing and Financing Activities (g2) Total Print Done Choose from any list or enter any number in the input fields and then continue to the next question.
Expert Answer:
Answer rating: 100% (QA)
Vitamins Plus Inc Spreadsheet of statement of cash flow For Year Ended Se... View the full answer
Related Book For
Financial and Managerial Accounting
ISBN: 978-0132497978
3rd Edition
Authors: Horngren, Harrison, Oliver
Posted Date:
Students also viewed these accounting questions
-
The income statement and additional data of Best Corporation follow: Additional data follow: (a) Collections from customers are $15,500 more than sales. (b) Dividend revenue, interest expense, and...
-
The income statement and additional data of Newbury Travel Products, Inc., follow: Additional data: a. Acquisition of plant assets was $212,000. Of this amount, $160,000 was paid in cash and $52,000...
-
The income statement and additional data of Norton Travel Products, Inc., follow: Additional data: a. Acquisition of plant assets was $170,000. Of this amount, $140,000 was paid in cash and $30,000...
-
If you were the lead analyst for LGM, how would you determine the requirements? Be specific in your answer. List several questions you need answered. Artif. Intell. Med., 56 (3) pp. 137-156, Link:...
-
Allied Applications, a multinational commodities trading company, has recently introduced a new personnel evaluation system. Six months after implementing the system, Allieds human resources director...
-
At the beginning of the year, you bought a $ 1,000 par value corporate bond with a 6 percent annual coupon rate and a 10- year maturity date. When you bought the bond, it had an expected yield to...
-
As can be easily verified by means of the formula for the binomial distribution, the probabilities of getting 0 , 1,2 , or 3 heads in 3 flips of a coin whose probability of heads is 0.4 are...
-
A large number of firms are capable of producing chocolate- covered cockroaches. The linear, upward-sloping supply curve starts on the price axis at $ 6 per box. A few hardy consumers are willing to...
-
A girl delivering newspapers covers her route by traveling 8.70 blocks north, 2.18 blocks south, and 9.93 blocks east. Find the angle (a positive value in , between 0 and 360) of her resultant...
-
Julio and Milania are owners of Falcons Corporation, an S corporation. They each own 50 percent of Falcons Corporation. In year 1, Julio and Milani received distributions of $20,000 and $10,000,...
-
Over the next few years, starting now, you plan to save R36000 pa into a tax freesavings account, until you reach the maximum investment allowed of R500000.If your investment grows at 16% pa, what...
-
A change in chromosome structure that does not involve a change in the total amount of genetic material is a. a deletion. b. a duplication. c. an inversion. d. none of the above.
-
To synthesize DNA, what does telomerase use as a template? a. It uses the DNA in the 3 overhang region. b. It uses RNA that is a component of telomerase. c. No template is used. d. Both a and b are...
-
The origin of replication in E. coli contains a. an AT-rich region. b. DnaA boxes. c. GATC methylation sites. d. all of the above.
-
A double-stranded region of RNA a. forms a helical structure. b. obeys the AU/GC rule. c. may result in the formation of a structure such as a bulge loop or a stem-loop. d. does all of the above.
-
In eukaryotes, DNA replication is initiated at an origin of replication by a. DnaA proteins. b. the origin recognition complex. c. DNA polymerase . d. MCM helicase.
-
Given the following set of slope staking notes: C Sta 51+00 50+00 49+00 L CX 33.4 F 9.1 33.6. F 10.3 35.4 C 5.5 0.0 F 3.5 R C 3.2 X C 4.1 30.2 0.0 20.0 Bases Base for cut=48 ft Base for fill= 40 ft s...
-
Consider the circuit of Fig. 7.97. Find v0 (t) if i(0) = 2 A and v(t) = 0. 1 3 ett)
-
Separation of duties is a key internal control. Requirement 1. Explain in your own words why separation of duties is often described as the cornerstone of internal control for safeguarding assets....
-
Refer to the Smith Valley Snow Park Lodge expansion project in S21-2. Requirement 1. What is the projects NPV? Is the investment attractive? Why?
-
Data Integrity Company performed $1,000 of services on account for a customer on January 5. The same customer paid $600 of the January 5 bill on January 28. Requirement 1. Identify the three steps to...
-
What is the primary business of Satyam Computer Services Ltd?
-
In January 2009, approximately how many employees did Satyam Computer Services employ?
-
What was the cash balance sheet amount and how much cash actually existed in the Satyams bank accounts?
Study smarter with the SolutionInn App