The book's own inputs, to type back into the blank set

1. Northgate_Model_Blank.xlsx  (Chapters 2 to 16, Appendix A)

   Assumptions!B4        IT capacity delivered (MW)                            96
   Assumptions!B5        All-in construction cost (M$ per MW IT)               6.4
   Assumptions!B6        Non-depreciable share of cost                         0.06
   Assumptions!B9        Rent ($/kW IT/month, triple net)                      56
   Assumptions!B10       Rent indexation (per year)                            0.025
   Assumptions!B11       Lease term (years)                                    15
   Assumptions!B12       Non-recoverable opex (M$/yr)                          2.9
   Assumptions!B13       Opex indexation (per year)                            0.025
   Assumptions!B16       Swap rate                                             0.041
   Assumptions!B17       Margin                                                0.02
   Assumptions!B18       Arrangement fee (% of facility)                       0.015
   Assumptions!B19       Term (years)                                          15
   Assumptions!B20       Sizing cover ratio (DSCR)                             1.45
   Assumptions!B21       Maximum loan to cost                                  0.65
   Assumptions!B22       Debt service reserve (months)                         6
   Assumptions!B23       Amortization profile (years)                          25
   Assumptions!B25       Exit year                                             10
   Assumptions!B26       Exit cap rate                                         0.0725
   Assumptions!B27       Selling costs                                         0.01
   Assumptions!B30       Tax rate                                              0.21
   Assumptions!B31       Tax depreciation life (years)                         39
   Assumptions!B35       Debt held fixed at (M$)                               427.3
   Solve!B9              Share of construction cost drawn in the quarter       0.06
   Solve!C9              Share of construction cost drawn in the quarter       0.11
   Solve!D9              Share of construction cost drawn in the quarter       0.16
   Solve!E9              Share of construction cost drawn in the quarter       0.18
   Solve!F9              Share of construction cost drawn in the quarter       0.18
   Solve!G9              Share of construction cost drawn in the quarter       0.15
   Solve!H9              Share of construction cost drawn in the quarter       0.11
   Solve!I9              Share of construction cost drawn in the quarter       0.05

   Result: 427.3 million of debt (loan to cost binds; the cover test allows 538.1), 1.826x in year one,
   a 247.2 balloon, 16.60 per cent to equity and 4.05x. Stress switch: NO; debt to hold with YES: 427.3.

2. Aurora_Model_Blank.xlsx  (Chapters 6, 10, 11 and 15, Appendix B)

   Assumptions!B4        Solar capacity (MWac)                                 220
   Assumptions!B5        Capacity factor (P50, net)                            0.285
   Assumptions!B6        Annual degradation                                    0.005
   Assumptions!B7        Battery power (MW)                                    80
   Assumptions!B8        Battery energy (MWh)                                  320
   Assumptions!B11       Solar EPC ($/Wac)                                     1.4
   Assumptions!B12       Battery ($/kWh installed)                             280
   Assumptions!B13       Grid connection (M$)                                  24
   Assumptions!B14       Contingency                                           0.04
   Assumptions!B15       Development cost (M$)                                 12
   Assumptions!B16       Owner's cost (M$)                                     18
   Assumptions!B19       PPA price ($/MWh)                                     55
   Assumptions!B20       PPA term (years)                                      15
   Assumptions!B21       Battery tolling ($/kW-month)                          11.5
   Assumptions!B22       Merchant price (2026 real, $/MWh)                     31
   Assumptions!B23       Solar capture factor                                  0.85
   Assumptions!B24       Inflation on the merchant price                       0.0225
   Assumptions!B25       Merchant tail (years)                                 10
   Assumptions!B28       Solar O&M ($/kW-yr)                                   8.5
   Assumptions!B29       Battery O&M ($/kW-yr)                                 6
   Assumptions!B30       Land (acres)                                          1400
   Assumptions!B31       Land rent ($/acre-yr)                                 900
   Assumptions!B32       Insurance (% of hard cost)                            0.0035
   Assumptions!B33       Asset management (M$/yr)                              0.75
   Assumptions!B34       Property tax (M$/yr)                                  1.1
   Assumptions!B35       Opex indexation                                       0.0225
   Assumptions!B38       Swap rate                                             0.041
   Assumptions!B39       Margin                                                0.01875
   Assumptions!B40       Arrangement fee                                       0.0175
   Assumptions!B41       Tenor (years)                                         18
   Assumptions!B42       Cover ratio, contracted years                         1.35
   Assumptions!B43       Cover ratio, merchant years                           1.9
   Assumptions!B44       Maximum loan to cost                                  0.7
   Assumptions!B45       Debt service reserve (months)                         6
   Assumptions!B48       Tax rate                                              0.21
   Assumptions!B49       Tax depreciation life (years)                         20
   Assumptions!B50       Investment tax credit                                 0.3
   Assumptions!B51       Battery revenue in the tail                           0.6
   Assumptions!B52       Terminal value at year 25                             0
   Assumptions!B53       Credit reduces the depreciable base by                0.5
   Assumptions!B57       Signed loan (M$)                                      242.933288845638
   Solve!B13             Share of construction cost drawn in the quarter       0.1
   Solve!C13             Share of construction cost drawn in the quarter       0.18
   Solve!D13             Share of construction cost drawn in the quarter       0.22
   Solve!E13             Share of construction cost drawn in the quarter       0.22
   Solve!F13             Share of construction cost drawn in the quarter       0.18
   Solve!G13             Share of construction cost drawn in the quarter       0.1
   Signed schedule!B5:S5 the eighteen installments signed at close (only for the stress switch):
   25.4172  25.1898  24.9602  24.7286  24.4948  24.2588
   24.0205  23.7798  23.5367  23.2911  23.0429  22.7921
   22.5386  22.2823  22.0231  8.2547  8.3115  8.3688

   Result: 242.9 million of sculpted debt (the cover test binds), 1.350x in every contracted year,
   5.59 per cent to equity with the 30 per cent credit, 0.13 per cent without (Returns, row 35).
