« Financial Functions 2: Accumulation | Main | Basic Functions: SUM, AVERAGE »

October 07, 2004

Financial Functions 3 : Complex Accumulation

In this example, we consider a more complex accumulation - wherein we are making regular payments as well as earning interest on our initial investment.

Here, we define names for the cells containing the main variables - so that the formulas are more readable.

accumulate2.jpg

The purpose of the month-by-month breakdown of the account also serves to confirm the accuracy of our original formula.

accumulate3.jpg

Posted by Dave at October 7, 2004 05:55 AM

Comments

I really appreciate blogs like this one becuase it is insightful and helps me communicate with others.

Posted by: op at February 1, 2005 01:29 AM

Post a comment




Remember Me?