{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Treasury Rates","Calculator (Annotated)"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Treasury Rates","index":0,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"TODAY()","v":"2015-07-07"}]
["US Treasury Rates: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue Bond Index:"]
["http://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yield ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.bondbuyer.com/apps/custom/msa_search.php?product=bbi_history&col3=1&start_date=01%2F01%2F2015&end_date=&submit=GO"]
["Date","1 mo","3 mo","6 mo","1 yr","2 yr","3 yr","5 yr","7 yr","10 yr","20 yr","30 yr",null,null,null,"Date","Revenue Bond Index"]
["2015-07-01",0.01,0.01,0.13,0.28000000000000003,0.69,1.08,1.7,2.14,2.4300000000000002,2.92,3.2,null,null,null,"2015-01-08",4.26]
["2015-07-02",0.01,0.01,0.1,0.26,0.64,1.01,1.64,2.09,2.4,2.9,3.19,null,null,null,"2015-01-15",4.0599999999999996]
["2015-07-06",0.01,0.02,0.09,0.26,0.6,0.95,1.56,2,2.2999999999999998,2.78,3.08,null,null,null,"2015-01-22",4.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-29",4.0599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-05",4.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-12",4.2300000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-19",4.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-26",4.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-05",4.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-12",4.3099999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-19",4.1900000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-26",4.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-02",4.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-09",4.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-16",4.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-23",4.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-30",4.3099999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-07",4.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-14",4.4800000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-21",4.5599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-28",4.4800000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-04",4.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-11",4.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-18",4.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-25",4.2699999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-02",4.25]

{"sheet":"Calculator (Annotated)","index":1,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,10,0,12]]}
[null,"Loan amount",100000000,null,null,null,null,null,null,null,"Annual Debt Service Schedule"]
[null,{"$f":"\"RE-Act loan interest rate: \"&TEXT(TODAY()-1,\"mmm d, yyyy\")","v":"RE-Act loan interest rate: Jul 6, 2015"},{"$f":"IF(ISNUMBER('Treasury Rates'!L7),INDEX('Treasury Rates'!L:L,MATCH('Treasury Rates'!B1,'Treasury Rates'!A1:A102,1))/100,0.025)","v":3.0800000000000001E-2},null,null,null,null,null,null,null,"Year","RE-Act Loan","Municipal Bond","xfilter"]
[null,"30 year municipal bond rate",4.3099999999999999E-2,null,null,null,null,null,null,null,{"$f":"$C$4","v":2015},{"$f":"IF($B$12=\"\",IF(K3<$C$6+$C$7,IF(K3<$C$6,IF($C$8=TRUE,$C$9,0),$C$14),0),0)","v":5115733.8375011133},{"$f":"IF($B$12=\"\",IF(K3<$C$4+30,$C$15,0),0)","v":5939315.3598916298},{"$f":"IF(K3<$C$6+$C$7,TRUE,FALSE)","v":true}]
[null,"Loan/bond disbursement",2015,null,null,null,null,null,null,null,{"$f":"K3+1","v":2016},5115733.8375011133,5939315.3598916298,true]
[null,"Substantial completion of project:",2020,null,null,null,null,null,null,null,{"$f":"K4+1","v":2017},5115733.8375011133,5939315.3598916298,true]
[null,"Repayment begins:",2015,null," ",null,null,null,null,null,2018,5115733.8375011133,5939315.3598916298,true]
[null,"RE-Act loan repayment period",30,"years",null,null,null,null,null,null,2019,5115733.8375011133,5939315.3598916298,true]
[null,"Pay interest during deferral period",false,null,null,null,null,null,null,null,2020,5115733.8375011133,5939315.3598916298,true]
[null,"Interest payment",{"$f":"IF($C$8=TRUE,$C$1*((1+$C$2)^(1/$C$10)-1)*$C$10,\"\")","v":""},null,null,null,null,null,null,null,2021,5115733.8375011133,5939315.3598916298,true]
[null,"Payments per year",2,null,null,null,null,null,null,null,2022,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2023,5115733.8375011133,5939315.3598916298,true]
[null,{"$f":"IF(C6>(C5+5),\"Repayment must begin no later than 5 years after the date of substantial completion of the project\",IF(C6+C7>C5+35,\"The final maturity date of the loan must be no later than 35 years after the date of substantial completion of the project\",\"\"))","v":""},null,null,null,null,null,null,null,null,2024,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2025,5115733.8375011133,5939315.3598916298,true]
[null,"RE-Act Loan Annual Debt Service",{"$f":"IF(B12=\"\",IF(C8=FALSE,(C10*(C1*(((1+C2)^(1/C10))^((C6-C4)*C10))))*(((1+C2)^(1/C10)-1)/(1-(1+((1+C2)^(1/C10)-1))^-(C7*C10))),C1*(((1+C2)^(1/C10)-1)/(1-(1+((1+C2)^(1/C10)-1))^-(C7*C10)))*C10),\"-\")","v":5115733.8375011133},null,null,null,null,null,null,null,2026,5115733.8375011133,5939315.3598916298,true]
[null,"30 Year Municipal Bond Annual Debt Service",{"$f":"((((1+C3)^(1/C10)-1)/(1-(1+((1+C3)^(1/C10)-1))^-(30*C10)))*C1)*C10","v":5939315.3598916298},null,null,null,null,null,null,null,2027,5115733.8375011133,5939315.3598916298,true]
[null,"Annual Savings vs 30 Year Municipal Bond",{"$f":"IF(B12=\"\",C15-C14,\"-\")","v":823581.52239051647},null,null,null,null,null,null,null,2028,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2029,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2030,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2031,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2032,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2033,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2034,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2035,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2036,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2037,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2038,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2039,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2040,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2041,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2042,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2043,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2044,5115733.8375011133,5939315.3598916298,true]
[null,null,null,null,null,null,null,null,null,null,2045,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2046,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2047,{"$f":"IF($B$12=\"\",IF(K35<$C$6+$C$7,IF(K35<$C$6,IF($C$8=TRUE,$C$9,0),$C$14),0),0)","v":0},0,false]
[null,null,null,null,null,null,null,null,null,null,2048,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2049,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2050,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2051,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2052,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2053,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2054,0,0,false]
[null,null,null,null,null,null,null,null,null,null,2055,0,{"$f":"IF($B$12=\"\",IF(K43<=$C$4+30,$C$15,0),0)","v":0},false]
[null,null,null,null,null,null,null,null,null,null,2056,0,{"$f":"\"-\"","v":"-"},false]
[null,null,null,null,null,null,null,null,null,null,2057,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2058,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2059,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2060,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2061,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2062,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2063,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2064,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2065,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2066,0,"-",false]
[null,null,null,null,null,null,null,null,null,null,2067,0,"-",false]