For the homework assignment you will have the opportunity to practice an array of calculations from chapters five and six. The use of the appropriate financial Excel formula (PV, FV, NPER, etc) is required when the problem requires more than basic addition, subtraction, multiplication of division. No credit for answers not calculated by the appropriate formula. All rules of academic integrity apply to this and all assignment sin this course. 1) Cyborg Technologies issues preferred stock that pays a dividend of $3.50 a quarter. Assuming and interest rate of 8% what is the present value of this perpetuity? 2) Smith Bank pays 8% interest, compounded quarterly. If you deposit $1,000 into the account today, how much interest will you earn in one year? What is the EAR? 3) Asad is planning for the future and deposits $5,000 into an investment account that earns a 11% annual return. Bob hears about this great investment and plans to invest in it as well. But Bob has spent all his money on tattoos, junk food, and games for his PS4. So it takes a year of saving before Bob can deposit $5,000 in the investment account. Ten years from today, how much money will Asad and Bob have in their investment accounts, assuming they each only made one $5,000 investment? 4) Sherry figures out she spends $3,500 a year at Starbucks. Assuming she can invest her money and earn 6% annually, if she quits going to Starbucks how long will it take for her to save the $10,000 she needs to go a dream vacation