Based on your grandmother's savings, her rate of return, and inflation, the amount she can withdraw at the beginning of each year is $81,027.
An annuity is a financial product that pays out a fixed stream of payments to an individual, primarily used as an income stream for retirees.
The grandmother can withdraw at the beginning of each year
First, find the inflation adjusted return,
1 + Adjusted return = (1 + nominal return) / (1 + inflation rate)
1 + Adjusted return = 1.05 / 1.023
Adjusted return = 2.94%
Using the PMT function on the spreadsheet, the amount to be withdrawn can be found:
Rate = 2.9%
Nper = 15 years
PV = - 1,000,000
Type = 1 (Withdrawal at year beginning)
Amount will be found as $81,027.
Learn more about annuity here,
https://brainly.com/question/14761171
#SPJ1