Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 5R
To determine
Interpret the behavior of each component from the chart and explain whether the trends are favorable or unfavorable.
To determine
Prepare and print the statement of cash flow using CASHFLOW2 worksheet.
To determine
Prepare a line chart explaining the relationship between net income and operating cash flows over the five years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excel’s online help. Then use it to develop a spreadsheet model that finds the NPV of the following series: a payment of $25,000 today (assumed to be June 15, 2017), and cash inflows of $10,000 on March 1, 2018; $15,000 on September 15, 2018; $8000 on January 20, 2019; $20,000 on April 1, 2019; and $10,000 on May 15, 2019. Discount these back to “today” using a discount rate of 12%
ARCI Instruments manufactures a ventilation controller designed for monitoring and controlling carbon monoxide in parking garages, boiler rooms, tunnels, etc. The net cash flow associated with one phase of the operation is shown on the next page. (a) How many possible rate of returnvalues are there for this cash flow series? (b) Find all the rate of return values between 0 and 100% using tabulated factors and a spreadsheet.
Hi, do you agree with the net cash flow in investing activities amount, or did you receive a different amount? I got $682,000, but the last reviewer thinks the total is -$534,000. Also, could you let me know if I need the retained earnings section for my assignment to calculate cash flows? I am trying to get my cashflow statement to equal the difference in cash of $86,000.
Assets
20X1
20X0
Difference
Current assets
Cash
$450,000.00
$364,000.00
$86,000
Accounts receivable—net
692,000
625,000
$67,000
Inventory
723,000
610,000
$113,000
Prepaid expenses
50,000
70,000
($20,000)
Total current assets
1,915,000
1,669,000
$246,000
Long-term investments
150,000
20,000
$130,000
Property, plant, and equipment
1,622,000
815,000
$807,000
Less: Accumulated depreciation
-100,000
-75,000
($25,000)
1,522,000
740,000
$782,000
Total assets
$3,587,000
$2,429,000
$1,158,000
Liabilities and…
Chapter 14 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.arrow_forwardUse a spreadsheet and the following financial information from Mineola Companys financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardBased on the income statement, balanced sheet, and additional information shown below and the statement of cash flows you prepared on your scratch paper, how much did the actual cash account change over this period?arrow_forward
- A company has received a proposal from a manager asking to spend ₱1,500,000on equipment that will result in cash inflows as indicated in the table below:Year Cash Flow1 150,0002 150,0003 200,0004 600,0005 900,000What is the payback period if averaging and subtracting methods are used?arrow_forwardYour goal is to prepare a Statement of Cash Flows within the problem noted below. In the Excel Template provided, you will find the Balance Sheet of Marina Comp for December 31, 2013. In addition to the information on the Balance Sheet, we are presented with the following additional data related to current year operations: 1. Net income for the year 2013, $66,000. 2. Depreciation on plant assets for the year, $12,700. 3. Sold the long-term investments for $28,000 (assume gain or loss is ordinary). 4. Paid dividends of $25,000. 1 / 2 5. Purchased machinery costing $21,500, paid cash. 6. Purchased machinery and gave a $60,000 long-term note payable. 7. Paid a $40,000 long-term note payable by issuing common stock.arrow_forwardUsing Statementsof Cash Flows John Marshall is employed as a bank loan officer for First State Bank. He is comparing twocompanies that have applied for loans, and he wants your help in evaluating those companies. Thetwo companies—Morris, Inc., and Walker Company—are approximately the same size and hadapproximately the same cash balance at the beginning of 2009. Because the total cash flows for thethree-year period are virtually the same, John is inclined to evaluate the two companies as equal interms of their desirability as loan candidates.Abbreviated information (in thousands of dollars) from Morris, Inc., and Walker Company is as follow: Morris, Inc. Walker Company 2009 2010 2011 2009 2010 2011Cash flows from:Operating activities $10 $13 $15 $ 8 $3 $(2)Investing activities:…arrow_forward
- Graffiti Advertising, Inc., reported the following financial statements for the last two years. a. Calculate the operating cash flow. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) b.Calculate the change in net working capital. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) c. Calculate the net capital spending. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) d. Calculate the cash flow from assets. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) e. Calculate the cash flow to creditors. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) f. Calculate the cash flow to stockholders. (A negative answer should be indicated by a minus sign. Do not round intermediate…arrow_forwardSee the cash flow statement LOADING... (all values in thousands of dollars) (see MyLab Finance for the data in Excel format): a. What were the company's cumulative earnings over these four quarters? What were its cumulative cash flows from operating activities? b. What fraction of the cash from operating activities was used for investment over the four quarters? c. What fraction of the cash from operating activities was used for financing activities over the four quarters? a. What were the company's cumulative earnings over these four quarters? The cumulative earnings were $enter your response here (000). (Round to the nearest integer.) Part 2 What were its cumulative cash flows from operating activities? The cumulative cash flows from the operating activities were $enter your response here (000). (Round to the nearest integer.) b. What fraction of the cash from operating activities was used for investment over the four quarters? The fraction of the cash from operating…arrow_forwardUsing the financial statements and additional information below, construct an indirect cash flow statement in Excel for year 4. As long as you are following general cash flow formatting rules (e.g. operating section, investing section, financing section), you can format it as you see fit. Remember that these reports should be clean, easy to read and understand, and useful for decision-making purposes.arrow_forward
- Refer to the financial statements and related disclosure notes of The Kroger Company for the fiscal year endingJanuary 30, 2016. You can locate the report online from “investor relations” at www.kroger.com.Notice that Kroger’s net income has increased over the three years reported. To supplement their analysis ofprofitability, many analysts like to look at “free cash flow.” A popular way to measure this metric is “structuralfree cash flow” (or as Warren Buffett calls it, “owner’s earnings”), which is calculated as net income from operations, plus depreciation and amortization, minus capital expenditures.Required:Determine free cash flows for Kroger in each of the three years reported. Compare that amount with net incomeeach year. What pattern do you detect?arrow_forwardFor each of the following problems, (a) draw the cash flow diagram; (b) present clean and clear manual solutions to the problem; (c) highlight the final answer (only the final answer as required by the problem) by enclosing it within a box. A cash flow sequence starts in year 1 at $5,000 and increases by $200 each year through year 10. Determine the present worth of the sequence. Use an interest rate of 10%.arrow_forwardBelow is a year-end cash flow diagram in dollars, deferred in some years. MARR = 2.7% Find the value of thearrow indicated.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College