{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Get Started","Simple DSCR Tool"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Get Started","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Simple DSCR Tool","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,4,6,6],[10,4,10,6],[0,0,1,6],[2,0,3,1],[2,3,3,6],[4,4,5,4],[4,3,5,3]]}
["Simple Debt Service Coverage Tool"]
[]
["Your Business Information",null,null,"Loan Information"]
[]
["Net Income (Yearly)",null,null,"Required DSCR:",{"$nulls":4},"DSCR Common Values"]
["+ Depreciation"]
["+ Amortization",null,null,null,"Loan Scenarios",null,null,null,1]
["+ Interest",null,null,"Loan Amount",{"$nulls":4},1.1000000000000001]
["+ Rent",null,null,"Interest Rate",{"$nulls":4},1.1499999999999999]
["+ Other ",null,null,"Term (years)",{"$nulls":4},1.2]
["Adjusted Net Income",{"$f":"SUM(B5:B10)","v":0},null,null,"Loan Costs",null,null,null,1.25]
["- Owner's Draw",null,null,"Payment (monthly)",{"$f":"IFERROR(PMT(E9/12,E10*12,E8)*-1,\"\")","v":""},{"$f":"IFERROR(PMT(F9/12,F10*12,F8)*-1,\"\")","v":""},{"$f":"IFERROR(PMT(G9/12,G10*12,G8)*-1,\"\")","v":""},null,1.3]
["- Capital Expenditures",null,null,"Debt Service (yearly)",{"$f":"IFERROR(E12*12,\"\")","v":""},{"$f":"IFERROR(F12*12,\"\")","v":""},{"$f":"IFERROR(G12*12,\"\")","v":""},null,1.35]
["- Other"]
["Available for Debt Service",{"$f":"B11-B12-B13-B14","v":0},null,"DSCR",{"$f":"IFERROR($B$15/E13,\"\")","v":""},{"$f":"IFERROR($B$15/F13,\"\")","v":""},{"$f":"IFERROR($B$15/G13,\"\")","v":""}]