An Existing Macro or Formula To Display Countdown on Monthly Contract Balances?

[Novice101A]

I have a Mac and I'm using Office 2011 for Mac. I guess I'm repeating a swing and a miss trying to create either a formula or macro that will allow me to depict the following on a financial spreadsheet.

I have a number of financial contracts that I need to be able to determine their status at a glance on a regular basis. For the sake of illustration, I have the contract outstanding balances listed in cells A1 through A26. I have the monthly liability amounts listed in B1 through B26 and I have the total months remaining on the contracts listed in C1 through C36. A grand total of the contract liability amounts is in cell A27. I'm seeking to have the individual remaining balances and individual remaining months reduced as the static monthly liability amount is paid every 30 days and the grand total remaining balance in A27 revised as necessary.

What is the most simple method to automate this process using the date and time on my computer to accurately depict the results? It reminds me of simple amortization without any interest input but I don't want to produce a full amortization schedule and yet need it to be active with passage of time. I'm making a very simple problem increasingly complex in trying to make it function correctly. Any nudge in the right direction is greatly appreciated.

[cubangt]

Can you provide a sample file?
currently without a formula or macro are you able to manually populate those totals?

If you can manually do it, then it can be done using a formula or macro/logic...

An simple sample file with how its expected to work would go a long way.

[Novice101A]

"currently without a formula or macro are you able to manually populate those totals?"

Some of them quite easily but not with the ability to move them through time. I had found and copied a VBA string but the variables weren't similar enough that I could transpose it. Quite frustrating that the solution is probably all too basic but it's like learning a foreign language. Sample Sheet attached.

[cubangt]

Looking at your sample file, i only see one formula.
I guess what i was looking for was at least one or 2 records in the file that are fully populated how you need it to look, so the logic could be written to provide the same results.
When you say first of the month, is that over all, meaning you only want the calculations to be updated/changed on the first of every month?
Or something else?
Which cells are provided as source data? (Active Contracts, Monthly Payment and Start Date) and like you have listed in the file, the others are auto calculated?

Since each of the columns are "remaining" or "outstanding" where are the initial values? I would assume that with the initial values, the these columns can be easily calculated with a formula and automated to update as per your needs.

[Novice101A]

Okay, I spent time trying to actually create a working spreadsheet of what I'm seeking to achieve using
several formulas subsequent to some time learning how to incorporate date and time functions. It's likely
not the most efficient way, but it seems that it would work.