self-employed calc for an age-weighted plan

[Guest annieap1]

We have a Schedule C person with an age-weighted allocation formula. I'm OK with regular and integrated formulas, but am wondering how to set up the circular calculation for this type of allocation. If Tom Poje sees this post, perhaps he can help. I downloaded his self-employed/partnership calculation spreadsheet and found that my own spreadsheet was exactly like his as to the outcome - not the format. Any help/suggestions will be greatly appreciated.

[Tom Poje]

many many moons ago, back when I was doing software support, I figured out a way to trick the old glorious Pentabs system into doing an ideal salary calc for an age weighted plan - using of all things, the target benefit module. It started from a service call in which the client asked if it was possible, and I said no, but give me a day and I'll figure a way around it. send me the plan to test. I'm sure I figured it out on a Friday night - no one else wanted to work that night, since I'm no party animal it didn't matter to me. I thought it was great, cuz those nights were slow for service calls, and it gave me a chance to figure out solutions to such ridiculous questions. well, I expected a simple 10 life 1 ideal salary calc - instead I got a 100 life with 20 'owners' to figure ideal salaries on. what a test! but the solution I came up with actually worked.

well, I'm not in support anymore, I have a desk covered with work, and appreciate even more why software people get paid for the time they spend doing such things. I actually have an idea how it might be possible to do this in the spreadsheet, at least on a fairly simple level, but getting the time to even try it is another thing. Go and figure, my boss doesn't like me spending my time doing stuff for nothing!

(I do take that as a compliment that you even mentioned my name in your post!)

[No Name]

Modification of the standard Schedule C calc (I use an Excel version that does iteration) is fairly straight forward. I add a couple extra columns called AGE and POINTS. Allocation is my points over total points. Be careful that these extra columns don't interfere with the owner's compensation calc.