Hello,
I need help in modeling a payment plan on a monthly basis which is based on some pre-defined parameters.
Essentially for units sold in 2023 there is a separate payment plan from those sold in 2024. I am unable to arrive at a formula that captures the payment plan against units sold in each year.
I have added part of the model below. Appreciate if someone can help me with this?
Thank you
I need help in modeling a payment plan on a monthly basis which is based on some pre-defined parameters.
Essentially for units sold in 2023 there is a separate payment plan from those sold in 2024. I am unable to arrive at a formula that captures the payment plan against units sold in each year.
I have added part of the model below. Appreciate if someone can help me with this?
Thank you
| S-Curve Standard Deviation | 8 | ||||||||||||
| Sales Start Month | |||||||||||||
| Year | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | ||||||
| Residential NSA | 253,890 | Year | 0 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Selling Price Per Sqm | 100 | Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||||
| Month Ending | 5/30/2023 | 6/30/2023 | 7/31/2023 | 8/31/2023 | 9/30/2023 | 10/31/2023 | 11/30/2023 | ||||||
| Timing | Checks | Item | Total | Month Start | Month End | Total Months | |||||||
| Development progress | OK | Residential NSA | 253,890 | 0 | 61 | 62 | 14 | 22 | 35 | 53 | 79 | 117 | |
| Total | 253,890 | 0 | 61 | 62 | 14 | 22 | 35 | 53 | 79 | 117 | |||
0.01% | 0.01% | 0.01% | 0.02% | 0.03% | 0.05% | ||||||||
0.0% | 0.0% | 0.0% | 0.1% | 0.1% | |||||||||
| Progress By Item | 2023 | 2024 | 2025 | 2026 | 2027 | Total | |||||||
| Residential NSA | 0.29% | 10.27% | 49.31% | 36.13% | 3.95% | 100% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Payment Plan | 2023 | 2024 | 2025 | 2026 | 2027 | ||||||||
10% | 10% | 10% | 10% | 60% | |||||||||
20% | 10% | 10% | 60% | ||||||||||
30% | 10% | 60% | |||||||||||
40% | 60% | ||||||||||||
100% |
