You want to have $1 million to use for retirement in 35 years. If you can earn 1% per month, how much do you need to deposit on a monthly basis if

You want to have $1 million to use for retirement in 35 years. If you can earn 1% per month, how much do you need to deposit on a monthly basis if the firstpayment is made in one month?What if the first payment is made today?You are considering preferred stock that pays a quarterly dividend of $1.50. If your desired return is 3% per quarter, how much would you be willing to pay?

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),It will show all calculations and formulas AutomaticallyQuestionYou want to...