How do I calculate rate when pmt is made at end of periods
I have made a loan for 152 days. The amount is 160000 payable at end of
period in the amount of 179543. Please give me the formula. |
Here you go:
The rate function will give you the periodic rate (for 152/365 of a year). =RATE(nper,pmt,pv,fv,type) Which must be adjusted to get the APR =RATE(1,179543,-160000,0)/152*365 Does that help? Regards, Ron "hsummer" wrote in message ... I have made a loan for 152 days. The amount is 160000 payable at end of period in the amount of 179543. Please give me the formula. |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com