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 |
XNPV is calculated using the excel function:
=XNPV(12%,B2:B8,A2:A8)
Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent....
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 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 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 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 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 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 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 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, 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...
Calculate the Present Value Ratio for the following Investment C, assuming an annual discount rate of 12%. C=10,000 C=8,000 C=6,000 I=7,500 I=7,500 ... I=7,500 L=8,000 0 1 2 3 4 ... 10 C: Cost, I:Income, L: Salvage value