Please help solve

4. An investor invested $25,000 in preferred stock with a dividend yield (payout) of 8%, if the \% could be maintained for 35 years, what is the future value of the investment? 5. An investor invested $10,000 in common stock with a dividend yield (payout) of 11%, if the \% could be maintained for 40 years, what is the future value of the investment? Solve the following five Future Value of an Ordinary Annuity problems using your calculator, then solve the same five problems using the Excel spreadsheet. You will generate the same answer with the calculator and the spreadsheet. 6. An investor invested $5,000 in a stock index mutual fund on 12 31XX, with an annual return of 6%, if the % could be maintained for 22 years, what is the future value of an ordinary annulity of the investment? 7. An investor invested $10,000 in a junk bond mutual fund on 12 31-XX, with an annual return of 7%, if the % could be maintained for 15 years, what is the future value of an ordinary annulity of the investment? 8. An investor invested $25,000 in Face-Book stock on 12-31-XX, with an annual return of 9%, if the % could be maintained for 40 years, what is the future value of an ordinary annuity of the investment? 1. An investor invested $40,000 in a stock index mutual fund with an annual return of 5%, if the \% could be maintained for 20 years, what is the future value of the investment? 2. An investor invested $30,000 in a bond index mutual fund with an annual return of 7%, if the \% could be maintained for 25 years, what is the future value of the investment? 3. An investor invested $50,000 in Coca-Cola stock with an annual return of 9%, if the \% could be maintained for 30 years, what is the future value of the investment? 9. An investor invested $15,000 in a hedge fund on 1231XX, with an annual return of 5%, if the \% could be maintained for 35 years, what is the future value of an ordinary annuity of the investment? 10. An investor invested $100,000 in a real estate syndicate on 1231XX, that averaged an annual return of 10%, if the % could be maintained for 30 years, what is the future value of an ordinary annulity of the investment? Solve the following five Future Value of an Annulity Due problems using your calculator, then solve the same five problems using the Excel spreadsheet. You will generate the same answer with the calculator and the spreadsheet. 11. An investor invested $8,000 in a stock index mutual fund on 101X, with an annual return of 5%, if the % could be maintained for 25 years, what is the future value of an annuity due of the investment? 12. An investor invested $12,000 in a junk bond mutual fund on 101XX, with an annual return of 8%, if the % could be maintained for 15 years, what is the future value of an annulty due of the investment? 13. An investor invested $5,000 in Face-Book stock on 1-01-x x, with an annual return of 9%, if the % could be maintained for 20 years, what is the future value of an annulity due of the investment