Math excel - Microsoft Community

ex question : find savings plan balance after 5 years apr of 11% , monthly payments of 250.    answer should 19,879.52  

what formula should use?  looks flipped , can't seem figure how got answer.

hi ruby,

 

based on test, if save 250 every month, , 11% profit second year, 19786.3 after 5 years: =(((((250*12)+(250*12)*(1+11%)+(250*12))*(1+11%)+(250*12))*(1+11%)+(250*12))*(1+11%))

 

if not scenario, please specify more details calculation way , related screenshots data range in excel workbook.

 

regards,

yoga 

Microsoft Education / Microsoft Teams for Education / Assignments