Auto Calculate Financing Options

[CMJ]

Hi,

I'm trying to figure out the best way to automate the following financing / payment schedule:

[TABLE="width: 310"]
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Payment Amount[/TD]
[TD="colspan: 2"]Percentage of Contract[/TD]
[TD]Available financing[/TD]
[TD]Required Client Payment[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$250.00[/TD]
[TD="colspan: 2"]25%[/TD]
[TD]$0.00[/TD]
[TD]$250.00[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$250.00[/TD]
[TD="colspan: 2"]25%[/TD]
[TD]$0.00[/TD]
[TD]$250.00[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$240.00[/TD]
[TD="colspan: 2"]24%[/TD]
[TD]$240.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$240.00[/TD]
[TD="colspan: 2"]24%[/TD]
[TD]$240.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$20.00[/TD]
[TD="colspan: 2"]2%[/TD]
[TD]$20.00[/TD]
[TD]$0.00[/TD]
[/TR]
[TR]
[TD="colspan: 2"]$1,000.00[/TD]
[TD="colspan: 2"]100%[/TD]
[TD]$500.00[/TD]
[TD]$500.00[/TD]
[/TR]
</tbody>[/TABLE]


Essentially, if there is financing available for 50% of the project, I'd like that to automatically calculate at the END of the payment schedule, so that we collect cash required up front before financing kicks in. So in this scenario, financing available kicks in after the client has paid the $500, or 50% of the total value.

Any help would be much appreciated!