Calculations need to be shown in excel

ents of $100 if the a rate interest rate is 10%? 4 What is the PVA of an ordinary annuity with 10 10 10% $100 6 PMT PVE FV LO L 1 what would the PVA be if the interest rate were 4%? 10 15 PMT 16 $100 FV 9 What would the PVAs be if we were dealing with annuities due? 20 Part b Part a BEGIN MODE BEGIN MODE 10 10% $100 SO 10 4% $100 SO PMT FV PMT FV 26 Assume that you are offered an annuity that pays $100 at the end of each year for 10 years. You could earn 8% on your money in other equally risky investments. What is the most you should pay for the annu 1 32 10 $100 PMT FV 8 If the 39 0 BEGIN MODE ents began immediately, then how much would the annuity be worth? 10 13 PMT $100