{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Lease Payment Schedule"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Instructions","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Amortization Table/Payment Schedule Instructions"]
[]
["Purpose and Objective:"]
["An amortization table is a data table that shows the process of paying off a loan, with details for each payment."]
["For each payment, an amortization table provides interest charges on your loan/lease, executory cost if applicable, the amount of principal that you pay off and  your loan balance. "]
["This worksheet can also provide principal, interest rate OR payment amount as long as two of the fields are known and the term of the lease."]
[]
[]
["Instructions for Use of this Form:"]
["1. Enter the information requested by the description of each field highlighted in blue."]
["First Payment Date - date the first payment is due"]
["Principal - total amount of loan or value of lease at the commencement of the lease. "]
["Interest Rate - annual rate of interest for financing "]
["Executory Cost - these costs could property taxes, sales tax, insuance and maintance costs"]
["Payment - amount of minimum payment per period"]
["Term - length of lease in years"]
["2. Use the drop down to select frequency of payment"]
["3. Click the \"Click to Update Summary\" button. This will update the summary information starting in column I."]
[]
["Instructions for Calculating for the Unknown:"]
["The section highlighted in yellow may be used to calculate the principal, interest reate OR payment if either of the three are unknown. "]
["Two of the three fields must be entered in column C for results in column K to be accurate."]
["Payment frequency and term are required as well."]
[]
["* Questions on the completion of the attached form or problems with the form should be directed to cafr@cg.sc.gov"]

