Need to be completed in Excel.

7. Find the value of the following cash flow stream at the end of year 30 if the rate of return is 8.75%: Years 1-5 $3000 per year Year 6 $7500 Years 7-15 $9000 per year Years 16-30 $12,000 per year 8. Find the effective annual rate of interest for a nominal rate of 9% compounded 8c. Monthly 11. You are a recent college graduate and want to start saving for retirement. You plan to save $2000 per year for the next 15 years. After that you will stop contributing and just allow your savings to accumulate for another 20 years. Your twin brother would rather wait awhile before he starts saving. He is not going to put away anything for the next ten years, then he will start making contributions at the end of each year for the final 25 years. You both anticipate earning a 9.5% rate of return on your investments. How much must your brother put away at the end of each year to have the same amount of money for retirement as you