{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","RATE","from yearly","simple","Compound","VBA","Principal+Interest"],"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":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value"]
[null,"No of Periods (Months)","nper",60]
[null,"Monthly Payment","Pmt",300]
[null,"Loan Amount","Pv",15000]
[null,"Periods per Year",null,12]
[null,"Number of Years",null,5]

{"sheet":"RATE","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,12,1]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value"]
[null,"No of Periods (Months)","nper",60]
[null,"Monthly Payment","Pmt",300]
[null,"Loan Amount","Pv",15000]
[null,"Periods per Year",null,12]
[null,"Number of Years",null,5]
[null,"Total"]
[null,"Interest Rate","Monthly",{"$f":"RATE(D6,-D7,D8)","v":6.1834131612537183E-3}]
[null,null,"Annually",{"$f":"RATE(D6,-D7,D8)*D9","v":7.4200957935044623E-2}]

{"sheet":"from yearly","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,1,5,1],[2,1,2,3]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Interest Rate","Annually",0.14000000000000001]
[null,null,"Monthly",{"$f":"D5/12","v":1.1666666666666667E-2}]

{"sheet":"simple","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,12,1]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value"]
[null,"Final Amount","A",25000]
[null,"Principal Amount","P",15000]
[null,"Periods per Year","n",12]
[null,"Total Periods",null,60]
[null,"Number of Years","t",5]
[]
[null,"Simple Interest Rate","Annually",{"$f":"((D6/D7)-1)/D10","v":0.13333333333333336}]
[null,null,"Monthly",{"$f":"D12/12","v":1.1111111111111113E-2}]

{"sheet":"Compound","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[11,1,11,2]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value"]
[null,"Final Amount","A",25000]
[null,"Initial Principal Amount","P",15000]
[null,"Periods per Year","n",12]
[null,"Total Periods",null,60]
[null,"Number of Years","t",5]
[null,"Total"]
[null,"Monthly Interest Rate",null,{"$f":"((D6/D7)^(1/(D8*D10))-1)*D8","v":0.10260126630593813}]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[10,1,11,1],[10,8,11,8],[5,6,8,7],[10,6,11,7],[2,6,2,10]]}
[]
[]
[null,"Interest Rate of Michigan State Bank",null,null,null,null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value",null,null,null,null,"Description","Argument","Value"]
[null,"Final Amount","A",null,null,null,"Input",null,"Final Amount","A",25000]
[null,"Principal Amount","P",null,null,null,null,null,"Principal Amount","P",15000]
[null,"Periods per Year","n",null,null,null,null,null,"Periods per Year","n",12]
[null,"Number of Years","t",null,null,null,null,null,"No of Years","t",5]
[]
[null,"Simple Interest Rate","Annually",0.13333334028720856,null,null,"Output",null,"Simple Interest Rate","Annually",0.13333334028720856]
[null,null,"Monthly",1.1111111380159855E-2,null,null,null,null,null,"Monthly",1.1111111380159855E-2]

{"sheet":"Principal+Interest","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,3],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[]
[]
[null,"Interest Rate of Michigan State Bank"]
[]
[null,"Description","Argument","Value"]
[null,"Loan Amount","pv",100000]
[null,"Yearly Interest Rate",null,0.11]
[null,"Period per Year",null,12]
[null,"Period (Year)","per",1]
[null,"Total Period (Year)",null,5]
[null,"Number of Periods","nper",60]
[null,"Future Value","fv",0]
[null,"Type","type",0]
[null,"Total"]
[null,"Monthly Interest Rate",null,{"$f":"D7/D8","v":9.1666666666666667E-3}]
[null,"Principal Amount",null,{"$f":"PPMT(D15,D9,D11,-D6,D12,D13)","v":1257.5756405976642}]
[null,"Interest Amount",null,{"$f":"IPMT(D15,D9,D11,-D6,D12,D13)","v":916.66666666666663}]