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

Question

Question

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

business finance

Answer 1

Answer #1

Computation of Present Value of Cashflows: PVF @ Present Year Cash flows 12% Value 500.00 500.00 500.00 600.00 700.00 400.00

Answer 2

Similar Homework Help Questions

Problem 3 a) Find the Present Value at Year 0 (5 points) b) Find the Future...

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

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

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

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

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

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

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

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...
Find the present values of the following cash flow streams at an 8% discount rate

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 $

Find the present values of the following cash flow streams at a6% discount rate. Do...

Find the present values of the following cash flow streams at a 6% discount rate. Do not round intermediate calculations. Round your answers to the nearest cent.012345Stream A: $ Stream A$0$100$400$400$400$250Stream B$0$250$400$400$400$100Stream B: $ What are the PVs of the streams at a 0% discount rate? Round your answers to the nearest dollar.Stream A: $ Stream B: $