@LipoLoHu,
You can apply a condition into the formula where the Annual Rate is 0. For example:
Round(
With(
{
AnnualRate: .209,
LoanAmount: 2600,
PeriodsinMonths: 60,
AnnualPayments: 12
},
With(
{
P: LoanAmount,
t: PeriodsinMonths
},
If(
AnnualRate = 0,
P / t,
(AnnualRate / AnnualPayments) * P / (1 - (1 + (AnnualRate / AnnualPayments))^-t)
)
)
),
2
)
Where interest is variable, for example 0% APR for the first 6 months and then 0.29%
thereafter, from the top of my head I suspect you will need a separate amortization table (generated via a Collection or a Table function) listing the rates for each period to run the calculation.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
