Costs Spread Over Time in a Dynamic Bell Curve, Incline Curve, Declining Curve  This Intellectual Capital has a video  This design has 2 screenshots

Seller : Richard L

  1. Rating 0 Rating0 Rating(s)
  2. views 3,257
  3. price$35.00
  4. Compatibility
  5. Date added May 14, 2014

You must be logged in to purchase or download design files.

Not a member? Create an account.

Product Description

This spreadsheet has the ability to spread costs DYNAMICALLY over time in four different curves: a Bell Curve, Flat Curve, Inclining Curve, and a Declining Curve. Once a line item total is entered the beginning and ending period of the costs may be entered to dynamically spread the line item total over the entered amount of periods beginning and ending in the chosen periods. In addition once the periods have been established, the user can change the shape of the curve to accurately model the rate that these funds will be spent over time. The Inclining and Declining curves are merely half of a Bell Curve or Normal Distribution Curve since Excel does not have a formula for the inverse of the function EXPONDIST. This spreadsheet or the formulas therein are meant to be a tool inserted into a larger spreadsheet or proforma. This spreadsheet was originally created to model development costs over time in a commercial real estate development to accurately calculate interest carry for costs incurred over the course of the development and construction periods.

Demonstration video can be viewed at: http://youtu.be/DPjvIIXrCEU

Features

Unlocked for Editing

Auto Chart/Graph Updating

Includes Support/Help

Auto Data Analysis




Ratings & Reviews

There are 0 reviews posted on this application.