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
Comments
Post a Comment