Payment of loan or annuity with odd first period
Payment = payodd(Rate, NumPeriods, PresentValue, FutureValue, Days)
Interest rate per period. Enter as a decimal fraction.
Number of periods in the life of the instrument.
Present value of the instrument.
Future value or target value to be attained after NumPeriods periods.
Actual number of days until the first payment is made.
Payment = payodd(Rate, NumPeriods, PresentValue, FutureValue, Days) returns the payment for a loan or annuity with an odd first period.
A two-year loan for $4000 has an annual interest rate of 11%. The first payment will be made in 36 days. To find the monthly payment
Payment = payodd(0.11/12, 24, 4000, 0, 36)
Payment = 186.77