Economics Homework Help

Need the answers of 4 questions in excel

6.1 Future value with multiple cash flows: Konerko, Inc., management expects the company to earn cash flows of $13,227, $15,611, $18,970, and $19,114 over the next four years. If the company uses an 8 percent discount rate, what is the future value of these cash flows at the end of year 4?

6.4 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 appropriate discount rate is 10.875 percent, what is the cost in today’s dollars of the equipment Saul purchased today?

6.7 Present value of an ordinary annuity: An investment opportunity requires a payment of $750 for 12 years, starting a year from today. If your required rate of return is 8 percent, what is the value of the investment to you today?

6.12

Computing annuity payment: Kevin Winthrop is saving for an Australian vacation in three years. He estimates that he will need $5,000 to cover his airfare and all other expenses for a week-long holiday in Australia. If he can invest his money in an S&P 500 equity index fund that is expected to earn an average annual return of 10.3 percent over the next three years, how much will he have to save every year if he starts saving at the end of this year?