Hoi chummer

Road Tunnels MTR/AP/849 Shek Yam To Mei Lai Road Tunnels MTR/AP/850 Shek Yam To Mei Lai Road Tunnels MTR/AP/851 Shek Yam To Mei Lai Road Tunnels MTR/AP/852 Shek Yam To Mei Lai Road Tunnels MTR/AP/853 Shek Yam To Mei Lai Road Tunnels MTR/AP/854 Shek Yam To Mei Lai Road Tunnels MTR/AP/855 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/856 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/857 Nam Cheong Vnetilation Building MTR/AP/858 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/859 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/860 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/861 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/862 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/863 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/864 Mei Lai Road Tunnels To Hoi Ting Road MTR/AP/865 Mong Kok West Ventilation Building MTR/AP/866 West Kowloon Station MTR/AP/867 West Kowloon Station MTR/AP/868 West Kowloon Station MTR/AP/869 Kwai Chung Ventilation Building

Amount:}, {__Month 1 Escrow Balance} + {Monthly Escrow Amount:}) - IF( MONTH(DATEADD({First Payment Due Date:}, 1, 'month')) = 7, {Buyer's Share of Summer/Village Taxes:}) - IF( MONTH(DATEADD({First Payment Due Date:}, 1, 'month')) = 12, {Buyer's Share of Winter Taxes:})These don’t account for HOI yet, just the escrow accrual and the Summer/Winter payments – but perhaps you can continue that pattern, and then find a way to account for HOI in the formula as well.This is just the first step, as well. The next step will be creating a formula field that finds the minimum balance out of all the __Month fields. Ah, ok.Going to be away from computer for a few hours, but I’ve gotten a start with a pattern that perhaps you can continue to get you moving along.I’ve created a field for each month (so far months 1-5) that attempts to get the projected balance for that month. Here’s the formula in the first month field:{__Month 1 Escrow Balance}IF( {Monthly Escrow Amount:}, {Monthly Escrow Amount:}) - IF( MONTH({First Payment Due Date:}) = 7, {Buyer's Share of Summer/Village Taxes:}) - IF( MONTH({First Payment Due Date:}) = 12, {Buyer's Share of Winter Taxes:})And the second month, {__Month 2 Escrow Balance}IF( {Monthly Escrow Amount:}, {__Month 1 Escrow Balance} + {Monthly Escrow Amount:}) - IF( MONTH(DATEADD({First Payment Due Date:}, 1, 'month')) = 7, {Buyer's Share of Summer/Village Taxes:}) - IF( MONTH(DATEADD({First Payment Due Date:}, 1, 'month')) = 12, {Buyer's Share of Winter Taxes:})These don’t account for HOI yet, just the escrow accrual and the Summer/Winter payments – but perhaps you can continue that pattern, and then find a way to account for HOI in the formula as well.This is just the first step, as well. The next step will be creating a formula field that finds the minimum balance out of all the __Month fields.Thank you very much. I will review this and see if I can continue the formula. So there are the 12 fields that accumulate the escrow payments, and deduct taxes and HOI at the appropriate times, ending with the final balance in month 12 being $0. Then, we find the MIN() value out of all those months, and combine the ABS() of that value with your cushion value.Here’s the formula in __Month 12 Escrow Balance, which is representative of all the others:ROUND( IF( {Monthly Escrow Amount:}, {__Month 11 Escrow Balance} + {Monthly Escrow Amount:} ) - IF( MONTH(DATEADD({First

We start with the first payment month (In this example March) and add G - Monthly Escrow each month minus any expenses coming out of the account (summer/winter/HOI). Here is how it looks in excel:March$438.12April$876.24May$1,314.36June$1,752.48July$2,969.52-$778.92August-$340.80September$97.32October$535.44November$973.56December$1,248.84$162.84January$1,039.08-$438.12February$0.00The summer tax due date is always July. The winter tax due date is always December, and the HOI due date is always 1-year away from the closing date month. As you can see from the above, the lowest balance in the account is -778.92. If I take the positive value of that figure (778.92) and add that to the Cushion of $876.42 above, we get $1655.16.Not sure if I made this clear enough to follow. Even though I now understand the logic behind it, I have no idea how to get the formula to work in Airtable based on different closing/first payment dates. They are unknown values. Somehow I have to solve for “T” without knowing columns H, I, or S. In other words, we many to to solve for H, I, or S first in order to calculate T. I think I am narrowing in on a solution on how it is calculated, but I still don’t know the formula for Airtable.Here is how I believe it should work. I will use this one as an example:A - Closing DateB - First Payment DateC - Winter TaxesD - Summer TaxesE - HOIF- USDA AnnualG - Monthly EscrowH - AggregateI - Actual lnitial DepositJ - Winter MonthsK - Winter $L - Summer MonthsM - Summer #N -HOI MonthsO -HOI $P - USDA MonthsQ - USDA $R - TotaledS - Agg AdjustT - Aggregate Calc1/1/20213/1/2021$104.07$247.46$86.59$438.12-$1,248.03$1,655.164$416.289$2,227.143$259.77$0.002,903.19-$1,248.03$1,655.16First, I have to figure out the ‘Cushion’. That isn’t a column on the spreadsheet currently. The cushion is fairly easy to figure out though. It is simply “G” x 12 x 16.67% = $876.42. Once we know the cushion, here is the hard part. I have to add the cushion to the lowest balance in the escrow account during the 12 month period. I know how it is calculated now, but I don’t know who to structure the formula in Airtable.In order to calculate what that lowest balance is, we need to know column A- Closing Date, B - First Payment Date, G - Monthly Escrow, and a few other items that I will know (Summer tax due date/annual amount, winter tax due date/annual amount, and HOI due date/annual amount.From there,