ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)
 
// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)
 
// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

function FVSCHEDULE(principal, schedule) {
  // Initialize future value
  var future = principal;

  // Apply all interests in schedule
  for (var i = 0; i < schedule.length; i++) {
    // Return error if schedule value is not a number
    if (isNaN(schedule[i])) return '#VALUE!';

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)
 
// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)
 
// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

function EFFECT(rate, periods) {
  // Return error if any of the parameters is not a number
  if (isNaN(rate) || isNaN(periods)) return '#VALUE!';

  // Return error if rate <=0 or periods < 1
  if (rate <=0 || periods < 1) return '#NUM!';

  // Truncate periods if it is not an integer

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

// Some algorithms have been ported from Apache OpenOffice:
 
/**************************************************************
 * 
 * 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

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

function DDB(cost, salvage, life, period, factor) {
  // Initialize factor
  var factor = (typeof factor === 'undefined') ? 2 : factor;

  // Return error if any of the parameters is not a number
  if (isNaN(cost) || isNaN(salvage) || isNaN(life) || isNaN(period) || isNaN(factor)) return '#VALUE!';  

  // Return error if any of the parameters is negative or if factor is null

ghalimi

// Copyright (c) 2012 Sutoiku, Inc. (MIT License)

function DB(cost, salvage, life, period, month) {
  // Initialize month
  var month = (typeof month === 'undefined') ? 12 : month;

  // Return error if any of the parameters is not a number
  if (isNaN(cost) || isNaN(salvage) || isNaN(life) || isNaN(period) || isNaN(month)) return '#VALUE!';  

  // Return error if any of the parameters is negative