{"sheet":"Lease Payment Schedule","index":1,"n_rows":411,"n_cols":22,"rows_kept":411,"cut":false,"hidden":false,"merged":[[0,0,0,13],[6,0,6,1],[5,8,5,9],[4,8,4,9],[7,0,7,1],[3,8,3,9],[2,8,2,10],[2,0,2,1],[2,4,2,5],[3,0,3,1],[3,4,3,5],[4,0,4,1],[5,0,5,1]]}
["Amortization Schedule"]
[]
["First Payment Date ",null,null,null,"Frequency of Payment",null,null,null,"Calculating for the Unknown (Use As Needed)",null,null,null,null,null,"Fiscal Year/Month",7,null,"Sum of Principal",null,null,"Please Select"]
["Principal",null,null,null,"Monthly",null,null,null,"Principal",null,{"$f":"IFERROR(IF(ISBLANK(C4),IF($E$4=\"Annually\",-PV(C5,C8,C7),IF($E$4=\"Semi-Annual\",-PV(C5/2,C8*2,C7),IF($E$4=\"Quarterly\",-PV(C5/4,C8*4,C7),IF($E$4=\"Monthly\",-PV(C5/12,C8*12,C7),0)))),\"-\"),\" \")","v":0},null,null,null,null,null,null,"Fiscal Year","Total",null,"Annually",1]
["Interest Rate",null,null,null,null,null,null,null,"Interest ",null,{"$f":"IFERROR(IF(ISBLANK(C5),IF($E$4=\"Annually\",((RATE($C$8,-$C$7,$C$4,0,1,0))),\nIF($E$4=\"Semi-Annual\",((RATE($C$8*2,-$C$7,$C$4,0,1,0))*2),\nIF($E$4=\"Quarterly\",((RATE($C$8*4,-$C$7,$C$4,0,1,0))*4),\nIF($E$4=\"Monthly\",((RATE($C$8*12,-$C$7,$C$4,0,1,0))*12),0)))),\"-\"),\" \")","v":" "},null,null,null,"https://e-farmcredit.com/calculator",null,null,1900,0,null,"Semi-Annual",2]
["Executory Cost (Per Pmt)",null,null,null,null,null,null,null,"Payment",null,{"$f":"IFERROR(IF(ISBLANK(C7),IF($E$4=\"Annually\",-PMT(C5,C8,C4),IF($E$4=\"Semi-Annual\",-PMT(C5/2,2*C8,C4),IF($E$4=\"Quarterly\",-PMT(C5/4,4*C8,C4),IF($E$4=\"Monthly\",-PMT(C5/12,12*C8,C4),0)))),\"-\"),\" \")","v":" "},null,null,null,null,null,null,1901,0,null,"Quarterly",4]
["Payment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1902,0,null,"Monthly",12]
["Term (Years)",null,null,null,null,null,null,null,"** Please notify the CGO if lease term exceeds 30 years **",null,null,null,null,null,null,null,null,1903,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1904,0]
["Fiscal Year","Date","Interest","Executory","Principal","Total Payment","Balance",null,"Fiscal Year","Interest","Executory","Principal","Payments","Balance",null,null,null,1905,0]
[null,null,null,null,null,null,{"$f":"C4","v":0},null,{"$f":"R5","v":1900},{"$f":"SUMIF($A$11:$A$411,I11,$C$11:$C$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I11,$D$12:$D$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I11,$E$12:$E$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I11,$E$12:$E$411)","v":0},{"$f":"C4-L11","v":0},null,null,null,1906,0]
[{"$f":"YEAR(DATE(YEAR(B12),MONTH(B12)+($P$3-1),1))","v":1900},{"$f":"C3","v":"00:00:00"},{"$f":"IF($E$4=\"Annually\",(($C$5)*C4),IF($E$4=\"Semi-Annual\",(($C$5/2)*C4),IF($E$4=\"Quarterly\",(($C$5/4)*C4),IF($E$4=\"Monthly\",(($C$5/12))*C4,0))))","v":0},{"$f":"IF(G11>0,$C$6,0)","v":0},{"$f":"IF(G11<$C$7,G11,$C$7-C12-D12)","v":0},{"$f":"SUM(C12:E12)","v":0},{"$f":"G11-E12","v":0},null,{"$f":"R6","v":1901},{"$f":"SUMIF($A$11:$A$411,I12,$C$11:$C$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I12,$D$12:$D$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I12,$E$12:$E$411)","v":0},{"$f":"SUMIF($A$12:$A$411,I12,$E$12:$E$411)","v":0},{"$f":"N11-L12","v":0},null,null,null,1907,0]
[1900,{"$f":"IF($E$4=\"Annually\",EDATE(B12,12),IF($E$4=\"Semi-Annual\",EDATE(B12,6),IF($E$4=\"Quarterly\",EDATE(B12,3),IF($E$4=\"Monthly\",EDATE(B12,1),0))))","v":"1900-01-31"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G12),IF($E$4=\"Semi-Annual\",(($C$5/2)*G12),IF($E$4=\"Quarterly\",(($C$5/4)*G12),IF($E$4=\"Monthly\",(($C$5/12))*G12,0))))","v":0},{"$f":"IF(G12>0,$C$6,0)","v":0},{"$f":"IF(G12<$C$7,G12,$C$7-C13-D13)","v":0},{"$f":"SUM(C13:E13)","v":0},{"$f":"G12-E13","v":0},null,1902,{"$f":"SUMIF($A$11:$A$411,I13,$C$11:$C$411)","v":0},0,0,0,{"$f":"N12-L13","v":0},null,null,null,1908,0]
[1900,{"$f":"IF($E$4=\"Annually\",EDATE(B13,12),IF($E$4=\"Semi-Annual\",EDATE(B13,6),IF($E$4=\"Quarterly\",EDATE(B13,3),IF($E$4=\"Monthly\",EDATE(B13,1),0))))","v":"1900-02-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G13),IF($E$4=\"Semi-Annual\",(($C$5/2)*G13),IF($E$4=\"Quarterly\",(($C$5/4)*G13),IF($E$4=\"Monthly\",(($C$5/12))*G13,0))))","v":0},{"$f":"IF(G13>0,$C$6,0)","v":0},{"$f":"IF(G13<$C$7,G13,$C$7-C14-D14)","v":0},0,{"$f":"G13-E14","v":0},null,1903,0,0,0,0,0,null,null,null,1909,0]
[1900,"1900-03-28",0,0,{"$f":"IF(G14<$C$7,G14,$C$7-C15)","v":0},0,0,null,1904,0,0,0,0,0,null,null,null,1910,0]
[1900,"1900-04-28",0,0,0,0,0,null,1905,0,0,0,0,0,null,null,null,1911,0]
[1900,"1900-05-28",0,0,0,0,0,null,1906,0,0,0,0,0,null,null,null,1912,0]
[1900,"1900-06-28",0,0,0,0,0,null,1907,0,0,0,0,0,null,null,null,1913,0]
[1901,"1900-07-28",0,0,0,0,0,null,1908,0,0,0,0,0,null,null,null,1914,0]
[1901,"1900-08-28",0,0,0,0,0,null,1909,0,0,0,0,0,null,null,null,1915,0]
[1901,"1900-09-28",0,0,0,0,0,null,1910,0,0,0,0,0,null,null,null,1916,0]
[1901,"1900-10-28",0,0,0,0,0,null,1911,0,0,0,0,0,null,null,null,1917,0]
[1901,"1900-11-28",0,0,0,0,0,null,1912,0,0,0,0,0,null,null,null,1918,0]
[1901,"1900-12-28",0,0,0,0,0,null,1913,0,0,0,0,0,null,null,null,1919,0]
[1901,"1901-01-28",0,0,0,0,0,null,1914,0,0,0,0,0,null,null,null,1920,0]
[1901,"1901-02-28",0,0,0,0,0,null,1915,0,0,0,0,0,null,null,null,1921,0]
[1901,"1901-03-28",0,0,0,0,0,null,1916,0,0,0,0,0,null,null,null,1922,0]
[1901,"1901-04-28",0,0,0,0,0,null,1917,0,0,0,0,0,null,null,null,1923,0]
[1901,"1901-05-28",0,0,0,0,0,null,1918,0,0,0,0,0,null,null,null,1924,0]
[1901,"1901-06-28",0,0,0,0,0,null,1919,0,0,0,0,0,null,null,null,1925,0]
[1902,"1901-07-28",0,0,0,0,0,null,1920,0,0,0,0,0,null,null,null,1926,0]
[1902,"1901-08-28",0,0,0,0,0,null,1921,0,0,0,0,0,null,null,null,1927,0]
[1902,"1901-09-28",0,0,0,0,0,null,1922,0,0,0,0,0,null,null,null,1928,0]
[1902,"1901-10-28",0,0,0,0,0,null,1923,0,0,0,0,0,null,null,null,1929,0]
[1902,"1901-11-28",0,0,0,0,0,null,1924,0,0,0,0,0,null,null,null,1930,0]
[1902,"1901-12-28",0,0,0,0,0,null,1925,0,0,0,0,0,null,null,null,1931,0]
[1902,"1902-01-28",0,0,0,0,0,null,1926,0,0,0,0,0,null,null,null,1932,0]
[1902,"1902-02-28",0,0,0,0,0,null,1927,0,0,0,0,0,null,null,null,1933,0]
[1902,"1902-03-28",0,0,0,0,0,null,1928,0,0,0,0,0,null,null,null,"(blank)"]
[1902,"1902-04-28",0,0,0,0,0,null,1929,0,0,0,0,0]
[1902,"1902-05-28",0,0,0,0,0,null,null,{"$f":"SUM(J11:J30)","v":0},{"$f":"SUM(K11:K30)","v":0},{"$f":"SUM(L11:L30)","v":0},{"$f":"SUM(M11:M30)","v":0}]
[1902,"1902-06-28",0,0,0,0,0]
[1903,"1902-07-28",0,0,0,0,0,null,"Year","Interest","Executory","Principal","Payments","Balance"]
[1903,"1902-08-28",0,0,0,0,0,null,{"$f":"I11","v":1900},{"$f":"J11","v":0},0,0,0,0]
[1903,"1902-09-28",0,0,0,0,0,null,{"$f":"I12","v":1901},0,0,0,0,0]
[1903,"1902-10-28",0,0,0,0,0,null,1902,0,0,0,0,0]
[1903,"1902-11-28",0,0,0,0,0,null,1903,0,0,0,0,0]
[1903,"1902-12-28",0,0,0,0,0,null,1904,0,0,0,0,0]
[1903,"1903-01-28",0,0,0,0,0,null,{"$f":"I16&\" - \"&I20","v":"1905 - 1909"},{"$f":"SUM(J16:J20)","v":0},{"$f":"SUM(K16:K20)","v":0},{"$f":"SUM(L16:L20)","v":0},{"$f":"SUM(M16:M20)","v":0},{"$f":"SUM(N16:N20)","v":0}]
[1903,"1903-02-28",0,0,0,0,0,null,{"$f":"I21&\" - \"&I25","v":"1910 - 1914"},{"$f":"SUM(J21:J25)","v":0},{"$f":"SUM(K21:K25)","v":0},{"$f":"SUM(L21:L25)","v":0},{"$f":"SUM(M21:M25)","v":0},{"$f":"SUM(N21:N25)","v":0}]
[1903,"1903-03-28",0,0,0,0,0,null,{"$f":"I26&\" - \"&I30","v":"1915 - 1919"},{"$f":"SUM(J26:J30)","v":0},{"$f":"SUM(K26:K30)","v":0},{"$f":"SUM(L26:L30)","v":0},{"$f":"SUM(M26:M30)","v":0},{"$f":"SUM(N26:N30)","v":0}]
[1903,"1903-04-28",0,0,0,0,0,null,{"$f":"I31&\" - \"&I35","v":"1920 - 1924"},{"$f":"SUM(J31:J35)","v":0},{"$f":"SUM(K31:K35)","v":0},{"$f":"SUM(L31:L35)","v":0},{"$f":"SUM(M31:M35)","v":0},{"$f":"SUM(N31:N35)","v":0}]
[1903,"1903-05-28",0,0,0,0,0,null,{"$f":"I36&\" - \"&I40","v":"1925 - 1929"},{"$f":"SUM(J36:J40)","v":0},{"$f":"SUM(K36:K40)","v":0},{"$f":"SUM(L36:L40)","v":0},{"$f":"SUM(M36:M40)","v":0},{"$f":"SUM(N36:N40)","v":0}]
[1903,"1903-06-28",0,0,0,0,0,null,null,{"$f":"SUM(J44:J53)","v":0},{"$f":"SUM(K44:K53)","v":0},0,0,0]
[1904,"1903-07-28",0,0,0,0,0]
[1904,"1903-08-28",0,0,0,0,0]
[1904,"1903-09-28",0,0,0,0,0]
[1904,"1903-10-28",0,0,0,0,0]
[1904,"1903-11-28",0,0,0,0,0]
[1904,"1903-12-28",0,0,0,0,0]
[1904,"1904-01-28",0,0,0,0,0]
[1904,"1904-02-28",0,0,0,0,0]
[1904,"1904-03-28",0,0,0,0,0]
[1904,"1904-04-28",0,0,0,0,0]
[1904,"1904-05-28",0,0,0,0,0]
[1904,"1904-06-28",0,0,0,0,0]
[1905,"1904-07-28",0,0,0,0,0]
[1905,"1904-08-28",0,0,0,0,0]
[1905,"1904-09-28",0,0,0,0,0]
[1905,"1904-10-28",0,0,0,0,0]
[1905,"1904-11-28",0,0,0,0,0]
[1905,"1904-12-28",0,0,0,0,0]
[1905,"1905-01-28",0,0,0,0,0]
[1905,"1905-02-28",0,0,0,0,0]
[1905,"1905-03-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B76),MONTH(B76)+($P$3-1),1))","v":1905},"1905-04-28",0,0,0,0,0]
[1905,"1905-05-28",0,0,0,{"$f":"SUM(C77:E77)","v":0},0]
[1905,{"$f":"IF($E$4=\"Annually\",EDATE(B77,12),IF($E$4=\"Semi-Annual\",EDATE(B77,6),IF($E$4=\"Quarterly\",EDATE(B77,3),IF($E$4=\"Monthly\",EDATE(B77,1),0))))","v":"1905-06-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G77),IF($E$4=\"Semi-Annual\",(($C$5/2)*G77),IF($E$4=\"Quarterly\",(($C$5/4)*G77),IF($E$4=\"Monthly\",(($C$5/12))*G77,0))))","v":0},{"$f":"IF(G77>0,$C$6,0)","v":0},0,0,{"$f":"G77-E78","v":0}]
[1906,"1905-07-28",0,0,{"$f":"IF(G78<$C$7,G78,$C$7-C79)","v":0},0,0]
[1906,"1905-08-28",0,0,0,0,0]
[1906,"1905-09-28",0,0,0,0,0]
[1906,"1905-10-28",0,0,0,0,0]
[1906,"1905-11-28",0,0,0,0,0]
[1906,"1905-12-28",0,0,0,0,0]
[1906,"1906-01-28",0,0,0,0,0]
[1906,"1906-02-28",0,0,0,0,0]
[1906,"1906-03-28",0,0,0,0,0]
[1906,"1906-04-28",0,0,0,0,0]
[1906,"1906-05-28",0,0,0,0,0]
[1906,"1906-06-28",0,0,0,0,0]
[1907,"1906-07-28",0,0,0,0,0]
[1907,"1906-08-28",0,0,0,0,0]
[1907,"1906-09-28",0,0,0,0,0]
[1907,"1906-10-28",0,0,0,0,0]
[1907,"1906-11-28",0,0,0,0,0]
[1907,"1906-12-28",0,0,0,0,0]
[1907,"1907-01-28",0,0,0,0,0]
[1907,"1907-02-28",0,0,0,0,0]
[1907,"1907-03-28",0,0,0,0,0]
[1907,"1907-04-28",0,0,0,0,0]
[1907,"1907-05-28",0,0,0,0,0]
[1907,"1907-06-28",0,0,0,0,0]
[1908,"1907-07-28",0,0,0,0,0]
[1908,"1907-08-28",0,0,0,0,0]
[1908,"1907-09-28",0,0,0,0,0]
[1908,"1907-10-28",0,0,0,0,0]
[1908,"1907-11-28",0,0,0,0,0]
[1908,"1907-12-28",0,0,0,0,0]
[1908,"1908-01-28",0,0,0,0,0]
[1908,"1908-02-28",0,0,0,0,0]
[1908,"1908-03-28",0,0,0,0,0]
[1908,"1908-04-28",0,0,0,0,0]
[1908,"1908-05-28",0,0,0,0,0]
[1908,"1908-06-28",0,0,0,0,0]
[1909,"1908-07-28",0,0,0,0,0]
[1909,"1908-08-28",0,0,0,0,0]
[1909,"1908-09-28",0,0,0,0,0]
[1909,"1908-10-28",0,0,0,0,0]
[1909,"1908-11-28",0,0,0,0,0]
[1909,"1908-12-28",0,0,0,0,0]
[1909,"1909-01-28",0,0,0,0,0]
[1909,"1909-02-28",0,0,0,0,0]
[1909,"1909-03-28",0,0,0,0,0]
[1909,"1909-04-28",0,0,0,0,0]
[1909,"1909-05-28",0,0,0,0,0]
[1909,"1909-06-28",0,0,0,0,0]
[1910,"1909-07-28",0,0,0,0,0]
[1910,"1909-08-28",0,0,0,0,0]
[1910,"1909-09-28",0,0,0,0,0]
[1910,"1909-10-28",0,0,0,0,0]
[1910,"1909-11-28",0,0,0,0,0]
[1910,"1909-12-28",0,0,0,0,0]
[1910,"1910-01-28",0,0,0,0,0]
[1910,"1910-02-28",0,0,0,0,0]
[1910,"1910-03-28",0,0,0,0,0]
[1910,"1910-04-28",0,0,0,0,0]
[1910,"1910-05-28",0,0,0,0,0]
[1910,"1910-06-28",0,0,0,0,0]
[1911,"1910-07-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B140),MONTH(B140)+($P$3-1),1))","v":1911},"1910-08-28",0,0,0,0,0]
[1911,"1910-09-28",0,0,0,{"$f":"SUM(C141:E141)","v":0},0]
[1911,{"$f":"IF($E$4=\"Annually\",EDATE(B141,12),IF($E$4=\"Semi-Annual\",EDATE(B141,6),IF($E$4=\"Quarterly\",EDATE(B141,3),IF($E$4=\"Monthly\",EDATE(B141,1),0))))","v":"1910-10-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G141),IF($E$4=\"Semi-Annual\",(($C$5/2)*G141),IF($E$4=\"Quarterly\",(($C$5/4)*G141),IF($E$4=\"Monthly\",(($C$5/12))*G141,0))))","v":0},{"$f":"IF(G141>0,$C$6,0)","v":0},0,0,{"$f":"G141-E142","v":0}]
[1911,"1910-11-28",0,0,{"$f":"IF(G142<$C$7,G142,$C$7-C143)","v":0},0,0]
[1911,"1910-12-28",0,0,0,0,0]
[1911,"1911-01-28",0,0,0,0,0]
[1911,"1911-02-28",0,0,0,0,0]
[1911,"1911-03-28",0,0,0,0,0]
[1911,"1911-04-28",0,0,0,0,0]
[1911,"1911-05-28",0,0,0,0,0]
[1911,"1911-06-28",0,0,0,0,0]
[1912,"1911-07-28",0,0,0,0,0]
[1912,"1911-08-28",0,0,0,0,0]
[1912,"1911-09-28",0,0,0,0,0]
[1912,"1911-10-28",0,0,0,0,0]
[1912,"1911-11-28",0,0,0,0,0]
[1912,"1911-12-28",0,0,0,0,0]
[1912,"1912-01-28",0,0,0,0,0]
[1912,"1912-02-28",0,0,0,0,0]
[1912,"1912-03-28",0,0,0,0,0]
[1912,"1912-04-28",0,0,0,0,0]
[1912,"1912-05-28",0,0,0,0,0]
[1912,"1912-06-28",0,0,0,0,0]
[1913,"1912-07-28",0,0,0,0,0]
[1913,"1912-08-28",0,0,0,0,0]
[1913,"1912-09-28",0,0,0,0,0]
[1913,"1912-10-28",0,0,0,0,0]
[1913,"1912-11-28",0,0,0,0,0]
[1913,"1912-12-28",0,0,0,0,0]
[1913,"1913-01-28",0,0,0,0,0]
[1913,"1913-02-28",0,0,0,0,0]
[1913,"1913-03-28",0,0,0,0,0]
[1913,"1913-04-28",0,0,0,0,0]
[1913,"1913-05-28",0,0,0,0,0]
[1913,"1913-06-28",0,0,0,0,0]
[1914,"1913-07-28",0,0,0,0,0]
[1914,"1913-08-28",0,0,0,0,0]
[1914,"1913-09-28",0,0,0,0,0]
[1914,"1913-10-28",0,0,0,0,0]
[1914,"1913-11-28",0,0,0,0,0]
[1914,"1913-12-28",0,0,0,0,0]
[1914,"1914-01-28",0,0,0,0,0]
[1914,"1914-02-28",0,0,0,0,0]
[1914,"1914-03-28",0,0,0,0,0]
[1914,"1914-04-28",0,0,0,0,0]
[1914,"1914-05-28",0,0,0,0,0]
[1914,"1914-06-28",0,0,0,0,0]
[1915,"1914-07-28",0,0,0,0,0]
[1915,"1914-08-28",0,0,0,0,0]
[1915,"1914-09-28",0,0,0,0,0]
[1915,"1914-10-28",0,0,0,0,0]
[1915,"1914-11-28",0,0,0,0,0]
[1915,"1914-12-28",0,0,0,0,0]
[1915,"1915-01-28",0,0,0,0,0]
[1915,"1915-02-28",0,0,0,0,0]
[1915,"1915-03-28",0,0,0,0,0]
[1915,"1915-04-28",0,0,0,0,0]
[1915,"1915-05-28",0,0,0,0,0]
[1915,"1915-06-28",0,0,0,0,0]
[1916,"1915-07-28",0,0,0,0,0]
[1916,"1915-08-28",0,0,0,0,0]
[1916,"1915-09-28",0,0,0,0,0]
[1916,"1915-10-28",0,0,0,0,0]
[1916,"1915-11-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B204),MONTH(B204)+($P$3-1),1))","v":1916},"1915-12-28",0,0,0,0,0]
[1916,"1916-01-28",0,0,0,{"$f":"SUM(C205:E205)","v":0},0]
[1916,{"$f":"IF($E$4=\"Annually\",EDATE(B205,12),IF($E$4=\"Semi-Annual\",EDATE(B205,6),IF($E$4=\"Quarterly\",EDATE(B205,3),IF($E$4=\"Monthly\",EDATE(B205,1),0))))","v":"1916-02-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G205),IF($E$4=\"Semi-Annual\",(($C$5/2)*G205),IF($E$4=\"Quarterly\",(($C$5/4)*G205),IF($E$4=\"Monthly\",(($C$5/12))*G205,0))))","v":0},{"$f":"IF(G205>0,$C$6,0)","v":0},0,0,{"$f":"G205-E206","v":0}]
[1916,"1916-03-28",0,0,{"$f":"IF(G206<$C$7,G206,$C$7-C207)","v":0},0,0]
[1916,"1916-04-28",0,0,0,0,0]
[1916,"1916-05-28",0,0,0,0,0]
[1916,"1916-06-28",0,0,0,0,0]
[1917,"1916-07-28",0,0,0,0,0]
[1917,"1916-08-28",0,0,0,0,0]
[1917,"1916-09-28",0,0,0,0,0]
[1917,"1916-10-28",0,0,0,0,0]
[1917,"1916-11-28",0,0,0,0,0]
[1917,"1916-12-28",0,0,0,0,0]
[1917,"1917-01-28",0,0,0,0,0]
[1917,"1917-02-28",0,0,0,0,0]
[1917,"1917-03-28",0,0,0,0,0]
[1917,"1917-04-28",0,0,0,0,0]
[1917,"1917-05-28",0,0,0,0,0]
[1917,"1917-06-28",0,0,0,0,0]
[1918,"1917-07-28",0,0,0,0,0]
[1918,"1917-08-28",0,0,0,0,0]
[1918,"1917-09-28",0,0,0,0,0]
[1918,"1917-10-28",0,0,0,0,0]
[1918,"1917-11-28",0,0,0,0,0]
[1918,"1917-12-28",0,0,0,0,0]
[1918,"1918-01-28",0,0,0,0,0]
[1918,"1918-02-28",0,0,0,0,0]
[1918,"1918-03-28",0,0,0,0,0]
[1918,"1918-04-28",0,0,0,0,0]
[1918,"1918-05-28",0,0,0,0,0]
[1918,"1918-06-28",0,0,0,0,0]
[1919,"1918-07-28",0,0,0,0,0]
[1919,"1918-08-28",0,0,0,0,0]
[1919,"1918-09-28",0,0,0,0,0]
[1919,"1918-10-28",0,0,0,0,0]
[1919,"1918-11-28",0,0,0,0,0]
[1919,"1918-12-28",0,0,0,0,0]
[1919,"1919-01-28",0,0,0,0,0]
[1919,"1919-02-28",0,0,0,0,0]
[1919,"1919-03-28",0,0,0,0,0]
[1919,"1919-04-28",0,0,0,0,0]
[1919,"1919-05-28",0,0,0,0,0]
[1919,"1919-06-28",0,0,0,0,0]
[1920,"1919-07-28",0,0,0,0,0]
[1920,"1919-08-28",0,0,0,0,0]
[1920,"1919-09-28",0,0,0,0,0]
[1920,"1919-10-28",0,0,0,0,0]
[1920,"1919-11-28",0,0,0,0,0]
[1920,"1919-12-28",0,0,0,0,0]
[1920,"1920-01-28",0,0,0,0,0]
[1920,"1920-02-28",0,0,0,0,0]
[1920,"1920-03-28",0,0,0,0,0]
[1920,"1920-04-28",0,0,0,0,0]
[1920,"1920-05-28",0,0,0,0,0]
[1920,"1920-06-28",0,0,0,0,0]
[1921,"1920-07-28",0,0,0,0,0]
[1921,"1920-08-28",0,0,0,0,0]
[1921,"1920-09-28",0,0,0,0,0]
[1921,"1920-10-28",0,0,0,0,0]
[1921,"1920-11-28",0,0,0,0,0]
[1921,"1920-12-28",0,0,0,0,0]
[1921,"1921-01-28",0,0,0,0,0]
[1921,"1921-02-28",0,0,0,0,0]
[1921,"1921-03-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B268),MONTH(B268)+($P$3-1),1))","v":1921},"1921-04-28",0,0,0,0,0]
[1921,"1921-05-28",0,0,0,{"$f":"SUM(C269:E269)","v":0},0]
[1921,{"$f":"IF($E$4=\"Annually\",EDATE(B269,12),IF($E$4=\"Semi-Annual\",EDATE(B269,6),IF($E$4=\"Quarterly\",EDATE(B269,3),IF($E$4=\"Monthly\",EDATE(B269,1),0))))","v":"1921-06-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G269),IF($E$4=\"Semi-Annual\",(($C$5/2)*G269),IF($E$4=\"Quarterly\",(($C$5/4)*G269),IF($E$4=\"Monthly\",(($C$5/12))*G269,0))))","v":0},{"$f":"IF(G269>0,$C$6,0)","v":0},0,0,{"$f":"G269-E270","v":0}]
[1922,"1921-07-28",0,0,{"$f":"IF(G270<$C$7,G270,$C$7-C271)","v":0},0,0]
[1922,"1921-08-28",0,0,0,0,0]
[1922,"1921-09-28",0,0,0,0,0]
[1922,"1921-10-28",0,0,0,0,0]
[1922,"1921-11-28",0,0,0,0,0]
[1922,"1921-12-28",0,0,0,0,0]
[1922,"1922-01-28",0,0,0,0,0]
[1922,"1922-02-28",0,0,0,0,0]
[1922,"1922-03-28",0,0,0,0,0]
[1922,"1922-04-28",0,0,0,0,0]
[1922,"1922-05-28",0,0,0,0,0]
[1922,"1922-06-28",0,0,0,0,0]
[1923,"1922-07-28",0,0,0,0,0]
[1923,"1922-08-28",0,0,0,0,0]
[1923,"1922-09-28",0,0,0,0,0]
[1923,"1922-10-28",0,0,0,0,0]
[1923,"1922-11-28",0,0,0,0,0]
[1923,"1922-12-28",0,0,0,0,0]
[1923,"1923-01-28",0,0,0,0,0]
[1923,"1923-02-28",0,0,0,0,0]
[1923,"1923-03-28",0,0,0,0,0]
[1923,"1923-04-28",0,0,0,0,0]
[1923,"1923-05-28",0,0,0,0,0]
[1923,"1923-06-28",0,0,0,0,0]
[1924,"1923-07-28",0,0,0,0,0]
[1924,"1923-08-28",0,0,0,0,0]
[1924,"1923-09-28",0,0,0,0,0]
[1924,"1923-10-28",0,0,0,0,0]
[1924,"1923-11-28",0,0,0,0,0]
[1924,"1923-12-28",0,0,0,0,0]
[1924,"1924-01-28",0,0,0,0,0]
[1924,"1924-02-28",0,0,0,0,0]
[1924,"1924-03-28",0,0,0,0,0]
[1924,"1924-04-28",0,0,0,0,0]
[1924,"1924-05-28",0,0,0,0,0]
[1924,"1924-06-28",0,0,0,0,0]
[1925,"1924-07-28",0,0,0,0,0]
[1925,"1924-08-28",0,0,0,0,0]
[1925,"1924-09-28",0,0,0,0,0]
[1925,"1924-10-28",0,0,0,0,0]
[1925,"1924-11-28",0,0,0,0,0]
[1925,"1924-12-28",0,0,0,0,0]
[1925,"1925-01-28",0,0,0,0,0]
[1925,"1925-02-28",0,0,0,0,0]
[1925,"1925-03-28",0,0,0,0,0]
[1925,"1925-04-28",0,0,0,0,0]
[1925,"1925-05-28",0,0,0,0,0]
[1925,"1925-06-28",0,0,0,0,0]
[1926,"1925-07-28",0,0,0,0,0]
[1926,"1925-08-28",0,0,0,0,0]
[1926,"1925-09-28",0,0,0,0,0]
[1926,"1925-10-28",0,0,0,0,0]
[1926,"1925-11-28",0,0,0,0,0]
[1926,"1925-12-28",0,0,0,0,0]
[1926,"1926-01-28",0,0,0,0,0]
[1926,"1926-02-28",0,0,0,0,0]
[1926,"1926-03-28",0,0,0,0,0]
[1926,"1926-04-28",0,0,0,0,0]
[1926,"1926-05-28",0,0,0,0,0]
[1926,"1926-06-28",0,0,0,0,0]
[1927,"1926-07-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B332),MONTH(B332)+($P$3-1),1))","v":1927},"1926-08-28",0,0,0,0,0]
[1927,"1926-09-28",0,0,0,{"$f":"SUM(C333:E333)","v":0},0]
[1927,{"$f":"IF($E$4=\"Annually\",EDATE(B333,12),IF($E$4=\"Semi-Annual\",EDATE(B333,6),IF($E$4=\"Quarterly\",EDATE(B333,3),IF($E$4=\"Monthly\",EDATE(B333,1),0))))","v":"1926-10-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G333),IF($E$4=\"Semi-Annual\",(($C$5/2)*G333),IF($E$4=\"Quarterly\",(($C$5/4)*G333),IF($E$4=\"Monthly\",(($C$5/12))*G333,0))))","v":0},{"$f":"IF(G333>0,$C$6,0)","v":0},0,0,{"$f":"G333-E334","v":0}]
[1927,"1926-11-28",0,0,{"$f":"IF(G334<$C$7,G334,$C$7-C335)","v":0},0,0]
[1927,"1926-12-28",0,0,0,0,0]
[1927,"1927-01-28",0,0,0,0,0]
[1927,"1927-02-28",0,0,0,0,0]
[1927,"1927-03-28",0,0,0,0,0]
[1927,"1927-04-28",0,0,0,0,0]
[1927,"1927-05-28",0,0,0,0,0]
[1927,"1927-06-28",0,0,0,0,0]
[1928,"1927-07-28",0,0,0,0,0]
[1928,"1927-08-28",0,0,0,0,0]
[1928,"1927-09-28",0,0,0,0,0]
[1928,"1927-10-28",0,0,0,0,0]
[1928,"1927-11-28",0,0,0,0,0]
[1928,"1927-12-28",0,0,0,0,0]
[1928,"1928-01-28",0,0,0,0,0]
[1928,"1928-02-28",0,0,0,0,0]
[1928,"1928-03-28",0,0,0,0,0]
[1928,"1928-04-28",0,0,0,0,0]
[1928,"1928-05-28",0,0,0,0,0]
[1928,"1928-06-28",0,0,0,0,0]
[1929,"1928-07-28",0,0,0,0,0]
[1929,"1928-08-28",0,0,0,0,0]
[1929,"1928-09-28",0,0,0,0,0]
[1929,"1928-10-28",0,0,0,0,0]
[1929,"1928-11-28",0,0,0,0,0]
[1929,"1928-12-28",0,0,0,0,0]
[1929,"1929-01-28",0,0,0,0,0]
[1929,"1929-02-28",0,0,0,0,0]
[1929,"1929-03-28",0,0,0,0,0]
[1929,"1929-04-28",0,0,0,0,0]
[1929,"1929-05-28",0,0,0,0,0]
[1929,"1929-06-28",0,0,0,0,0]
[1930,"1929-07-28",0,0,0,0,0]
[1930,"1929-08-28",0,0,0,0,0]
[1930,"1929-09-28",0,0,0,0,0]
[1930,"1929-10-28",0,0,0,0,0]
[1930,"1929-11-28",0,0,0,0,0]
[1930,"1929-12-28",0,0,0,0,0]
[1930,"1930-01-28",0,0,0,0,0]
[1930,"1930-02-28",0,0,0,0,0]
[1930,"1930-03-28",0,0,0,0,0]
[1930,"1930-04-28",0,0,0,0,0]
[1930,"1930-05-28",0,0,0,0,0]
[1930,"1930-06-28",0,0,0,0,0]
[1931,"1930-07-28",0,0,0,0,0]
[1931,"1930-08-28",0,0,0,0,0]
[1931,"1930-09-28",0,0,0,0,0]
[1931,"1930-10-28",0,0,0,0,0]
[1931,"1930-11-28",0,0,0,0,0]
[1931,"1930-12-28",0,0,0,0,0]
[1931,"1931-01-28",0,0,0,0,0]
[1931,"1931-02-28",0,0,0,0,0]
[1931,"1931-03-28",0,0,0,0,0]
[1931,"1931-04-28",0,0,0,0,0]
[1931,"1931-05-28",0,0,0,0,0]
[1931,"1931-06-28",0,0,0,0,0]
[1932,"1931-07-28",0,0,0,0,0]
[1932,"1931-08-28",0,0,0,0,0]
[1932,"1931-09-28",0,0,0,0,0]
[1932,"1931-10-28",0,0,0,0,0]
[1932,"1931-11-28",0,0,0,0,0]
[{"$f":"YEAR(DATE(YEAR(B396),MONTH(B396)+($P$3-1),1))","v":1932},"1931-12-28",0,0,0,0,0]
[1932,"1932-01-28",0,0,0,{"$f":"SUM(C397:E397)","v":0},0]
[1932,{"$f":"IF($E$4=\"Annually\",EDATE(B397,12),IF($E$4=\"Semi-Annual\",EDATE(B397,6),IF($E$4=\"Quarterly\",EDATE(B397,3),IF($E$4=\"Monthly\",EDATE(B397,1),0))))","v":"1932-02-28"},{"$f":"IF($E$4=\"Annually\",(($C$5)*G397),IF($E$4=\"Semi-Annual\",(($C$5/2)*G397),IF($E$4=\"Quarterly\",(($C$5/4)*G397),IF($E$4=\"Monthly\",(($C$5/12))*G397,0))))","v":0},{"$f":"IF(G397>0,$C$6,0)","v":0},0,0,{"$f":"G397-E398","v":0}]
[1932,"1932-03-28",0,0,{"$f":"IF(G398<$C$7,G398,$C$7-C399)","v":0},0,0]
[1932,"1932-04-28",0,0,0,0,0]
[1932,"1932-05-28",0,0,0,0,0]
[1932,"1932-06-28",0,0,0,0,0]
[1933,"1932-07-28",0,0,0,0,0]
[1933,"1932-08-28",0,0,0,0,0]
[1933,"1932-09-28",0,0,0,0,0]
[1933,"1932-10-28",0,0,0,0,0]
[1933,"1932-11-28",0,0,0,0,0]
[1933,"1932-12-28",0,0,0,0,0]
[1933,"1933-01-28",0,0,0,0,0]
[1933,"1933-02-28",0,0,0,0,0]
[1933,"1933-03-28",0,0,0,0,0]