Computing multiple cash flows for a year
Excel spreadsheet and the FV< and PMT functions to determine the amount of each of the following. R=annual interest rate and t= number of years. When there are multiple cash flows per year, the amount of the annuity shown below is the amount of each individual cash flow (not the total cash flow for the year). Round all answers to the nearest dollar.
Future value of a $950 annuity when R=12.8 compounded semi-annually and t=15