Question
Future value with multiple cashflows. Ben Woolmer has an investment that will pay him the following cash flows over the next five years: $2,350, $2,725,
Future value with multiple cashflows. Ben Woolmer has an investment that will pay him the following cash flows over the next five years: $2,350, $2,725, $3,128, $3,366 and $3,695. If his investments typically earn 7.65 percent, what is the future value of the investment's cash flows at the end of five years?
Present value with multiple cash flows: Saul Cervantes has just purchased some equipment for his landscaping business. For this equipment he must pay the following amounts at the end of each of the next five years: $10,450, $8,500, $9,675, $12,500, and $11,635. If the approriate discount rate is 10.875 percent, what is the cost in today's dollars of the equipment Saul purchased today?
Present value with multiple cash flows: Biogenesis Inc. management expects the following cash flow stream over the next five years. They discount all cash flows at a 23 percent discount rate. What is the present value of this cash flow stream?
Present value of an ordinary annuity: Dynamics Telecommunications Corp. has made an investment in another company that will guarantee it a cash flow of $22,500 each year for the next five years. If the company uses a discount rate of 15 percent on its investments, what is the present value of this investment?
Please answer with excel format (Ex: =PV(B12,C4,C11, ETC)
** I will rate and comment! Thanksss
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started