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

{"sheet":"Sheet1","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["rate ",4.6300000000000001E-2]
["principle ",150000]
["period ",25]
[]
["Payments for a loan"]
["payment",{"$f":"PMT(B1/12,B3*12,B2)","v":-844.85551682531832},{"$f":"GetFormula(B6)","v":"=PMT(B1/12,B3*12,B2)"}]
[]
["Total interest payment"]
["total payment ",{"$f":"B3*12*B6","v":-253456.6550475955},{"$f":"GetFormula(B9)","v":"=B3*12*B6"}]
[]
["principle ",{"$f":"B2","v":150000},{"$f":"GetFormula(B11)","v":"=B2"}]
["priciple per month",{"$f":"-B11/B3/12","v":-500},{"$f":"GetFormula(B12)","v":"=-B11/B3/12"}]
[]
["total interest v1",{"$f":"B9+B11","v":-103456.6550475955},{"$f":"GetFormula(B14)","v":"=B9+B11"}]
["total interest per month v1",{"$f":"B6-B12","v":-344.85551682531832},{"$f":"GetFormula(B15)","v":"=B6-B12"}]
[]
["total interest v2",{"$f":"CUMIPMT(B1/12,B3*12,B2,1,B3*12,0)","v":-103456.6550475933},{"$f":"GetFormula(B17)","v":"=CUMIPMT(B1/12,B3*12,B2,1,B3*12,0)"}]
["total interest per month v2",{"$f":"B17/B3/12","v":-344.85551682531104},{"$f":"GetFormula(B18)","v":"=B17/B3/12"}]
[]
["Additional fees"]
["work out the interest rate"]
["total interest",{"$f":"B17","v":-103456.6550475933},{"$f":"GetFormula(B22)","v":"=B17"}]
[]
["additional fees",{"$f":"25*-395","v":-9875},{"$f":"GetFormula(B24)","v":"=25*-395"}]
["additional fees per month",{"$f":"B24/B3/12","v":-32.916666666666664},{"$f":"GetFormula(B25)","v":"=B24/B3/12"}]
[]
["total outgoings",{"$f":"-B2+B22+B24","v":-263331.65504759329},{"$f":"GetFormula(B27)","v":"=-B2+B22+B24"}]
["total outgoings per month",{"$f":"B27/B3/12","v":-877.77218349197756},{"$f":"GetFormula(B28)","v":"=B27/B3/12"}]
[]
["total outgoings"]
["principle ",{"$f":"B2","v":150000},{"$f":"GetFormula(B31)","v":"=B2"}]
["total interest plus fees per month",{"$f":"B28","v":-877.77218349197756},{"$f":"GetFormula(B32)","v":"=B28"}]
[]
["Comparison rate"]
["comparison rate",{"$f":"RATE(B3*12,B32,B31)*12","v":5.0101482203266746E-2},{"$f":"GetFormula(B35)","v":"=RATE(B3*12,B32,B31)*12"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}