ASSET MANAGEMENT - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.
The four workbooks share one Inputs sheet: type it once in each file (or copy the sheet across).

Inputs sheet (all four files)

   Inputs!B7             500000000
   Inputs!B8             0.0035
   Inputs!B9             0.0022
   Inputs!B10            250000000
   Inputs!B15            0
   Inputs!C15            120000000
   Inputs!D15            -180000000
   Inputs!E15            0
   Inputs!F15            0
   Inputs!B20            0.45
   Inputs!C20            18.4
   Inputs!D20            -12.6
   Inputs!E20            19.2
   Inputs!F20            9.8
   Inputs!G20            2.6
   Inputs!B21            0.25
   Inputs!C21            -1.2
   Inputs!D21            2.8
   Inputs!E21            4.1
   Inputs!F21            3.2
   Inputs!G21            4.4
   Inputs!B22            0.15
   Inputs!C22            6.3
   Inputs!D22            -3.1
   Inputs!E22            8.6
   Inputs!F22            5.6
   Inputs!G22            3.9
   Inputs!B23            0.1
   Inputs!C23            9.1
   Inputs!D23            -4.4
   Inputs!E23            2.2
   Inputs!F23            -1.8
   Inputs!G23            0.6
   Inputs!B24            0.05
   Inputs!C24            1.1
   Inputs!D24            2.4
   Inputs!E24            3.3
   Inputs!F24            3.9
   Inputs!G24            3.6
   Inputs!B30            0.48
   Inputs!C30            0.46
   Inputs!D30            0.5
   Inputs!E30            0.47
   Inputs!F30            0.44
   Inputs!B31            0.22
   Inputs!C31            0.24
   Inputs!D31            0.2
   Inputs!E31            0.23
   Inputs!F31            0.26
   Inputs!B32            0.16
   Inputs!C32            0.16
   Inputs!D32            0.16
   Inputs!E32            0.15
   Inputs!F32            0.15
   Inputs!B33            0.1
   Inputs!C33            0.1
   Inputs!D33            0.11
   Inputs!E33            0.11
   Inputs!F33            0.11
   Inputs!B34            0.04
   Inputs!C34            0.04
   Inputs!D34            0.03
   Inputs!E34            0.04
   Inputs!F34            0.04
   Inputs!B40            18.9
   Inputs!C40            -12.1
   Inputs!D40            19.8
   Inputs!E40            9.2
   Inputs!F40            2.9
   Inputs!B41            -1
   Inputs!C41            2.6
   Inputs!D41            3.8
   Inputs!E41            3.4
   Inputs!F41            4.2
   Inputs!B42            6.9
   Inputs!C42            -3.6
   Inputs!D42            9.4
   Inputs!E42            5.9
   Inputs!F42            3.6
   Inputs!B43            8.4
   Inputs!C43            -5.1
   Inputs!D43            2.6
   Inputs!E43            -2.4
   Inputs!F43            0.9
   Inputs!B44            1.1
   Inputs!C44            2.4
   Inputs!D44            3.3
   Inputs!E44            3.9
   Inputs!F44            3.6

Fees_Active_and_Passive_Blank.xlsx only

   Active vs passive!B5  0.0005

Result: time-weighted gross 5.0887, net 4.8012, rolling three-year 6.8290, money-weighted 4.1272, benchmark 4.7455;
terminal value 549,908,879.55; fees 7,616,440.40; timing cost 6,357,745.18; index account 547,495,942.65;
allocation 0.2582, selection 0.1030, tracking error 0.6601, information ratio 0.5624 gross and 0.1262 net.

