Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / Solving the below problem on Excel; 1) Find the future values of these ordinary annuities
Solving the below problem on Excel;
1) Find the future values of these ordinary annuities. Compounding occurs once a year.
a) $400 per year for 10 years at 10%
b) $200 per year for 5 years at 5%
c) $400 per year for 5 years at 0%
d) Rework parts a, b, and c assuming they are annuities due.
2) Find the present values of these ordinary annuities. Discounting occurs once a year.
a) $400 per year for 10 years at 10%
b) $200 per year for 5 years at 5%
c) $400 per year for 5 years at 0
d) Rework parts a, b, and c assuming they are annuities due
3) An investment will pay $100 at the end of each of the next 3 years, $200 at the end of Year 4, $300 at the end of Year 5, and $500 at the end of Year 6. If other investments of equal risk earn 8% annually, what is its present value? Its future value?
