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

{"sheet":"Leasing Calculator","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"THE CCTV COMPANY"]
[null,"LEASING CALCULATOR"]
[null,"CAPITAL AMOUNT (ex.VAT)",null,"STANDARD CREDIT CUSTOMERS"]
[null,1000,"3 YEARS","4 YEARS","5 YEARS"]
[null,"PROFILE","1 + 11","1 + 15","1 + 19"]
[null,"NO. OF PAYMENTS",12,16,20]
[null,"PAID (IN ADVANCE)","Quarterly","Quarterly","Quarterly"]
[null,"REPAYMENT",{"$f":"SUM(CAPITAL_AMOUNT/1000)*'Calculator Data'!C13","v":99.5},{"$f":"SUM(CAPITAL_AMOUNT/1000)*'Calculator Data'!C14","v":78},{"$f":"SUM(CAPITAL_AMOUNT/1000)*'Calculator Data'!C15","v":65.5}]
[null,"TOTAL REPAID",{"$f":"SUM(S1TotalPayments*C9)","v":1194},{"$f":"SUM(D9*S2TotalPayments)","v":1248},{"$f":"SUM(E9*S3TotalPayments)","v":1310}]
[]
[null,"INTEREST PAID",{"$f":"SUM(S1ScheduledPayment-CAPITAL_AMOUNT)","v":194},{"$f":"SUM(S2ScheduledPayment-CAPITAL_AMOUNT)","v":248},{"$f":"SUM(S3ScheduledPayment-CAPITAL_AMOUNT)","v":310}]
[null,"CAPITAL BORROWED",{"$f":"CAPITAL_AMOUNT","v":1000},{"$f":"CAPITAL_AMOUNT","v":1000},{"$f":"CAPITAL_AMOUNT","v":1000}]
[null,"NEW BUSINESS (TRADING >3 YRS) & WEAKER CREDIT CUSTOMERS"]
[null,"REPAYMENT",{"$f":"SUM(CAPITAL_AMOUNT/1000)*'Calculator Data'!C16","v":105},"3 YRS 1+11 QUARTERLY"]
[null,"TOTAL REPAID",{"$f":"SUM(C15*S1TotalPayments)","v":1260}]
[null,"FLAT RATE OF INTEREST",{"$f":"SUM(C16-CAPITAL_AMOUNT)/3/CAPITAL_AMOUNT","v":8.666666666666667E-2}]
[]
[]
[null,"Notes"]
[null,"All figures exclude VAT at the applicable rate"]
[null,"All figures are for illustration purposes only and do not constitute an offer of any kind"]
[null,"All figures are subject to underwriting and full execution of documentation"]
[null,"All transactions are subject to Bluestone Leasing Ltd standard terms and conditions of trade"]
[]
[]
[]
[null,"90% ACCEPTANCE RATES |  FAST CREDIT DECISIONS  | SIMPLE DOCUMENTATION"]

{"sheet":"Calculator Data","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"CALCULATOR DATA"]
[null,"This sheet holds data that is used in lease calculations and to populate drop down lists. Changing information in it may result in incorrect payment calculations."]
[null,"Payment Frequency Lookup"]
[null,"FREQUENCY","PAYMENTS PER YEAR"]
[null,"Monthly",12]
[null,"Quarterly",4]
[null,"Annually",1]
[]
[]
[null,"Rates Lookup"]
[null,"TERM","RATE"]
[null,"3 YEARS",99.5]
[null,"4 YEARS",78]
[null,"5 years",65.5]
[null,"3 YEARS - WEAK CREDIT",105]