HomeworkLib
Question

Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent....

Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent. (please provide excel work and functions)

A B
1 Date Cash flow
2 30-Jun-07 -600
3 14-Feb-08 100
4 14-Feb-09 300
5 14-Feb-10 400
6 14-Feb-11 600
7 14-Feb-12 800
8 14-Feb-13 -1,900
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

XNPV is calculated using the excel function:

=XNPV(12%,B2:B8,A2:A8)

CashfloW 600 100 300 400 600 800 1900 1 Date 2 30/07/07 14/02/08 14/02/09 14/02/10 6 14/02/11 14/02/12 8 14/02/13 4 9 10 11 X

0 0
Add a comment
Know the answer?
Add Answer to:
Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Use XIRR to compute the internal rate of return for the following investment (please provide excel...

    Use XIRR to compute the internal rate of return for the following investment (please provide excel work and functions): A B 1 Date Cash flow 2 30-Jun-07 -799 3 14-Feb-08 70 4 14-Feb-09 70 5 14-Feb-10 70 6 14-Feb-11 70 7 14-Feb-12 70 8 14-Feb-13 1,020

  • Find the present value of the following stream of payments. The discount rate is 12% 0         ...

    Find the present value of the following stream of payments. The discount rate is 12% 0          1          2          3          4          5          6          7          8          9          10        year _______|_____|______|_____|______|_____|______|______|_____|______| 0          500      500      500      600      700      400      300      500      500      600            amount solve using excel

  • 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...

  • What does this graph mean and how can I interpret it? Relative Value Value relative to...

    What does this graph mean and how can I interpret it? Relative Value Value relative to August 28, 2019 with 0% reference level 2019-09-20 2019-10-14 2019-11-11 2019-11-13 2019-11-15 2019-11-19 Date 2019-08-28 2019-08-30 2019-09-04 2019-09-06 2019-09-10 2019-09-12 2019-09-16 2019-09-18 2019-09-24 2019-09-26 201909-30 2049-10-02 2019-300 2019-10-08 2019 2020 2019 10-16 2019-10-18 10-22 2019-10-24 2019-10-28 2019-10-30 2019-11-01 2019-11-6 2019-11-07 PG Nike Facebook Portfolio

  • 1) Use the data given in Example 2.1 and assume that the feeder has the peak loss of 72 kW at peak load and an annual lo...

    1) Use the data given in Example 2.1 and assume that the feeder has the peak loss of 72 kW at peak load and an annual loss factor of 0.14. Determine the following: a. The daily average load of the feeder: b. The average power loss of the feeder (Example 2.1 Assume that the loading data given in Table 2.1 belongs to one of the primary feeders of the No Light & No Power (NL&NP) Company and that they are...

  • Studern Date: 08/12/2018 #1, #2and #3 are based onthe below given information: Task z Corporation's Balance...

    Studern Date: 08/12/2018 #1, #2and #3 are based onthe below given information: Task z Corporation's Balance Sheet is made from: Date 31/12/17 31/12/16 1) Equipment 2) Bank Loans (Long Term) 74 000 21 000 1 200 6 300 14 200 2 000 3 400 4 200 26 100 7600 13 000 23 400 300 45 000 4 300 23 700 8 000 12 000 11 900 29 500 13 500 3 100 23 000 200 23 000 6 500 6...

  • If the annual interest rate is 12 percent, what is the two-year discount factor? Question 14...

    If the annual interest rate is 12 percent, what is the two-year discount factor? Question 14 options: 1.2544 0.8065 0.8929 0.7972

  • Must make time series graph but have no statistical software!! Please show steps. Due tomorrow help...

    Must make time series graph but have no statistical software!! Please show steps. Due tomorrow help me Median total annual income of Canadian residents(s Year | Lowest 20% of earners | Middle 20% of earners | High 11 100 11 700 12 300 12 500 13 200 12 900 12 000 12 400 13 000 13 300 13 500 13 700 14 500 13 300 50 500 50 500 50 400 51 900 50 700 48 800 46 900 47...

  • Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15,...

    Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15, 2010 2.079 80.06 Jan 22, 2010 2.010 76.62 Jan 29, 2010 1.942 73.94 Feb 05, 2010 1.885 74.57 Feb 12, 2010 1.908 73.88 Feb 19, 2010 2.031 78.25 Feb 26, 2010 2.042 79.22 Mar 05, 2010 2.127 80.19 Mar 12, 2010 2.154 81.76 Mar 19, 2010 2.150 81.44 Mar 26, 2010 2.118 80.65 Apr 02, 2010 2.191 83.01 Apr 09, 2010 2.238 85.66 Apr...

  • Output Price Marginal Cost 100 7.50 0.50 200 7 1.50 300 6.50 2.50 400 6 3.50...

    Output Price Marginal Cost 100 7.50 0.50 200 7 1.50 300 6.50 2.50 400 6 3.50 500 5.50 5.50 600 5 6.50 Please consider the above data for a monopolist. At which output level does the monopolist maximize its profits (or minimize its losses)?    At an output of 500     At an output of 400     At an output of 300     At an output of 200     At an output of 600 Part b: Output Price TR MR...

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