å½æ°ç常ç¨è¯æ³ =PMT(贷款æå©çï¼æ¯ä»çæ»æ份ï¼æ¬éï¼ï¼
=PMT(8%/12ï¼5*12ï¼50000), å设æ¬é50000ï¼è®¡ç®ç»æâï¼ -1013.80ï¼å°±æ¯è¯´æ¯æè¿æ¬¾1013.8.
1013.8*60=60828å
ï¼æ»è¿æ¬¾é¢ï¼
æä¸æ¯ä¼è®¡ï¼ä½ 说çå¹´éãéå¼ãç»å¼æä¸æã
ä½ å¯ä»¥å¨EXCELè¡¨æ ¼çå³ä¸è§âé®å
¥éè¦å¸®å©çé®é¢âæ å
ï¼è¾å
¥âPMTâ å车ï¼å°±æ详ç»ç解éã
温馨提示:答案为网友推荐,仅供参考