Consider the following financial information and answer the questions that follow: Sales : $250,000 Costs : $134,000 Depreciation : $10,200 Operating expenses : $6,000 Interest expenses : $20,700 Taxes : $18,420 Dividends : $10,600 Addition to Retained Earnings : $50,080 Long term debt repaid : $9,300 New Equity issued : $8,470 New fixed assets acquired : $15,000You are required to: i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC Show all computations

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 14M
icon
Related questions
Question
100%

Consider the following financial information and answer the questions that follow: Sales : $250,000 Costs : $134,000 Depreciation : $10,200 Operating expenses : $6,000 Interest expenses : $20,700 Taxes : $18,420 Dividends : $10,600 Addition to Retained Earnings : $50,080 Long term debt repaid : $9,300 New Equity issued : $8,470 New fixed assets acquired : $15,000You are required to:

i) Calculate the operating cash flow

ii) Calculate the cash flow to creditors

iii) Calculate the cash flow to shareholders

iv) Calculate the cash flow from assets

v) Calculate net capital spending

vi) Calculate change in NWC

Show all computations

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

this was my answer for question 3:

  1. CFC = Interest paid – Net New Long-Term Debt

Net New Long-Term Debt= Long Term Debt – Long term Debt repaid

NNLTD= $0 - $9,300

NNLTD= -$9,300

                Then, CFC = $20,700 – (-$9,300)

                          CFC= $20,700 + $9300

  CFC= $30,000

Can you explain why the new long term debt issued was considered in your calculation?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College