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.
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 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.
Find out more on annuities due at https://brainly.com/question/14761171.
#SPJ1