掌握贷款契机-

08088.18.28.38.48.58-21015158121.5212.52-38.18-30808262418-48.21004%10.xls5PV()4AnPMTPVIFA%,nAnPMTPVIFA4%,101,000,000PMT8.1109PMT1,000,0008.1109123,2918-5080810123,291.xlsB6=E5/C3C6E5D2D6B6C6E6E5B6E1508-6ExcelH6PMT()I6IPMT()J6PPMT()PMTPMT(rate,nper,pv,fv,type)RateNperPVFVfv00Type0108-70808IPMTIPMT(rate,per,nper,pv,fv,type)PerPPM()PPMTPPMT(rate,per,nper,pv,fv,type)8.38-8.xls50080%4004%20122012PMT()D6=PMT(D4,D5,-D3)=24,239C10:D251Excel2003Y8-90808.xls8-10D6D6C14:D255Excel20038-1108081Excel20038-122Excel3A253:E2568-1308084B2535,8174115,606,667B253210,744211222452522612.xlsD4=4%/26D5=20*26=520C531=1,814,009