How to Handle Future Cash Flows in Celestial Divide

Spousal support, mortgage reimbursements, and other promised payments don't enter Celestial Divide as their total nominal value. Here's the right way to think about it — and how to calculate what to actually enter.

The Core Principle: Enter Present Value, Not the Lump Sum

When a divorce settlement includes a future cash flow — spousal support, a reimbursement stream, or any other scheduled payment — what goes into Celestial Divide is the present value of that cash flow, not the total sum of all future payments.

Why? Because a dollar promised 10 years from now is not worth a dollar today. Inflation, opportunity cost, and investment returns all affect what that future income is actually worth to the person receiving it. Present value captures that reality.

A Concrete Example

Say one spouse is required to pay $12,000 at the end of each year for 15 years. The nominal total is $180,000. But that's not what those payments are worth today.

To find the present value, you apply a discount rate — which represents the rate of return the recipient could expect to earn if they received that money upfront and invested it.

At a 10% discount rate, that 15-year stream of $12,000 annual payments is worth $91,272.95 today. That's the number you enter into Celestial Divide.

Choosing the Right Discount Rate

The discount rate isn't arbitrary. It reflects assumptions about the future — and different situations call for different rates.

• Conservative (around 4%): Closer to current bond yields. Appropriate for someone who places a high value on steady, predictable income, or who doesn't expect strong investment returns. At 4%, that same 15-year payment stream is worth closer to $133,000.
• Moderate (around 10%): A reasonable baseline in many planning scenarios. Reflects a moderate expected rate of return on invested capital. Present value: $91,272.95.
• Aggressive (15% or higher): Reflects confidence in high investment returns or a high-interest-rate environment. At 15%, the same stream drops to roughly $70,000.

The discount rate you use is a judgment call — but it should be defensible. It reflects either expected returns, the value placed on income stability, or both.

Strategic Bidding on Cash Flows

In a cordial process, both parties can agree on a single discount rate and each enter the resulting present value. Simple and clean.

In a more contested matter, the bidding on a cash flow becomes its own negotiation. A few things to keep in mind:

• A lower bid signals a higher expected rate of return — or a lower appreciation for steady income. If you bid $75,000 on a cash flow, you're implicitly saying the income stream isn't worth much to you, or that you're confident you'll earn more by deploying that capital elsewhere.
• A higher bid signals the opposite. At $125,000, you're saying this income stream is valuable — you'll prioritize it over other assets in the estate.

In a contentious matter, the gap between bids can work in your favor through the platform's jealousy mechanism. If one party bids high on the cash flow and you bid slightly lower, you may receive compensation from the allocation rather than the asset itself. That's a legitimate strategy — but it requires thinking through your bids before the process begins.

Once the data is entered, bids are binding. There's no walking back a number after the fact. That's by design: blind bidding protects both parties from post-hoc negotiation.

How to Calculate Present Value Yourself

If you're working in Excel, two functions handle this:

• NPV — takes a discount rate and a series of equal periodic payments. Enter the discount rate (e.g., 0.10 for 10%) as the first argument, then the payment amounts.
• XNPV — works the same way, but allows you to enter specific dates for each payment rather than assuming equal intervals. Useful for monthly payments, uneven schedules, or streams that don't align neatly with calendar year-end.

In both cases, what the function returns is the present value — the number you bring into Celestial Divide.

One Important Caveat: Retirement Accounts

This approach doesn't apply to IRAs, Roth IRAs, or similar retirement vehicles. The tax treatment, withdrawal rules, and timing involved in those assets create a different set of considerations. If retirement accounts are part of the matter, work with a financial advisor who can model those correctly before any numbers go into the system.

Frequently Asked Questions

Why can't I just enter the total payment amount?

Entering the nominal total overstates the value of future payments. A dollar received 10 years from now is worth less than a dollar today because of inflation and the opportunity cost of capital. Present value corrects for this — it's what makes the allocation defensible and economically accurate.

How do I pick the right discount rate for my case?

It depends on the circumstances. A conservative rate (around 4%) is appropriate when the recipient has limited investment options or prioritizes income stability. A moderate rate (around 10%) reflects a typical expected return on invested capital. An aggressive rate (15%+) assumes high returns or a high-rate environment. Whatever rate you use, document the reasoning — it needs to hold up if questioned.

What if both parties disagree on the discount rate?

Each party bids what the cash flow is worth to them. That's exactly what the bidding process is designed for — you don't need to agree upfront. The platform's allocation model will account for the difference in valuations and assign the asset accordingly.

Does this apply to spousal support specifically, or other payment types too?

Any scheduled future cash flow — spousal support, mortgage reimbursements, installment buyouts, or other recurring obligations — should be entered as a present value using the same approach.

What about IRAs and retirement accounts?

Retirement accounts are handled differently due to tax treatment, withdrawal rules, and timing considerations. Don't apply the present value approach to IRAs or similar vehicles — consult a financial advisor to model those correctly before entering any figures into the system.

Celestial Divide is estate asset division software built for professionals. It helps executors, estate attorneys, trust officers, and family law practitioners manage asset allocation, document every decision, and produce defensible outcomes — without spreadsheets or manual negotiation.