Spreadsheet: 885762d1735597586-end-of-month-formula-problem-on-payment-schedule-for-budget-model-budget-test
Sheet: Budget

 |  |  |  |  |  |  |  |  |  |  | Payment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Category | Description | Details | Amount | π | Start Date | End Date | [NAME] | Start Year | Reset Month | Date1 | Date2 | Date3 | [NAME] | Date5 | Date6 | Date7 |  | 2025-02-12 00:00:00
 | Income | Primary | Salary |  | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 12 |  |  |  |  |  | EoM
 | Income | Secondary | Freelance | 1000 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  |  | 5 |  |  | 17
 | Income | Secondary | Side Gigs | 5000 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 2 |  | 12
 | Income | Investment | Dividend | 100 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Income | Investment | Interest | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 3 |  |  | 4
 | Income | Other Income | Gifts | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Income | Other Income | Refunds | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Rent | Apartment | 1675 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 10
 | Fixed Expenses | Rent | Building Maintenance | 130 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 5
 | Fixed Expenses | Rent | Property Tax | 65 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 10
 | Fixed Expenses | Utilities | Water | 20 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 5
 | Fixed Expenses | Utilities | Electricity | 200 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 6
 | Fixed Expenses | Utilities | Gas | 25 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 10 |  |  |  |  |  | EoM
 | Fixed Expenses | Utilities | Internet | 85 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 28
 | Fixed Expenses | Utilities | Phone -1 | 74.9 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 21
 | Fixed Expenses | Utilities | Phone - 2 | 54.9 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 7
 | Fixed Expenses | Insurance | Life | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Insurance | Renters | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Debt | Car | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Debt | Student | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Debt | Credit Card | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Subscriptions | Netflix | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Fixed Expenses | Subscriptions | HBO | 254.9 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-02-14 00:00:00
 | Fixed Expenses | Subscriptions | Disney | 449.9 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-04-22 00:00:00
 | Fixed Expenses | Subscriptions | Twitter | 439 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-12-02 00:00:00
 | Fixed Expenses | Subscriptions | X | 375 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-12-02 00:00:00
 | Fixed Expenses | Subscriptions | Bloomberg |  | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-12-03 00:00:00
 | Fixed Expenses | Subscriptions | WSJ | 1800 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-12-02 00:00:00
 | Fixed Expenses | Subscriptions | Tinder | 129 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 | 2025-04-22 00:00:00
 | Variable Expenses | Pets | Food | 400 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 15 |  | 30
 | Variable Expenses | Pets | Vet | 250 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 15 |  | 15
 | Variable Expenses | Pets | Toys | 100 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 20 |  | 20
 | Variable Expenses | Food & Groceries | Metro |  | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 1
 | Variable Expenses | Food & Groceries | [NAME] |  | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 | 30 | 31
 | Variable Expenses | Food & Groceries | [NAME] |  | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  |  |  | 20
 | Variable Expenses | Food & Groceries | Mass |  | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  |  |  |  |  |  |  | 28
 | Variable Expenses | Transportation | Gas | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Transportation | Uber |  | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Transportation | Cabify | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Transportation | Bus | 0 | 0.04 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Healthcare | Medication | 50 | 0.08 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 13
 | Variable Expenses | Personal Care | Haircuts | 20 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 25
 | Variable Expenses | Personal Care | Pedicures | 50 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 24
 | Variable Expenses | Personal Care | [NAME] | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Personal Care | Facials | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 17
 | Variable Expenses | Personal Care | Sauna | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Personal Care | Messages | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 26
 | Variable Expenses | Personal Care | Makeup | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Personal Care | Products for Hair | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Personal Care | Other Products | 0 | 0.07 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Memberships | Tennis | 640 | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 3
 | Variable Expenses | Memberships | Gym |  | 0.1 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 11
 | Variable Expenses | Clothing | Shoes | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Clothing | Dress Clothing | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Clothing | Sports Clothing | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Variable Expenses | Clothing | Dress Shoes | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Movies | 100 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 1
 | Discretionary Spending | Entertaiment | Concerts | 100 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 7
 | Discretionary Spending | Entertaiment | Fairs | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Hobbies | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Festivals | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Beach | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 27
 | Discretionary Spending | Entertaiment | Dining Out | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Travel | 0 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Discretionary Spending | Entertaiment | Gifts | 20 | 0.03 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Savings | Emergency Fund | Medical Emergencies | 50 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Savings | Emergency Fund | Family Emergencies | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Savings | Emergency Fund | Other Emergencies | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Savings | Emergency Fund | Education | 0 | 0.035 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Retirement Fund | 401K | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Retirement Fund | IRA - Traditional | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Retirement Fund | IRA - Roth | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Stocks | Large Cap | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Stocks | Mid Cap | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Stocks | Small Cap | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Bonds | Domestic | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Bonds | International | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Bonds | Government | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Real Estate | Commercial | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Real Estate | Residencial | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Commodities | Gold | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Investing | Commodities | Silver | 0 | 0.05 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Charity | Donations | 20 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Charity | Church | 0 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Charity | Street | 0 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Home | Décor | 80 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Transportation | Car | 0 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Food | Vendor | 30 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | Miscellaneous | Other | Other | 15 | 0.025 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 1 | 5 | 10 |  |  |  | 15
 | [NAME] | Prepayments | Credit Card - Visa | 0 | 0 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00 |  |  |  | 15
 | [NAME] | Prepayments | Credit Card - MasterCard | 0 | 0 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | [NAME] | Prepayments | Credit Card - AMEX | 0 | 0 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00
 | [NAME] | Prepayments | Credit Card - Diners Club | 0 | 0 | 2025-01-01 00:00:00 | 2028-12-31 00:00:00