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.
-
1-Write an algorithm to get two numbers from the user (as
inputs) and calculate the sum...
asked 25 minutes ago -
Define white-collar crime. What is the difference between
offender and offense-based definitions of white-collar crime? What...
asked 1 hour ago -
Consider a reaction which is 1st order with respect to A and 1st
order with respect...
asked 1 hour ago -
c++
The length of the hypotenuse of a right-angled triangle is the
square root of the...
asked 1 hour ago -
When a metal rod is heated, not only its resistance but also its
length and cross‐sectional...
asked 1 hour ago -
write a c++ program that computes the L^1 - Norm of a given
vector (L^1 norm...
asked 1 hour ago -
A manufacturer of banana chips would like to know whether its
bag filling machine works correctly...
asked 1 hour ago -
Complete the chapter case, "Turnover Analysis".
Chapter Case
Turnover Analysis
You recently completed your company’s new...
asked 1 hour ago -
What is the pH of solutions having the following H3O+
concentrations? Identify each as acidic, basic,...
asked 1 hour ago -
How does over-voltage of the diode usually occur?
asked 2 hours ago -
If you step on a dirty nail, your doctor will recommend you
update your Tetanus vaccination....
asked 2 hours ago -
Suppose that decreases in the price of milk lead to decrease s
in the retail prices...
asked 2 hours ago