cumulative percent formula

[biz]

Hello,

I am trying to get the correct function for cumulative percent.

For example:
Cumulative % of CPA (Row2) = (Principal Balance1+Principal Balance2)/CPA.
Cumulative % of CPA (Row3) = (Principal Balance1+Principal
Balance2+Principal Balance3)/CPA
etc....
(Please see visual example below):

(CPA): $300,000,000.00

Row Principal Balance Cumulative % of (CPA)
1 $10,000,000.00
2 $20,000,000.00 0.1000
3 $21,000,000.00 0.1700
4 $11,000,000.00 0.2067
5 $12,000,000.00 0.2467

 

[Ken Snell \(MVP\)]

See answer in other newsgroup where you posted this same question.