FVSCHEDULE Function

FVSCHEDULE.js

// 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!';
    
    // Apply scheduled interest
    future *= 1 + schedule[i];
  }
  
  // Return future value
  return future;
}