Hi,
I'm trying to figure out the best way to automate the following financing / payment schedule, specifically the "Available Financing" column in bold below (based on a total number hard coded, in this case $500):
<tbody>
</tbody>
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 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!
I'm trying to figure out the best way to automate the following financing / payment schedule, specifically the "Available Financing" column in bold below (based on a total number hard coded, in this case $500):
Payment Amount | Percentage of Contract | Available financing | Required Client Payment |
$250.00 | 25% | $0.00 | $250.00 |
$250.00 | 25% | $0.00 | $250.00 |
$240.00 | 24% | $240.00 | $0.00 |
$240.00 | 24% | $240.00 | $0.00 |
$20.00 | 2% | $20.00 | $0.00 |
$1,000.00 | 100% | $500.00 | $500.00 |
<tbody>
</tbody>
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 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!