{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Exhibit 1-URTA Comments"]
["Equity: 100 Percent","No Iinterest Synchronization Applied","With Interest Sychronization Applied"]
[]
["Earnings before UUSF, Interest, and Taxes",2000000,2000000]
["Utah USF",601674.64114832529,317038.34114832617]
["Less: Hypothetical Interest Sync Expense  (54.34% debt at 5.87%)",0,{"$f":"$C$13*0.5434*0.0587","v":478463.7}]
["Taxable Earnings",{"$f":"B4+B5-B6","v":2601674.6411483251},{"$f":"C4+C5-C6","v":1838574.6411483262}]
["Composite State and Federal Tax Rate (2017)",{"$f":"0.05+(1-0.05)*0.34","v":0.373},{"$f":"0.05+(1-0.05)*0.34","v":0.373}]
["State/Federal Income Tax",{"$f":"B7*B8","v":970424.64114832529},{"$f":"C7*C8","v":685788.34114832571}]
["After Tax Net Utility Operating Income",{"$f":"B7-B9","v":1631249.9999999998},{"$f":"C7-C9","v":1152786.3000000005}]
["UUSF Operating Income (does not include interest)",{"$f":"B4+B5-B9","v":1631249.9999999998},{"$f":"C4+C5-C9","v":1631250.0000000005}]
[]
["Rate Base",15000000,15000000]
["Rate of Return",0.10875,0.10875]
["Return on Rate Base",{"$f":"B13*B14","v":1631250},{"$f":"C13*C14","v":1631250}]
[]
["Actual Tax Liability",{"$f":"B9","v":970424.64114832529},{"$f":"B17","v":970424.64114832529}]
["Hypothetical Tax Reduction from Interest Sync (cannot be realized on tax filings)",{"$f":"B17-B9","v":0},{"$f":"C17-C19","v":284636.29999999958}]
["UUSF adjusted income tax expense",{"$f":"B9","v":970424.64114832529},{"$f":"C9","v":685788.34114832571}]
["Total Regulated Realized Rate of Return with Interest Sync",{"$f":"(B15-B18)/B13","v":0.10875},{"$f":"(C15-C18)/C13","v":8.9774246666666696E-2}]
[null,{"$f":"B11-B15","v":0},{"$f":"C11-C15","v":0},"(check figure must be zero-use goal seek button below)"]