Using Excel solve for the following missing values in the ta…
Using Excel solve for the following missing values in the table below:Isntructions:FV = Future Value, PV = Present Value, N or Nper = Number of periods, I/Y = interest rate per period, PMT = Payments made each period. For a lump sum payment, PMT should be left unspecified. Assume that the periods (Nper) are years.PV is conventionally expressed as a negative value as it is usually what you are paying out, and the FV returned will be positive, what you will receive. Use 2 decimal places for your answers.Upload your excel file to the exam
Read Details