in excel, go to function - finance - rate, and using the following parameters,
=RATE(260,-423.1,100000),
so far you will get the daily rate of the loan, then times 260
in excel, go to function - finance - rate, and using the following parameters,
=RATE(260,-423.1,100000),
so far you will get the daily rate of the loan, then times 260
•
赞,不知道还有Rate function。19.3%是年利率,Compounded daily.
-ybdddnlyglny-
♂
(0 bytes)
()
11/26/2017 postreply
13:25:03
•
thanks
-puma_bill-
♂
(0 bytes)
()
11/26/2017 postreply
18:46:08