Purchase Solution

Cash Flow Analysis

Not what you're looking for?

Ask Custom Question

** Please see the attached file for the complete problem description **

Hello, I have been having difficulties with a problem relating to cash flow analysis. Your assistance in the matter would be greatly appreciated.

Dunder-Mifflin, Inc. is analyzing the potential profitability of three printing jobs put up for bid by the State Dept. of Revenue:
(please see the attached file)

Assume that (1) the company's marginal city-plus-state-plus-federal tax rate is 50%; (2) each job is expected to have a six year life; (3) the firm uses straight-line depreciation; (4) the average cost of capital is 14%; (5) the jobs have the same risk as the firm's other businesses; and (6) the company has already spent $60,000 developing the preceeding data. This $60,000 has been capitalized and will be amortized over the life of the project.
A. What is the expected net cash flow for each year?
B. What is the NPV of each project?
C. Suppose that Dunder-Mifflin's primary business is quite cyclical, improving and declining with the economy, but that job A is expected to be countercyclical. Might this have any bearing on your decision?

Thank you.

Attachments
Purchase this Solution
Solution Summary

This solution shows how to perform a given cash flow analysis in Excel.

Purchase this Solution
Free BrainMass Quizzes
Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

View More Free Quizzes
Related BrainMass Solutions

  • Cash flow, trend analysis

    56756 Cash flow, trend analysis 1. How can an organization with a loss show a positive cash flow? 2. Why is trend analysis more beneficial than a single period of information?

  • Accounting: Cash flow.

    339200 Benefits of Cash Flow analysis and management; evaluate negative cash flow Please help explain or simplify the following questions concerning cash flow analysis.

  • benefits of cash-flow analysis and problems if not conducted

    381844 Explain the benefits of cash-flow analysis and any problems that could arise if it is not conducted. Explain the benefits of cash-flow analysis and any problems that could arise if it is not conducted.

  • Performing discounted cash flow analysis

    ANSWERS In capital budgeting analysis, one of the tools used is discounted cash flow analysis.

  • Statement of cash flows

    Another reason why cash flow analysis is important is because cash flow indicates the liquidity and solvency of the company. Higher the cash flow, more liquid the company is.

  • Explain why cash flow is important

    Methods such as discounted cash flow analysis use cash flow expected to be generated by the new capital project to arrive at investment decisions. Cash flows are also important for short term and long term financing decisions.

  • Article Critique: Cash Flow

    This is an analysis of an article dealing with cash flow and discounted cash flow analysis.

  • Cash Flow for the Year

    Calculate cash flow for the year by using all three methods: (a) adjusted accounting profits; (b) cash inflow/cash outflow analysis; and (c) the depreciation tax shield approach.

  • NPV & IRR

    A cash flow analysis is provided for Mesa Products.

  • Cash Flows Statement: Purpose and Structure

    The third analysis is a free cash flow analysis. The free cash flow is the amount of discretionary cash flow a company has.

View More Related Solutions