Excel application. Consider the following data from BNF Corporation's statement of cash flows for the quarter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel application. Consider the following data from BNF Corporation's statement of cash flows for the quarter ended 31 March 2014: Cash received from issuance of capital stock $ 9,499 Cash received from customers 9,215 Cash received from sale of marketable securities 7,448 Cash loaned as notes receivable (5,265) Cash paid for inventory Cash paid to retire long-term bonds (5,676) (8,427) Cash paid to employees (9,805) a. Group the cash flows listed into the three categories found on the statement of cash flows. Use a formula to calculate the total for each category. (Check figure: the last group total = $1,072) b. Using the link in the 4 February 2014 post on my AIS blog, find the XBRL tags for the three categories on the statement of cash flows. Excel application. Consider the following data from BNF Corporation's statement of cash flows for the quarter ended 31 March 2014: Cash received from issuance of capital stock $ 9,499 Cash received from customers 9,215 Cash received from sale of marketable securities 7,448 Cash loaned as notes receivable (5,265) Cash paid for inventory Cash paid to retire long-term bonds (5,676) (8,427) Cash paid to employees (9,805) a. Group the cash flows listed into the three categories found on the statement of cash flows. Use a formula to calculate the total for each category. (Check figure: the last group total = $1,072) b. Using the link in the 4 February 2014 post on my AIS blog, find the XBRL tags for the three categories on the statement of cash flows.
Expert Answer:
Related Book For
College Accounting
ISBN: 978-1111528126
11th edition
Authors: Tracie Nobles, Cathy Scott, Douglas McQuaig, Patricia Bille
Posted Date:
Students also viewed these accounting questions
-
Excel application. Consider the following data from BNF Corporations statement of cash flows for the quarter ended 31 March 2014: a. Group the cash flows listed into the three categories found on the...
-
Consider the following data from three different firms (1, 2, and 3) each selling to two different customers (A and B). Shown are the price per unit charged each customer and the marginal cost of...
-
Consider the following data from two independent samples with equal population variances. Construct a 95% confidence interval to estimate the difference in population means. Assume the population...
-
Solutions to which of the following categories of modeling techniques indicate a course of action to the decision maker? Group of answer choices Preventive models Predictive models Descriptive models...
-
The Excel file University Grant Proposals provides data on the dollar amount of proposals, gender of the researcher, and whether the proposal was funded or not. Construct a PivotTable to find the...
-
Which of the following reports is filed annually with the SEC? a. Form \(10-\mathrm{Q}\) b. Form \(10-\mathrm{K}\) c. Form 8-K d. Press release
-
Repeat Exercise 20 for samples of size 18 and 12. What happens to the mean and the standard deviation of the distribution of sample means as the sample size decreases? Data from Exercises 20 The...
-
The data that follow were drawn from the city of Boulder, Colorado's CAFR. Dates have been changed. They are from two statisticalsection schedules showing the mix of revenue and expenditures for a...
-
The inputs of a JK FF are Delay and Toggle flip-flops. The Q output of the D-FF is connected to the J input and the Q output of the T-FF to the K input. (i) Draw the logic diagram using AND/NOR gates...
-
The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. a. Run a forward stepwise regression of Annual Salary versus Gender, Age, Prior Experience, Beta...
-
What are the processes of marketing management?
-
Discuss the structural and functional diversity of enzyme classes, including oxidoreductases, transferases, hydrolases, lyases, isomerases, and ligases, and how do these enzyme classes catalyze a...
-
Assume the net assets transferred from the investee qualify as a business, as that term is defined in FASB ASC Master Glossary. At what amount will the Licenses be reported in the financial...
-
Garrison Keller claims the children of Lake Wobegon are above average. You take a simple random sample of 9 children from Lake Wobegon and measure their intelligence with a Wechsler test and find the...
-
What theory best explains why Chris's brother became so upset when people called Chris a junkie?
-
differences between life cycle costing and traditional management accounting technique
-
It's that time of the year again - Safeway is offering its Monopoly Card promotion. Each time you visit Safeway, you are given one of n different Monopoly Cards with equal probability. You need to...
-
The following selected accounts and normal balances existed at year-end. Notice that expenses exceed revenue in this period. Make the four journal entries required to close the books: Accounts...
-
What is the difference between a job-order cost accounting system and a process cost accounting system? Give an example of products that would work best with each cost accounting system.
-
Explain the deposit requirement for federal unemployment tax.
-
The account balances of Miss Beverlys Tutoring Service as of June 30, the end of the current fiscal year, are as follows: Required 1. Complete the work sheet. Data for the adjustments are as follows:...
-
Which of the following are boiler mountings ? (a) Economiser (b) Fusible plug (c) Super heater (d) Injector
-
Which out of the following boiler is capable of generating superheated steam without additional accessories ? (a) Cochran (b) Lancashire (c) Locomotive (d) Cornish
-
The economiser of the boiler plant is used mainly to (a) increase steam capacity (b) reduce fuel consumption (c) increase steam pressure (d) increase life of the boiler
Study smarter with the SolutionInn App