Payroll For Next Season Question

[kayber76]

I'm trying to figure out my pay roll for next year, please let me know if I'm doing this right.

To figure out my pay roll for next year I have to add up all my salaries of current contracts, and arbitration for next year? Then subract the money of the guys that are free agents right?

THe guys I dont' resign I'm pretty sure I subract them. Plus I know I have to add in the arbitration salaries into the total right?

[sporr]

That's correct. Simply add up all of the contracts for players that will be on your team next year using the salary that they will be making that season. You can use the arbitration estimate for players that will be going to arbitration.

[kayber76]

Ok so if I add up the salaries of the players I won't be resigning. That's money I can use for signing new guys in the off season right?

Would I add that to total revenue?

This should give me an idea of what I"ll have in the offseason?

[ssmarsh]

I believe the formula for $$ available for free agents is something like this:

last years revenue - current payroll + cash

[kq76]

Formulas for this year:

http://www.ootpdevelopments.com/boar...threadid=40133

Figuring "$ for... next year" is a bit complicated, but my archive in my sig tries to get a reasonably close figure (it's not exact because it cannot foresee the future). Here's a screenshot of the applicable sheet for my old solo league. Notice what is inside the red square. NY stands for next year.

EDIT: Bah! It didn't attach. I'll put it here temporarily:



EDIT2: Here's the applicable VB code:

    'ny
    Range("I23") = "=I17+I40-I50" 'payroll
    Range("I24") = "=IF($B$7>0,$B$7-I23,""N/A"")" 'cap room
    Range("I25") = "=I$4+I$6+I$5+I$15-I23" '$ for FAs
    Range("I26") = "=I$4+I$6+I$5+I$15-(I23-I51)" '$ for Exts

So..

NY payroll = TY payroll + NY Salary Extensions - 1 Yr Salary Obligations (I count salary obligations as those contracts you _have_ to pay and 1 Yr Salary Obligations are just those 1 yr contracts you have)

NY $ for FAs = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - NY Payroll

NY $ for Exts = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - (NY Payroll - 2 Yr Salary Obligations)

If you think I should change something, let me know.

[kayber76]

Using last years info though wont' help me this year will it. 30 games left till our season ends. I'm just trying to get an idea.

I'd had to use this years marketing wont' i? (cause at the end of the season that info would be last year) Or does that not matter just use the formula your refering me too. I see that we still have to add last years revenue to this years tv contract.

[kayber76]

I think i'm confusing myself..

[kq76]

Originally posted by kayber76
Using last years info though wont' help me this year will it. 30 games left till our season ends. I'm just trying to get an idea.

I'd had to use this years marketing wont' i? (cause at the end of the season that info would be last year) Or does that not matter just use the formula your refering me too. I see that we still have to add last years revenue to this years tv contract.

During the season it's more complicated (and the latest released version of my archive won't calculate it correctly). What you could do is calculate what your this year's revenue will likely be at the end of the season. If you don't want to do that, using last year's is maybe the next best thing.

[kayber76]

Ah got it

Thanks guys.

Not to hard to figure out actually once you get it