Clare Jackson is donating $416,290 today to a charity that will establish an ann
ID: 2815620 • Letter: C
Question
Clare Jackson is donating $416,290 today to a charity that will establish an annual prize in her name of $38,000 with the first prize being awarded today. The charity can invest funds at 4.15% per annum.
(a) How many years can the charity operate at this rate? Answer to two decimal places for part years. Note this point is likely occur part-way through a year, and after then the charity may pay one final prize of a lesser amount. Also be careful we want the length of time from today (the first prize which is awarded today is in recognition of achievements in the past year).
(b) What amount of money could the Jackson prize pay on its final occasion assuming it is saved up from its partial year and paid at the next whole number of years from today?
Explanation / Answer
a. PV = 416,290, FV = 0, rate =4.15%, PMT = -38,000
use noer function in Excel with type as 1
number of years = 14.11 years
b. PV = 416,290, nper = 14, rate =4.15%, PMT = -38,000
use FV function in Excel
amount of the last prize = 4,139.85