/*
 *  ====================================================================
 *    Licensed to the Apache Software Foundation (ASF) under one or more
 *    contributor license agreements.  See the NOTICE file distributed with
 *    this work for additional information regarding copyright ownership.
 *    The ASF licenses this file to You under the Apache License, Version 2.0
 *    (the "License"); you may not use this file except in compliance with
 *    the License.  You may obtain a copy of the License at
 *
 *        http://www.apache.org/licenses/LICENSE-2.0
 *
 *    Unless required by applicable law or agreed to in writing, software
 *    distributed under the License is distributed on an "AS IS" BASIS,
 *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *    See the License for the specific language governing permissions and
 *    limitations under the License.
 * ====================================================================
 */

package org.apache.poi.ss.formula.functions;

import org.apache.poi.ss.formula.eval.*;

Compute the interest portion of a payment.
Author:Mike Argyriou micharg@gmail.com
/** * Compute the interest portion of a payment. * * @author Mike Argyriou micharg@gmail.com */
public class PPMT extends NumericFunction { @Override public double eval(ValueEval[] args, int srcCellRow, int srcCellCol) throws EvaluationException { if(args.length < 4) throw new EvaluationException(ErrorEval.VALUE_INVALID); double result; ValueEval v1 = OperandResolver.getSingleValue(args[0], srcCellRow, srcCellCol); ValueEval v2 = OperandResolver.getSingleValue(args[1], srcCellRow, srcCellCol); ValueEval v3 = OperandResolver.getSingleValue(args[2], srcCellRow, srcCellCol); ValueEval v4 = OperandResolver.getSingleValue(args[3], srcCellRow, srcCellCol); double interestRate = OperandResolver.coerceValueToDouble(v1); int period = OperandResolver.coerceValueToInt(v2); int numberPayments = OperandResolver.coerceValueToInt(v3); double PV = OperandResolver.coerceValueToDouble(v4); result = Finance.ppmt(interestRate, period, numberPayments, PV) ; checkValue(result); return result; } }