LewisVsDarvish
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXY
1
Predicting a ContractContract WAR Projections After the Fact
2
3
Dollar per win5Years of Contract5
4
Inflation Amount1.05Current Age32
5
Current Age24Total Contract Value77
6
Current Value (WAR)6.5Inflation Amount1.05
7
WAR aging factor >= 28 and <= 320.5Dollars per win5
8
WAR aging factor > 320.6WAR aging factor0.5
9
WAR aging factor < 280
10
11
12
Total WAR =3.16.08.811.514.016.418.720.923.025.0
13
WAR needed per year
14
YearAge$/WWAR ProjectionValue in millions (year)Total Value of contract (millions)Year Age$/WWAR ProjectionValue in MillionsTotal Value of ContractTotal WARYears =12345678910
15
124$5.06.5$32.5$33132$5.03.1$15.415.43.13.13.33.43.63.84.04.24.44.64.7
16
225$5.36.5$34.1$67233$5.32.9$15.430.86.02.82.93.13.33.53.73.94.14.2
17
326$5.56.5$35.8$102334$5.52.8$15.446.28.82.42.62.83.03.23.43.63.7
18
427$5.86.5$37.6$140435$5.82.7$15.461.611.52.12.32.52.72.93.13.2
19
528$6.16.0$36.5$177536$6.12.5$15.47714.01.82.02.22.42.62.7
20
629$6.45.5$35.1$212637$6.42.4$15.492.416.41.51.71.92.12.2
21
730$6.75.0$33.5$245738$6.72.3$15.4107.818.71.21.41.61.7
22
831$7.04.5$31.7$277839$7.02.2$15.4123.220.90.91.11.2
23
932$7.44.0$29.5$306940$7.42.1$15.4138.623.00.60.7
24
1033$7.83.4$26.4$3331041$7.82.0$15.415425.00.2
25
26
27
28
29
30
31
http://www.insidethebook.com/ee/index.php/site/are_my_war_aging_numbers_not_aggressive_enough/
Loading...
 
 
 
Sheet3