What is the excel formula to calculate the present value at a 10% annual discount rate...
What is the excel formula to calculate the present value at a 10% annual discount rate for a cash flow stream of $1,000, $2,000, $3,000 and $4,000 in years 1, 2, 3 and 4, respectively.
Homework Answers
The excel formula to calculate the present value at 10% annual discount for a cash flow stream of $1000, $2000, $3,000 and $4,000 in years 1,2,3 and 4 respectively is :
Net Present Value = (Annual required return, Total of cash flow of streams)
For example, In this case the derivation of the formula will be :
NPV = (10,1000+2000+3000+4000)
Add Answer to:
What is the excel formula to calculate the present value at a
10% annual discount rate...
What is the present value of each of these three investments if the appropriate discount rate is 11 percent?
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows:InvestmentEnd of YearABC1$1,000$2,000$5,00022,0002,0005,00033,0002,000(5,000)4(4,000)2,000(5,000)54,0005,00015,000 What is the present value of each of these three investments if the appropriate discount rate is 11 percent?
2 4 .6 18 5) What is the present value of 5 annual payments of $10,000.00...
2 4 .6 18 5) What is the present value of 5 annual payments of $10,000.00 and another 5 annual payments of $2,500 @ 5% 3 6) The present value of saving $2,000.00 a year, at-5%, for 5 years is greater than saving $1,500.00 a year, at 5%, for 10 years. s 7) if I want to have $2,000,000, in 45 years, I need to save $2,500 each year for 45 years, at 7%. 7 8) Which stream of future...
If the applicable discount rate is 2.6%, what is the present value of the following stream...
If the applicable discount rate is 2.6%, what is the present value of the following stream of cash flows? Round to the nearest cent. Cash Flow Year 1: $3,000 Cash Flow Year 2: $4,000 Cash Flow Year 3: $9,000
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze....
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: End of Year A B C 1 $1,000 $3,000 $5,000 2 2,000 3,000 5,000 3 3,000 3,000 (5,000) 4 -4,000 3,000 (5,000) 5 4,000 5,000 15,000 a. What is the present value of investment A at an annual discount rate of 9 percent? (Round to the nearest cent.) What is the present value of...
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze....
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year A C 2,000 $1,000 1,000 1,000 1 4,000 4,000 (4,000) (4,000) 14,000 2 3,000 4,000 (5,000) 5,000 3 1,000 3,000 5 What is the present value of each of these three investments if the appropriate discount rate is 13 percent? a. What is the present value of investment A at...
A) What is the present value of this cash flow at 8% discount rate? B) What...
A) What is the present value of this cash flow at 8% discount
rate?
B) What is the present value of this cash flow at 14% discount
rate?
C) What is the present value of this cash flow at 27% discount
rate?
Different cash flow. Given the following cash inflow, what is the present value of this cash flow at 8%, 14%, and 27% discount rates? Year 1 Year 2: Years 3 through 7: Year 8: $1,000 $5,000 $0 $25,000
26- What is the present value of the following cash flow stream at a rate of...
26- What is the present value of the following cash flow stream at a rate of 13.5%? Years: 0 1 2 3 4 CFs: $0 $1,500 $3,000 $4,500 $6,000 27- What is the future value of the following cash flow stream at a rate of 13.5%? Years: 0 1 2 3 4 CFs: $0 $1,500 $3,000 $4,500 $6,000
Use Excel to calculate the expected present value of the following cash flows using a 5%...
Use Excel to calculate the expected present value of the
following cash flows using a 5% discount rate? Be prepared to
explain how you calculated your answer.
Year 1 Cash Flow Estimates $ 1,500 $ 2,000 $ 2,500 Probabiltiy of Estimate 10% 50% 40% Total Year 2 $ $ $ 3,300 3,600 4,000 15% 40% 45%
1. Calculate the present value of $50,000 to be received in 15 years assuming an annual...
1. Calculate the present value of $50,000 to be received in 15 years assuming an annual interest rate of 6%. 2. Calculate the present value of $1,000,000 to be received in 20 years assuming an annual interest rate of 5%, compounded monthly. 3. Calculate the future value of $1,000 invested for 5 years assuming an annual interest rate of 20%. 4. Calculate the future value of $12,000 invested for 18 years assuming an annual interest rate of 12%, compounded monthly....
Which cash flow has the greatest present value if your discount rate is 9.5%? A) A...
Which cash flow has the greatest present value if your discount rate is 9.5%? A) A lump sum payment of $10,000 today B) A lump sum payment of $25,000 at the end of 10 years C) A perpetual stream of annual payments starting at $500 in one year and increasing at 5% per year thereafter D) A perpetual stream of annual parents of $1,000 starting in one year
2 4 .6 18 5) What is the present value of 5 annual payments of $10,000.00 and another 5 annual payments of $2,500 @ 5% 3 6) The present value of saving $2,000.00 a year, at-5%, for 5 years is greater than saving $1,500.00 a year, at 5%, for 10 years. s 7) if I want to have $2,000,000, in 45 years, I need to save $2,500 each year for 45 years, at 7%. 7 8) Which stream of future...
(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year A C 2,000 $1,000 1,000 1,000 1 4,000 4,000 (4,000) (4,000) 14,000 2 3,000 4,000 (5,000) 5,000 3 1,000 3,000 5 What is the present value of each of these three investments if the appropriate discount rate is 13 percent? a. What is the present value of investment A at...
A) What is the present value of this cash flow at 8% discount
rate?
B) What is the present value of this cash flow at 14% discount
rate?
C) What is the present value of this cash flow at 27% discount
rate?
Different cash flow. Given the following cash inflow, what is the present value of this cash flow at 8%, 14%, and 27% discount rates? Year 1 Year 2: Years 3 through 7: Year 8: $1,000 $5,000 $0 $25,000
26- What is the present value of the following cash flow stream at a rate of 13.5%? Years: 0 1 2 3 4 CFs: $0 $1,500 $3,000 $4,500 $6,000 27- What is the future value of the following cash flow stream at a rate of 13.5%? Years: 0 1 2 3 4 CFs: $0 $1,500 $3,000 $4,500 $6,000
Use Excel to calculate the expected present value of the
following cash flows using a 5% discount rate? Be prepared to
explain how you calculated your answer.
Year 1 Cash Flow Estimates $ 1,500 $ 2,000 $ 2,500 Probabiltiy of Estimate 10% 50% 40% Total Year 2 $ $ $ 3,300 3,600 4,000 15% 40% 45%
Most questions answered within 3 hours.
-
In this part, calculate the present values. Use the Excel PV
function to compute the present...
asked 20 minutes ago -
A grammar is a 4-tuple G, G = (Ν, Σ, Π, Σ, S) where, Ν is...
asked 21 minutes ago -
Part 1. Primitive Types, Sorting, Recursion for
Homework.java
a) Implement the static method initializeArray that receives...
asked 1 hour ago -
Using C++, build a sorter that can rank a sequence of numbers in
a descending order....
asked 1 hour ago -
Derive ground state term symbols. Use notation 2S(1/2) for state
2S1/2
a) d5
b) f3
c)...
asked 1 hour ago -
A sample of size 31 will be drawn from a population with mean 39
and standard...
asked 2 hours ago -
What is the effect on the P-value when a test is changed from a
two-tailed hypothesis...
asked 2 hours ago -
I wish to estimate µ, the mean of a population. After I collect
and an-
alyze...
asked 2 hours ago -
At a local university, you poll a group of 115 students and find
that 37 of...
asked 2 hours ago -
Gladstone company tracks the number of units purchased and sold
throughout each accounting period but applies...
asked 2 hours ago -
When determining if a molecule's configuration is E or Z, what
determines the higher priority groups?
asked 2 hours ago -
13. What is the amount
of conversion cost transferred to finished goods? (Round
your intermediate calculations...
asked 2 hours ago