Purchase Solution

conduct a discounted cash flow calculation to determine NPV

Not what you're looking for?

Ask Custom Question

A five-year project has a projected net cash flow of $15,000, $25,000, $30,000,
$20,000, and $15,000 in the next five years. It will cost $50,000 to implement the
project. If the required rate of return is 20 percent, conduct a discounted cash flow
calculation to determine the NPV.

Please explain using excel.

Purchase this Solution
Solution Preview

Hi there,

The answer to your question is $10,746. Please see the attached Excel spreadsheet for the calculation. Also, for your reference, here is some information for you regarding the net present value and a discounted cash flow calculation.

The Net Present Value (NPV) of an investment (project) is the difference between the sum of the discounted cash flows ...

Purchase this Solution
Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • Net Present Value for a Five Year Project

    If the required rate of return is 20%, conduct a discounted cash flow calculation to determine the Net Present Value.

  • DCF and NPV method

    Next, show some sample figures (not just words) and use the DCF model and NPV calculation to determine whether an investment or project should be carried out or not. c. Summarize and make a final recommendation. Thanks a bunch for this!!

  • Size Disparity Problem in Investment Proposals

    (i) Calculation of NPV of each project ('000s) Year DF @ 10% Project X Project Y Cash flow Discounted cash flow Cash flow Discounted cash flow 0 1.00 (200.00) (200.00) (200.00) (200.00) 1 0.91 35.00 31.85 218.00 198.38 2

  • evaluaing the attractiveness of a potential project

    The process for NPV would result in the calculation of the future projections of cash flow from the investment being DISCOUNTED back to the present (using discount factors to reflect the required return).

  • Capital Budgeting

    WACC = 12% Project A Time period: 0 1 2 3 4 5 6 7 Cash flow: (375) (300) (200) (100) 600 $600 $926 ($200) Disc. cash flow: Disc. cum. cash flow: Discounted Payback:

  • Financing: Trebor Pharmaceutical

    NPV is a discounted cash flow technique, which explicitly recognize the time value of money.

  • Calculation of Payback Period and NPV

    0.683013 0 =0*0.683013 NPV= -1,011 NPV of Project a -$1,011 Project b Year Cash flow Discount factor @ Discounted cash flow= 10% 0 (1,000) 1 -1,000 =-1000*1 1 0 0.909091 0 =0*0.909091 2

  • NPV and IRR

    Explain how you would arrive at the discounted cash flows for each year represented within the time line. How does this calculation differ from the internal rate of return (IRR) equation (11-2)?

  • Capital Budgeting

    $24,545.45$24,545.45$24,921.11$25,604.13$26,535.51 NPV ($454.55) ($454.55) ($78.89) $604.13 $1,535.51 The discounted cash flow is the sum of 7,000 discountd for the year of occurence and the total cash flow.

View More Related Solutions