[kq76]

It's easiest to just wait until the next season, but if you really want to calculate a following season's $ for FAs then you can try the following which should get you close:

$ for Free Agents Next Season

=Forecasted Current Year End (Attendance + Broadcasting + Merchandise) + Forecasted Next Year Start (Cash - Payroll)

[ignore]
=IF(Refs2!$AE$13=0,I29+I30+I31+I45-I64,(($E$33+I33)/2)+I45-(I17+I59+I60)+(I50+I51+I52)-I62)
[/ignore]

WHERE:

Forecasted Current Year End Attendance
= Actual Year To Date Attendance / (Actual Year To Date Home Games / Games per Games per Season / 2)

[ignore]
=I4/I73
[/ignore]

Forecasted Current Year End Broadcasting
= Full Amount

Forecasted Current Year End Merchandise
= Actual Year To Date Merchandise / (Actual Year To Date Total Games / Games per Team per Season)

[ignore]
=I6/I72
[/ignore]

Forecasted Next Year Start Cash
=IF
Actual Year To Date Cash + Forecasted Current Year End Profit > Cash Max,
THEN
Cash Max
OTHERWISE
Actual Year To Date Cash + Forecasted Current Year End Profit

[ignore]
=IF(I12+I41>Refs2!$AE$3,Refs2!$AE$3,I12+I41)
[/ignore]

Forecasted Next Year Start Payroll
=Actual Year To Date Payroll + Next Year Extension Salaries - 1 Yr Obligations

[ignore]
=I17+I59-I63
[/ignore]