Question

Consider the following project Time Cash flows 0 -800 1 80 2 100 3 300 4 500 5 500 Financing rate=15% 2 Reinvestment rate=20%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

-800 100 300.00 500 500 Project NPV Cash flows Financing rate Reinvestment rate NPV of cash flows IRR of cash flows MIRR of c

Excel command

500 А D н 1599 Project NPV =C1599+1 =D1599+1 =E1599+1 =F1599+1 =G1599+1 1600 Cash flows 80 100 300 500 1601 Financing rate 0.

Add a comment
Know the answer?
Add Answer to:
Consider the following project Time Cash flows 0 -800 1 80 2 100 3 300 4...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 16) You are offered an investment that will pay the following cash flows at the end...

    16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...

  • A project has the following cash flows: Year Cash Flows 0 -2,500 1 750 2 800...

    A project has the following cash flows: Year Cash Flows 0 -2,500 1 750 2 800 3 500 4 400 5 300 6 250 What is the Internal Rate of Return (IRR) of this project?

  • s. Understanding the NPV profile Aa Aa If an independent project with conventional, or normal, cash flows is being...

    s. Understanding the NPV profile Aa Aa If an independent project with conventional, or normal, cash flows is being analyzed, the net present value (NPV) and internal rate of return (IRR) methods agree. Projects W and X are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. NPV (Dollars) Year Project W Project x 800 0 - $1,500 -$1,000 $200 $350 600 Project X 2 $350 $500 $400 $600 400 4 $600 $750 Project W 200...

  • If an independent project with conventional, or normal, cash flows is being analyzed, the net present...

    If an independent project with conventional, or normal, cash flows is being analyzed, the net present value (NPV) and internal rate of return (IRR) methods agree Projects Y and Z are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. NPV (Dollars Year Project Y Project Z 800 -$1,500 -$1,500 0 $200 $900 1 600 Project Y $400 $600 2 $600 $300 400 $1,000 $200 4 Project Z 200 If the weighted average cost of capital...

  • If an independent project with conventional, or normal, cash flows is being analyzed, the net present...

    If an independent project with conventional, or normal, cash flows is being analyzed, the net present value (NPV) and internal rate of return (IRR) methods agree. Projects W and X are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. NPV (Dollars) 800 0 -$1,00 Year Project W -$1,000 1 $200 2 $350 $400 $600 Project x -$1,500 $350 $500 $600 $750 Project X Project W If the weighted average cost of capital (WACC) for each...

  • Given the following cash flows for a capital project, calculate the Payback period, NPV, PI, IRR,...

    Given the following cash flows for a capital project, calculate the Payback period, NPV, PI, IRR, and MIRR. The required rate of return is 8 percent.                 Year                                  CF 0 $(50,000.00) 1 $15,000.00 2 $15,000.00 3 $15,000.00 4 $15,000.00 5 $5,000.00

  • 1. Given the following set of cash flows for a project, calculate the NPV, PI, IRR,...

    1. Given the following set of cash flows for a project, calculate the NPV, PI, IRR, MIRR, Payback, Discounted Payback and Accounting Rate of Return. Assume a cost of capital of 10%. Assuming that this is an independent project, should the project be accepted? Why or why not? (20 pts.) Year                Cash Flow                 Net Profit                   Depreciation 0                    -$125,000 1                    $22,000                     $15,000                      $10,000 2                    $58,000                     $43,000                      $25,000 3                    -$30,000                   $24,000                      $21,000 4                    $35,000                     $28,000                      $18,000 5                    $28,000                     $20,000                      $15,000 6                    $60,000                     ...

  • IBM is evaluating a project in Eutopia. The project will create the following cash flows: Year...

    IBM is evaluating a project in Eutopia. The project will create the following cash flows: Year $ 0 -1,330,000 1 250,000 2 470,000 3 450,000 4 215,000 5 95,000 All cash flows will occur in Eutopia and are expressed in dollars. In an attempt to improve its economy, the Eutopia’s government has declared that all cash flows created by a foreign company are “blocked” and must be reinvested with the government for one year. The reinvestment rate for these funds...

  • A bond is currently selling for $1,300 and pays $65fyear (on an anmual basis) for 10...

    A bond is currently selling for $1,300 and pays $65fyear (on an anmual basis) for 10 years. What is the IRR of the bond? (Note that this is the same as wking the bond's YTM.) 11-3 Internal Rate of Return- Part 1 Calculate the IRR of the following project Cash Flow 1000 200 300 Time Period Double-click to hide white space 500 300 2000 11-4 Multiple Internal Rates of Return Why might a financial analyst use the NPV method for...

  • Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR...

    Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR Cash Flow......($200).....$850....($700)......15% What is the best decision for Project Theta (accept or reject) if the project’s required rate of return is 15% and why? a. Accept the project because the payback is short b. Accept the project because the NPV is greater than zero c. Reject the project because the IRR is less than the required rate of return d. Reject the project because...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT