{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Start","HistoricalData","Assumptions","Mortgage-StyleDetail","Income","CashFlow","Balance","SourcesUses","Ratios","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":3,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":9,"reason":"part_missing"}],"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":"Start","index":0,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,2,5,7],[11,2,13,3]]}
[null,null,"TEMPLATE LAST REVISED ON:",null,null,"2021-11-19"]
[]
[]
[]
[null,null,"Enter Project/Company Name"]
[null,null,"Sample Company"]
[]
[null,null," "]
[null,null," ",null,null," ",null,null,null," "]
[null,null," ",null,null," "]
[]
[null,null,"Enter Target Date for First Disbursement of DFC-Supported Debt"]
[null,null,null,null,"2022-06-15"]

{"sheet":"HistoricalData","index":1,"n_rows":140,"n_cols":15,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(Start!C6,\" Historical Financial Statements\")","v":"Sample Company Historical Financial Statements"}]
[null,null,null,null," "]
[null," "]
[null,"Please enter amounts in \"thousands\" of currency units.  ",null,null,null,null,null,null,null,null,null,"Rounding"]
[" ",null,null,null,null,null,null,null,null,null,null,"Thousands"," "]
[null,{"$f":"YEAR(Start!E13)-3","v":2019},{"$f":"B6+1","v":2020},{"$f":"C6+1","v":2021},null,null,null,null,null,null,"Millions"]
["Statement Preparation Type"]
[" "]
[]
["End of Year Exchange Rate                 (statement currency/USD)"]
[null,null,null,null,null,null,null,null,null,null,"Statement Type"]
["Balance Sheet Items",null,null,null,null,null,null," ",null,null,"Audited-Unqualified",1,1,1,1]
["Current Assets",null,null,null,null,null,null,null,null,null,"Audited-Qualified"]
["Cash and Cash Equivalents",null,null,null,null,null,null,null,null,null,"Reviewed"]
["Receivables (Trade)",null,null,null,null,null,null,null,null,null,"Compiled"]
["Receivables (Notes, Other)",null,null,null,null,null,null,null,null,null,"Company Prepared"]
["Inventory (Sum of all Types)"]
["Fixed Assets"]
["Land"]
["Buildings and Leasehold Improvements"]
["Machinery and Equipment"]
["Furniture and Fixtures"]
["Transportation Equipment"]
["Long Term Receivables"]
["Other Fixed Assets"]
["Intangibles"]
["Accumulated Depreciation (-)"]
[]
["Total Assets",{"$f":"SUM(B14:B17)+SUM(B19:B27)","v":0},{"$f":"SUM(C14:C17)+SUM(C19:C27)","v":0},{"$f":"SUM(D14:D17)+SUM(D19:D27)","v":0}]
[]
["Current Liabilities"]
["Trade Payables and Other Current Liabilities"]
["Short Term Debt"]
["Current Portion of Long Term Debt"]
[]
["Long Term Liabilities"]
["Long Term Debt (Senior)"]
["Subordinated Debt"]
["Other Long-Term Liabilities"]
[]
["Equity/Net Worth"]
["Common Stock"]
["Paid in Capital"]
["Retained Earnings"]
[]
["Total Liabilites and Net Worth",{"$f":"SUM(B32:B34)+SUM(B37:B39)+SUM(B42:B44)","v":0},{"$f":"SUM(C32:C34)+SUM(C37:C39)+SUM(C42:C44)","v":0},{"$f":"SUM(D32:D34)+SUM(D37:D39)+SUM(D42:D44)","v":0}]
[null,{"$f":"IF(B29-B46=0,\"    \",\"Error\")","v":"    "},{"$f":"IF(C29-C46=0,\"    \",\"Error\")","v":"    "},{"$f":"IF(D29-D46=0,\"    \",\"Error\")","v":"    "}]
[]
[]
[]
["Profit and Loss/Income Statement Items"]
["Revenue (net of discounts/allowances)"]
["Cost of Goods Sold"]
["Cash Operating Expenses"]
["Non-Cash Operating Expenses"]
["Depreciation and Amortization"]
["Net Interest Income/(Expense)"]
["Taxes"]
["Other Cash Income"]
["Other Non-Cash Income"]
["Other Cash Deductions (-)"]
["Other Non-Cash Deductions (-)"]
["Net Income",{"$f":"B52-SUM(B53:B56)+B57-B58+SUM(B59:B62)","v":0},0,{"$f":"D52-SUM(D53:D56)+D57-D58+SUM(D59:D62)","v":0}]
["Dividends"]
[" "]
["Adjustments During the Year"]
["Non-Dividend Adjmts to Retained Earnings"]
["Other Cash Adjustments to Equity"]
["Other Non-Cash Adjustments to Equity"]
[]
[null,null,"[Convert to USD button]"]
[]
[]
[]
["Balance Sheet Items"]
["Current Assets"]
["Cash and Cash Equivalents",{"$f":"B14*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C14*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"CashFlow!D42","v":0}]
["Receivables (Trade)",{"$f":"B15*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C15*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D15*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Receivables (Notes, Other)",{"$f":"B16*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C16*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D16*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Inventory (Sum of all Types)",{"$f":"B17*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C17*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D17*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Fixed Assets"]
["Land",{"$f":"B19*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C19*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D19*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Buildings and Leasehold Improvements",{"$f":"B20*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C20*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D20*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Machinery and Equipment",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Furniture and Fixtures",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Transportation Equipment",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Long Term Receivables",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Fixed Assets",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Intangibles",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Accumulated Depreciation (-)",{"$error":"#DIV/0!"},{"$f":"B27/$B$10+(B27/$C$10-B27/$B$10)-C118","v":{"$error":"#DIV/0!"}},{"$f":"C27/$C$10+(C27/$D$10-C27/$C$10)-D118","v":{"$error":"#DIV/0!"}}]
[]
["Total Assets",{"$f":"SUM(B77:B80)+SUM(B82:B90)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C77:C80)+SUM(C82:C90)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D77:D80)+SUM(D82:D90)","v":{"$error":"#DIV/0!"}}]
[]
["Current Liabilities"]
["Trade and Other Payables",{"$f":"B32*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C32*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D32*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Short Term Debt",{"$f":"B33*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C33*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D33*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Current Portion of Long Term Debt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Long Term Liabilities"]
["Long Term Debt (Senior)",{"$f":"B37*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C37*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D37*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Subordinated Debt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Long-Term Liabilities",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Equity/Net Worth"]
["Common Stock",{"$f":"B42*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C42*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D42*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Paid in Capital",{"$f":"B43*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C43*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D43*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Retained Earnings",{"$f":"B44*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"B44/$B$10+(B44/$C$10-B44/$B$10)+C125-C126","v":{"$error":"#DIV/0!"}},{"$f":"C44/$C$10+(C44/$D$10-C44/$C$10)+D125-D126","v":{"$error":"#DIV/0!"}}]
[]
["Total Liabilites and Net Worth",{"$f":"SUM(B95:B97)+SUM(B100:B102)+SUM(B105:B107)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C95:C97)+SUM(C100:C102)+SUM(C105:C107)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D95:D97)+SUM(D100:D102)+SUM(D105:D107)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(OR(B92-B109<1,B92-B109>-1),\"    \",\"Error\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C92-C109<1,C92-C109>-1),\"    \",\"Error\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D92-D109<1,D92-D109>-1),\"    \",\"Error\")","v":{"$error":"#DIV/0!"}}]
[]
[]
["Profit and Loss/Income Statement Items"]
["Revenue (net of discounts/allowances)",{"$f":"B52*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C52*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D52*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Cost of Goods Sold",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Cash Operating Expenses",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Non-Cash Operating Expenses",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Depreciation and Amortization",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Net Interest Income/(Expense)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Taxes",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Cash Income",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Non-Cash Income",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Cash Deductions",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other Non-Cash Deductions",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Net Income",{"$f":"B114-SUM(B115:B118)+B119-B120+SUM(B121:B124)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Dividends",{"$f":"B64*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C64*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D64*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
[" "]
["Adjustments During the Year"]
["Non-Dividend Adjmts to Retained Earnings",{"$f":"B67*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C67*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D67*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Other Cash Adjustments to Equity",{"$f":"B68*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C68*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D68*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
["Other Non-Cash Adjustments to Equity",{"$f":"B69*(1/$B$10)","v":{"$error":"#DIV/0!"}},{"$f":"C69*(1/$C$10)","v":{"$error":"#DIV/0!"}},{"$f":"D69*(1/$D$10)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Reconciliation of Equity"]
["Starting Equity"," ",{"$f":"IF($C$10=0,SUM(B42:B44),SUM(B105:B107))","v":0},{"$f":"IF($D$10=0,SUM(C42:C44),SUM(C105:C107))","v":0}]
["Changes to Retained Earnings"," ",{"$f":"IF($C$10=0,C63-C64+C67,C125-C126+C129)","v":0},{"$f":"IF($D$10=0,D63-D64+D67,D125-D126+D129)","v":0}]
["Changes to Other Equity"," ",{"$f":"IF($C$10=0,C68+C69,C130+C131)","v":0},{"$f":"IF($D$10=0,D68+D69,D130+D131)","v":0}]
["Changes due to Y-to-Y Exchange Rate"," ",{"$f":"IF(C10=0,0,(SUM(B42:B44)/C10)-(SUM(B42:B44)/B10))","v":0},{"$f":"IF(D10=0,0,(SUM(C42:C44)/D10)-(SUM(C42:C44)/C10))","v":0}]
["Unexplained Changes to Equity",null,{"$f":"C140-SUM(C135:C138)","v":0},0]
["Ending Equity"," ",{"$f":"IF($C$10=0,SUM(C42:C44),SUM(C105:C107))","v":0},{"$f":"IF($D$10=0,SUM(D42:D44),SUM(D105:D107))","v":0}]

{"sheet":"Assumptions","index":2,"n_rows":181,"n_cols":19,"rows_kept":181,"cut":false,"hidden":false,"merged":[[30,0,30,1],[99,1,99,3],[111,1,111,3],[123,1,123,3],[28,0,28,1],[67,0,67,1]]}
["Calendar Year",null,null,{"$f":"YEAR(Start!E13)","v":2022},{"$f":"D1+1","v":2023},{"$f":"E1+1","v":2024},2025,2026,2027,2028,2029,2030,{"$f":"L1+1","v":2031},{"$f":"M1+1","v":2032},{"$f":"N1+1","v":2033},{"$f":"O1+1","v":2034}]
[" ",null,null,{"$f":"Start!C6","v":"Sample Company"},null,null,null,null,null,null," "]
["Revenues in $000s"]
[]
["Business Line \"A\""]
["Number of Units sold annually",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Existing",1]
["Price per Unit (local currency)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"New"]
["Currency conversion (local currency per USD)",null,null,1,1,1,{"$f":"$F$8","v":1},{"$f":"$F$8","v":1},1,1,1,1,1,1,1,1]
[{"$f":"CONCATENATE(A5,\" Revenue in $000s\")","v":"Business Line \"A\" Revenue in $000s"},null,null,{"$f":"(D6*D7/1000)*(1/D8)","v":0},{"$f":"(E6*E7/1000)*(1/E8)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Business Line \"B\""]
["Number of Units sold annually",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Existing",1]
["Price per Unit (local currency)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"New"]
["Currency conversion (local currency per USD)",null,null,{"$f":"D8","v":1},{"$f":"E8","v":1},1,1,1,1,1,1,1,1,1,{"$f":"O8","v":1},{"$f":"P8","v":1}]
[{"$f":"CONCATENATE(A11,\" Revenue in $000s\")","v":"Business Line \"B\" Revenue in $000s"},null,null,{"$f":"(D12*D13/1000)*(1/D14)","v":0},{"$f":"(E12*E13/1000)*(1/E14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Business Line \"C\""]
["Number of Units sold annually",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Existing",1]
["Price per Unit (local currency)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"New"]
["Currency conversion (local currency per USD)",null,null,{"$f":"D8","v":1},{"$f":"E8","v":1},1,1,1,1,1,1,1,1,1,{"$f":"O8","v":1},{"$f":"P8","v":1}]
[{"$f":"CONCATENATE(A17,\" Revenue in $000s\")","v":"Business Line \"C\" Revenue in $000s"},null,null,{"$f":"(D18*D19/1000)*(1/D20)","v":0},{"$f":"(E18*E19/1000)*(1/E20)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Business Line \"D\""]
["Number of Units sold annually",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Existing",1]
["Price per Unit (local currency)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"New"]
["Currency conversion (local currency per USD)",null,null,{"$f":"D8","v":1},{"$f":"E8","v":1},1,1,1,1,1,1,1,1,1,{"$f":"O8","v":1},{"$f":"P8","v":1}]
[{"$f":"CONCATENATE(A23,\" Revenue in $000s\")","v":"Business Line \"D\" Revenue in $000s"},null,null,{"$f":"(D24*D25/1000)*(1/D26)","v":0},{"$f":"(E24*E25/1000)*(1/E26)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"CONCATENATE(\"Total Sales Revenues in $000s\")","v":"Total Sales Revenues in $000s"},null,null,{"$f":"D9+D15+D21+D27","v":0},{"$f":"E9+E15+E21+E27","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating Costs in $000s"]
[]
["Cost of Goods Sold as % of Total Sales Revenue",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cost of Goods Sold in $000s",null,null,{"$f":"D29*D33","v":0},0,0,0,0,0,0,0,0,{"$f":"M29*M33","v":0},{"$f":"N29*N33","v":0},{"$f":"O29*O33","v":0},{"$f":"P29*P33","v":0}]
[]
["Indirect/Overhead Costs"]
["Local Currency Costs"]
["Operating Expense (local 000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense (local 000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense (local 000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense (local 000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense (local 000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Local Currency Cost (local 000s)",null,null,{"$f":"SUM(D38:D42)","v":0},{"$f":"SUM(E38:E42)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O38:O42)","v":0},{"$f":"SUM(P38:P42)","v":0}]
["Conversion (local currency per USD)",null,null,{"$f":"D8","v":1},{"$f":"E8","v":1},1,1,1,1,1,1,1,1,1,{"$f":"O8","v":1},{"$f":"P8","v":1}]
["Total Local currency cost in $000s",null,null,{"$f":"D43*(1/D44)","v":0},{"$f":"E43*(1/E44)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"O43*(1/O44)","v":0},{"$f":"P43*(1/P44)","v":0}]
[]
["US Dollar Costs"]
["Operating Expense ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expense ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total US Dollar Costs ($000s)",null,null,{"$f":"SUM(D48:D52)","v":0},{"$f":"SUM(E48:E52)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O48:O52)","v":0},{"$f":"SUM(P48:P52)","v":0}]
["Total Indirect Costs ($000s)",null,null,{"$f":"D45+D53","v":0},{"$f":"E45+E53","v":0},0,0,0,0,0,0,0,0,0,{"$f":"O45+O53","v":0},{"$f":"P45+P53","v":0}]
[]
["Capital Costs in $000s"]
["Capital Expenditures (Up-front costs)"]
["Expense Line Item 1",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 2",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 3",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 4",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 5",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 6",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 7",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 8",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 9",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Expense Line Item 10",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Capital Expenditures",null,null,{"$f":"SUM(D58:D67)","v":0},{"$f":"SUM(E58:E67)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M58:M67)","v":0},{"$f":"SUM(N58:N67)","v":0},{"$f":"SUM(O58:O67)","v":0},{"$f":"SUM(P58:P67)","v":0}]
[]
[]
["DFC Debt Assumptions and Schedule"]
[" ",null,null,null,null,null,null,null,"Anchor Date"]
["Total Loan Amount in $000s",null,null,0,null,null," ",null," "]
["Base Interest Cost (%)",null,null,2.5000000000000001E-2,null,null,null,null," "]
["Interest Risk Spread (%)",null,null,0.04,null,null,null,null," "]
["All-in Annual Interest Rate (%)",null,null,{"$f":"D74+D75","v":6.5000000000000002E-2},null,null,null,null," "]
["Commitment Fee (%)",null,null,0,null,null," ",null," "]
["Facility/Administrative Fee (%)",null,null,0,null,null,null,null," "]
["Total Loan Term (months)",null,null,120,null,null," ",null," "]
["Grace Period on Principal Repayment (months)",null,null,12,null,null,null,null," "]
["# of payments per year",null,null,4," ",null,null,null," "]
["Estimated Date of First Drawdown",null,null,{"$f":"Start!E13","v":"2022-06-15"},{"$f":"IF(D82>DATE(D1,12,31),\"Error -- 1st disb must be in 1st year.\",\" \")","v":" "},null,null,null," "]
["Estimated Date of First Principal Repayment",null,null,{"$f":"EDATE(D82,D80)","v":"2023-06-15"},null," ",null," "," "]
["Estimated Maturity Date",null,null,{"$f":"EDATE(D82,D79)","v":"2032-06-15"}]
["Number of Principal Payments",null,null,{"$f":"COUPNUM(D83,D84,D81,1)+1","v":37},null," "]
["Straight-line or Mortgage-Style?",null,null,1]
[null,null,null,null,null,null,null,null,"\""]
["# of principal Payments if quarterly",null,null,{"$f":"IF(OR(DATE(D1,12,31)<$D$83,DATE(D1,1,1)>$D$84),0,IF(AND(DATE(D1,1,1)>$D$83,DATE(D1,12,31)<$D$84),4,IF(AND($D$83>DATE(D1,1,1),$D$83<DATE(D1,12,31)),COUPNUM($D$83,DATE(D1,12,31),4,1),COUPNUM(DATE(D1,1,1),$D$84,4,1))))","v":0},3,4,4,4,4,4,4,4,4,2,0,0," "]
["# of principal Payments if semi-annual",null,null,{"$f":"IF(OR(DATE(D1,12,31)<$D$83,DATE(D1,1,1)>$D$84),0,IF(AND(DATE(D1,1,1)>$D$83,DATE(D1,12,31)<$D$84),2,IF(AND($D$83>DATE(D1,1,1),$D$83<DATE(D1,12,31)),COUPNUM($D$83,DATE(D1,12,31),2,1),COUPNUM(DATE(D1,1,1),$D$84,2,1))))","v":0},2,2,2,2,2,2,2,2,2,1,0,0]
[null,null,null,{"$f":"IF($D$81=4,D88,D89)","v":0},3,4,4,4,4,4,4,4,4,2,0,0]
["Outstanding Principal (Start of Year)",null,null,0,{"$f":"D97","v":0},0,0,{"$f":"G97","v":0},{"$f":"H97","v":0},0,0,0,{"$f":"L97","v":0},{"$f":"M97","v":0},{"$f":"N97","v":0},{"$f":"O97","v":0}]
["DFC Debt Principal Disbursements in $000s",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["DFC Debt Fees (Facility, Commitment)",null,null,{"$f":"$D$73*$D$78+YEARFRAC(D82,DATE(D1,12,31))*$D$77*($D$73-$D$92)","v":0},{"$f":"($D$73-SUM($D$92:D92)-E92/2)*$D$77/2+($D$73-SUM($D$92:E92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:E92)-F92/2)*$D$77/2+($D$73-SUM($D$92:F92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:F92)-G92/2)*$D$77/2+($D$73-SUM($D$92:G92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:G92)-H92/2)*$D$77/2+($D$73-SUM($D$92:H92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:H92)-I92/2)*$D$77/2+($D$73-SUM($D$92:I92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:I92)-J92/2)*$D$77/2+($D$73-SUM($D$92:J92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:J92)-K92/2)*$D$77/2+($D$73-SUM($D$92:K92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:K92)-L92/2)*$D$77/2+($D$73-SUM($D$92:L92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:L92)-M92/2)*$D$77/2+($D$73-SUM($D$92:M92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:M92)-N92/2)*$D$77/2+($D$73-SUM($D$92:N92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:N92)-O92/2)*$D$77/2+($D$73-SUM($D$92:O92))*$D$77/2","v":0},{"$f":"($D$73-SUM($D$92:O92)-P92/2)*$D$77/2+($D$73-SUM($D$92:P92))*$D$77/2","v":0}]
["DFC Debt Interest",null,null,{"$f":"YEARFRAC(D82,DATE(D1,12,31))*D92*$D$76","v":0},{"$f":"IF($D$86=1,((E91+E97)/2)*$D$76,LOOKUP(E1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((F91+F97)/2)*$D$76,LOOKUP(F1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((G91+G97)/2)*$D$76,LOOKUP(G1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((H91+H97)/2)*$D$76,LOOKUP(H1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((I91+I97)/2)*$D$76,LOOKUP(I1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((J91+J97)/2)*$D$76,LOOKUP(J1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((K91+K97)/2)*$D$76,LOOKUP(K1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((L91+L97)/2)*$D$76,LOOKUP(L1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((M91+M97)/2)*$D$76,LOOKUP(M1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((N91+N97)/2)*$D$76,LOOKUP(N1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((O91+O97)/2)*$D$76,LOOKUP(O1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0},{"$f":"IF($D$86=1,((P91+P97)/2)*$D$76,LOOKUP(P1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$C$13:$C$28))","v":0}]
["DFC Debt Principal Repayments",null,null,{"$f":"IF($D$86=1,($D$73/$D$85)*D90,LOOKUP(D1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*E90,LOOKUP(E1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*F90,LOOKUP(F1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*G90,LOOKUP(G1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*H90,LOOKUP(H1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*I90,LOOKUP(I1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*J90,LOOKUP(J1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*K90,LOOKUP(K1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*L90,LOOKUP(L1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*M90,LOOKUP(M1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*N90,LOOKUP(N1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*O90,LOOKUP(O1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0},{"$f":"IF($D$86=1,($D$73/$D$85)*P90,LOOKUP(P1,'Mortgage-StyleDetail'!$A$13:$A$28,'Mortgage-StyleDetail'!$B$13:$B$28))","v":0}]
["Total DFC Debt Service",null,null,{"$f":"SUM(D93:D95)","v":0},{"$f":"SUM(E93:E95)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Outstanding Principal (End of Year)",null,null,{"$f":"D91+D92-D95","v":0},{"$f":"E91+E92-E95","v":0},0,0,0,0,0,0,0,{"$f":"M91+M92-M95","v":0},{"$f":"N91+N92-N95","v":0},{"$f":"O91+O92-O95","v":0},{"$f":"P91+P92-P95","v":0}]
[]
["Other Senior Debt -- Assumptions and Schedule"]
["Name of Lender","Name"]
["Annual Interest Rate (%)",null,null,0]
[]
["Outstanding Principal (Start of Year)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D37,HistoricalData!D100)+IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D34,HistoricalData!D97)","v":0},{"$f":"D109","v":0},{"$f":"E109","v":0},0,0,0,0,0,0,0,0,0,0]
["Principal Disbursements (in $000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fees (in $000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Interest",null,null,{"$f":"((D103+D109)/2)*$D$101","v":0},{"$f":"((E103+E109)/2)*$D$101","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Principal Repayments (in $000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Other Senior Debt Service",null,null,{"$f":"SUM(D105:D107)","v":0},{"$f":"SUM(E105:E107)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Outstanding Principal (End of Year)",null,null,{"$f":"D103+D104-D107","v":0},{"$f":"E103+E104-E107","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Short Term Debt -- Assumptions and Schedule"]
["Name of Lender","Name"]
["Annual Interest Rate (%)",null,null,0]
[]
["Outstanding Principal (Start of Year)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D33,HistoricalData!D96)","v":0},{"$f":"D121","v":0},{"$f":"E121","v":0},{"$f":"F121","v":0},{"$f":"G121","v":0},{"$f":"H121","v":0},{"$f":"I121","v":0},{"$f":"J121","v":0},{"$f":"K121","v":0},{"$f":"L121","v":0},{"$f":"M121","v":0},{"$f":"N121","v":0},{"$f":"O121","v":0}]
["Principal Disbursements (in $000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fees (in $000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Interest",null,null,{"$f":"((D115+D121)/2)*$D$113","v":0},{"$f":"((E115+E121)/2)*$D$113","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Principal Repayments (in $000)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Short Term Debt Service",null,null,{"$f":"SUM(D117:D119)","v":0},{"$f":"SUM(E117:E119)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Outstanding Principal (End of Year)",null,null,{"$f":"D115+D116-D119","v":0},{"$f":"E115+E116-E119","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Subordinated Debt -- Assumptions and Schedule"]
["Name of Lender","Name"]
[]
[]
["Outstanding Principal (Start of Year)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D38,HistoricalData!D101)","v":0},{"$f":"D132","v":0},{"$f":"E132","v":0},{"$f":"F132","v":0},{"$f":"G132","v":0},{"$f":"H132","v":0},{"$f":"I132","v":0},{"$f":"J132","v":0},{"$f":"K132","v":0},{"$f":"L132","v":0},{"$f":"M132","v":0},{"$f":"N132","v":0},{"$f":"O132","v":0}]
["Principal Disbursements ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fees or Interest (if allowed) ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Principal Repayments ($000s)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Subordinated Debt Service",null,null,{"$f":"SUM(D129:D130)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Outstanding Principal (End of Year)",null,null,{"$f":"D127+D128-D130","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Equity and Reconciliation of Retained Earnings"]
[]
["Equity (Start of Year) in $000s",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D42:D43),SUM(HistoricalData!D105:D106))","v":0},{"$f":"D138","v":0},0,0,{"$f":"G138","v":0},{"$f":"H138","v":0},0,0,0,{"$f":"L138","v":0},{"$f":"M138","v":0},{"$f":"N138","v":0},{"$f":"O138","v":0}]
["New Equity Contributions in $000s",null,null,0]
["Equity (End of Year)",null,null,{"$f":"D136+D137","v":0},{"$f":"E136+E137","v":0},0,0,0,0,0,0,0,{"$f":"M136+M137","v":0},{"$f":"N136+N137","v":0},{"$f":"O136+O137","v":0},{"$f":"P136+P137","v":0}]
[]
["Retained Earnings (Start of Year)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D44,HistoricalData!D107)","v":0},{"$f":"D144","v":0},0,0,{"$f":"G144","v":0},{"$f":"H144","v":0},0,0,0,{"$f":"L144","v":0},{"$f":"M144","v":0},{"$f":"N144","v":0},{"$f":"O144","v":0}]
["Net Income",null,null,{"$f":"Income!F39","v":0},{"$f":"Income!H39","v":0},{"$f":"Income!J39","v":0},{"$f":"Income!L39","v":0},{"$f":"Income!N39","v":0},{"$f":"Income!P39","v":0},{"$f":"Income!R39","v":0},{"$f":"Income!T39","v":0},{"$f":"Income!V39","v":0},{"$f":"Income!X39","v":0},{"$f":"Income!Z39","v":0},{"$f":"Income!AB39","v":0},{"$f":"Income!AD39","v":0}]
["Dividend Payout Ratio (%)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Dividends Paid",null,null,{"$f":"IF(D141>0,D141*D142,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(O141>0,O141*O142,0)","v":0},{"$f":"IF(P141>0,P141*P142,0)","v":0}]
["Retained Earnings (End of Year)",null,null,{"$f":"D140+D141-D143","v":0},{"$f":"E140+E141-E143","v":0},0,0,0,0,0,0,0,{"$f":"M140+M141-M143","v":0},{"$f":"N140+N141-N143","v":0},{"$f":"O140+O141-O143","v":0},{"$f":"P140+P141-P143","v":0}]
[]
["Income Tax Assumptions"]
[]
["Tax Rate",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Depreciation/Amortization Assumptions"]
["Year Depreciation/Amortization Begins",null,null,2013]
[" ","Years",null," "]
["Pre-Existing Fixed Assets",0,null,{"$f":"IF(D1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(E1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(F1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(G1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(H1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(I1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(J1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(K1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(L1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(M1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(N1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(O1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0},{"$f":"IF(P1-$D$1<$B$154,IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!$D$19:$D$27)/$B$154,SUM(HistoricalData!$D$82:$D$90)/$B$154),0)","v":0}]
[{"$f":"A58","v":"Expense Line Item 1"},0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$155),SUM(C$58:$D58)/$B$155,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$155),SUM($D$58:D58)/$B$155,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$155),SUM($D$58:E58)/$B$155,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$155),SUM($D$58:F58)/$B$155,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$155),SUM($D$58:G58)/$B$155,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$155),SUM($D$58:H58)/$B$155,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$155),SUM($D$58:I58)/$B$155,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$155),SUM($D$58:J58)/$B$155,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$155),SUM($D$58:K58)/$B$155,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$155),SUM($D$58:L58)/$B$155,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$155),SUM($D$58:M58)/$B$155,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$155),SUM($D$58:N58)/$B$155,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$155),SUM($D$58:O58)/$B$155,0)","v":0}]
["Expense Line Item 2",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$156),SUM(C$59:$D59)/$B$156,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$156),SUM($D$59:D59)/$B$156,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$156),SUM($D$59:E59)/$B$156,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$156),SUM($D$59:F59)/$B$156,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$156),SUM($D$59:G59)/$B$156,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$156),SUM($D$59:H59)/$B$156,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$156),SUM($D$59:I59)/$B$156,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$156),SUM($D$59:J59)/$B$156,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$156),SUM($D$59:K59)/$B$156,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$156),SUM($D$59:L59)/$B$156,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$156),SUM($D$59:M59)/$B$156,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$156),SUM($D$59:N59)/$B$156,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$156),SUM($D$59:O59)/$B$156,0)","v":0}]
["Expense Line Item 3",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$157),SUM(C$60:$D60)/$B$157,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$157),SUM($D$60:D60)/$B$157,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$157),SUM($D$60:E60)/$B$157,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$157),SUM($D$60:F60)/$B$157,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$157),SUM($D$60:G60)/$B$157,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$157),SUM($D$60:H60)/$B$157,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$157),SUM($D$60:I60)/$B$157,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$157),SUM($D$60:J60)/$B$157,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$157),SUM($D$60:K60)/$B$157,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$157),SUM($D$60:L60)/$B$157,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$157),SUM($D$60:M60)/$B$157,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$157),SUM($D$60:N60)/$B$157,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$157),SUM($D$60:O60)/$B$157,0)","v":0}]
["Expense Line Item 4",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$158),SUM(C$61:$D61)/$B$158,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$158),SUM($D$61:D61)/$B$158,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$158),SUM($D$61:E61)/$B$158,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$158),SUM($D$61:F61)/$B$158,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$158),SUM($D$61:G61)/$B$158,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$158),SUM($D$61:H61)/$B$158,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$158),SUM($D$61:I61)/$B$158,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$158),SUM($D$61:J61)/$B$158,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$158),SUM($D$61:K61)/$B$158,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$158),SUM($D$61:L61)/$B$158,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$158),SUM($D$61:M61)/$B$158,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$158),SUM($D$61:N61)/$B$158,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$158),SUM($D$61:O61)/$B$158,0)","v":0}]
["Expense Line Item 5",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$159),SUM(C$62:$D62)/$B$159,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$159),SUM($D$62:D62)/$B$159,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$159),SUM($D$62:E62)/$B$159,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$159),SUM($D$62:F62)/$B$159,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$159),SUM($D$62:G62)/$B$159,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$159),SUM($D$62:H62)/$B$159,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$159),SUM($D$62:I62)/$B$159,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$159),SUM($D$62:J62)/$B$159,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$159),SUM($D$62:K62)/$B$159,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$159),SUM($D$62:L62)/$B$159,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$159),SUM($D$62:M62)/$B$159,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$159),SUM($D$62:N62)/$B$159,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$159),SUM($D$62:O62)/$B$159,0)","v":0}]
["Expense Line Item 6",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$160),SUM(C$63:$D63)/$B$160,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$160),SUM($D$63:D63)/$B$160,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$160),SUM($D$63:E63)/$B$160,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$160),SUM($D$63:F63)/$B$160,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$160),SUM($D$63:G63)/$B$160,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$160),SUM($D$63:H63)/$B$160,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$160),SUM($D$63:I63)/$B$160,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$160),SUM($D$63:J63)/$B$160,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$160),SUM($D$63:K63)/$B$160,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$160),SUM($D$63:L63)/$B$160,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$160),SUM($D$63:M63)/$B$160,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$160),SUM($D$63:N63)/$B$160,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$160),SUM($D$63:O63)/$B$160,0)","v":0}]
["Expense Line Item 7",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$161),SUM(C$64:$D64)/$B$161,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$161),SUM($D$64:D64)/$B$161,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$161),SUM($D$64:E64)/$B$161,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$161),SUM($D$64:F64)/$B$161,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$161),SUM($D$64:G64)/$B$161,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$161),SUM($D$64:H64)/$B$161,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$161),SUM($D$64:I64)/$B$161,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$161),SUM($D$64:J64)/$B$161,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$161),SUM($D$64:K64)/$B$161,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$161),SUM($D$64:L64)/$B$161,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$161),SUM($D$64:M64)/$B$161,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$161),SUM($D$64:N64)/$B$161,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$161),SUM($D$64:O64)/$B$161,0)","v":0}]
["Expense Line Item 8",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$162),SUM(C$65:$D65)/$B$162,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$162),SUM($D$65:D65)/$B$162,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$162),SUM($D$65:E65)/$B$162,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$162),SUM($D$65:F65)/$B$162,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$162),SUM($D$65:G65)/$B$162,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$162),SUM($D$65:H65)/$B$162,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$162),SUM($D$65:I65)/$B$162,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$162),SUM($D$65:J65)/$B$162,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$162),SUM($D$65:K65)/$B$162,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$162),SUM($D$65:L65)/$B$162,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$162),SUM($D$65:M65)/$B$162,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$162),SUM($D$65:N65)/$B$162,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$162),SUM($D$65:O65)/$B$162,0)","v":0}]
["Expense Line Item 9",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$163),SUM(C$66:$D66)/$B$163,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$163),SUM($D$66:D66)/$B$163,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$163),SUM($D$66:E66)/$B$163,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$163),SUM($D$66:F66)/$B$163,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$163),SUM($D$66:G66)/$B$163,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$163),SUM($D$66:H66)/$B$163,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$163),SUM($D$66:I66)/$B$163,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$163),SUM($D$66:J66)/$B$163,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$163),SUM($D$66:K66)/$B$163,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$163),SUM($D$66:L66)/$B$163,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$163),SUM($D$66:M66)/$B$163,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$163),SUM($D$66:N66)/$B$163,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$163),SUM($D$66:O66)/$B$163,0)","v":0}]
["Expense Line Item 10",0,null,{"$f":"IF(AND(D1>=$D$152,(D1-$D$152)<$B$164),SUM(C$67:$D67)/$B$164,0)","v":0},{"$f":"IF(AND(E1>=$D$152,(E1-$D$152)<$B$164),SUM($D$67:D67)/$B$164,0)","v":0},{"$f":"IF(AND(F1>=$D$152,(F1-$D$152)<$B$164),SUM($D$67:E67)/$B$164,0)","v":0},{"$f":"IF(AND(G1>=$D$152,(G1-$D$152)<$B$164),SUM($D$67:F67)/$B$164,0)","v":0},{"$f":"IF(AND(H1>=$D$152,(H1-$D$152)<$B$164),SUM($D$67:G67)/$B$164,0)","v":0},{"$f":"IF(AND(I1>=$D$152,(I1-$D$152)<$B$164),SUM($D$67:H67)/$B$164,0)","v":0},{"$f":"IF(AND(J1>=$D$152,(J1-$D$152)<$B$164),SUM($D$67:I67)/$B$164,0)","v":0},{"$f":"IF(AND(K1>=$D$152,(K1-$D$152)<$B$164),SUM($D$67:J67)/$B$164,0)","v":0},{"$f":"IF(AND(L1>=$D$152,(L1-$D$152)<$B$164),SUM($D$67:K67)/$B$164,0)","v":0},{"$f":"IF(AND(M1>=$D$152,(M1-$D$152)<$B$164),SUM($D$67:L67)/$B$164,0)","v":0},{"$f":"IF(AND(N1>=$D$152,(N1-$D$152)<$B$164),SUM($D$67:M67)/$B$164,0)","v":0},{"$f":"IF(AND(O1>=$D$152,(O1-$D$152)<$B$164),SUM($D$67:N67)/$B$164,0)","v":0},{"$f":"IF(AND(P1>=$D$152,(P1-$D$152)<$B$164),SUM($D$67:O67)/$B$164,0)","v":0}]
["Total Annual Depreciation Exp.",null,null,{"$f":"SUM(D154:D164)","v":0},{"$f":"SUM(E154:E164)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Working Capital and Debt Service Reserve Assumptions"]
["Days in Receivables",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Days Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Days in Payables",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Months Debt Service to Restricted Cash",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cost of Capital (for Net Present Value Calculation Purposes)"]
["Amount of DFC Debt",{"$f":"D73","v":0},{"$f":"B174/B177","v":{"$error":"#DIV/0!"}}]
["Amount of other Senior Debt",{"$f":"SUM(D104:P104)","v":0},{"$f":"B175/B177","v":{"$error":"#DIV/0!"}}]
["Amount of Sub-Debt/Equity",{"$f":"SUM(D137:P137)+SUM(D128:P128)","v":0},{"$f":"B176/B177","v":{"$error":"#DIV/0!"}}]
["Total Project Capitalization",{"$f":"SUM(B174:B176)","v":0},{"$f":"SUM(C174:C176)","v":{"$error":"#DIV/0!"}}]
[]
["Cost of Debt",{"$f":"(((B174)/(B174+B175))*D76)+(((B175)/(B174+B175))*D101)","v":{"$error":"#DIV/0!"}}]
["Cost of Equity",0.2]
["Weighted Average Cost of Capital",{"$f":"C174*B179+C176*B180","v":{"$error":"#DIV/0!"}}]

{"sheet":"Mortgage-StyleDetail","index":3,"n_rows":182,"n_cols":10,"rows_kept":182,"cut":false,"hidden":true,"merged":[]}
["Assumptions",null,null," ","Payment Date","Year","Mortgage Payment","Interest Portion","Principal Portion","Principal Balance"]
["Disbursement Amount",null,{"$f":"Assumptions!D73","v":0},null,{"$f":"C4","v":"2022-09-15"},{"$f":"YEAR(E2)","v":2022},{"$f":"IF(OR(E2<$C$5,E2>$C$6),0,-PMT($C$8/$C$7,$C$9,$C$2))","v":0},{"$f":"YEARFRAC(C3,E2)*C2*C8","v":0},{"$f":"IF($C$5>E2,0,G2-H2)","v":0},{"$f":"$C$2-I2","v":0}]
["Disbursement Date",null,{"$f":"Assumptions!D82","v":"2022-06-15"},null,{"$f":"IF($C$7=12,EDATE(E2,1),IF($C$7=4,EDATE(E2,3),IF($C$7=2,EDATE(E2,6),0)))","v":"2022-12-15"},{"$f":"YEAR(E3)","v":2022},{"$f":"IF(OR(E3<$C$5,E3>$C$6),0,-PMT($C$8/$C$7,$C$9,$C$2))","v":0},{"$f":"IF(OR(E3<$C$5,E3>$C$6),YEARFRAC(E2,E3)*J2*$C$8,($C$2-SUM($I$1:I2))*($C$8/$C$7))","v":0},{"$f":"IF($C$5>E3,0,G3-H3)","v":0},{"$f":"J2-I3","v":0}]
["First Int Payment Date",null,{"$f":"EDATE(C3,12/C7)","v":"2022-09-15"},null,"2023-03-15",2023,0,{"$f":"IF(OR(E4<$C$5,E4>$C$6),YEARFRAC(E3,E4)*J3*$C$8,($C$2-SUM($I$1:I3))*($C$8/$C$7))","v":0},0,{"$f":"J3-I4","v":0}]
["First Principal Payment Date",null,{"$f":"Assumptions!D83","v":"2023-06-15"},null,"2023-06-15",2023,0,{"$f":"IF(OR(E5<$C$5,E5>$C$6),YEARFRAC(E4,E5)*J4*$C$8,($C$2-SUM($I$1:I4))*($C$8/$C$7))","v":0},0,0]
["Maturity Date",null,{"$f":"Assumptions!D84","v":"2032-06-15"},null,"2023-09-15",2023,0,{"$f":"IF(OR(E6<$C$5,E6>$C$6),YEARFRAC(E5,E6)*J5*$C$8,($C$2-SUM($I$1:I5))*($C$8/$C$7))","v":0},0,0]
["Number of Payments per Year",null,{"$f":"Assumptions!D81","v":4},null,"2023-12-15",2023,0,{"$f":"IF(OR(E7<$C$5,E7>$C$6),YEARFRAC(E6,E7)*J6*$C$8,($C$2-SUM($I$1:I6))*($C$8/$C$7))","v":0},0,0]
["Estimated Annual Interest Rate",null,{"$f":"Assumptions!D76","v":6.5000000000000002E-2},null,"2024-03-15",2024,0,{"$f":"IF(OR(E8<$C$5,E8>$C$6),YEARFRAC(E7,E8)*J7*$C$8,($C$2-SUM($I$1:I7))*($C$8/$C$7))","v":0},0,0]
["# of Principal Payments",null,{"$f":"Assumptions!D85","v":37},null,"2024-06-15",2024,0,{"$f":"IF(OR(E9<$C$5,E9>$C$6),YEARFRAC(E8,E9)*J8*$C$8,($C$2-SUM($I$1:I8))*($C$8/$C$7))","v":0},0,0]
[" ",null," ",null,"2024-09-15",2024,0,{"$f":"IF(OR(E10<$C$5,E10>$C$6),YEARFRAC(E9,E10)*J9*$C$8,($C$2-SUM($I$1:I9))*($C$8/$C$7))","v":0},0,0]
[null,null," ",null,"2024-12-15",2024,0,{"$f":"IF(OR(E11<$C$5,E11>$C$6),YEARFRAC(E10,E11)*J10*$C$8,($C$2-SUM($I$1:I10))*($C$8/$C$7))","v":0},0,0]
["Summary","Principal","Interest",null,"2025-03-15",2025,0,{"$f":"IF(OR(E12<$C$5,E12>$C$6),YEARFRAC(E11,E12)*J11*$C$8,($C$2-SUM($I$1:I11))*($C$8/$C$7))","v":0},0,0]
[{"$f":"F2","v":2022},{"$f":"SUMIF($F$2:$F$182,A13,$I$2:$I$182)","v":0},{"$f":"SUMIF($F$2:$F$182,A13,$H$2:$H$182)","v":0},null,"2025-06-15",2025,0,{"$f":"IF(OR(E13<$C$5,E13>$C$6),YEARFRAC(E12,E13)*J12*$C$8,($C$2-SUM($I$1:I12))*($C$8/$C$7))","v":0},0,0]
[{"$f":"A13+1","v":2023},{"$f":"SUMIF($F$2:$F$182,A14,$I$2:$I$182)","v":0},{"$f":"SUMIF($F$2:$F$182,A14,$H$2:$H$182)","v":0},null,"2025-09-15",2025,0,{"$f":"IF(OR(E14<$C$5,E14>$C$6),YEARFRAC(E13,E14)*J13*$C$8,($C$2-SUM($I$1:I13))*($C$8/$C$7))","v":0},0,0]
[{"$f":"A14+1","v":2024},0,0,null,"2025-12-15",2025,0,{"$f":"IF(OR(E15<$C$5,E15>$C$6),YEARFRAC(E14,E15)*J14*$C$8,($C$2-SUM($I$1:I14))*($C$8/$C$7))","v":0},0,0]
[2025,0,0,null,"2026-03-15",2026,0,{"$f":"IF(OR(E16<$C$5,E16>$C$6),YEARFRAC(E15,E16)*J15*$C$8,($C$2-SUM($I$1:I15))*($C$8/$C$7))","v":0},0,0]
[2026,0,0,null,"2026-06-15",2026,0,{"$f":"IF(OR(E17<$C$5,E17>$C$6),YEARFRAC(E16,E17)*J16*$C$8,($C$2-SUM($I$1:I16))*($C$8/$C$7))","v":0},0,0]
[2027,0,0,null,"2026-09-15",2026,0,{"$f":"IF(OR(E18<$C$5,E18>$C$6),YEARFRAC(E17,E18)*J17*$C$8,($C$2-SUM($I$1:I17))*($C$8/$C$7))","v":0},0,0]
[2028,0,0,null,"2026-12-15",2026,0,{"$f":"IF(OR(E19<$C$5,E19>$C$6),YEARFRAC(E18,E19)*J18*$C$8,($C$2-SUM($I$1:I18))*($C$8/$C$7))","v":0},0,0]
[2029,0,0,null,"2027-03-15",2027,0,{"$f":"IF(OR(E20<$C$5,E20>$C$6),YEARFRAC(E19,E20)*J19*$C$8,($C$2-SUM($I$1:I19))*($C$8/$C$7))","v":0},0,0]
[2030,0,0,null,"2027-06-15",2027,0,{"$f":"IF(OR(E21<$C$5,E21>$C$6),YEARFRAC(E20,E21)*J20*$C$8,($C$2-SUM($I$1:I20))*($C$8/$C$7))","v":0},0,0]
[2031,0,0,null,"2027-09-15",2027,0,{"$f":"IF(OR(E22<$C$5,E22>$C$6),YEARFRAC(E21,E22)*J21*$C$8,($C$2-SUM($I$1:I21))*($C$8/$C$7))","v":0},0,0]
[2032,0,0,null,"2027-12-15",2027,0,{"$f":"IF(OR(E23<$C$5,E23>$C$6),YEARFRAC(E22,E23)*J22*$C$8,($C$2-SUM($I$1:I22))*($C$8/$C$7))","v":0},0,0]
[2033,0,0,null,"2028-03-15",2028,0,{"$f":"IF(OR(E24<$C$5,E24>$C$6),YEARFRAC(E23,E24)*J23*$C$8,($C$2-SUM($I$1:I23))*($C$8/$C$7))","v":0},0,0]
[2034,0,0,null,"2028-06-15",2028,0,{"$f":"IF(OR(E25<$C$5,E25>$C$6),YEARFRAC(E24,E25)*J24*$C$8,($C$2-SUM($I$1:I24))*($C$8/$C$7))","v":0},0,0]
[2035,0,0,null,"2028-09-15",2028,0,{"$f":"IF(OR(E26<$C$5,E26>$C$6),YEARFRAC(E25,E26)*J25*$C$8,($C$2-SUM($I$1:I25))*($C$8/$C$7))","v":0},0,0]
[2036,0,0,null,"2028-12-15",2028,0,{"$f":"IF(OR(E27<$C$5,E27>$C$6),YEARFRAC(E26,E27)*J26*$C$8,($C$2-SUM($I$1:I26))*($C$8/$C$7))","v":0},0,0]
[2037,0,0,null,"2029-03-15",2029,0,{"$f":"IF(OR(E28<$C$5,E28>$C$6),YEARFRAC(E27,E28)*J27*$C$8,($C$2-SUM($I$1:I27))*($C$8/$C$7))","v":0},0,0]
["Total",{"$f":"SUM(B13:B28)","v":0},{"$f":"SUM(C13:C28)","v":0},null,"2029-06-15",2029,0,{"$f":"IF(OR(E29<$C$5,E29>$C$6),YEARFRAC(E28,E29)*J28*$C$8,($C$2-SUM($I$1:I28))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2029-09-15",2029,0,{"$f":"IF(OR(E30<$C$5,E30>$C$6),YEARFRAC(E29,E30)*J29*$C$8,($C$2-SUM($I$1:I29))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2029-12-15",2029,0,{"$f":"IF(OR(E31<$C$5,E31>$C$6),YEARFRAC(E30,E31)*J30*$C$8,($C$2-SUM($I$1:I30))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2030-03-15",2030,0,{"$f":"IF(OR(E32<$C$5,E32>$C$6),YEARFRAC(E31,E32)*J31*$C$8,($C$2-SUM($I$1:I31))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2030-06-15",2030,0,{"$f":"IF(OR(E33<$C$5,E33>$C$6),YEARFRAC(E32,E33)*J32*$C$8,($C$2-SUM($I$1:I32))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2030-09-15",2030,0,{"$f":"IF(OR(E34<$C$5,E34>$C$6),YEARFRAC(E33,E34)*J33*$C$8,($C$2-SUM($I$1:I33))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2030-12-15",2030,0,{"$f":"IF(OR(E35<$C$5,E35>$C$6),YEARFRAC(E34,E35)*J34*$C$8,($C$2-SUM($I$1:I34))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2031-03-15",2031,0,{"$f":"IF(OR(E36<$C$5,E36>$C$6),YEARFRAC(E35,E36)*J35*$C$8,($C$2-SUM($I$1:I35))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2031-06-15",2031,0,{"$f":"IF(OR(E37<$C$5,E37>$C$6),YEARFRAC(E36,E37)*J36*$C$8,($C$2-SUM($I$1:I36))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2031-09-15",2031,0,{"$f":"IF(OR(E38<$C$5,E38>$C$6),YEARFRAC(E37,E38)*J37*$C$8,($C$2-SUM($I$1:I37))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2031-12-15",2031,0,{"$f":"IF(OR(E39<$C$5,E39>$C$6),YEARFRAC(E38,E39)*J38*$C$8,($C$2-SUM($I$1:I38))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2032-03-15",2032,0,{"$f":"IF(OR(E40<$C$5,E40>$C$6),YEARFRAC(E39,E40)*J39*$C$8,($C$2-SUM($I$1:I39))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2032-06-15",2032,0,{"$f":"IF(OR(E41<$C$5,E41>$C$6),YEARFRAC(E40,E41)*J40*$C$8,($C$2-SUM($I$1:I40))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2032-09-15",2032,0,{"$f":"IF(OR(E42<$C$5,E42>$C$6),YEARFRAC(E41,E42)*J41*$C$8,($C$2-SUM($I$1:I41))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2032-12-15",2032,0,{"$f":"IF(OR(E43<$C$5,E43>$C$6),YEARFRAC(E42,E43)*J42*$C$8,($C$2-SUM($I$1:I42))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2033-03-15",2033,0,{"$f":"IF(OR(E44<$C$5,E44>$C$6),YEARFRAC(E43,E44)*J43*$C$8,($C$2-SUM($I$1:I43))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2033-06-15",2033,0,{"$f":"IF(OR(E45<$C$5,E45>$C$6),YEARFRAC(E44,E45)*J44*$C$8,($C$2-SUM($I$1:I44))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2033-09-15",2033,0,{"$f":"IF(OR(E46<$C$5,E46>$C$6),YEARFRAC(E45,E46)*J45*$C$8,($C$2-SUM($I$1:I45))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2033-12-15",2033,0,{"$f":"IF(OR(E47<$C$5,E47>$C$6),YEARFRAC(E46,E47)*J46*$C$8,($C$2-SUM($I$1:I46))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2034-03-15",2034,0,{"$f":"IF(OR(E48<$C$5,E48>$C$6),YEARFRAC(E47,E48)*J47*$C$8,($C$2-SUM($I$1:I47))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2034-06-15",2034,0,{"$f":"IF(OR(E49<$C$5,E49>$C$6),YEARFRAC(E48,E49)*J48*$C$8,($C$2-SUM($I$1:I48))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2034-09-15",2034,0,{"$f":"IF(OR(E50<$C$5,E50>$C$6),YEARFRAC(E49,E50)*J49*$C$8,($C$2-SUM($I$1:I49))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2034-12-15",2034,0,{"$f":"IF(OR(E51<$C$5,E51>$C$6),YEARFRAC(E50,E51)*J50*$C$8,($C$2-SUM($I$1:I50))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2035-03-15",2035,0,{"$f":"IF(OR(E52<$C$5,E52>$C$6),YEARFRAC(E51,E52)*J51*$C$8,($C$2-SUM($I$1:I51))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2035-06-15",2035,0,{"$f":"IF(OR(E53<$C$5,E53>$C$6),YEARFRAC(E52,E53)*J52*$C$8,($C$2-SUM($I$1:I52))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2035-09-15",2035,0,{"$f":"IF(OR(E54<$C$5,E54>$C$6),YEARFRAC(E53,E54)*J53*$C$8,($C$2-SUM($I$1:I53))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2035-12-15",2035,0,{"$f":"IF(OR(E55<$C$5,E55>$C$6),YEARFRAC(E54,E55)*J54*$C$8,($C$2-SUM($I$1:I54))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2036-03-15",2036,0,{"$f":"IF(OR(E56<$C$5,E56>$C$6),YEARFRAC(E55,E56)*J55*$C$8,($C$2-SUM($I$1:I55))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2036-06-15",2036,0,{"$f":"IF(OR(E57<$C$5,E57>$C$6),YEARFRAC(E56,E57)*J56*$C$8,($C$2-SUM($I$1:I56))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2036-09-15",2036,0,{"$f":"IF(OR(E58<$C$5,E58>$C$6),YEARFRAC(E57,E58)*J57*$C$8,($C$2-SUM($I$1:I57))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2036-12-15",2036,0,{"$f":"IF(OR(E59<$C$5,E59>$C$6),YEARFRAC(E58,E59)*J58*$C$8,($C$2-SUM($I$1:I58))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2037-03-15",2037,0,{"$f":"IF(OR(E60<$C$5,E60>$C$6),YEARFRAC(E59,E60)*J59*$C$8,($C$2-SUM($I$1:I59))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2037-06-15",2037,0,{"$f":"IF(OR(E61<$C$5,E61>$C$6),YEARFRAC(E60,E61)*J60*$C$8,($C$2-SUM($I$1:I60))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2037-09-15",2037,0,{"$f":"IF(OR(E62<$C$5,E62>$C$6),YEARFRAC(E61,E62)*J61*$C$8,($C$2-SUM($I$1:I61))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2037-12-15",2037,0,{"$f":"IF(OR(E63<$C$5,E63>$C$6),YEARFRAC(E62,E63)*J62*$C$8,($C$2-SUM($I$1:I62))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2038-03-15",2038,0,{"$f":"IF(OR(E64<$C$5,E64>$C$6),YEARFRAC(E63,E64)*J63*$C$8,($C$2-SUM($I$1:I63))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2038-06-15",2038,0,{"$f":"IF(OR(E65<$C$5,E65>$C$6),YEARFRAC(E64,E65)*J64*$C$8,($C$2-SUM($I$1:I64))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2038-09-15",2038,0,{"$f":"IF(OR(E66<$C$5,E66>$C$6),YEARFRAC(E65,E66)*J65*$C$8,($C$2-SUM($I$1:I65))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,{"$f":"IF($C$7=12,EDATE(E66,1),IF($C$7=4,EDATE(E66,3),IF($C$7=2,EDATE(E66,6),0)))","v":"2038-12-15"},{"$f":"YEAR(E67)","v":2038},{"$f":"IF(OR(E67<$C$5,E67>$C$6),0,-PMT($C$8/$C$7,$C$9,$C$2))","v":0},{"$f":"IF(OR(E67<$C$5,E67>$C$6),YEARFRAC(E66,E67)*J66*$C$8,($C$2-SUM($I$1:I66))*($C$8/$C$7))","v":0},{"$f":"IF($C$5>E67,0,G67-H67)","v":0},0]
[null,null,null,null,"2039-03-15",2039,0,{"$f":"IF(OR(E68<$C$5,E68>$C$6),YEARFRAC(E67,E68)*J67*$C$8,($C$2-SUM($I$1:I67))*($C$8/$C$7))","v":0},0,{"$f":"J67-I68","v":0}]
[null,null,null,null,"2039-06-15",2039,0,{"$f":"IF(OR(E69<$C$5,E69>$C$6),YEARFRAC(E68,E69)*J68*$C$8,($C$2-SUM($I$1:I68))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2039-09-15",2039,0,{"$f":"IF(OR(E70<$C$5,E70>$C$6),YEARFRAC(E69,E70)*J69*$C$8,($C$2-SUM($I$1:I69))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2039-12-15",2039,0,{"$f":"IF(OR(E71<$C$5,E71>$C$6),YEARFRAC(E70,E71)*J70*$C$8,($C$2-SUM($I$1:I70))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2040-03-15",2040,0,{"$f":"IF(OR(E72<$C$5,E72>$C$6),YEARFRAC(E71,E72)*J71*$C$8,($C$2-SUM($I$1:I71))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2040-06-15",2040,0,{"$f":"IF(OR(E73<$C$5,E73>$C$6),YEARFRAC(E72,E73)*J72*$C$8,($C$2-SUM($I$1:I72))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2040-09-15",2040,0,{"$f":"IF(OR(E74<$C$5,E74>$C$6),YEARFRAC(E73,E74)*J73*$C$8,($C$2-SUM($I$1:I73))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2040-12-15",2040,0,{"$f":"IF(OR(E75<$C$5,E75>$C$6),YEARFRAC(E74,E75)*J74*$C$8,($C$2-SUM($I$1:I74))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2041-03-15",2041,0,{"$f":"IF(OR(E76<$C$5,E76>$C$6),YEARFRAC(E75,E76)*J75*$C$8,($C$2-SUM($I$1:I75))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2041-06-15",2041,0,{"$f":"IF(OR(E77<$C$5,E77>$C$6),YEARFRAC(E76,E77)*J76*$C$8,($C$2-SUM($I$1:I76))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2041-09-15",2041,0,{"$f":"IF(OR(E78<$C$5,E78>$C$6),YEARFRAC(E77,E78)*J77*$C$8,($C$2-SUM($I$1:I77))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2041-12-15",2041,0,{"$f":"IF(OR(E79<$C$5,E79>$C$6),YEARFRAC(E78,E79)*J78*$C$8,($C$2-SUM($I$1:I78))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2042-03-15",2042,0,{"$f":"IF(OR(E80<$C$5,E80>$C$6),YEARFRAC(E79,E80)*J79*$C$8,($C$2-SUM($I$1:I79))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2042-06-15",2042,0,{"$f":"IF(OR(E81<$C$5,E81>$C$6),YEARFRAC(E80,E81)*J80*$C$8,($C$2-SUM($I$1:I80))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2042-09-15",2042,0,{"$f":"IF(OR(E82<$C$5,E82>$C$6),YEARFRAC(E81,E82)*J81*$C$8,($C$2-SUM($I$1:I81))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2042-12-15",2042,0,{"$f":"IF(OR(E83<$C$5,E83>$C$6),YEARFRAC(E82,E83)*J82*$C$8,($C$2-SUM($I$1:I82))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2043-03-15",2043,0,{"$f":"IF(OR(E84<$C$5,E84>$C$6),YEARFRAC(E83,E84)*J83*$C$8,($C$2-SUM($I$1:I83))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2043-06-15",2043,0,{"$f":"IF(OR(E85<$C$5,E85>$C$6),YEARFRAC(E84,E85)*J84*$C$8,($C$2-SUM($I$1:I84))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2043-09-15",2043,0,{"$f":"IF(OR(E86<$C$5,E86>$C$6),YEARFRAC(E85,E86)*J85*$C$8,($C$2-SUM($I$1:I85))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2043-12-15",2043,0,{"$f":"IF(OR(E87<$C$5,E87>$C$6),YEARFRAC(E86,E87)*J86*$C$8,($C$2-SUM($I$1:I86))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2044-03-15",2044,0,{"$f":"IF(OR(E88<$C$5,E88>$C$6),YEARFRAC(E87,E88)*J87*$C$8,($C$2-SUM($I$1:I87))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2044-06-15",2044,0,{"$f":"IF(OR(E89<$C$5,E89>$C$6),YEARFRAC(E88,E89)*J88*$C$8,($C$2-SUM($I$1:I88))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2044-09-15",2044,0,{"$f":"IF(OR(E90<$C$5,E90>$C$6),YEARFRAC(E89,E90)*J89*$C$8,($C$2-SUM($I$1:I89))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2044-12-15",2044,0,{"$f":"IF(OR(E91<$C$5,E91>$C$6),YEARFRAC(E90,E91)*J90*$C$8,($C$2-SUM($I$1:I90))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2045-03-15",2045,0,{"$f":"IF(OR(E92<$C$5,E92>$C$6),YEARFRAC(E91,E92)*J91*$C$8,($C$2-SUM($I$1:I91))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2045-06-15",2045,0,{"$f":"IF(OR(E93<$C$5,E93>$C$6),YEARFRAC(E92,E93)*J92*$C$8,($C$2-SUM($I$1:I92))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2045-09-15",2045,0,{"$f":"IF(OR(E94<$C$5,E94>$C$6),YEARFRAC(E93,E94)*J93*$C$8,($C$2-SUM($I$1:I93))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2045-12-15",2045,0,{"$f":"IF(OR(E95<$C$5,E95>$C$6),YEARFRAC(E94,E95)*J94*$C$8,($C$2-SUM($I$1:I94))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2046-03-15",2046,0,{"$f":"IF(OR(E96<$C$5,E96>$C$6),YEARFRAC(E95,E96)*J95*$C$8,($C$2-SUM($I$1:I95))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2046-06-15",2046,0,{"$f":"IF(OR(E97<$C$5,E97>$C$6),YEARFRAC(E96,E97)*J96*$C$8,($C$2-SUM($I$1:I96))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2046-09-15",2046,0,{"$f":"IF(OR(E98<$C$5,E98>$C$6),YEARFRAC(E97,E98)*J97*$C$8,($C$2-SUM($I$1:I97))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2046-12-15",2046,0,{"$f":"IF(OR(E99<$C$5,E99>$C$6),YEARFRAC(E98,E99)*J98*$C$8,($C$2-SUM($I$1:I98))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2047-03-15",2047,0,{"$f":"IF(OR(E100<$C$5,E100>$C$6),YEARFRAC(E99,E100)*J99*$C$8,($C$2-SUM($I$1:I99))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2047-06-15",2047,0,{"$f":"IF(OR(E101<$C$5,E101>$C$6),YEARFRAC(E100,E101)*J100*$C$8,($C$2-SUM($I$1:I100))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2047-09-15",2047,0,{"$f":"IF(OR(E102<$C$5,E102>$C$6),YEARFRAC(E101,E102)*J101*$C$8,($C$2-SUM($I$1:I101))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2047-12-15",2047,0,{"$f":"IF(OR(E103<$C$5,E103>$C$6),YEARFRAC(E102,E103)*J102*$C$8,($C$2-SUM($I$1:I102))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2048-03-15",2048,0,{"$f":"IF(OR(E104<$C$5,E104>$C$6),YEARFRAC(E103,E104)*J103*$C$8,($C$2-SUM($I$1:I103))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2048-06-15",2048,0,{"$f":"IF(OR(E105<$C$5,E105>$C$6),YEARFRAC(E104,E105)*J104*$C$8,($C$2-SUM($I$1:I104))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2048-09-15",2048,0,{"$f":"IF(OR(E106<$C$5,E106>$C$6),YEARFRAC(E105,E106)*J105*$C$8,($C$2-SUM($I$1:I105))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2048-12-15",2048,0,{"$f":"IF(OR(E107<$C$5,E107>$C$6),YEARFRAC(E106,E107)*J106*$C$8,($C$2-SUM($I$1:I106))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2049-03-15",2049,0,{"$f":"IF(OR(E108<$C$5,E108>$C$6),YEARFRAC(E107,E108)*J107*$C$8,($C$2-SUM($I$1:I107))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2049-06-15",2049,0,{"$f":"IF(OR(E109<$C$5,E109>$C$6),YEARFRAC(E108,E109)*J108*$C$8,($C$2-SUM($I$1:I108))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2049-09-15",2049,0,{"$f":"IF(OR(E110<$C$5,E110>$C$6),YEARFRAC(E109,E110)*J109*$C$8,($C$2-SUM($I$1:I109))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2049-12-15",2049,0,{"$f":"IF(OR(E111<$C$5,E111>$C$6),YEARFRAC(E110,E111)*J110*$C$8,($C$2-SUM($I$1:I110))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2050-03-15",2050,0,{"$f":"IF(OR(E112<$C$5,E112>$C$6),YEARFRAC(E111,E112)*J111*$C$8,($C$2-SUM($I$1:I111))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2050-06-15",2050,0,{"$f":"IF(OR(E113<$C$5,E113>$C$6),YEARFRAC(E112,E113)*J112*$C$8,($C$2-SUM($I$1:I112))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2050-09-15",2050,0,{"$f":"IF(OR(E114<$C$5,E114>$C$6),YEARFRAC(E113,E114)*J113*$C$8,($C$2-SUM($I$1:I113))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2050-12-15",2050,0,{"$f":"IF(OR(E115<$C$5,E115>$C$6),YEARFRAC(E114,E115)*J114*$C$8,($C$2-SUM($I$1:I114))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2051-03-15",2051,0,{"$f":"IF(OR(E116<$C$5,E116>$C$6),YEARFRAC(E115,E116)*J115*$C$8,($C$2-SUM($I$1:I115))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2051-06-15",2051,0,{"$f":"IF(OR(E117<$C$5,E117>$C$6),YEARFRAC(E116,E117)*J116*$C$8,($C$2-SUM($I$1:I116))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2051-09-15",2051,0,{"$f":"IF(OR(E118<$C$5,E118>$C$6),YEARFRAC(E117,E118)*J117*$C$8,($C$2-SUM($I$1:I117))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2051-12-15",2051,0,{"$f":"IF(OR(E119<$C$5,E119>$C$6),YEARFRAC(E118,E119)*J118*$C$8,($C$2-SUM($I$1:I118))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2052-03-15",2052,0,{"$f":"IF(OR(E120<$C$5,E120>$C$6),YEARFRAC(E119,E120)*J119*$C$8,($C$2-SUM($I$1:I119))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2052-06-15",2052,0,{"$f":"IF(OR(E121<$C$5,E121>$C$6),YEARFRAC(E120,E121)*J120*$C$8,($C$2-SUM($I$1:I120))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2052-09-15",2052,0,{"$f":"IF(OR(E122<$C$5,E122>$C$6),YEARFRAC(E121,E122)*J121*$C$8,($C$2-SUM($I$1:I121))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2052-12-15",2052,0,{"$f":"IF(OR(E123<$C$5,E123>$C$6),YEARFRAC(E122,E123)*J122*$C$8,($C$2-SUM($I$1:I122))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2053-03-15",2053,0,{"$f":"IF(OR(E124<$C$5,E124>$C$6),YEARFRAC(E123,E124)*J123*$C$8,($C$2-SUM($I$1:I123))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2053-06-15",2053,0,{"$f":"IF(OR(E125<$C$5,E125>$C$6),YEARFRAC(E124,E125)*J124*$C$8,($C$2-SUM($I$1:I124))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2053-09-15",2053,0,{"$f":"IF(OR(E126<$C$5,E126>$C$6),YEARFRAC(E125,E126)*J125*$C$8,($C$2-SUM($I$1:I125))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2053-12-15",2053,0,{"$f":"IF(OR(E127<$C$5,E127>$C$6),YEARFRAC(E126,E127)*J126*$C$8,($C$2-SUM($I$1:I126))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2054-03-15",2054,0,{"$f":"IF(OR(E128<$C$5,E128>$C$6),YEARFRAC(E127,E128)*J127*$C$8,($C$2-SUM($I$1:I127))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2054-06-15",2054,0,{"$f":"IF(OR(E129<$C$5,E129>$C$6),YEARFRAC(E128,E129)*J128*$C$8,($C$2-SUM($I$1:I128))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2054-09-15",2054,0,{"$f":"IF(OR(E130<$C$5,E130>$C$6),YEARFRAC(E129,E130)*J129*$C$8,($C$2-SUM($I$1:I129))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,{"$f":"IF($C$7=12,EDATE(E130,1),IF($C$7=4,EDATE(E130,3),IF($C$7=2,EDATE(E130,6),0)))","v":"2054-12-15"},{"$f":"YEAR(E131)","v":2054},{"$f":"IF(OR(E131<$C$5,E131>$C$6),0,-PMT($C$8/$C$7,$C$9,$C$2))","v":0},{"$f":"IF(OR(E131<$C$5,E131>$C$6),YEARFRAC(E130,E131)*J130*$C$8,($C$2-SUM($I$1:I130))*($C$8/$C$7))","v":0},{"$f":"IF($C$5>E131,0,G131-H131)","v":0},0]
[null,null,null,null,"2055-03-15",2055,0,{"$f":"IF(OR(E132<$C$5,E132>$C$6),YEARFRAC(E131,E132)*J131*$C$8,($C$2-SUM($I$1:I131))*($C$8/$C$7))","v":0},0,{"$f":"J131-I132","v":0}]
[null,null,null,null,"2055-06-15",2055,0,{"$f":"IF(OR(E133<$C$5,E133>$C$6),YEARFRAC(E132,E133)*J132*$C$8,($C$2-SUM($I$1:I132))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2055-09-15",2055,0,{"$f":"IF(OR(E134<$C$5,E134>$C$6),YEARFRAC(E133,E134)*J133*$C$8,($C$2-SUM($I$1:I133))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2055-12-15",2055,0,{"$f":"IF(OR(E135<$C$5,E135>$C$6),YEARFRAC(E134,E135)*J134*$C$8,($C$2-SUM($I$1:I134))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2056-03-15",2056,0,{"$f":"IF(OR(E136<$C$5,E136>$C$6),YEARFRAC(E135,E136)*J135*$C$8,($C$2-SUM($I$1:I135))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2056-06-15",2056,0,{"$f":"IF(OR(E137<$C$5,E137>$C$6),YEARFRAC(E136,E137)*J136*$C$8,($C$2-SUM($I$1:I136))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2056-09-15",2056,0,{"$f":"IF(OR(E138<$C$5,E138>$C$6),YEARFRAC(E137,E138)*J137*$C$8,($C$2-SUM($I$1:I137))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2056-12-15",2056,0,{"$f":"IF(OR(E139<$C$5,E139>$C$6),YEARFRAC(E138,E139)*J138*$C$8,($C$2-SUM($I$1:I138))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2057-03-15",2057,0,{"$f":"IF(OR(E140<$C$5,E140>$C$6),YEARFRAC(E139,E140)*J139*$C$8,($C$2-SUM($I$1:I139))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2057-06-15",2057,0,{"$f":"IF(OR(E141<$C$5,E141>$C$6),YEARFRAC(E140,E141)*J140*$C$8,($C$2-SUM($I$1:I140))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2057-09-15",2057,0,{"$f":"IF(OR(E142<$C$5,E142>$C$6),YEARFRAC(E141,E142)*J141*$C$8,($C$2-SUM($I$1:I141))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2057-12-15",2057,0,{"$f":"IF(OR(E143<$C$5,E143>$C$6),YEARFRAC(E142,E143)*J142*$C$8,($C$2-SUM($I$1:I142))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2058-03-15",2058,0,{"$f":"IF(OR(E144<$C$5,E144>$C$6),YEARFRAC(E143,E144)*J143*$C$8,($C$2-SUM($I$1:I143))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2058-06-15",2058,0,{"$f":"IF(OR(E145<$C$5,E145>$C$6),YEARFRAC(E144,E145)*J144*$C$8,($C$2-SUM($I$1:I144))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2058-09-15",2058,0,{"$f":"IF(OR(E146<$C$5,E146>$C$6),YEARFRAC(E145,E146)*J145*$C$8,($C$2-SUM($I$1:I145))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2058-12-15",2058,0,{"$f":"IF(OR(E147<$C$5,E147>$C$6),YEARFRAC(E146,E147)*J146*$C$8,($C$2-SUM($I$1:I146))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2059-03-15",2059,0,{"$f":"IF(OR(E148<$C$5,E148>$C$6),YEARFRAC(E147,E148)*J147*$C$8,($C$2-SUM($I$1:I147))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2059-06-15",2059,0,{"$f":"IF(OR(E149<$C$5,E149>$C$6),YEARFRAC(E148,E149)*J148*$C$8,($C$2-SUM($I$1:I148))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2059-09-15",2059,0,{"$f":"IF(OR(E150<$C$5,E150>$C$6),YEARFRAC(E149,E150)*J149*$C$8,($C$2-SUM($I$1:I149))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2059-12-15",2059,0,{"$f":"IF(OR(E151<$C$5,E151>$C$6),YEARFRAC(E150,E151)*J150*$C$8,($C$2-SUM($I$1:I150))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2060-03-15",2060,0,{"$f":"IF(OR(E152<$C$5,E152>$C$6),YEARFRAC(E151,E152)*J151*$C$8,($C$2-SUM($I$1:I151))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2060-06-15",2060,0,{"$f":"IF(OR(E153<$C$5,E153>$C$6),YEARFRAC(E152,E153)*J152*$C$8,($C$2-SUM($I$1:I152))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2060-09-15",2060,0,{"$f":"IF(OR(E154<$C$5,E154>$C$6),YEARFRAC(E153,E154)*J153*$C$8,($C$2-SUM($I$1:I153))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2060-12-15",2060,0,{"$f":"IF(OR(E155<$C$5,E155>$C$6),YEARFRAC(E154,E155)*J154*$C$8,($C$2-SUM($I$1:I154))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2061-03-15",2061,0,{"$f":"IF(OR(E156<$C$5,E156>$C$6),YEARFRAC(E155,E156)*J155*$C$8,($C$2-SUM($I$1:I155))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2061-06-15",2061,0,{"$f":"IF(OR(E157<$C$5,E157>$C$6),YEARFRAC(E156,E157)*J156*$C$8,($C$2-SUM($I$1:I156))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2061-09-15",2061,0,{"$f":"IF(OR(E158<$C$5,E158>$C$6),YEARFRAC(E157,E158)*J157*$C$8,($C$2-SUM($I$1:I157))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2061-12-15",2061,0,{"$f":"IF(OR(E159<$C$5,E159>$C$6),YEARFRAC(E158,E159)*J158*$C$8,($C$2-SUM($I$1:I158))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2062-03-15",2062,0,{"$f":"IF(OR(E160<$C$5,E160>$C$6),YEARFRAC(E159,E160)*J159*$C$8,($C$2-SUM($I$1:I159))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2062-06-15",2062,0,{"$f":"IF(OR(E161<$C$5,E161>$C$6),YEARFRAC(E160,E161)*J160*$C$8,($C$2-SUM($I$1:I160))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2062-09-15",2062,0,{"$f":"IF(OR(E162<$C$5,E162>$C$6),YEARFRAC(E161,E162)*J161*$C$8,($C$2-SUM($I$1:I161))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2062-12-15",2062,0,{"$f":"IF(OR(E163<$C$5,E163>$C$6),YEARFRAC(E162,E163)*J162*$C$8,($C$2-SUM($I$1:I162))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2063-03-15",2063,0,{"$f":"IF(OR(E164<$C$5,E164>$C$6),YEARFRAC(E163,E164)*J163*$C$8,($C$2-SUM($I$1:I163))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2063-06-15",2063,0,{"$f":"IF(OR(E165<$C$5,E165>$C$6),YEARFRAC(E164,E165)*J164*$C$8,($C$2-SUM($I$1:I164))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2063-09-15",2063,0,{"$f":"IF(OR(E166<$C$5,E166>$C$6),YEARFRAC(E165,E166)*J165*$C$8,($C$2-SUM($I$1:I165))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2063-12-15",2063,0,{"$f":"IF(OR(E167<$C$5,E167>$C$6),YEARFRAC(E166,E167)*J166*$C$8,($C$2-SUM($I$1:I166))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2064-03-15",2064,0,{"$f":"IF(OR(E168<$C$5,E168>$C$6),YEARFRAC(E167,E168)*J167*$C$8,($C$2-SUM($I$1:I167))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2064-06-15",2064,0,{"$f":"IF(OR(E169<$C$5,E169>$C$6),YEARFRAC(E168,E169)*J168*$C$8,($C$2-SUM($I$1:I168))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2064-09-15",2064,0,{"$f":"IF(OR(E170<$C$5,E170>$C$6),YEARFRAC(E169,E170)*J169*$C$8,($C$2-SUM($I$1:I169))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2064-12-15",2064,0,{"$f":"IF(OR(E171<$C$5,E171>$C$6),YEARFRAC(E170,E171)*J170*$C$8,($C$2-SUM($I$1:I170))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2065-03-15",2065,0,{"$f":"IF(OR(E172<$C$5,E172>$C$6),YEARFRAC(E171,E172)*J171*$C$8,($C$2-SUM($I$1:I171))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2065-06-15",2065,0,{"$f":"IF(OR(E173<$C$5,E173>$C$6),YEARFRAC(E172,E173)*J172*$C$8,($C$2-SUM($I$1:I172))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2065-09-15",2065,0,{"$f":"IF(OR(E174<$C$5,E174>$C$6),YEARFRAC(E173,E174)*J173*$C$8,($C$2-SUM($I$1:I173))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2065-12-15",2065,0,{"$f":"IF(OR(E175<$C$5,E175>$C$6),YEARFRAC(E174,E175)*J174*$C$8,($C$2-SUM($I$1:I174))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2066-03-15",2066,0,{"$f":"IF(OR(E176<$C$5,E176>$C$6),YEARFRAC(E175,E176)*J175*$C$8,($C$2-SUM($I$1:I175))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2066-06-15",2066,0,{"$f":"IF(OR(E177<$C$5,E177>$C$6),YEARFRAC(E176,E177)*J176*$C$8,($C$2-SUM($I$1:I176))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2066-09-15",2066,0,{"$f":"IF(OR(E178<$C$5,E178>$C$6),YEARFRAC(E177,E178)*J177*$C$8,($C$2-SUM($I$1:I177))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2066-12-15",2066,0,{"$f":"IF(OR(E179<$C$5,E179>$C$6),YEARFRAC(E178,E179)*J178*$C$8,($C$2-SUM($I$1:I178))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2067-03-15",2067,0,{"$f":"IF(OR(E180<$C$5,E180>$C$6),YEARFRAC(E179,E180)*J179*$C$8,($C$2-SUM($I$1:I179))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2067-06-15",2067,0,{"$f":"IF(OR(E181<$C$5,E181>$C$6),YEARFRAC(E180,E181)*J180*$C$8,($C$2-SUM($I$1:I180))*($C$8/$C$7))","v":0},0,0]
[null,null,null,null,"2067-09-15",2067,0,{"$f":"IF(OR(E182<$C$5,E182>$C$6),YEARFRAC(E181,E182)*J181*$C$8,($C$2-SUM($I$1:I181))*($C$8/$C$7))","v":0},0,0]

{"sheet":"Income","index":4,"n_rows":43,"n_cols":31,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,11,0,19]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!C6","v":"Sample Company"}]
["Calendar Year",null,null,{"$f":"HistoricalData!D6","v":2021},null,{"$f":"Assumptions!D1","v":2022},null,{"$f":"F2+1","v":2023},null,{"$f":"H2+1","v":2024},null,{"$f":"J2+1","v":2025},null,{"$f":"L2+1","v":2026},null,{"$f":"N2+1","v":2027},null,{"$f":"P2+1","v":2028},null,{"$f":"R2+1","v":2029},null,{"$f":"T2+1","v":2030},null,{"$f":"V2+1","v":2031},null,{"$f":"X2+1","v":2032},null,{"$f":"Z2+1","v":2033},null,{"$f":"AB2+1","v":2034}]
[null,null,null,"Actual",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected",null,"Projected"]
[]
["Revenues",null,null,null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%",null,"%"]
[{"$f":"Assumptions!A9","v":"Business Line \"A\" Revenue in $000s"},null,null,null,null,{"$f":"Assumptions!D9","v":0},{"$f":"IFERROR(F6/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E9","v":0},{"$f":"IFERROR(H6/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F9","v":0},{"$f":"IFERROR(J6/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G9","v":0},{"$f":"IFERROR(L6/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H9","v":0},{"$f":"IFERROR(N6/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I9","v":0},{"$f":"IFERROR(P6/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J9","v":0},{"$f":"IFERROR(R6/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K9","v":0},{"$f":"IFERROR(T6/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L9","v":0},{"$f":"IFERROR(V6/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M9","v":0},{"$f":"IFERROR(X6/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N9","v":0},{"$f":"IFERROR(Z6/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O9","v":0},{"$f":"IFERROR(AB6/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P9","v":0},{"$f":"IFERROR(AD6/$AD$10,\"  \")","v":"  "}]
[{"$f":"Assumptions!A15","v":"Business Line \"B\" Revenue in $000s"},null,null,null,null,{"$f":"Assumptions!D15","v":0},{"$f":"IFERROR(F7/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E15","v":0},{"$f":"IFERROR(H7/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F15","v":0},{"$f":"IFERROR(J7/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G15","v":0},{"$f":"IFERROR(L7/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H15","v":0},{"$f":"IFERROR(N7/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I15","v":0},{"$f":"IFERROR(P7/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J15","v":0},{"$f":"IFERROR(R7/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K15","v":0},{"$f":"IFERROR(T7/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L15","v":0},{"$f":"IFERROR(V7/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M15","v":0},{"$f":"IFERROR(X7/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N15","v":0},{"$f":"IFERROR(Z7/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O15","v":0},{"$f":"IFERROR(AB7/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P15","v":0},{"$f":"IFERROR(AD7/$AD$10,\"  \")","v":"  "}]
[{"$f":"Assumptions!A21","v":"Business Line \"C\" Revenue in $000s"},null,null,null,null,{"$f":"Assumptions!D21","v":0},{"$f":"IFERROR(F8/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E21","v":0},{"$f":"IFERROR(H8/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F21","v":0},{"$f":"IFERROR(J8/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G21","v":0},{"$f":"IFERROR(L8/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H21","v":0},{"$f":"IFERROR(N8/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I21","v":0},{"$f":"IFERROR(P8/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J21","v":0},{"$f":"IFERROR(R8/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K21","v":0},{"$f":"IFERROR(T8/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L21","v":0},{"$f":"IFERROR(V8/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M21","v":0},{"$f":"IFERROR(X8/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N21","v":0},{"$f":"IFERROR(Z8/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O21","v":0},{"$f":"IFERROR(AB8/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P21","v":0},{"$f":"IFERROR(AD8/$AD$10,\"  \")","v":"  "}]
[{"$f":"Assumptions!A27","v":"Business Line \"D\" Revenue in $000s"},null,null,null,null,{"$f":"Assumptions!D27","v":0},{"$f":"IFERROR(F9/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E27","v":0},{"$f":"IFERROR(H9/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F27","v":0},{"$f":"IFERROR(J9/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G27","v":0},{"$f":"IFERROR(L9/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H27","v":0},{"$f":"IFERROR(N9/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I27","v":0},{"$f":"IFERROR(P9/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J27","v":0},{"$f":"IFERROR(R9/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K27","v":0},{"$f":"IFERROR(T9/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L27","v":0},{"$f":"IFERROR(V9/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M27","v":0},{"$f":"IFERROR(X9/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N27","v":0},{"$f":"IFERROR(Z9/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O27","v":0},{"$f":"IFERROR(AB9/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P27","v":0},{"$f":"IFERROR(AD9/$AD$10,\"  \")","v":"  "}]
["Gross Revenues",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D52,HistoricalData!D114)","v":0},null,{"$f":"SUM(F6:F9)","v":0},null,{"$f":"SUM(H6:H9)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
["Cost of Product Sold",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D53,HistoricalData!D115)","v":0},{"$f":"IFERROR(D12/$D$10,\"  \")","v":"  "},{"$f":"Assumptions!D34","v":0},{"$f":"IFERROR(F12/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E34","v":0},{"$f":"IFERROR(H12/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F34","v":0},{"$f":"IFERROR(J12/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G34","v":0},{"$f":"IFERROR(L12/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H34","v":0},{"$f":"IFERROR(N12/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I34","v":0},{"$f":"IFERROR(P12/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J34","v":0},{"$f":"IFERROR(R12/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K34","v":0},{"$f":"IFERROR(T12/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L34","v":0},{"$f":"IFERROR(V12/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M34","v":0},{"$f":"IFERROR(X12/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N34","v":0},{"$f":"IFERROR(Z12/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O34","v":0},{"$f":"IFERROR(AB12/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P34","v":0},{"$f":"IFERROR(AD12/$AD$10,\"  \")","v":"  "}]
[]
["Operating Expenses"]
[{"$f":"Assumptions!A38","v":"Operating Expense (local 000s)"},null,null,null,null,{"$f":"Assumptions!D38*(1/Assumptions!D44)","v":0},null,{"$f":"Assumptions!E38*(1/Assumptions!E44)","v":0},null,{"$f":"Assumptions!F38*(1/Assumptions!F44)","v":0},null,{"$f":"Assumptions!G38*(1/Assumptions!G44)","v":0},null,{"$f":"Assumptions!H38*(1/Assumptions!H44)","v":0},null,{"$f":"Assumptions!I38*(1/Assumptions!I44)","v":0},null,{"$f":"Assumptions!J38*(1/Assumptions!J44)","v":0},null,{"$f":"Assumptions!K38*(1/Assumptions!K44)","v":0},null,{"$f":"Assumptions!L38*(1/Assumptions!L44)","v":0},null,{"$f":"Assumptions!M38*(1/Assumptions!M44)","v":0},null,{"$f":"Assumptions!N38*(1/Assumptions!N44)","v":0},null,{"$f":"Assumptions!O38*(1/Assumptions!O44)","v":0},null,{"$f":"Assumptions!P38*(1/Assumptions!P44)","v":0}]
[{"$f":"Assumptions!A39","v":"Operating Expense (local 000s)"},null,null,null,null,{"$f":"Assumptions!D39*(1/Assumptions!D44)","v":0},null,{"$f":"Assumptions!E39*(1/Assumptions!E44)","v":0},null,{"$f":"Assumptions!F39*(1/Assumptions!F44)","v":0},null,{"$f":"Assumptions!G39*(1/Assumptions!G44)","v":0},null,{"$f":"Assumptions!H39*(1/Assumptions!H44)","v":0},null,{"$f":"Assumptions!I39*(1/Assumptions!I44)","v":0},null,{"$f":"Assumptions!J39*(1/Assumptions!J44)","v":0},null,{"$f":"Assumptions!K39*(1/Assumptions!K44)","v":0},null,{"$f":"Assumptions!L39*(1/Assumptions!L44)","v":0},null,{"$f":"Assumptions!M39*(1/Assumptions!M44)","v":0},null,{"$f":"Assumptions!N39*(1/Assumptions!N44)","v":0},null,{"$f":"Assumptions!O39*(1/Assumptions!O44)","v":0},null,{"$f":"Assumptions!P39*(1/Assumptions!P44)","v":0}]
[{"$f":"Assumptions!A40","v":"Operating Expense (local 000s)"},null,null,null,null,{"$f":"Assumptions!D40*(1/Assumptions!D44)","v":0},null,{"$f":"Assumptions!E40*(1/Assumptions!E44)","v":0},null,{"$f":"Assumptions!F40*(1/Assumptions!F44)","v":0},null,{"$f":"Assumptions!G40*(1/Assumptions!G44)","v":0},null,{"$f":"Assumptions!H40*(1/Assumptions!H44)","v":0},null,{"$f":"Assumptions!I40*(1/Assumptions!I44)","v":0},null,{"$f":"Assumptions!J40*(1/Assumptions!J44)","v":0},null,{"$f":"Assumptions!K40*(1/Assumptions!K44)","v":0},null,{"$f":"Assumptions!L40*(1/Assumptions!L44)","v":0},null,{"$f":"Assumptions!M40*(1/Assumptions!M44)","v":0},null,{"$f":"Assumptions!N40*(1/Assumptions!N44)","v":0},null,{"$f":"Assumptions!O40*(1/Assumptions!O44)","v":0},null,{"$f":"Assumptions!P40*(1/Assumptions!P44)","v":0}]
[{"$f":"Assumptions!A41","v":"Operating Expense (local 000s)"},null,null,null,null,{"$f":"Assumptions!D41*(1/Assumptions!D44)","v":0},null,{"$f":"Assumptions!E41*(1/Assumptions!E44)","v":0},null,{"$f":"Assumptions!F41*(1/Assumptions!F44)","v":0},null,{"$f":"Assumptions!G41*(1/Assumptions!G44)","v":0},null,{"$f":"Assumptions!H41*(1/Assumptions!H44)","v":0},null,{"$f":"Assumptions!I41*(1/Assumptions!I44)","v":0},null,{"$f":"Assumptions!J41*(1/Assumptions!J44)","v":0},null,{"$f":"Assumptions!K41*(1/Assumptions!K44)","v":0},null,{"$f":"Assumptions!L41*(1/Assumptions!L44)","v":0},null,{"$f":"Assumptions!M41*(1/Assumptions!M44)","v":0},null,{"$f":"Assumptions!N41*(1/Assumptions!N44)","v":0},null,{"$f":"Assumptions!O41*(1/Assumptions!O44)","v":0},null,{"$f":"Assumptions!P41*(1/Assumptions!P44)","v":0}]
[{"$f":"Assumptions!A42","v":"Operating Expense (local 000s)"},null,null,null,null,{"$f":"Assumptions!D42*(1/Assumptions!D44)","v":0},null,{"$f":"Assumptions!E42*(1/Assumptions!E44)","v":0},null,{"$f":"Assumptions!F42*(1/Assumptions!F44)","v":0},null,{"$f":"Assumptions!G42*(1/Assumptions!G44)","v":0},null,{"$f":"Assumptions!H42*(1/Assumptions!H44)","v":0},null,{"$f":"Assumptions!I42*(1/Assumptions!I44)","v":0},null,{"$f":"Assumptions!J42*(1/Assumptions!J44)","v":0},null,{"$f":"Assumptions!K42*(1/Assumptions!K44)","v":0},null,{"$f":"Assumptions!L42*(1/Assumptions!L44)","v":0},null,{"$f":"Assumptions!M42*(1/Assumptions!M44)","v":0},null,{"$f":"Assumptions!N42*(1/Assumptions!N44)","v":0},null,{"$f":"Assumptions!O42*(1/Assumptions!O44)","v":0},null,{"$f":"Assumptions!P42*(1/Assumptions!P44)","v":0}]
[{"$f":"Assumptions!A48","v":"Operating Expense ($000s)"},null,null,null,null,{"$f":"Assumptions!D48","v":0},null,{"$f":"Assumptions!E48","v":0},null,{"$f":"Assumptions!F48","v":0},null,{"$f":"Assumptions!G48","v":0},null,{"$f":"Assumptions!H48","v":0},null,{"$f":"Assumptions!I48","v":0},null,{"$f":"Assumptions!J48","v":0},null,{"$f":"Assumptions!K48","v":0},null,{"$f":"Assumptions!L48","v":0},null,{"$f":"Assumptions!M48","v":0},null,{"$f":"Assumptions!N48","v":0},null,{"$f":"Assumptions!O48","v":0},null,{"$f":"Assumptions!P48","v":0}]
[{"$f":"Assumptions!A49","v":"Operating Expense ($000s)"},null,null,null,null,{"$f":"Assumptions!D49","v":0},null,{"$f":"Assumptions!E49","v":0},null,{"$f":"Assumptions!F49","v":0},null,{"$f":"Assumptions!G49","v":0},null,{"$f":"Assumptions!H49","v":0},null,{"$f":"Assumptions!I49","v":0},null,{"$f":"Assumptions!J49","v":0},null,{"$f":"Assumptions!K49","v":0},null,{"$f":"Assumptions!L49","v":0},null,{"$f":"Assumptions!M49","v":0},null,{"$f":"Assumptions!N49","v":0},null,{"$f":"Assumptions!O49","v":0},null,{"$f":"Assumptions!P49","v":0}]
[{"$f":"Assumptions!A50","v":"Operating Expense ($000s)"},null,null,null,null,{"$f":"Assumptions!D50","v":0},null,{"$f":"Assumptions!E50","v":0},null,{"$f":"Assumptions!F50","v":0},null,{"$f":"Assumptions!G50","v":0},null,{"$f":"Assumptions!H50","v":0},null,{"$f":"Assumptions!I50","v":0},null,{"$f":"Assumptions!J50","v":0},null,{"$f":"Assumptions!K50","v":0},null,{"$f":"Assumptions!L50","v":0},null,{"$f":"Assumptions!M50","v":0},null,{"$f":"Assumptions!N50","v":0},null,{"$f":"Assumptions!O50","v":0},null,{"$f":"Assumptions!P50","v":0}]
[{"$f":"Assumptions!A51","v":"Operating Expense ($000s)"},null,null,null,null,{"$f":"Assumptions!D51","v":0},null,{"$f":"Assumptions!E51","v":0},null,{"$f":"Assumptions!F51","v":0},null,{"$f":"Assumptions!G51","v":0},null,{"$f":"Assumptions!H51","v":0},null,{"$f":"Assumptions!I51","v":0},null,{"$f":"Assumptions!J51","v":0},null,{"$f":"Assumptions!K51","v":0},null,{"$f":"Assumptions!L51","v":0},null,{"$f":"Assumptions!M51","v":0},null,{"$f":"Assumptions!N51","v":0},null,{"$f":"Assumptions!O51","v":0},null,{"$f":"Assumptions!P51","v":0}]
[{"$f":"Assumptions!A52","v":"Operating Expense ($000s)"},null,null,null,null,{"$f":"Assumptions!D52","v":0},null,{"$f":"Assumptions!E52","v":0},null,{"$f":"Assumptions!F52","v":0},null,{"$f":"Assumptions!G52","v":0},null,{"$f":"Assumptions!H52","v":0},null,{"$f":"Assumptions!I52","v":0},null,{"$f":"Assumptions!J52","v":0},null,{"$f":"Assumptions!K52","v":0},null,{"$f":"Assumptions!L52","v":0},null,{"$f":"Assumptions!M52","v":0},null,{"$f":"Assumptions!N52","v":0},null,{"$f":"Assumptions!O52","v":0},null,{"$f":"Assumptions!P52","v":0}]
["Total Operating Expenses",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D54+HistoricalData!D55,HistoricalData!D116+HistoricalData!D117)","v":0},{"$f":"IFERROR(D25/$D$10,\"  \")","v":"  "},{"$f":"SUM(F15:F24)","v":0},{"$f":"IFERROR(F25/$F$10,\"  \")","v":"  "},0,{"$f":"IFERROR(H25/$H$10,\"  \")","v":"  "},0,{"$f":"IFERROR(J25/$J$10,\"  \")","v":"  "},0,{"$f":"IFERROR(L25/$L$10,\"  \")","v":"  "},0,{"$f":"IFERROR(N25/$N$10,\"  \")","v":"  "},0,{"$f":"IFERROR(P25/$P$10,\"  \")","v":"  "},0,{"$f":"IFERROR(R25/$R$10,\"  \")","v":"  "},0,{"$f":"IFERROR(T25/$T$10,\"  \")","v":"  "},0,{"$f":"IFERROR(V25/$V$10,\"  \")","v":"  "},{"$f":"SUM(X15:X24)","v":0},{"$f":"IFERROR(X25/$X$10,\"  \")","v":"  "},{"$f":"SUM(Z15:Z24)","v":0},{"$f":"IFERROR(Z25/$Z$10,\"  \")","v":"  "},{"$f":"SUM(AB15:AB24)","v":0},{"$f":"IFERROR(AB25/$AB$10,\"  \")","v":"  "},{"$f":"SUM(AD15:AD24)","v":0},{"$f":"IFERROR(AD25/$AD$10,\"  \")","v":"  "}]
[]
["Gross Operating Profit (EBITDA)",null,null,{"$f":"D10-D12-D25","v":0},{"$f":"IFERROR(D27/$D$10,\"  \")","v":"  "},0,{"$f":"IFERROR(F27/$F$10,\"  \")","v":"  "},0,{"$f":"IFERROR(H27/$H$10,\"  \")","v":"  "},0,{"$f":"IFERROR(J27/$J$10,\"  \")","v":"  "},0,{"$f":"IFERROR(L27/$L$10,\"  \")","v":"  "},0,{"$f":"IFERROR(N27/$N$10,\"  \")","v":"  "},0,{"$f":"IFERROR(P27/$P$10,\"  \")","v":"  "},0,{"$f":"IFERROR(R27/$R$10,\"  \")","v":"  "},0,{"$f":"IFERROR(T27/$T$10,\"  \")","v":"  "},{"$f":"V10-V12-V25","v":0},{"$f":"IFERROR(V27/$V$10,\"  \")","v":"  "},{"$f":"X10-X12-X25","v":0},{"$f":"IFERROR(X27/$X$10,\"  \")","v":"  "},{"$f":"Z10-Z12-Z25","v":0},{"$f":"IFERROR(Z27/$Z$10,\"  \")","v":"  "},{"$f":"AB10-AB12-AB25","v":0},{"$f":"IFERROR(AB27/$AB$10,\"  \")","v":"  "},{"$f":"AD10-AD12-AD25","v":0},{"$f":"IFERROR(AD27/$AD$10,\"  \")","v":"  "}]
[]
["Depreciation Expense",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D56,HistoricalData!D118)","v":0},{"$f":"IFERROR(D29/$D$10,\"  \")","v":"  "},{"$f":"Assumptions!D165","v":0},{"$f":"IFERROR(F29/$F$10,\"  \")","v":"  "},{"$f":"Assumptions!E165","v":0},{"$f":"IFERROR(H29/$H$10,\"  \")","v":"  "},{"$f":"Assumptions!F165","v":0},{"$f":"IFERROR(J29/$J$10,\"  \")","v":"  "},{"$f":"Assumptions!G165","v":0},{"$f":"IFERROR(L29/$L$10,\"  \")","v":"  "},{"$f":"Assumptions!H165","v":0},{"$f":"IFERROR(N29/$N$10,\"  \")","v":"  "},{"$f":"Assumptions!I165","v":0},{"$f":"IFERROR(P29/$P$10,\"  \")","v":"  "},{"$f":"Assumptions!J165","v":0},{"$f":"IFERROR(R29/$R$10,\"  \")","v":"  "},{"$f":"Assumptions!K165","v":0},{"$f":"IFERROR(T29/$T$10,\"  \")","v":"  "},{"$f":"Assumptions!L165","v":0},{"$f":"IFERROR(V29/$V$10,\"  \")","v":"  "},{"$f":"Assumptions!M165","v":0},{"$f":"IFERROR(X29/$X$10,\"  \")","v":"  "},{"$f":"Assumptions!N165","v":0},{"$f":"IFERROR(Z29/$Z$10,\"  \")","v":"  "},{"$f":"Assumptions!O165","v":0},{"$f":"IFERROR(AB29/$AB$10,\"  \")","v":"  "},{"$f":"Assumptions!P165","v":0},{"$f":"IFERROR(AD29/$AD$10,\"  \")","v":"  "}]
[]
["EBIT",null,null,{"$f":"D27-D29","v":0},{"$f":"IFERROR(D31/$D$10,\"  \")","v":"  "},{"$f":"F27-F29","v":0},{"$f":"IFERROR(F31/$F$10,\"  \")","v":"  "},{"$f":"H27-H29","v":0},{"$f":"IFERROR(H31/$H$10,\"  \")","v":"  "},0,{"$f":"IFERROR(J31/$J$10,\"  \")","v":"  "},0,{"$f":"IFERROR(L31/$L$10,\"  \")","v":"  "},0,{"$f":"IFERROR(N31/$N$10,\"  \")","v":"  "},0,{"$f":"IFERROR(P31/$P$10,\"  \")","v":"  "},0,{"$f":"IFERROR(R31/$R$10,\"  \")","v":"  "},0,{"$f":"IFERROR(T31/$T$10,\"  \")","v":"  "},0,{"$f":"IFERROR(V31/$V$10,\"  \")","v":"  "},{"$f":"X27-X29","v":0},{"$f":"IFERROR(X31/$X$10,\"  \")","v":"  "},{"$f":"Z27-Z29","v":0},{"$f":"IFERROR(Z31/$Z$10,\"  \")","v":"  "},{"$f":"AB27-AB29","v":0},{"$f":"IFERROR(AB31/$AB$10,\"  \")","v":"  "},{"$f":"AD27-AD29","v":0},{"$f":"IFERROR(AD31/$AD$10,\"  \")","v":"  "}]
[]
["Interest & Fee Income/(Expense)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D57,HistoricalData!D119)","v":0},{"$f":"IFERROR(ABS(D33/$D$10),\"  \")","v":"  "},{"$f":"-(Assumptions!D93+Assumptions!D94+Assumptions!D105+Assumptions!D106+Assumptions!D117+Assumptions!D118+Assumptions!D129)","v":0},{"$f":"IFERROR(ABS(F33/$F$10),\"  \")","v":"  "},{"$f":"-(Assumptions!E93+Assumptions!E94+Assumptions!E105+Assumptions!E106+Assumptions!E117+Assumptions!E118+Assumptions!E129)","v":0},{"$f":"IFERROR(ABS(H33/$H$10),\"  \")","v":"  "},{"$f":"-(Assumptions!F93+Assumptions!F94+Assumptions!F105+Assumptions!F106+Assumptions!F117+Assumptions!F118+Assumptions!F129)","v":0},{"$f":"IFERROR(ABS(J33/$J$10),\"  \")","v":"  "},{"$f":"-(Assumptions!G93+Assumptions!G94+Assumptions!G105+Assumptions!G106+Assumptions!G117+Assumptions!G118+Assumptions!G129)","v":0},{"$f":"IFERROR(ABS(L33/$L$10),\"  \")","v":"  "},{"$f":"-(Assumptions!H93+Assumptions!H94+Assumptions!H105+Assumptions!H106+Assumptions!H117+Assumptions!H118+Assumptions!H129)","v":0},{"$f":"IFERROR(ABS(N33/$N$10),\"  \")","v":"  "},{"$f":"-(Assumptions!I93+Assumptions!I94+Assumptions!I105+Assumptions!I106+Assumptions!I117+Assumptions!I118+Assumptions!I129)","v":0},{"$f":"IFERROR(ABS(P33/$P$10),\"  \")","v":"  "},{"$f":"-(Assumptions!J93+Assumptions!J94+Assumptions!J105+Assumptions!J106+Assumptions!J117+Assumptions!J118+Assumptions!J129)","v":0},{"$f":"IFERROR(ABS(R33/$R$10),\"  \")","v":"  "},{"$f":"-(Assumptions!K93+Assumptions!K94+Assumptions!K105+Assumptions!K106+Assumptions!K117+Assumptions!K118+Assumptions!K129)","v":0},{"$f":"IFERROR(ABS(T33/$T$10),\"  \")","v":"  "},{"$f":"-(Assumptions!L93+Assumptions!L94+Assumptions!L105+Assumptions!L106+Assumptions!L117+Assumptions!L118+Assumptions!L129)","v":0},{"$f":"IFERROR(ABS(V33/$V$10),\"  \")","v":"  "},{"$f":"-(Assumptions!M93+Assumptions!M94+Assumptions!M105+Assumptions!M106+Assumptions!M117+Assumptions!M118+Assumptions!M129)","v":0},{"$f":"IFERROR(ABS(X33/$X$10),\"  \")","v":"  "},{"$f":"-(Assumptions!N93+Assumptions!N94+Assumptions!N105+Assumptions!N106+Assumptions!N117+Assumptions!N118+Assumptions!N129)","v":0},{"$f":"IFERROR(ABS(Z33/$Z$10),\"  \")","v":"  "},{"$f":"-(Assumptions!O93+Assumptions!O94+Assumptions!O105+Assumptions!O106+Assumptions!O117+Assumptions!O118+Assumptions!O129)","v":0},{"$f":"IFERROR(ABS(AB33/$AB$10),\"  \")","v":"  "},{"$f":"-(Assumptions!P93+Assumptions!P94+Assumptions!P105+Assumptions!P106+Assumptions!P117+Assumptions!P118+Assumptions!P129)","v":0},{"$f":"IFERROR(ABS(AD33/$AD$10),\"  \")","v":"  "}]
[]
["Income Taxes",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D58,HistoricalData!D120)","v":0},{"$f":"IFERROR(D35/$D$10,\"  \")","v":"  "},{"$f":"IF((F31+F33)<=0,0,(F31+F33)*Assumptions!D148)","v":0},{"$f":"IFERROR(F35/$F$10,\"  \")","v":"  "},{"$f":"IF((H31+H33)<=0,0,(H31+H33)*Assumptions!E148)","v":0},{"$f":"IFERROR(H35/$H$10,\"  \")","v":"  "},{"$f":"IF((J31+J33)<=0,0,(J31+J33)*Assumptions!F148)","v":0},{"$f":"IFERROR(J35/$J$10,\"  \")","v":"  "},{"$f":"IF((L31+L33)<=0,0,(L31+L33)*Assumptions!G148)","v":0},{"$f":"IFERROR(L35/$L$10,\"  \")","v":"  "},{"$f":"IF((N31+N33)<=0,0,(N31+N33)*Assumptions!H148)","v":0},{"$f":"IFERROR(N35/$N$10,\"  \")","v":"  "},{"$f":"IF((P31+P33)<=0,0,(P31+P33)*Assumptions!I148)","v":0},{"$f":"IFERROR(P35/$P$10,\"  \")","v":"  "},{"$f":"IF((R31+R33)<=0,0,(R31+R33)*Assumptions!J148)","v":0},{"$f":"IFERROR(R35/$R$10,\"  \")","v":"  "},{"$f":"IF((T31+T33)<=0,0,(T31+T33)*Assumptions!K148)","v":0},{"$f":"IFERROR(T35/$T$10,\"  \")","v":"  "},{"$f":"IF((V31+V33)<=0,0,(V31+V33)*Assumptions!L148)","v":0},{"$f":"IFERROR(V35/$V$10,\"  \")","v":"  "},{"$f":"IF((X31+X33)<=0,0,(X31+X33)*Assumptions!M148)","v":0},{"$f":"IFERROR(X35/$X$10,\"  \")","v":"  "},{"$f":"IF((Z31+Z33)<=0,0,(Z31+Z33)*Assumptions!N148)","v":0},{"$f":"IFERROR(Z35/$Z$10,\"  \")","v":"  "},{"$f":"IF((AB31+AB33)<=0,0,(AB31+AB33)*Assumptions!O148)","v":0},{"$f":"IFERROR(AB35/$AB$10,\"  \")","v":"  "},{"$f":"IF((AD31+AD33)<=0,0,(AD31+AD33)*Assumptions!P148)","v":0},{"$f":"IFERROR(AD35/$AD$10,\"  \")","v":"  "}]
[]
["Special (Historical) Items",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D59:'HistoricalData'!D62),SUM(HistoricalData!D121:'HistoricalData'!D124))","v":0}]
[" "]
["Net Income",null,null,{"$f":"D31+D33-D35+D37","v":0},{"$f":"IFERROR(D39/$D$10,\"  \")","v":"  "},{"$f":"F31+F33-F35","v":0},{"$f":"IFERROR(F39/$F$10,\"  \")","v":"  "},{"$f":"H31+H33-H35","v":0},{"$f":"IFERROR(H39/$H$10,\"  \")","v":"  "},{"$f":"J31+J33-J35","v":0},{"$f":"IFERROR(J39/$J$10,\"  \")","v":"  "},{"$f":"L31+L33-L35","v":0},{"$f":"IFERROR(L39/$L$10,\"  \")","v":"  "},{"$f":"N31+N33-N35","v":0},{"$f":"IFERROR(N39/$N$10,\"  \")","v":"  "},{"$f":"P31+P33-P35","v":0},{"$f":"IFERROR(P39/$P$10,\"  \")","v":"  "},{"$f":"R31+R33-R35","v":0},{"$f":"IFERROR(R39/$R$10,\"  \")","v":"  "},{"$f":"T31+T33-T35","v":0},{"$f":"IFERROR(T39/$T$10,\"  \")","v":"  "},{"$f":"V31+V33-V35","v":0},{"$f":"IFERROR(V39/$V$10,\"  \")","v":"  "},{"$f":"X31+X33-X35","v":0},{"$f":"IFERROR(X39/$X$10,\"  \")","v":"  "},{"$f":"Z31+Z33-Z35","v":0},{"$f":"IFERROR(Z39/$Z$10,\"  \")","v":"  "},{"$f":"AB31+AB33-AB35","v":0},{"$f":"IFERROR(AB39/$AB$10,\"  \")","v":"  "},{"$f":"AD31+AD33-AD35","v":0},{"$f":"IFERROR(AD39/$AD$10,\"  \")","v":"  "}]
[]
["Dividends",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D64,HistoricalData!D126)","v":0},null,{"$f":"Assumptions!D143","v":0}," ",{"$f":"Assumptions!E143","v":0},null,{"$f":"Assumptions!F143","v":0},null,{"$f":"Assumptions!G143","v":0},null,{"$f":"Assumptions!H143","v":0},null,{"$f":"Assumptions!I143","v":0},null,{"$f":"Assumptions!J143","v":0},null,{"$f":"Assumptions!K143","v":0},null,{"$f":"Assumptions!L143","v":0},null,{"$f":"Assumptions!M143","v":0},null,{"$f":"Assumptions!N143","v":0},null,{"$f":"Assumptions!O143","v":0},null,{"$f":"Assumptions!P143","v":0}]
[]
["Addition to Retained Earnings",null,null,{"$f":"D39-D41","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"V39-V41","v":0},null,{"$f":"X39-X41","v":0},null,{"$f":"Z39-Z41","v":0},null,{"$f":"AB39-AB41","v":0},null,{"$f":"AD39-AD41","v":0}]

{"sheet":"CashFlow","index":5,"n_rows":102,"n_cols":17,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,7,0,11],[44,7,44,11]]}
[null,null,null,null,null,null,null,{"$f":"Start!C6","v":"Sample Company"}]
["Calendar Year",null,null,{"$f":"HistoricalData!D6","v":2021},{"$f":"Assumptions!D1","v":2022},{"$f":"E2+1","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L2+1","v":2030},{"$f":"M2+1","v":2031},{"$f":"N2+1","v":2032},{"$f":"O2+1","v":2033},{"$f":"P2+1","v":2034}]
[null,null,null,"Actual","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected"]
["Cash Flow Statement"]
["Sales",null,null,{"$f":"Income!D10","v":0},{"$f":"Income!F10","v":0},{"$f":"Income!H10","v":0},{"$f":"Income!J10","v":0},{"$f":"Income!L10","v":0},{"$f":"Income!N10","v":0},{"$f":"Income!P10","v":0},{"$f":"Income!R10","v":0},{"$f":"Income!T10","v":0},{"$f":"Income!V10","v":0},{"$f":"Income!X10","v":0},{"$f":"Income!Z10","v":0},{"$f":"Income!AB10","v":0},{"$f":"Income!AD10","v":0}]
["Change in Receivables",null,null,{"$f":"-IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D15:D16)-SUM(HistoricalData!C15:C16),SUM(HistoricalData!D78:D79)-SUM(HistoricalData!C78:C79)-(SUM(HistoricalData!C15:C16)/HistoricalData!D10-SUM(HistoricalData!C15:C16)/HistoricalData!C10))","v":0},{"$f":"-(Balance!E9-Balance!D9)","v":0},{"$f":"-(Balance!F9-Balance!E9)","v":0},{"$f":"-(Balance!G9-Balance!F9)","v":0},{"$f":"-(Balance!H9-Balance!G9)","v":0},{"$f":"-(Balance!I9-Balance!H9)","v":0},{"$f":"-(Balance!J9-Balance!I9)","v":0},{"$f":"-(Balance!K9-Balance!J9)","v":0},{"$f":"-(Balance!L9-Balance!K9)","v":0},{"$f":"-(Balance!M9-Balance!L9)","v":0},{"$f":"-(Balance!N9-Balance!M9)","v":0},{"$f":"-(Balance!O9-Balance!N9)","v":0},{"$f":"-(Balance!P9-Balance!O9)","v":0},{"$f":"-(Balance!Q9-Balance!P9)","v":0}]
["Cash from Sales",null,null,{"$f":"D5+D6","v":0},0,0,0,0,0,0,0,0,0,{"$f":"N5+N6","v":0},{"$f":"O5+O6","v":0},{"$f":"P5+P6","v":0},{"$f":"Q5+Q6","v":0}]
[]
["Cost of Goods Sold",null,null,{"$f":"Income!D12","v":0},{"$f":"Income!F12","v":0},{"$f":"Income!H12","v":0},{"$f":"Income!J12","v":0},{"$f":"Income!L12","v":0},{"$f":"Income!N12","v":0},{"$f":"Income!P12","v":0},{"$f":"Income!R12","v":0},{"$f":"Income!T12","v":0},{"$f":"Income!V12","v":0},{"$f":"Income!X12","v":0},{"$f":"Income!Z12","v":0},{"$f":"Income!AB12","v":0},{"$f":"Income!AD12","v":0}]
["Change in Inventory",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D17-HistoricalData!C17,HistoricalData!D80-HistoricalData!C80-(HistoricalData!C17/HistoricalData!D10-HistoricalData!C17/HistoricalData!C10))","v":0},{"$f":"Balance!E10-Balance!D10","v":0},{"$f":"Balance!F10-Balance!E10","v":0},{"$f":"Balance!G10-Balance!F10","v":0},{"$f":"Balance!H10-Balance!G10","v":0},{"$f":"Balance!I10-Balance!H10","v":0},{"$f":"Balance!J10-Balance!I10","v":0},{"$f":"Balance!K10-Balance!J10","v":0},{"$f":"Balance!L10-Balance!K10","v":0},{"$f":"Balance!M10-Balance!L10","v":0},{"$f":"Balance!N10-Balance!M10","v":0},{"$f":"Balance!O10-Balance!N10","v":0},{"$f":"Balance!P10-Balance!O10","v":0},{"$f":"Balance!Q10-Balance!P10","v":0}]
["Change in Payables/Other Curr. Liabilities",null,null,{"$f":"-IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D32-HistoricalData!C32,HistoricalData!D95-HistoricalData!C95-(HistoricalData!C32/HistoricalData!D10-HistoricalData!C32/HistoricalData!C10))","v":0},{"$f":"-(Balance!E36-Balance!D36)","v":0},{"$f":"-(Balance!F36-Balance!E36)","v":0},{"$f":"-(Balance!G36-Balance!F36)","v":0},{"$f":"-(Balance!H36-Balance!G36)","v":0},{"$f":"-(Balance!I36-Balance!H36)","v":0},{"$f":"-(Balance!J36-Balance!I36)","v":0},{"$f":"-(Balance!K36-Balance!J36)","v":0},{"$f":"-(Balance!L36-Balance!K36)","v":0},{"$f":"-(Balance!M36-Balance!L36)","v":0},{"$f":"-(Balance!N36-Balance!M36)","v":0},{"$f":"-(Balance!O36-Balance!N36)","v":0},{"$f":"-(Balance!P36-Balance!O36)","v":0},{"$f":"-(Balance!Q36-Balance!P36)","v":0}]
["Cash Production Costs",null,null,{"$f":"SUM(D9:D11)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N9:N11)","v":0},{"$f":"SUM(O9:O11)","v":0},{"$f":"SUM(P9:P11)","v":0},{"$f":"SUM(Q9:Q11)","v":0}]
[]
["Gross Cash Profits",null,null,{"$f":"D7-D12","v":0},0,0,0,0,0,0,0,0,{"$f":"M7-M12","v":0},{"$f":"N7-N12","v":0},{"$f":"O7-O12","v":0},{"$f":"P7-P12","v":0},{"$f":"Q7-Q12","v":0}]
[]
["Cash Operating Expenses",null,null,{"$f":"Income!D25-IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D55,HistoricalData!D117)","v":0},{"$f":"Income!F25","v":0},{"$f":"Income!H25","v":0},{"$f":"Income!J25","v":0},{"$f":"Income!L25","v":0},{"$f":"Income!N25","v":0},{"$f":"Income!P25","v":0},{"$f":"Income!R25","v":0},{"$f":"Income!T25","v":0},{"$f":"Income!V25","v":0},{"$f":"Income!X25","v":0},{"$f":"Income!Z25","v":0},{"$f":"Income!AB25","v":0},{"$f":"Income!AD25","v":0}]
[]
["Cash After Operations",null,null,{"$f":"D14-D16","v":0},0,0,0,0,0,0,0,0,{"$f":"M14-M16","v":0},{"$f":"N14-N16","v":0},{"$f":"O14-O16","v":0},{"$f":"P14-P16","v":0},{"$f":"Q14-Q16","v":0}]
[]
["Taxes Paid",null,null,{"$f":"Income!D35","v":0},{"$f":"Income!F35","v":0},{"$f":"Income!H35","v":0},{"$f":"Income!J35","v":0},{"$f":"Income!L35","v":0},{"$f":"Income!N35","v":0},{"$f":"Income!P35","v":0},{"$f":"Income!R35","v":0},{"$f":"Income!T35","v":0},{"$f":"Income!V35","v":0},{"$f":"Income!X35","v":0},{"$f":"Income!Z35","v":0},{"$f":"Income!AB35","v":0},{"$f":"Income!AD35","v":0}]
[]
["Net Cash After Operations",null,null,{"$f":"D18-D20","v":0},0,0,0,0,0,0,0,0,{"$f":"M18-M20","v":0},{"$f":"N18-N20","v":0},{"$f":"O18-O20","v":0},{"$f":"P18-P20","v":0},{"$f":"Q18-Q20","v":0}]
[]
["Capital Expenditures",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D19:D26)-SUM(HistoricalData!C19:C26),SUM(HistoricalData!D82:D89)-SUM(HistoricalData!C82:C89)-(SUM(HistoricalData!C19:C26)/HistoricalData!D10-SUM(HistoricalData!C19:C26)/HistoricalData!C10))","v":0},{"$f":"Assumptions!D68","v":0},{"$f":"Assumptions!E68","v":0},{"$f":"Assumptions!F68","v":0},{"$f":"Assumptions!G68","v":0},{"$f":"Assumptions!H68","v":0},{"$f":"Assumptions!I68","v":0},{"$f":"Assumptions!J68","v":0},{"$f":"Assumptions!K68","v":0},{"$f":"Assumptions!L68","v":0},{"$f":"Assumptions!M68","v":0},{"$f":"Assumptions!N68","v":0},{"$f":"Assumptions!O68","v":0},{"$f":"Assumptions!P68","v":0}]
["Other Historical Cash Items",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D59+HistoricalData!D61,HistoricalData!D121+HistoricalData!D123)","v":0}]
[]
["Net Cash After Investing Activities",null,null,{"$f":"D22-D24+D25","v":0},{"$f":"E22-E24+E25","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Interest & Fee Income/(Expense)",null,null,{"$f":"Income!D33","v":0},{"$f":"Income!F33","v":0},{"$f":"Income!H33","v":0},{"$f":"Income!J33","v":0},{"$f":"Income!L33","v":0},{"$f":"Income!N33","v":0},{"$f":"Income!P33","v":0},{"$f":"Income!R33","v":0},{"$f":"Income!T33","v":0},{"$f":"Income!V33","v":0},{"$f":"Income!X33","v":0},{"$f":"Income!Z33","v":0},{"$f":"Income!AB33","v":0},{"$f":"Income!AD33","v":0}]
["Dividends Paid",null,null,{"$f":"Income!D41","v":0},{"$f":"Income!F41","v":0},{"$f":"Income!H41","v":0},{"$f":"Income!J41","v":0},{"$f":"Income!L41","v":0},{"$f":"Income!N41","v":0},{"$f":"Income!P41","v":0},{"$f":"Income!R41","v":0},{"$f":"Income!T41","v":0},{"$f":"Income!V41","v":0},{"$f":"Income!X41","v":0},{"$f":"Income!Z41","v":0},{"$f":"Income!AB41","v":0},{"$f":"Income!AD41","v":0}]
["Short Term Debt Inflow/(Outflow)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D33-HistoricalData!C33,HistoricalData!D96-HistoricalData!C96-(HistoricalData!C33/HistoricalData!D10-HistoricalData!C33/HistoricalData!C10))","v":0},{"$f":"Balance!E37-Balance!D37","v":0},{"$f":"Balance!F37-Balance!E37","v":0},{"$f":"Balance!G37-Balance!F37","v":0},{"$f":"Balance!H37-Balance!G37","v":0},{"$f":"Balance!I37-Balance!H37","v":0},{"$f":"Balance!J37-Balance!I37","v":0},{"$f":"Balance!K37-Balance!J37","v":0},{"$f":"Balance!L37-Balance!K37","v":0},{"$f":"Balance!M37-Balance!L37","v":0},{"$f":"Balance!N37-Balance!M37","v":0},{"$f":"Balance!O37-Balance!N37","v":0},{"$f":"Balance!P37-Balance!O37","v":0},{"$f":"Balance!Q37-Balance!P37","v":0}]
["LT Senior Debt Inflow/(Outflow)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,(HistoricalData!D34+HistoricalData!D37)-(HistoricalData!C34+HistoricalData!C37),(HistoricalData!D97+HistoricalData!D100)-(HistoricalData!C97+HistoricalData!C100)-((HistoricalData!C34+HistoricalData!C37)/HistoricalData!D10-(HistoricalData!C34+HistoricalData!C37)/HistoricalData!C10))","v":0},{"$f":"Balance!E38+Balance!E42-Balance!D38-Balance!D42","v":0},{"$f":"Balance!F38+Balance!F42-Balance!E38-Balance!E42","v":0},{"$f":"Balance!G38+Balance!G42-Balance!F38-Balance!F42","v":0},{"$f":"Balance!H38+Balance!H42-Balance!G38-Balance!G42","v":0},{"$f":"Balance!I38+Balance!I42-Balance!H38-Balance!H42","v":0},{"$f":"Balance!J38+Balance!J42-Balance!I38-Balance!I42","v":0},{"$f":"Balance!K38+Balance!K42-Balance!J38-Balance!J42","v":0},{"$f":"Balance!L38+Balance!L42-Balance!K38-Balance!K42","v":0},{"$f":"Balance!M38+Balance!M42-Balance!L38-Balance!L42","v":0},{"$f":"Balance!N38+Balance!N42-Balance!M38-Balance!M42","v":0},{"$f":"Balance!O38+Balance!O42-Balance!N38-Balance!N42","v":0},{"$f":"Balance!P38+Balance!P42-Balance!O38-Balance!O42","v":0},{"$f":"Balance!Q38+Balance!Q42-Balance!P38-Balance!P42","v":0}]
["Subordinated Debt Inflow/(Outflow)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D38-HistoricalData!C38,HistoricalData!D101-HistoricalData!C101-(HistoricalData!C38/HistoricalData!D10-HistoricalData!C38/HistoricalData!C10))","v":0},{"$f":"Balance!E43-Balance!D43","v":0},{"$f":"Balance!F43-Balance!E43","v":0},{"$f":"Balance!G43-Balance!F43","v":0},{"$f":"Balance!H43-Balance!G43","v":0},{"$f":"Balance!I43-Balance!H43","v":0},{"$f":"Balance!J43-Balance!I43","v":0},{"$f":"Balance!K43-Balance!J43","v":0},{"$f":"Balance!L43-Balance!K43","v":0},{"$f":"Balance!M43-Balance!L43","v":0},{"$f":"Balance!N43-Balance!M43","v":0},{"$f":"Balance!O43-Balance!N43","v":0},{"$f":"Balance!P43-Balance!O43","v":0},{"$f":"Balance!Q43-Balance!P43","v":0}]
["Change in other LT Liabilities",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D39-HistoricalData!C39,HistoricalData!D102-HistoricalData!C102-(HistoricalData!C39/HistoricalData!D10-HistoricalData!C39/HistoricalData!C10))","v":0},{"$f":"Balance!E44-Balance!D44","v":0},{"$f":"Balance!F44-Balance!E44","v":0},{"$f":"Balance!G44-Balance!F44","v":0},{"$f":"Balance!H44-Balance!G44","v":0},{"$f":"Balance!I44-Balance!H44","v":0},{"$f":"Balance!J44-Balance!I44","v":0},{"$f":"Balance!K44-Balance!J44","v":0},{"$f":"Balance!L44-Balance!K44","v":0},{"$f":"Balance!M44-Balance!L44","v":0},{"$f":"Balance!N44-Balance!M44","v":0},{"$f":"Balance!O44-Balance!N44","v":0},{"$f":"Balance!P44-Balance!O44","v":0},{"$f":"Balance!Q44-Balance!P44","v":0}]
["Equity Inflow/(Outflow)",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D42:D43)-SUM(HistoricalData!C42:C43),SUM(HistoricalData!D105:D106)-SUM(HistoricalData!C105:C106)-(SUM(HistoricalData!C42:C43)/HistoricalData!D10-SUM(HistoricalData!C42:C43)/HistoricalData!C10))","v":0},{"$f":"Balance!E48-Balance!D48","v":0},{"$f":"Balance!F48-Balance!E48","v":0},{"$f":"Balance!G48-Balance!F48","v":0},{"$f":"Balance!H48-Balance!G48","v":0},{"$f":"Balance!I48-Balance!H48","v":0},{"$f":"Balance!J48-Balance!I48","v":0},{"$f":"Balance!K48-Balance!J48","v":0},{"$f":"Balance!L48-Balance!K48","v":0},{"$f":"Balance!M48-Balance!L48","v":0},{"$f":"Balance!N48-Balance!M48","v":0},{"$f":"Balance!O48-Balance!N48","v":0},{"$f":"Balance!P48-Balance!O48","v":0},{"$f":"Balance!Q48-Balance!P48","v":0}]
[]
["Net Cash After Financing Activities",null,null,{"$f":"D27+D29-D30+SUM(D31:D35)","v":0},{"$f":"E27+E29-E30+SUM(E31:E35)","v":0},{"$f":"F27+F29-F30+SUM(F31:F35)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[" "]
["Beginning Cash",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!C14,HistoricalData!C77+(HistoricalData!C14/HistoricalData!D10-HistoricalData!C14/HistoricalData!C10))","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0},0,0,0,0,0,0,0,{"$f":"M42","v":0},{"$f":"N42","v":0},{"$f":"O42","v":0},{"$f":"P42","v":0}]
["Change in Cash",null,null,{"$f":"D37","v":0},{"$f":"E37","v":0},0,0,0,0,0,0,0,{"$f":"M37","v":0},{"$f":"N37","v":0},{"$f":"O37","v":0},{"$f":"P37","v":0},{"$f":"Q37","v":0}]
["Cash (to)/from debt reserve",null,null,null,{"$f":"-((Assumptions!E96)/12)*Assumptions!D171","v":0},{"$f":"-((Assumptions!F96)/12)*Assumptions!E171-SUM($E$41:E41)","v":0},{"$f":"-((Assumptions!G96)/12)*Assumptions!F171-SUM($E$41:F41)","v":0},{"$f":"-((Assumptions!H96)/12)*Assumptions!G171-SUM($E$41:G41)","v":0},{"$f":"-((Assumptions!I96)/12)*Assumptions!H171-SUM($E$41:H41)","v":0},{"$f":"-((Assumptions!J96)/12)*Assumptions!I171-SUM($E$41:I41)","v":0},{"$f":"-((Assumptions!K96)/12)*Assumptions!J171-SUM($E$41:J41)","v":0},{"$f":"-((Assumptions!L96)/12)*Assumptions!K171-SUM($E$41:K41)","v":0},{"$f":"-((Assumptions!M96)/12)*Assumptions!L171-SUM($E$41:L41)","v":0},{"$f":"-((Assumptions!N96)/12)*Assumptions!M171-SUM($E$41:M41)","v":0},{"$f":"-((Assumptions!O96)/12)*Assumptions!N171-SUM($E$41:N41)","v":0},{"$f":"-((Assumptions!P96)/12)*Assumptions!O171-SUM($E$41:O41)","v":0},{"$f":"-((Assumptions!Q96)/12)*Assumptions!P171-SUM($E$41:P41)","v":0}]
["Ending Cash",null,null,{"$f":"D39+D40+D41","v":0},0,0,0,0,0,0,0,0,0,{"$f":"N39+N40+N41","v":0},{"$f":"O39+O40+O41","v":0},{"$f":"P39+P40+P41","v":0},{"$f":"Q39+Q40+Q41","v":0}]
[]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,{"$f":"Assumptions!D2","v":"Sample Company"}]
["Debt Service Coverages/Cash Available for Debt Service (CADS)"]
[]
["Operating Debt Service Coverage"]
[]
["Net Cash After Operations",null,null,{"$f":"D22","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,{"$f":"M22","v":0},{"$f":"N22","v":0},{"$f":"O22","v":0},{"$f":"P22","v":0},{"$f":"Q22","v":0}]
["(Operating CADS)"]
[]
["Net Interest & Fee Expense",null,null,{"$f":"IF(D29<0,-D29,0)","v":0},{"$f":"IF(E29<0,-E29,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Principal Payments",null,null,{"$f":"IF(SUM(D31:D33)<0,-SUM(D31:D33),0)","v":0},{"$f":"IF(SUM(E31:E33)<0,-SUM(E31:E33),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Total Debt Service",null,null,{"$f":"SUM(D53:D54)","v":0},{"$f":"SUM(E53:E54)","v":0},{"$f":"SUM(F53:F54)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(N53:N54)","v":0},{"$f":"SUM(O53:O54)","v":0},{"$f":"SUM(P53:P54)","v":0},{"$f":"SUM(Q53:Q54)","v":0}]
[]
["Operating CADS/Interest & Fee",null,null,{"$f":"IF(ISERROR(D50/D53),\"N/A\",D50/D53)","v":"N/A"},{"$f":"IF(ISERROR(E50/E53),\"N/A\",E50/E53)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Operating CADS/Principal",null,null,{"$f":"IF(ISERROR(D50/D54),\"N/A\",D50/D54)","v":"N/A"},{"$f":"IF(ISERROR(E50/E54),\"N/A\",E50/E54)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Operating CADS/Total Debt Service",null,null,{"$f":"IF(ISERROR(D50/D55),\"N/A\",D50/D55)","v":"N/A"},{"$f":"IF(ISERROR(E50/E55),\"N/A\",E50/E55)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Average Debt Service Coverage",null,null,null,{"$f":"IF(ISERROR(AVERAGE(E59:Q59)),\"N/A\",AVERAGE(E59:Q59))","v":"N/A"}]
[]
["Total Debt Service Coverage"]
["Net Cash Flow",null,null,{"$f":"D37","v":0},{"$f":"E37","v":0},0,0,0,0,0,0,0,{"$f":"M37","v":0},{"$f":"N37","v":0},{"$f":"O37","v":0},{"$f":"P37","v":0},{"$f":"Q37","v":0}]
["+Interest & Fee Expense",null,null,{"$f":"IF(D29<0,-D29,0)","v":0},{"$f":"IF(E29<0,-E29,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["+Principal Repayment",null,null,{"$f":"IF(SUM(D31:D33)<0,-SUM(D31:D33),0)","v":0},{"$f":"IF(SUM(E31:E33)<0,-SUM(E31:E33),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["+Dividends Paid",null,null,{"$f":"D30","v":0},{"$f":"E30","v":0},{"$f":"F30","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total CADS",null,null,{"$f":"SUM(D63:D66)","v":0},{"$f":"SUM(E63:E66)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(N63:N66)","v":0},{"$f":"SUM(O63:O66)","v":0},{"$f":"SUM(P63:P66)","v":0},{"$f":"SUM(Q63:Q66)","v":0}]
[]
["Interest & Fee Expense",null,null,{"$f":"D64","v":0},{"$f":"E64","v":0},0,0,0,0,0,0,0,{"$f":"M64","v":0},0,0,{"$f":"P64","v":0},{"$f":"Q64","v":0}]
["Principal Repayment",null,null,{"$f":"D65","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"P65","v":0},{"$f":"Q65","v":0}]
["Total Debt Service",null,null,{"$f":"D69+D70","v":0},{"$f":"E69+E70","v":0},0,0,0,0,0,0,0,0,{"$f":"N69+N70","v":0},{"$f":"O69+O70","v":0},{"$f":"P69+P70","v":0},{"$f":"Q69+Q70","v":0}]
[null,null,null,null," "]
["Total CADS/Interest+Fee",null,null,{"$f":"IF(ISERROR(D67/D69),\"N/A\",D67/D69)","v":"N/A"},{"$f":"IF(ISERROR(E67/E69),\"N/A\",E67/E69)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Total CADS/Scheduled Principal",null,null,{"$f":"IF(ISERROR(D67/D70),\"N/A\",D67/D70)","v":"N/A"},{"$f":"IF(ISERROR(E67/E70),\"N/A\",E67/E70)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Total CADS/Total Debt Service",null,null,{"$f":"IF(ISERROR(D67/D71),\"N/A\",D67/D71)","v":"N/A"},{"$f":"IF(ISERROR(E67/E71),\"N/A\",E67/E71)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Average Debt Service Coverage",null,null,null,{"$f":"IF(ISERROR(AVERAGE(E75:Q75)),\"N/A\",AVERAGE(E75:Q75))","v":"N/A"}]
[]
[]
["Discounted Cash Flow (DCF)/Net Present Value (NPV) Analysis"]
[]
["Project Value/Returns"]
["Equity and Debt Invested",null,null,null,{"$f":"-(IF(E32>0,E32,0)+IF(E33>0,E33,0)+IF(E35>0,E35,0))","v":0},{"$f":"-(IF(F32>0,F32,0)+IF(F33>0,F33,0)+IF(F35>0,F35,0))","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Net Cash After Operations",null,null,null,{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Net (Outflow)/Inflow",null,null,null,{"$f":"E82+E83","v":0},{"$f":"F82+F83","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Weighted average cost of capital",null,null,null,{"$f":"Assumptions!B181","v":{"$error":"#DIV/0!"}}]
["Internal Rate of Return",null,null,null,{"$f":"IRR(E84:Q84)","v":{"$error":"#NUM!"}}]
["Net Present Value",null,null,null,{"$f":"E84+NPV(E85,F84:Q84)","v":{"$error":"#DIV/0!"}}]
[]
["Equity Value/Returns"]
["Equity Invested",null,null,null,{"$f":"-(IF(E35>0,E35,0))","v":0},{"$f":"-F35","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Dividends Paid",null,null,null,{"$f":"E30","v":0},{"$f":"F30","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Terminal Value"]
["Net (Outflow/Inflow)",null,null,null,{"$f":"SUM(E90:E92)","v":0},{"$f":"SUM(F90:F92)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Cost of Equity",null,null,null,{"$f":"Assumptions!B180","v":0.2}]
["Internal Rate of Return",null,null,null,{"$f":"IRR(E93:Q93)","v":{"$error":"#NUM!"}}]
["Net Present Value",null,null,null,{"$f":"E93+NPV(E94,F93:Q93)","v":0}]
[]
["Working Capital Analysis"]
["Increase/(Decrease) in Receivables",null,null,{"$f":"-D6","v":0},{"$f":"-E6","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Increase/(Decrease) in Inventory",null,null,{"$f":"D10","v":0},{"$f":"E10","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["(Increase)/Decrease in Payables",null,null,{"$f":"D11","v":0},{"$f":"E11","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Net Working Capital Cost",null,null,{"$f":"SUM(D99:D101)","v":0},{"$f":"SUM(E99:E101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Balance","index":6,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,7,0,11]]}
[null,null,null,null,null,null,null,{"$f":"Start!C6","v":"Sample Company"}]
["Calendar Year",null,null,{"$f":"HistoricalData!D6","v":2021},{"$f":"Assumptions!D1","v":2022},{"$f":"E2+1","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L2+1","v":2030},{"$f":"M2+1","v":2031},{"$f":"N2+1","v":2032},{"$f":"O2+1","v":2033},{"$f":"P2+1","v":2034}]
[null,null,null,"Actual","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected"]
["Assets",null,null,null,{"$f":"IF(OR(E7<0,F7<0,G7<0,H7<0,I7<0,J7<0,K7<0,L7<0,M7<0,N7<0,O7<0,P7<0,Q7<0),\"WARNING:  CASH BALANCE IS NEGATIVE IN ONE OR MORE PERIODS\",\"   \")","v":"   "}]
[]
["Current Assets"]
["Cash",null,null,{"$f":"CashFlow!D42","v":0},{"$f":"CashFlow!E42","v":0},{"$f":"CashFlow!F42","v":0},{"$f":"CashFlow!G42","v":0},{"$f":"CashFlow!H42","v":0},{"$f":"CashFlow!I42","v":0},{"$f":"CashFlow!J42","v":0},{"$f":"CashFlow!K42","v":0},{"$f":"CashFlow!L42","v":0},{"$f":"CashFlow!M42","v":0},{"$f":"CashFlow!N42","v":0},{"$f":"CashFlow!O42","v":0},{"$f":"CashFlow!P42","v":0},{"$f":"CashFlow!Q42","v":0}]
["Debt Service Reserve/Restricted Cash",null,null,null,{"$f":"-CashFlow!E41","v":0},{"$f":"E8-CashFlow!F41","v":0},{"$f":"F8-CashFlow!G41","v":0},{"$f":"G8-CashFlow!H41","v":0},{"$f":"H8-CashFlow!I41","v":0},{"$f":"I8-CashFlow!J41","v":0},{"$f":"J8-CashFlow!K41","v":0},{"$f":"K8-CashFlow!L41","v":0},{"$f":"L8-CashFlow!M41","v":0},{"$f":"M8-CashFlow!N41","v":0},{"$f":"N8-CashFlow!O41","v":0},{"$f":"O8-CashFlow!P41","v":0},{"$f":"P8-CashFlow!Q41","v":0}]
["Accounts Receivable",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D15:D16),SUM(HistoricalData!D78:D79))","v":0},{"$f":"(Income!F10/360)*Assumptions!D168","v":0},{"$f":"(Income!H10/360)*Assumptions!E168","v":0},{"$f":"(Income!J10/360)*Assumptions!F168","v":0},{"$f":"(Income!L10/360)*Assumptions!G168","v":0},{"$f":"(Income!N10/360)*Assumptions!H168","v":0},{"$f":"(Income!P10/360)*Assumptions!I168","v":0},{"$f":"(Income!R10/360)*Assumptions!J168","v":0},{"$f":"(Income!T10/360)*Assumptions!K168","v":0},{"$f":"(Income!V10/360)*Assumptions!L168","v":0},{"$f":"(Income!X10/360)*Assumptions!M168","v":0},{"$f":"(Income!Z10/360)*Assumptions!N168","v":0},{"$f":"(Income!AB10/360)*Assumptions!O168","v":0},{"$f":"(Income!AD10/360)*Assumptions!P168","v":0}]
["Inventory",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D17,HistoricalData!D80)","v":0},{"$f":"(Income!F12/360)*Assumptions!D169","v":0},{"$f":"(Income!H12/360)*Assumptions!E169","v":0},{"$f":"(Income!J12/360)*Assumptions!F169","v":0},{"$f":"(Income!L12/360)*Assumptions!G169","v":0},{"$f":"(Income!N12/360)*Assumptions!H169","v":0},{"$f":"(Income!P12/360)*Assumptions!I169","v":0},{"$f":"(Income!R12/360)*Assumptions!J169","v":0},{"$f":"(Income!T12/360)*Assumptions!K169","v":0},{"$f":"(Income!V12/360)*Assumptions!L169","v":0},{"$f":"(Income!X12/360)*Assumptions!M169","v":0},{"$f":"(Income!Z12/360)*Assumptions!N169","v":0},{"$f":"(Income!AB12/360)*Assumptions!O169","v":0},{"$f":"(Income!AD12/360)*Assumptions!P169","v":0}]
[]
[]
["Total Current Assets",null,null,{"$f":"SUM(D7:D12)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N7:N12)","v":0},{"$f":"SUM(O7:O12)","v":0},{"$f":"SUM(P7:P12)","v":0},{"$f":"SUM(Q7:Q12)","v":0}]
[]
["Non-Current Assets"]
["Pre-existing Fixed Assets",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D19:D26),SUM(HistoricalData!D82:D89))","v":0},{"$f":"D16","v":0},{"$f":"E16","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Assumptions!A58","v":"Expense Line Item 1"},null,null,null,{"$f":"Assumptions!D58","v":0},{"$f":"E17+Assumptions!E58","v":0},{"$f":"F17+Assumptions!F58","v":0},{"$f":"G17+Assumptions!G58","v":0},{"$f":"H17+Assumptions!H58","v":0},{"$f":"I17+Assumptions!I58","v":0},{"$f":"J17+Assumptions!J58","v":0},{"$f":"K17+Assumptions!K58","v":0},{"$f":"L17+Assumptions!L58","v":0},{"$f":"M17+Assumptions!M58","v":0},{"$f":"N17+Assumptions!N58","v":0},{"$f":"O17+Assumptions!O58","v":0},{"$f":"P17+Assumptions!P58","v":0}]
[{"$f":"Assumptions!A59","v":"Expense Line Item 2"},null,null,null,{"$f":"Assumptions!D59","v":0},{"$f":"E18+Assumptions!E59","v":0},{"$f":"F18+Assumptions!F59","v":0},{"$f":"G18+Assumptions!G59","v":0},{"$f":"H18+Assumptions!H59","v":0},{"$f":"I18+Assumptions!I59","v":0},{"$f":"J18+Assumptions!J59","v":0},{"$f":"K18+Assumptions!K59","v":0},{"$f":"L18+Assumptions!L59","v":0},{"$f":"M18+Assumptions!M59","v":0},{"$f":"N18+Assumptions!N59","v":0},{"$f":"O18+Assumptions!O59","v":0},{"$f":"P18+Assumptions!P59","v":0}]
[{"$f":"Assumptions!A60","v":"Expense Line Item 3"},null,null,null,{"$f":"Assumptions!D60","v":0},{"$f":"E19+Assumptions!E60","v":0},{"$f":"F19+Assumptions!F60","v":0},{"$f":"G19+Assumptions!G60","v":0},{"$f":"H19+Assumptions!H60","v":0},{"$f":"I19+Assumptions!I60","v":0},{"$f":"J19+Assumptions!J60","v":0},{"$f":"K19+Assumptions!K60","v":0},{"$f":"L19+Assumptions!L60","v":0},{"$f":"M19+Assumptions!M60","v":0},{"$f":"N19+Assumptions!N60","v":0},{"$f":"O19+Assumptions!O60","v":0},{"$f":"P19+Assumptions!P60","v":0}]
[{"$f":"Assumptions!A61","v":"Expense Line Item 4"},null,null,null,{"$f":"Assumptions!D61","v":0},{"$f":"E20+Assumptions!E61","v":0},{"$f":"F20+Assumptions!F61","v":0},{"$f":"G20+Assumptions!G61","v":0},{"$f":"H20+Assumptions!H61","v":0},{"$f":"I20+Assumptions!I61","v":0},{"$f":"J20+Assumptions!J61","v":0},{"$f":"K20+Assumptions!K61","v":0},{"$f":"L20+Assumptions!L61","v":0},{"$f":"M20+Assumptions!M61","v":0},{"$f":"N20+Assumptions!N61","v":0},{"$f":"O20+Assumptions!O61","v":0},{"$f":"P20+Assumptions!P61","v":0}]
[{"$f":"Assumptions!A62","v":"Expense Line Item 5"},null,null,null,{"$f":"Assumptions!D62","v":0},{"$f":"E21+Assumptions!E62","v":0},{"$f":"F21+Assumptions!F62","v":0},{"$f":"G21+Assumptions!G62","v":0},{"$f":"H21+Assumptions!H62","v":0},{"$f":"I21+Assumptions!I62","v":0},{"$f":"J21+Assumptions!J62","v":0},{"$f":"K21+Assumptions!K62","v":0},{"$f":"L21+Assumptions!L62","v":0},{"$f":"M21+Assumptions!M62","v":0},{"$f":"N21+Assumptions!N62","v":0},{"$f":"O21+Assumptions!O62","v":0},{"$f":"P21+Assumptions!P62","v":0}]
[{"$f":"Assumptions!A63","v":"Expense Line Item 6"},null,null,null,{"$f":"Assumptions!D63","v":0},{"$f":"E22+Assumptions!E63","v":0},{"$f":"F22+Assumptions!F63","v":0},{"$f":"G22+Assumptions!G63","v":0},{"$f":"H22+Assumptions!H63","v":0},{"$f":"I22+Assumptions!I63","v":0},{"$f":"J22+Assumptions!J63","v":0},{"$f":"K22+Assumptions!K63","v":0},{"$f":"L22+Assumptions!L63","v":0},{"$f":"M22+Assumptions!M63","v":0},{"$f":"N22+Assumptions!N63","v":0},{"$f":"O22+Assumptions!O63","v":0},{"$f":"P22+Assumptions!P63","v":0}]
[{"$f":"Assumptions!A64","v":"Expense Line Item 7"},null,null,null,{"$f":"Assumptions!D64","v":0},{"$f":"E23+Assumptions!E64","v":0},{"$f":"F23+Assumptions!F64","v":0},{"$f":"G23+Assumptions!G64","v":0},{"$f":"H23+Assumptions!H64","v":0},{"$f":"I23+Assumptions!I64","v":0},{"$f":"J23+Assumptions!J64","v":0},{"$f":"K23+Assumptions!K64","v":0},{"$f":"L23+Assumptions!L64","v":0},{"$f":"M23+Assumptions!M64","v":0},{"$f":"N23+Assumptions!N64","v":0},{"$f":"O23+Assumptions!O64","v":0},{"$f":"P23+Assumptions!P64","v":0}]
[{"$f":"Assumptions!A65","v":"Expense Line Item 8"},null,null,null,{"$f":"Assumptions!D65","v":0},{"$f":"E24+Assumptions!E65","v":0},{"$f":"F24+Assumptions!F65","v":0},{"$f":"G24+Assumptions!G65","v":0},{"$f":"H24+Assumptions!H65","v":0},{"$f":"I24+Assumptions!I65","v":0},{"$f":"J24+Assumptions!J65","v":0},{"$f":"K24+Assumptions!K65","v":0},{"$f":"L24+Assumptions!L65","v":0},{"$f":"M24+Assumptions!M65","v":0},{"$f":"N24+Assumptions!N65","v":0},{"$f":"O24+Assumptions!O65","v":0},{"$f":"P24+Assumptions!P65","v":0}]
[{"$f":"Assumptions!A66","v":"Expense Line Item 9"},null,null,null,{"$f":"Assumptions!D66","v":0},{"$f":"E25+Assumptions!E66","v":0},{"$f":"F25+Assumptions!F66","v":0},{"$f":"G25+Assumptions!G66","v":0},{"$f":"H25+Assumptions!H66","v":0},{"$f":"I25+Assumptions!I66","v":0},{"$f":"J25+Assumptions!J66","v":0},{"$f":"K25+Assumptions!K66","v":0},{"$f":"L25+Assumptions!L66","v":0},{"$f":"M25+Assumptions!M66","v":0},{"$f":"N25+Assumptions!N66","v":0},{"$f":"O25+Assumptions!O66","v":0},{"$f":"P25+Assumptions!P66","v":0}]
[{"$f":"Assumptions!A67","v":"Expense Line Item 10"},null,null,null,{"$f":"Assumptions!D67","v":0},{"$f":"E26+Assumptions!E67","v":0},{"$f":"F26+Assumptions!F67","v":0},{"$f":"G26+Assumptions!G67","v":0},{"$f":"H26+Assumptions!H67","v":0},{"$f":"I26+Assumptions!I67","v":0},{"$f":"J26+Assumptions!J67","v":0},{"$f":"K26+Assumptions!K67","v":0},{"$f":"L26+Assumptions!L67","v":0},{"$f":"M26+Assumptions!M67","v":0},{"$f":"N26+Assumptions!N67","v":0},{"$f":"O26+Assumptions!O67","v":0},{"$f":"P26+Assumptions!P67","v":0}]
["Accumulated Depreciation",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D27,HistoricalData!D90)","v":0},{"$f":"D27-Assumptions!D165","v":0},{"$f":"E27-Assumptions!E165","v":0},{"$f":"F27-Assumptions!F165","v":0},{"$f":"G27-Assumptions!G165","v":0},{"$f":"H27-Assumptions!H165","v":0},{"$f":"I27-Assumptions!I165","v":0},{"$f":"J27-Assumptions!J165","v":0},{"$f":"K27-Assumptions!K165","v":0},{"$f":"L27-Assumptions!L165","v":0},{"$f":"M27-Assumptions!M165","v":0},{"$f":"N27-Assumptions!N165","v":0},{"$f":"O27-Assumptions!O165","v":0},{"$f":"P27-Assumptions!P165","v":0}]
["Total Non-Current Assets",null,null,{"$f":"SUM(D16:D27)","v":0},{"$f":"SUM(E16:E27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Assets",null,null,{"$f":"D13+D28","v":0},0,0,0,0,0,0,0,0,{"$f":"M13+M28","v":0},{"$f":"N13+N28","v":0},{"$f":"O13+O28","v":0},{"$f":"P13+P28","v":0},{"$f":"Q13+Q28","v":0}]
[]
[]
["Liabilities and Net Worth"]
[]
["Current Liabilities"]
["Accounts Payable",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D32,HistoricalData!D95)","v":0},{"$f":"((Income!F12+Income!F25)/360)*Assumptions!D170","v":0},{"$f":"((Income!H12+Income!H25)/360)*Assumptions!E170","v":0},{"$f":"((Income!J12+Income!J25)/360)*Assumptions!F170","v":0},{"$f":"((Income!L12+Income!L25)/360)*Assumptions!G170","v":0},{"$f":"((Income!N12+Income!N25)/360)*Assumptions!H170","v":0},{"$f":"((Income!P12+Income!P25)/360)*Assumptions!I170","v":0},{"$f":"((Income!R12+Income!R25)/360)*Assumptions!J170","v":0},{"$f":"((Income!T12+Income!T25)/360)*Assumptions!K170","v":0},{"$f":"((Income!V12+Income!V25)/360)*Assumptions!L170","v":0},{"$f":"((Income!X12+Income!X25)/360)*Assumptions!M170","v":0},{"$f":"((Income!Z12+Income!Z25)/360)*Assumptions!N170","v":0},{"$f":"((Income!AB12+Income!AB25)/360)*Assumptions!O170","v":0},{"$f":"((Income!AD12+Income!AD25)/360)*Assumptions!P170","v":0}]
["Short Term Debt",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D33,HistoricalData!D96)","v":0},{"$f":"Assumptions!D121","v":0},{"$f":"Assumptions!E121","v":0},{"$f":"Assumptions!F121","v":0},{"$f":"Assumptions!G121","v":0},{"$f":"Assumptions!H121","v":0},{"$f":"Assumptions!I121","v":0},{"$f":"Assumptions!J121","v":0},{"$f":"Assumptions!K121","v":0},{"$f":"Assumptions!L121","v":0},{"$f":"Assumptions!M121","v":0},{"$f":"Assumptions!N121","v":0},{"$f":"Assumptions!O121","v":0},{"$f":"Assumptions!P121","v":0}]
["Current Portion -- Long Term Debt",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D34,HistoricalData!D97)","v":0},{"$f":"Assumptions!E95+Assumptions!E107","v":0},{"$f":"Assumptions!F95+Assumptions!F107","v":0},{"$f":"Assumptions!G95+Assumptions!G107","v":0},{"$f":"Assumptions!H95+Assumptions!H107","v":0},{"$f":"Assumptions!I95+Assumptions!I107","v":0},{"$f":"Assumptions!J95+Assumptions!J107","v":0},{"$f":"Assumptions!K95+Assumptions!K107","v":0},{"$f":"Assumptions!L95+Assumptions!L107","v":0},{"$f":"Assumptions!M95+Assumptions!M107","v":0},{"$f":"Assumptions!N95+Assumptions!N107","v":0},{"$f":"Assumptions!O95+Assumptions!O107","v":0},{"$f":"Assumptions!P95+Assumptions!P107","v":0},{"$f":"Assumptions!Q95+Assumptions!Q107","v":0}]
["Total Current Liabilities",null,null,{"$f":"SUM(D36:D38)","v":0},{"$f":"SUM(E36:E38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Non-Current Liabilities"]
["Long Term Debt-Senior",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D37,HistoricalData!D100)","v":0},{"$f":"Assumptions!D97+Assumptions!D109-E38","v":0},{"$f":"Assumptions!E97+Assumptions!E109-F38","v":0},{"$f":"Assumptions!F97+Assumptions!F109-G38","v":0},{"$f":"Assumptions!G97+Assumptions!G109-H38","v":0},{"$f":"Assumptions!H97+Assumptions!H109-I38","v":0},{"$f":"Assumptions!I97+Assumptions!I109-J38","v":0},{"$f":"Assumptions!J97+Assumptions!J109-K38","v":0},{"$f":"Assumptions!K97+Assumptions!K109-L38","v":0},{"$f":"Assumptions!L97+Assumptions!L109-M38","v":0},{"$f":"Assumptions!M97+Assumptions!M109-N38","v":0},{"$f":"Assumptions!N97+Assumptions!N109-O38","v":0},{"$f":"Assumptions!O97+Assumptions!O109-P38","v":0},{"$f":"Assumptions!P97+Assumptions!P109-Q38","v":0}]
["Subordinated Debt",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D38,HistoricalData!D101)","v":0},{"$f":"Assumptions!D132","v":0},{"$f":"Assumptions!E132","v":0},{"$f":"Assumptions!F132","v":0},{"$f":"Assumptions!G132","v":0},{"$f":"Assumptions!H132","v":0},{"$f":"Assumptions!I132","v":0},{"$f":"Assumptions!J132","v":0},{"$f":"Assumptions!K132","v":0},{"$f":"Assumptions!L132","v":0},{"$f":"Assumptions!M132","v":0},{"$f":"Assumptions!N132","v":0},{"$f":"Assumptions!O132","v":0},{"$f":"Assumptions!P132","v":0}]
["Other Long Term Liabilities",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D39,HistoricalData!D102)","v":0},{"$f":"D44","v":0},{"$f":"E44","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total Non-Current Liabilities",null,null,{"$f":"SUM(D42:D44)","v":0},{"$f":"SUM(E42:E44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Worth/Stockholders Equity"]
["Stock and Paid in Capital",null,null,{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,SUM(HistoricalData!D42:D43),SUM(HistoricalData!D105:D106))","v":0},{"$f":"Assumptions!D138","v":0},{"$f":"Assumptions!E138","v":0},{"$f":"Assumptions!F138","v":0},{"$f":"Assumptions!G138","v":0},{"$f":"Assumptions!H138","v":0},{"$f":"Assumptions!I138","v":0},{"$f":"Assumptions!J138","v":0},{"$f":"Assumptions!K138","v":0},{"$f":"Assumptions!L138","v":0},{"$f":"Assumptions!M138","v":0},{"$f":"Assumptions!N138","v":0},{"$f":"Assumptions!O138","v":0},{"$f":"Assumptions!P138","v":0}]
["Retained Earnings",null," ",{"$f":"IF(ISBLANK(HistoricalData!$D$10)=TRUE,HistoricalData!D44,HistoricalData!D107)","v":0},{"$f":"D49+Income!F43","v":0},{"$f":"E49+Income!H43","v":0},{"$f":"F49+Income!J43","v":0},{"$f":"G49+Income!L43","v":0},{"$f":"H49+Income!N43","v":0},{"$f":"I49+Income!P43","v":0},{"$f":"J49+Income!R43","v":0},{"$f":"K49+Income!T43","v":0},{"$f":"L49+Income!V43","v":0},{"$f":"M49+Income!X43","v":0},{"$f":"N49+Income!Z43","v":0},{"$f":"O49+Income!AB43","v":0},{"$f":"P49+Income!AD43","v":0}]
["Total Net Worth",null,null,{"$f":"SUM(D48:D49)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N48:N49)","v":0},{"$f":"SUM(O48:O49)","v":0},{"$f":"SUM(P48:P49)","v":0},{"$f":"SUM(Q48:Q49)","v":0}]
[]
["Total Liabilites and Net Worth",null,null,{"$f":"D39+D45+D50","v":0},0,0,0,0,0,0,0,0,{"$f":"M39+M45+M50","v":0},{"$f":"N39+N45+N50","v":0},{"$f":"O39+O45+O50","v":0},{"$f":"P39+P45+P50","v":0},{"$f":"Q39+Q45+Q50","v":0}]
[]
[]
["Reconciliation",null,null,{"$f":"D30-D52","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"SourcesUses","index":7,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,6,0,10]]}
[null,null,null,null,null,null,{"$f":"Start!C6","v":"Sample Company"}]
["Calendar Year",null,null,{"$f":"Assumptions!D1","v":2022},{"$f":"D2+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,{"$f":"N2+1","v":2033},{"$f":"O2+1","v":2034}]
[null,null,null,"Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected"]
[]
["Uses of Funds"]
[]
[{"$f":"Assumptions!A58","v":"Expense Line Item 1"},null,null,{"$f":"Assumptions!D58","v":0},{"$f":"Assumptions!E58","v":0},{"$f":"Assumptions!F58","v":0},{"$f":"Assumptions!G58","v":0},{"$f":"Assumptions!H58","v":0},{"$f":"Assumptions!I58","v":0},{"$f":"Assumptions!J58","v":0},{"$f":"Assumptions!K58","v":0},{"$f":"Assumptions!L58","v":0},{"$f":"Assumptions!M58","v":0},{"$f":"Assumptions!N58","v":0},{"$f":"Assumptions!O58","v":0},{"$f":"Assumptions!P58","v":0}]
[{"$f":"Assumptions!A59","v":"Expense Line Item 2"},null,null,{"$f":"Assumptions!D59","v":0},{"$f":"Assumptions!E59","v":0},{"$f":"Assumptions!F59","v":0},{"$f":"Assumptions!G59","v":0},{"$f":"Assumptions!H59","v":0},{"$f":"Assumptions!I59","v":0},{"$f":"Assumptions!J59","v":0},{"$f":"Assumptions!K59","v":0},{"$f":"Assumptions!L59","v":0},{"$f":"Assumptions!M59","v":0},{"$f":"Assumptions!N59","v":0},{"$f":"Assumptions!O59","v":0},{"$f":"Assumptions!P59","v":0}]
[{"$f":"Assumptions!A60","v":"Expense Line Item 3"},null,null,{"$f":"Assumptions!D60","v":0},{"$f":"Assumptions!E60","v":0},{"$f":"Assumptions!F60","v":0},{"$f":"Assumptions!G60","v":0},{"$f":"Assumptions!H60","v":0},{"$f":"Assumptions!I60","v":0},{"$f":"Assumptions!J60","v":0},{"$f":"Assumptions!K60","v":0},{"$f":"Assumptions!L60","v":0},{"$f":"Assumptions!M60","v":0},{"$f":"Assumptions!N60","v":0},{"$f":"Assumptions!O60","v":0},{"$f":"Assumptions!P60","v":0}]
[{"$f":"Assumptions!A61","v":"Expense Line Item 4"},null,null,{"$f":"Assumptions!D61","v":0},{"$f":"Assumptions!E61","v":0},{"$f":"Assumptions!F61","v":0},{"$f":"Assumptions!G61","v":0},{"$f":"Assumptions!H61","v":0},{"$f":"Assumptions!I61","v":0},{"$f":"Assumptions!J61","v":0},{"$f":"Assumptions!K61","v":0},{"$f":"Assumptions!L61","v":0},{"$f":"Assumptions!M61","v":0},{"$f":"Assumptions!N61","v":0},{"$f":"Assumptions!O61","v":0},{"$f":"Assumptions!P61","v":0}]
[{"$f":"Assumptions!A62","v":"Expense Line Item 5"},null,null,{"$f":"Assumptions!D62","v":0},{"$f":"Assumptions!E62","v":0},{"$f":"Assumptions!F62","v":0},{"$f":"Assumptions!G62","v":0},{"$f":"Assumptions!H62","v":0},{"$f":"Assumptions!I62","v":0},{"$f":"Assumptions!J62","v":0},{"$f":"Assumptions!K62","v":0},{"$f":"Assumptions!L62","v":0},{"$f":"Assumptions!M62","v":0},{"$f":"Assumptions!N62","v":0},{"$f":"Assumptions!O62","v":0},{"$f":"Assumptions!P62","v":0}]
[{"$f":"Assumptions!A63","v":"Expense Line Item 6"},null,null,{"$f":"Assumptions!D63","v":0},{"$f":"Assumptions!E63","v":0},{"$f":"Assumptions!F63","v":0},{"$f":"Assumptions!G63","v":0},{"$f":"Assumptions!H63","v":0},{"$f":"Assumptions!I63","v":0},{"$f":"Assumptions!J63","v":0},{"$f":"Assumptions!K63","v":0},{"$f":"Assumptions!L63","v":0},{"$f":"Assumptions!M63","v":0},{"$f":"Assumptions!N63","v":0},{"$f":"Assumptions!O63","v":0},{"$f":"Assumptions!P63","v":0}]
[{"$f":"Assumptions!A64","v":"Expense Line Item 7"},null,null,{"$f":"Assumptions!D64","v":0},{"$f":"Assumptions!E64","v":0},{"$f":"Assumptions!F64","v":0},{"$f":"Assumptions!G64","v":0},{"$f":"Assumptions!H64","v":0},{"$f":"Assumptions!I64","v":0},{"$f":"Assumptions!J64","v":0},{"$f":"Assumptions!K64","v":0},{"$f":"Assumptions!L64","v":0},{"$f":"Assumptions!M64","v":0},{"$f":"Assumptions!N64","v":0},{"$f":"Assumptions!O64","v":0},{"$f":"Assumptions!P64","v":0}]
[{"$f":"Assumptions!A65","v":"Expense Line Item 8"},null,null,{"$f":"Assumptions!D65","v":0},{"$f":"Assumptions!E65","v":0},{"$f":"Assumptions!F65","v":0},{"$f":"Assumptions!G65","v":0},{"$f":"Assumptions!H65","v":0},{"$f":"Assumptions!I65","v":0},{"$f":"Assumptions!J65","v":0},{"$f":"Assumptions!K65","v":0},{"$f":"Assumptions!L65","v":0},{"$f":"Assumptions!M65","v":0},{"$f":"Assumptions!N65","v":0},{"$f":"Assumptions!O65","v":0},{"$f":"Assumptions!P65","v":0}]
[{"$f":"Assumptions!A66","v":"Expense Line Item 9"},null,null,{"$f":"Assumptions!D66","v":0},{"$f":"Assumptions!E66","v":0},{"$f":"Assumptions!F66","v":0},{"$f":"Assumptions!G66","v":0},{"$f":"Assumptions!H66","v":0},{"$f":"Assumptions!I66","v":0},{"$f":"Assumptions!J66","v":0},{"$f":"Assumptions!K66","v":0},{"$f":"Assumptions!L66","v":0},{"$f":"Assumptions!M66","v":0},{"$f":"Assumptions!N66","v":0},{"$f":"Assumptions!O66","v":0},{"$f":"Assumptions!P66","v":0}]
[{"$f":"Assumptions!A67","v":"Expense Line Item 10"},null,null,{"$f":"Assumptions!D67","v":0},{"$f":"Assumptions!E67","v":0},{"$f":"Assumptions!F67","v":0},{"$f":"Assumptions!G67","v":0},{"$f":"Assumptions!H67","v":0},{"$f":"Assumptions!I67","v":0},{"$f":"Assumptions!J67","v":0},{"$f":"Assumptions!K67","v":0},{"$f":"Assumptions!L67","v":0},{"$f":"Assumptions!M67","v":0},{"$f":"Assumptions!N67","v":0},{"$f":"Assumptions!O67","v":0},{"$f":"Assumptions!P67","v":0}]
["Project-Related Working Capital",null,null,{"$f":"IF(HLOOKUP(D2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(E2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(F2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(G2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(H2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(I2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(J2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(K2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(L2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(M2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(N2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(O2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0},{"$f":"IF(HLOOKUP(P2,CashFlow!$E$2:$Q$102,101)=MAX(CashFlow!$E$102:$Q$102),MAX(CashFlow!$E$102:$Q$102),0)","v":0}]
["Funding of Debt Service Reserve",null,null,{"$f":"IF(HLOOKUP(D2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(E2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(F2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(G2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(H2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(I2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(J2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(K2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(L2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(M2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(N2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(O2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0},{"$f":"IF(HLOOKUP(P2,Balance!$E$2:$Q$8,7)=MAX(Balance!$E$8:'Balance'!$Q$8),MAX(Balance!$E$8:'Balance'!$Q$8),0)","v":0}]
["Interest/Fees During Construction",null,null,{"$f":"IF(Income!F33<0,-Income!F33,0)","v":0},{"$f":"IF(Assumptions!D80<12,0,IF(Income!H33<0,-Income!H33,0))","v":0}]
["Contingency",null,null,{"$f":"IF(CashFlow!E42>0,CashFlow!E42,-CashFlow!E42)","v":0}]
["Annual Total",null,null,{"$f":"SUM(D7:D20)","v":0},{"$f":"SUM(E7:E20)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O7:O20)","v":0},{"$f":"SUM(P7:P20)","v":0}]
["Total Project Cost",null,null,{"$f":"SUM(D21:P21)","v":0}]
[]
[]
["Sources of Funds"]
[]
["DFC Debt Disbursements",null,null,{"$f":"Assumptions!D92","v":0},{"$f":"Assumptions!E92","v":0},{"$f":"Assumptions!F92","v":0},{"$f":"Assumptions!G92","v":0},{"$f":"Assumptions!H92","v":0},{"$f":"Assumptions!I92","v":0},{"$f":"Assumptions!J92","v":0},{"$f":"Assumptions!K92","v":0},{"$f":"Assumptions!L92","v":0},{"$f":"Assumptions!M92","v":0},{"$f":"Assumptions!N92","v":0},{"$f":"Assumptions!O92","v":0},{"$f":"Assumptions!P92","v":0}]
["Other LT and Subordinated Debt Disb",null,null,{"$f":"Assumptions!D104+Assumptions!D128","v":0},{"$f":"Assumptions!E104+Assumptions!E128","v":0},{"$f":"Assumptions!F104+Assumptions!F128","v":0},{"$f":"Assumptions!G104+Assumptions!G128","v":0},{"$f":"Assumptions!H104+Assumptions!H128","v":0},{"$f":"Assumptions!I104+Assumptions!I128","v":0},{"$f":"Assumptions!J104+Assumptions!J128","v":0},{"$f":"Assumptions!K104+Assumptions!K128","v":0},{"$f":"Assumptions!L104+Assumptions!L128","v":0},{"$f":"Assumptions!M104+Assumptions!M128","v":0},{"$f":"Assumptions!N104+Assumptions!N128","v":0},{"$f":"Assumptions!O104+Assumptions!O128","v":0},{"$f":"Assumptions!P104+Assumptions!P128","v":0}]
["New Equity Contributions",null,null,{"$f":"Assumptions!D137","v":0},{"$f":"Assumptions!E137","v":0},{"$f":"Assumptions!F137","v":0},{"$f":"Assumptions!G137","v":0},{"$f":"Assumptions!H137","v":0},{"$f":"Assumptions!I137","v":0},{"$f":"Assumptions!J137","v":0},{"$f":"Assumptions!K137","v":0},{"$f":"Assumptions!L137","v":0},{"$f":"Assumptions!M137","v":0},{"$f":"Assumptions!N137","v":0},{"$f":"Assumptions!O137","v":0},{"$f":"Assumptions!P137","v":0}]
["Annual Total",null,null,{"$f":"SUM(D27:D29)","v":0},{"$f":"SUM(E27:E29)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total Financing",null,null,{"$f":"SUM(D30:P30)","v":0}]

{"sheet":"Ratios","index":8,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,7,0,11]]}
[null,null,null,null,null,null,null,{"$f":"Start!C6","v":"Sample Company"}]
["Calendar Year",null,null,{"$f":"HistoricalData!D6","v":2021},{"$f":"Assumptions!D1","v":2022},{"$f":"E2+1","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L2+1","v":2030},{"$f":"M2+1","v":2031},{"$f":"N2+1","v":2032},{"$f":"O2+1","v":2033},{"$f":"P2+1","v":2034}]
[null,null,null,"Actual","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected","Projected"]
["Liquidity Ratios"]
["Quick Ratio",null,null,{"$f":"IF(ISERROR((Balance!D13-Balance!D10)/Balance!D39),\"  \",(Balance!D13-Balance!D10)/Balance!D39)","v":"  "},{"$f":"IF(ISERROR((Balance!E13-Balance!E10)/Balance!E39),\"  \",(Balance!E13-Balance!E10)/Balance!E39)","v":"  "},{"$f":"IF(ISERROR((Balance!F13-Balance!F10)/Balance!F39),\"  \",(Balance!F13-Balance!F10)/Balance!F39)","v":"  "},{"$f":"IF(ISERROR((Balance!G13-Balance!G10)/Balance!G39),\"  \",(Balance!G13-Balance!G10)/Balance!G39)","v":"  "},{"$f":"IF(ISERROR((Balance!H13-Balance!H10)/Balance!H39),\"  \",(Balance!H13-Balance!H10)/Balance!H39)","v":"  "},{"$f":"IF(ISERROR((Balance!I13-Balance!I10)/Balance!I39),\"  \",(Balance!I13-Balance!I10)/Balance!I39)","v":"  "},{"$f":"IF(ISERROR((Balance!J13-Balance!J10)/Balance!J39),\"  \",(Balance!J13-Balance!J10)/Balance!J39)","v":"  "},{"$f":"IF(ISERROR((Balance!K13-Balance!K10)/Balance!K39),\"  \",(Balance!K13-Balance!K10)/Balance!K39)","v":"  "},{"$f":"IF(ISERROR((Balance!L13-Balance!L10)/Balance!L39),\"  \",(Balance!L13-Balance!L10)/Balance!L39)","v":"  "},{"$f":"IF(ISERROR((Balance!M13-Balance!M10)/Balance!M39),\"  \",(Balance!M13-Balance!M10)/Balance!M39)","v":"  "},{"$f":"IF(ISERROR((Balance!N13-Balance!N10)/Balance!N39),\"  \",(Balance!N13-Balance!N10)/Balance!N39)","v":"  "},{"$f":"IF(ISERROR((Balance!O13-Balance!O10)/Balance!O39),\"  \",(Balance!O13-Balance!O10)/Balance!O39)","v":"  "},{"$f":"IF(ISERROR((Balance!P13-Balance!P10)/Balance!P39),\"  \",(Balance!P13-Balance!P10)/Balance!P39)","v":"  "},{"$f":"IF(ISERROR((Balance!Q13-Balance!Q10)/Balance!Q39),\"  \",(Balance!Q13-Balance!Q10)/Balance!Q39)","v":"  "}]
["Current Ratio",null,null,{"$f":"IF(ISERROR(Balance!D13/Balance!D39),\"  \",Balance!D13/Balance!D39)","v":"  "},{"$f":"IF(ISERROR(Balance!E13/Balance!E39),\"  \",Balance!E13/Balance!E39)","v":"  "},{"$f":"IF(ISERROR(Balance!F13/Balance!F39),\"  \",Balance!F13/Balance!F39)","v":"  "},{"$f":"IF(ISERROR(Balance!G13/Balance!G39),\"  \",Balance!G13/Balance!G39)","v":"  "},{"$f":"IF(ISERROR(Balance!H13/Balance!H39),\"  \",Balance!H13/Balance!H39)","v":"  "},{"$f":"IF(ISERROR(Balance!I13/Balance!I39),\"  \",Balance!I13/Balance!I39)","v":"  "},{"$f":"IF(ISERROR(Balance!J13/Balance!J39),\"  \",Balance!J13/Balance!J39)","v":"  "},{"$f":"IF(ISERROR(Balance!K13/Balance!K39),\"  \",Balance!K13/Balance!K39)","v":"  "},{"$f":"IF(ISERROR(Balance!L13/Balance!L39),\"  \",Balance!L13/Balance!L39)","v":"  "},{"$f":"IF(ISERROR(Balance!M13/Balance!M39),\"  \",Balance!M13/Balance!M39)","v":"  "},{"$f":"IF(ISERROR(Balance!N13/Balance!N39),\"  \",Balance!N13/Balance!N39)","v":"  "},{"$f":"IF(ISERROR(Balance!O13/Balance!O39),\"  \",Balance!O13/Balance!O39)","v":"  "},{"$f":"IF(ISERROR(Balance!P13/Balance!P39),\"  \",Balance!P13/Balance!P39)","v":"  "},{"$f":"IF(ISERROR(Balance!Q13/Balance!Q39),\"  \",Balance!Q13/Balance!Q39)","v":"  "}]
[]
["Leverage Ratios"]
["Debt/Equity",null,null,{"$f":"IF(ISERROR((Balance!D39+Balance!D45)/Balance!D50),\"   \",(Balance!D39+Balance!D45)/Balance!D50)","v":"   "},{"$f":"IF(ISERROR((Balance!E39+Balance!E45)/Balance!E50),\"   \",(Balance!E39+Balance!E45)/Balance!E50)","v":"   "},{"$f":"IF(ISERROR((Balance!F39+Balance!F45)/Balance!F50),\"   \",(Balance!F39+Balance!F45)/Balance!F50)","v":"   "},{"$f":"IF(ISERROR((Balance!G39+Balance!G45)/Balance!G50),\"   \",(Balance!G39+Balance!G45)/Balance!G50)","v":"   "},{"$f":"IF(ISERROR((Balance!H39+Balance!H45)/Balance!H50),\"   \",(Balance!H39+Balance!H45)/Balance!H50)","v":"   "},{"$f":"IF(ISERROR((Balance!I39+Balance!I45)/Balance!I50),\"   \",(Balance!I39+Balance!I45)/Balance!I50)","v":"   "},{"$f":"IF(ISERROR((Balance!J39+Balance!J45)/Balance!J50),\"   \",(Balance!J39+Balance!J45)/Balance!J50)","v":"   "},{"$f":"IF(ISERROR((Balance!K39+Balance!K45)/Balance!K50),\"   \",(Balance!K39+Balance!K45)/Balance!K50)","v":"   "},{"$f":"IF(ISERROR((Balance!L39+Balance!L45)/Balance!L50),\"   \",(Balance!L39+Balance!L45)/Balance!L50)","v":"   "},{"$f":"IF(ISERROR((Balance!M39+Balance!M45)/Balance!M50),\"   \",(Balance!M39+Balance!M45)/Balance!M50)","v":"   "},{"$f":"IF(ISERROR((Balance!N39+Balance!N45)/Balance!N50),\"   \",(Balance!N39+Balance!N45)/Balance!N50)","v":"   "},{"$f":"IF(ISERROR((Balance!O39+Balance!O45)/Balance!O50),\"   \",(Balance!O39+Balance!O45)/Balance!O50)","v":"   "},{"$f":"IF(ISERROR((Balance!P39+Balance!P45)/Balance!P50),\"   \",(Balance!P39+Balance!P45)/Balance!P50)","v":"   "},{"$f":"IF(ISERROR((Balance!Q39+Balance!Q45)/Balance!Q50),\"   \",(Balance!Q39+Balance!Q45)/Balance!Q50)","v":"   "}]
["Senior Debt/Sub-debt+Equity",null,null,{"$f":"IF(ISERROR((Balance!D39+Balance!D45-Balance!D43)/(Balance!D50+Balance!D43)),\"  \",(Balance!D39+Balance!D45-Balance!D43)/(Balance!D50+Balance!D43))","v":"  "},{"$f":"IF(ISERROR((Balance!E39+Balance!E45-Balance!E43)/(Balance!E50+Balance!E43)),\"  \",(Balance!E39+Balance!E45-Balance!E43)/(Balance!E50+Balance!E43))","v":"  "},{"$f":"IF(ISERROR((Balance!F39+Balance!F45-Balance!F43)/(Balance!F50+Balance!F43)),\"  \",(Balance!F39+Balance!F45-Balance!F43)/(Balance!F50+Balance!F43))","v":"  "},{"$f":"IF(ISERROR((Balance!G39+Balance!G45-Balance!G43)/(Balance!G50+Balance!G43)),\"  \",(Balance!G39+Balance!G45-Balance!G43)/(Balance!G50+Balance!G43))","v":"  "},{"$f":"IF(ISERROR((Balance!H39+Balance!H45-Balance!H43)/(Balance!H50+Balance!H43)),\"  \",(Balance!H39+Balance!H45-Balance!H43)/(Balance!H50+Balance!H43))","v":"  "},{"$f":"IF(ISERROR((Balance!I39+Balance!I45-Balance!I43)/(Balance!I50+Balance!I43)),\"  \",(Balance!I39+Balance!I45-Balance!I43)/(Balance!I50+Balance!I43))","v":"  "},{"$f":"IF(ISERROR((Balance!J39+Balance!J45-Balance!J43)/(Balance!J50+Balance!J43)),\"  \",(Balance!J39+Balance!J45-Balance!J43)/(Balance!J50+Balance!J43))","v":"  "},{"$f":"IF(ISERROR((Balance!K39+Balance!K45-Balance!K43)/(Balance!K50+Balance!K43)),\"  \",(Balance!K39+Balance!K45-Balance!K43)/(Balance!K50+Balance!K43))","v":"  "},{"$f":"IF(ISERROR((Balance!L39+Balance!L45-Balance!L43)/(Balance!L50+Balance!L43)),\"  \",(Balance!L39+Balance!L45-Balance!L43)/(Balance!L50+Balance!L43))","v":"  "},{"$f":"IF(ISERROR((Balance!M39+Balance!M45-Balance!M43)/(Balance!M50+Balance!M43)),\"  \",(Balance!M39+Balance!M45-Balance!M43)/(Balance!M50+Balance!M43))","v":"  "},{"$f":"IF(ISERROR((Balance!N39+Balance!N45-Balance!N43)/(Balance!N50+Balance!N43)),\"  \",(Balance!N39+Balance!N45-Balance!N43)/(Balance!N50+Balance!N43))","v":"  "},{"$f":"IF(ISERROR((Balance!O39+Balance!O45-Balance!O43)/(Balance!O50+Balance!O43)),\"  \",(Balance!O39+Balance!O45-Balance!O43)/(Balance!O50+Balance!O43))","v":"  "},{"$f":"IF(ISERROR((Balance!P39+Balance!P45-Balance!P43)/(Balance!P50+Balance!P43)),\"  \",(Balance!P39+Balance!P45-Balance!P43)/(Balance!P50+Balance!P43))","v":"  "},{"$f":"IF(ISERROR((Balance!Q39+Balance!Q45-Balance!Q43)/(Balance!Q50+Balance!Q43)),\"  \",(Balance!Q39+Balance!Q45-Balance!Q43)/(Balance!Q50+Balance!Q43))","v":"  "}]
[]
[]
["Cash Flow and Debt Service Coverage Statistics"]
["Operating Cash Flow (USD)",null,null,{"$f":"CashFlow!D22","v":0},{"$f":"CashFlow!E22","v":0},{"$f":"CashFlow!F22","v":0},{"$f":"CashFlow!G22","v":0},{"$f":"CashFlow!H22","v":0},{"$f":"CashFlow!I22","v":0},{"$f":"CashFlow!J22","v":0},{"$f":"CashFlow!K22","v":0},{"$f":"CashFlow!L22","v":0},{"$f":"CashFlow!M22","v":0},{"$f":"CashFlow!N22","v":0},{"$f":"CashFlow!O22","v":0},{"$f":"CashFlow!P22","v":0},{"$f":"CashFlow!Q22","v":0}]
["Operating CADS/Interest+Fees",null,null,{"$f":"CashFlow!D57","v":"N/A"},{"$f":"CashFlow!E57","v":"N/A"},{"$f":"CashFlow!F57","v":"N/A"},{"$f":"CashFlow!G57","v":"N/A"},{"$f":"CashFlow!H57","v":"N/A"},{"$f":"CashFlow!I57","v":"N/A"},{"$f":"CashFlow!J57","v":"N/A"},{"$f":"CashFlow!K57","v":"N/A"},{"$f":"CashFlow!L57","v":"N/A"},{"$f":"CashFlow!M57","v":"N/A"},{"$f":"CashFlow!N57","v":"N/A"},{"$f":"CashFlow!O57","v":"N/A"},{"$f":"CashFlow!P57","v":"N/A"},{"$f":"CashFlow!Q57","v":"N/A"}]
["Operating CADS/Scheduled Principal",null,null,{"$f":"CashFlow!D58","v":"N/A"},{"$f":"CashFlow!E58","v":"N/A"},{"$f":"CashFlow!F58","v":"N/A"},{"$f":"CashFlow!G58","v":"N/A"},{"$f":"CashFlow!H58","v":"N/A"},{"$f":"CashFlow!I58","v":"N/A"},{"$f":"CashFlow!J58","v":"N/A"},{"$f":"CashFlow!K58","v":"N/A"},{"$f":"CashFlow!L58","v":"N/A"},{"$f":"CashFlow!M58","v":"N/A"},{"$f":"CashFlow!N58","v":"N/A"},{"$f":"CashFlow!O58","v":"N/A"},{"$f":"CashFlow!P58","v":"N/A"},{"$f":"CashFlow!Q58","v":"N/A"}]
["Operating CADS/Total Debt Service",null,null,{"$f":"CashFlow!D59","v":"N/A"},{"$f":"CashFlow!E59","v":"N/A"},{"$f":"CashFlow!F59","v":"N/A"},{"$f":"CashFlow!G59","v":"N/A"},{"$f":"CashFlow!H59","v":"N/A"},{"$f":"CashFlow!I59","v":"N/A"},{"$f":"CashFlow!J59","v":"N/A"},{"$f":"CashFlow!K59","v":"N/A"},{"$f":"CashFlow!L59","v":"N/A"},{"$f":"CashFlow!M59","v":"N/A"},{"$f":"CashFlow!N59","v":"N/A"},{"$f":"CashFlow!O59","v":"N/A"},{"$f":"CashFlow!P59","v":"N/A"},{"$f":"CashFlow!Q59","v":"N/A"}]
[]
["Profitability Statistics"]
["EBITDA (USD)",null,null,{"$f":"Income!D27","v":0},{"$f":"Income!F27","v":0},{"$f":"Income!H27","v":0},{"$f":"Income!J27","v":0},{"$f":"Income!L27","v":0},{"$f":"Income!N27","v":0},{"$f":"Income!P27","v":0},{"$f":"Income!R27","v":0},{"$f":"Income!T27","v":0},{"$f":"Income!V27","v":0},{"$f":"Income!X27","v":0},{"$f":"Income!Z27","v":0},{"$f":"Income!AB27","v":0},{"$f":"Income!AD27","v":0}]
["EBITDA (%)",null,null,{"$f":"Income!E27","v":"  "},{"$f":"Income!G27","v":"  "},{"$f":"Income!I27","v":"  "},{"$f":"Income!K27","v":"  "},{"$f":"Income!M27","v":"  "},{"$f":"Income!O27","v":"  "},{"$f":"Income!Q27","v":"  "},{"$f":"Income!S27","v":"  "},{"$f":"Income!U27","v":"  "},{"$f":"Income!W27","v":"  "},{"$f":"Income!Y27","v":"  "},{"$f":"Income!AA27","v":"  "},{"$f":"Income!AC27","v":"  "},{"$f":"Income!AE27","v":"  "}]
["Net Income (USD)",null,null,{"$f":"Income!D39","v":0},{"$f":"Income!F39","v":0},{"$f":"Income!H39","v":0},{"$f":"Income!J39","v":0},{"$f":"Income!L39","v":0},{"$f":"Income!N39","v":0},{"$f":"Income!P39","v":0},{"$f":"Income!R39","v":0},{"$f":"Income!T39","v":0},{"$f":"Income!V39","v":0},{"$f":"Income!X39","v":0},{"$f":"Income!Z39","v":0},{"$f":"Income!AB39","v":0},{"$f":"Income!AD39","v":0}]
["Net Income (%)",null,null,{"$f":"Income!E39","v":"  "},{"$f":"Income!G39","v":"  "},{"$f":"Income!I39","v":"  "},{"$f":"Income!K39","v":"  "},{"$f":"Income!M39","v":"  "},{"$f":"Income!O39","v":"  "},{"$f":"Income!Q39","v":"  "},{"$f":"Income!S39","v":"  "},{"$f":"Income!U39","v":"  "},{"$f":"Income!W39","v":"  "},{"$f":"Income!Y39","v":"  "},{"$f":"Income!AA39","v":"  "},{"$f":"Income!AC39","v":"  "},{"$f":"Income!AE39","v":"  "}]
[" "]
["Return Statistics"]
["Project IRR",null,null,null,{"$f":"CashFlow!E86","v":{"$error":"#NUM!"}}]
["Project NPV",null,null,null,{"$f":"CashFlow!E87","v":{"$error":"#DIV/0!"}}]
["Equity IRR",null,null,null,{"$f":"CashFlow!E95","v":{"$error":"#NUM!"}}]
["Equity NPV",null,null,null,{"$f":"CashFlow!E96","v":0}]