20,30,40,50歲的投資人每月投資多少金額,才能在60歲退休時累積千萬退休金?Python如何使用numpy_financial.pmt() 計算每月應投資金額?送GUI介面程式

# -*- coding: utf-8 -*-
"""
Created on Fri May 25 18:48:55 2023

@author: SavingKing
"""
import numpy_financial as npf
import numpy as np
import pandas as pd
import os

fv = np.array([500,700,1000,1200,1500,2000])

years = [7,10,15,20,25,30,35,40]
#len = 7
shap = ( len(years),len(fv) )
table = np.zeros( shape=shap )
#shape= (8, 4)

rate=0.07

for f in range(len(fv)):
    for y in range(len(years)):
        #print(years[y])
        table[y][f]=\
        npf.pmt(rate/12,years[y]*12,0,fv[f],"begin")

df = pd.DataFrame(table,columns=fv,
                     index=years)
print("不同終值/年期之pmt表:\n",df)

currentFolder = os.getcwd()
xlsx_path = "\\".join( [currentFolder,"pmt.xlsx"] )
#'P:\\Python\\financial\\pmt.xlsx'
df.to_excel(xlsx_path)