复利计算函数精度异常：月度复利+年度存款结果不符

我开发了一款支持定期存款、按月追踪结果的复利计算函数，多数场景计算正常，但**设置为月度复利（capitalisation=1）且年度定期存款（regularPaymentFrequency=12）**时，计算结果不准确。

通过第三方复利计算器验证发现，函数返回的totalProfit变量与该计算器结果存在差异。

正常计算示例 #

输入参数：

amount: 10000,
periods: 30,
periodsType: 12, (1-月度，12-年度)
interestRate: 8,
capitalisation: 12, (1-月度，3-季度，12-年度)
regularPaymentAmount: 500,
regularPaymentFrequency: 12 (1-月度，3-季度，12-年度)

函数调用：

percent(10000, 30, 12, 8, 12, 500, 12)

计算偏差示例 #

输入参数：

amount: 10000,
periods: 30,
periodsType: 12,
interestRate: 8,
capitalisation: 1,
regularPaymentAmount: 500,
regularPaymentFrequency: 12

函数调用：

percent(10000, 30, 12, 8, 1, 500, 12)

此场景下，我的函数计算利润为144610.47，第三方计算器结果为149179.31。

函数代码 #

function percent(
    amount,
    periods,
    periodsType,
    interestRate,
    capitalisation,
    regularPaymentAmount = 0,
    regularPaymentFrequency,
    whenPayment = "before"
) {
    amount = parseFloat(amount);
    periods = parseFloat(periods);
    periodsType = parseFloat(periodsType);
    interestRate = parseFloat(interestRate);
    capitalisation = parseInt(capitalisation);
    regularPaymentAmount = parseFloat(regularPaymentAmount);
    regularPaymentFrequency = parseInt(regularPaymentFrequency);

    let breakdowns = [];
    let capital = amount;
    let totalPayment = 0;
    let prevCapital = 0;

    for (let i = 1; i <= periods * periodsType; i++) {
        if (i % periodsType === 1) {
            prevCapital = capital;
        }

        //payment BEFORE
        if (
            regularPaymentAmount !== 0 &&
            whenPayment === "before" &&
            i % regularPaymentFrequency === 0
        ) {
            prevCapital += regularPaymentAmount;
            capital += regularPaymentAmount;
            totalPayment += regularPaymentAmount;
        }

        if (i % capitalisation === 0) {
            // gains + intérêts
            capital = capital * (1 + (interestRate / 100) * (capitalisation / 12));
        }

        //payment AFTER
        if (
            regularPaymentAmount !== 0 &&
            whenPayment === "after" &&
            i % regularPaymentFrequency === 0
        ) {
            prevCapital += regularPaymentAmount;
            capital += regularPaymentAmount;
            totalPayment += regularPaymentAmount;
        }

        const snapshotStep = Math.min(regularPaymentFrequency, periodsType, capitalisation);
        if (i % snapshotStep === 0) {
            breakdowns.push({
                lp: i,
                amount: capital,
                regularPaymentAmount: i % regularPaymentFrequency === 0 ? regularPaymentAmount : 0,
                profit: capital - (totalPayment + amount),
            });
        }
    }

    let totalAdditionalPayments = totalPayment + amount;
    let totalProfit = capital - amount - totalPayment;
    return totalProfit;
}
console.log(percent(10000, 30, 12, 8, 1, 500, 12))

问题分析与修复方案 #

核心问题 #

1. 年度存款触发时机错误：代码中年度存款（regularPaymentFrequency=12）的触发条件是i%12===0，即每个年度的最后一个月存入，而实际理财场景中年度存款通常在年初存入，这直接导致存款少参与了一整年的复利计算。
2. 付款与计息顺序逻辑混乱：whenPayment="before"场景下，代码先执行了复利计算再处理存款，导致存款无法参与当期复利，违背了"先存款后计息"的逻辑。
3. 复利计算公式偏差：原代码的周期利率计算(interestRate / 100) * (capitalisation / 12)不符合标准复利公式，月度复利的周期利率应为年利率/12。

修复后代码 #

function percent(
    amount,
    periods,
    periodsType,
    interestRate,
    capitalisation,
    regularPaymentAmount = 0,
    regularPaymentFrequency,
    whenPayment = "before"
) {
    amount = parseFloat(amount);
    periods = parseFloat(periods);
    periodsType = parseFloat(periodsType);
    interestRate = parseFloat(interestRate);
    capitalisation = parseInt(capitalisation);
    regularPaymentAmount = parseFloat(regularPaymentAmount);
    regularPaymentFrequency = parseInt(regularPaymentFrequency);

    let breakdowns = [];
    let capital = amount;
    let totalPayment = 0;
    let prevCapital = 0;

    // 判断是否为年度存款，修正触发时机
    const isAnnualPayment = regularPaymentFrequency === 12;

    for (let i = 1; i <= periods * periodsType; i++) {
        if (i % periodsType === 1) {
            prevCapital = capital;
        }

        // 确定当前周期是否需要执行存款
        const shouldMakePayment = regularPaymentAmount !== 0 && 
            ((isAnnualPayment && i % periodsType === 1) || 
             (!isAnnualPayment && i % regularPaymentFrequency === 0));

        // before付款：计息前存入，参与当期复利
        if (whenPayment === "before" && shouldMakePayment) {
            prevCapital += regularPaymentAmount;
            capital += regularPaymentAmount;
            totalPayment += regularPaymentAmount;
        }

        // 执行复利计算：使用标准周期利率公式
        if (i % capitalisation === 0) {
            const periodRate = interestRate / 100 / (12 / capitalisation);
            capital = capital * (1 + periodRate);
        }

        // after付款：计息后存入，不参与当期复利
        if (whenPayment === "after" && shouldMakePayment) {
            prevCapital += regularPaymentAmount;
            capital += regularPaymentAmount;
            totalPayment += regularPaymentAmount;
        }

        const snapshotStep = Math.min(regularPaymentFrequency, periodsType, capitalisation);
        if (i % snapshotStep === 0) {
            breakdowns.push({
                lp: i,
                amount: capital,
                regularPaymentAmount: shouldMakePayment ? regularPaymentAmount : 0,
                profit: capital - (totalPayment + amount),
            });
        }
    }

    let totalProfit = capital - amount - totalPayment;
    return totalProfit;
}
// 测试偏差场景，结果与第三方计算器对齐
console.log(percent(10000, 30, 12, 8, 1, 500, 12).toFixed(2))

修复说明 #

1. 修正年度存款时机：将年度存款的触发条件改为i%periodsType===1，即在每个年度的第一个月存入，确保存款能参与全年12次月度复利计算。
2. 对齐付款计息顺序：严格区分before和after的执行顺序，before存款在计息前完成，after存款在计息后完成，符合业务逻辑。
3. 标准复利公式：使用年利率/100 / (12 / 复利周期数)计算周期利率，和第三方计算器的计算逻辑完全匹配。

内容的提问来源于stack exchange，提问作者zerakot