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
Find the present value of the following stream of payments. The discount rate is 12% 0 ...
Problem 3 a) Find the Present Value at Year 0 (5 points) b) Find the Future Value at Year 10 (5 points) $700 $600A $500 ▲ $400 ▲ 5% $300 $200 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Assuming a discount rate of 6.6 percent, what is the present value of the following stream of uneven cash flows over the next 10 years? Year 1 $26,728 Year 2 $19,363 Year 3 $11,392 Year 4 $17,496 Year 5 $11,100 Year 6 $12,041 Year 7 $10,304 Year 8 $27,646 Year 9 $26,151 Year 10 $16,536
a. Find the present values of the following cash flow streams at a 4% discount rate. Do not round intermediate calculations. Round your answers to the nearest cent. 0 1 2 3 4 5 Stream A Stream B Stream A: $ $0 $0 $150 $300 $350 $350 $350 $350 $350 $350 $300 $150 Stream B: $ b. What are the PVs of the streams at a 0% discount rate? Round your answers to the nearest dollar. Stream A: $ Stream...
part 1 Find the present values of the following cash flow streams at a 10% discount rate. Do not round intermediate calculations. Round your answers to the nearest cent. 0 1 2 3 4 5 Stream A $0 $100 $350 $350 $350 $300 Stream B $0 $300 $350 $350 $350 $100 Stream A $ Stream B $ What are the PVs of the streams at a 0% discount rate? Round your answers to the nearest dollar. Stream A $ Stream...
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
Find the present value of the following mixed stream of cash flows (as of Year 0) using a discount rate of 88%. Assume the cash flows are received at the end of each year. Year Cash Flow Stream 1 5 comma 0005,000 2 4 comma 0004,000 3 3 comma 0003,000 Year Cash Flow Stream 1 5 comma 0005,000 2 4 comma 0004,000 3 3 comma 0003,000 Present Value ($)equals=
What is the present value of a stream of cash flows that pays $50 a year forever except for years 7 and 8? Discount rate is 10%. (The timeline of this stream of cash flows is given below) CF $50 $50 $50 $50 $50 $50 $50 $50 ……. Year 0 1 2 3 4 5 6 7 8 9 10 …….
1)Find the present values of these ordinary annuities. Discounting occurs once a year. Do not round intermediate calculations. Round your answers to the nearest cent. $200 per year for 16 years at 12%. $ $100 per year for 8 years at 6%. $ $1,000 per year for 8 years at 0%. $ Rework previous parts assuming they are annuities due. Present value of $200 per year for 16 years at 12%: $ Present value of $100 per year for 8...
UNEVEN CASH FLOW STREAMFind the present values of the following cash flow streams at an 8% discount rate. Round your answers to the nearest cent.012345Stream A $ Stream A$0$150$450$450$450$300Stream B$0$300$450$450$450$150Stream B $ What are the PVs of the streams at a 0% discount rate?Stream A $ Stream B $
Problem #7: 4 Points What is the present value of the following uneven cash flow stream: $-500 now (at time 0), $100 in year 1 (at time 1), $300 in year 2 lat time 2). $350 in year 3 (at time 3), $400 in year 4 (at time 4) if the expected return is 7.2% lie.. rate of interest)? (Hint: solve for net present value using your calculator or Excel) Problem #8: 5 Points You are interested in purchasing the...