ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Rate formula (https://www.excelbanter.com/excel-worksheet-functions/34287-rate-formula.html)

Joanne

Rate formula
 
Hi
I am trying to calculate the interest rate for a lease that does not have
constant payments. I have to pay 1 and last lease payment in advance and some
loan origination fees.

Loan - 500000
payment -19860
up front fees 19000
any suggestions on how to use formula with variable payments and how to
deduct up from fees
thanks



All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com