{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Loan"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Loan","index":0,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,5]]}
["Studio Recording Equipment Amortization"]
[]
["Input Area"]
["Equipment Cost",24500]
["Down Payment",8545]
["Amount of the Loan",15955]
["Loan APR",4.7500000000000001E-2]
["# of Years in Loan",4]
["# of Payments Per Year",12]
["Monthly Payment",365.63]
[]
["Pmt #","Beginning Balance","Monthly Payment","Interest Paid","Principal Reduction","Ending Balance"]
[1,15955,365.63,63.16,302.47000000000003,15652.53]
[2,15652.53,365.63,61.96,303.67,15348.86]
[3,15348.86,365.63,60.76,304.87,15043.98]
[4,15043.98,365.63,59.55,306.08,14737.91]
[5,14737.91,365.63,58.34,307.29000000000002,14430.61]
[6,14430.61,365.63,57.12,308.51,14122.11]
[7,14122.11,365.63,55.9,309.73,13812.38]
[8,13812.38,365.63,54.67,310.95,13501.42]
[9,13501.42,365.63,53.44,312.19,13189.24]
[10,13189.24,365.63,52.21,313.42,12875.82]
[11,12875.82,365.63,50.97,314.66000000000003,12561.16]
[12,12561.16,365.63,49.72,315.91000000000003,12245.25]
[13,12245.25,365.63,48.47,317.16000000000003,11928.09]
[14,11928.09,365.63,47.22,318.41000000000003,11609.68]
[15,11609.68,365.63,45.95,319.67,11290.01]
[16,11290.01,365.63,44.69,320.94,10969.07]
[17,10969.07,365.63,43.42,322.20999999999998,10646.86]
[18,10646.86,365.63,42.14,323.48,10323.370000000001]
[19,10323.370000000001,365.63,40.86,324.76,9998.61]
[20,9998.61,365.63,39.58,326.05,9672.56]
[21,9672.56,365.63,38.29,327.33999999999997,9345.2199999999993]
[22,9345.2199999999993,365.63,36.99,328.64,9016.58]
[23,9016.58,365.63,35.69,329.94,8686.64]
[24,8686.64,365.63,34.380000000000003,331.24,8355.4]
[25,8355.4,365.63,33.07,332.55,8022.85]
[26,8022.85,365.63,31.76,333.87,7688.97]
[27,7688.97,365.63,30.44,335.19,7353.78]
[28,7353.78,365.63,29.11,336.52,7017.26]
[29,7017.26,365.63,27.78,337.85,6679.41]
[30,6679.41,365.63,26.44,339.19,6340.22]
[31,6340.22,365.63,25.1,340.53,5999.69]
[32,5999.69,365.63,23.75,341.88,5657.81]
[33,5657.81,365.63,22.4,343.23,5314.58]
[34,5314.58,365.63,21.04,344.59,4969.99]
[35,4969.99,365.63,19.670000000000002,345.96,4624.03]
[36,4624.03,365.63,18.3,347.32,4276.71]
[37,4276.71,365.63,16.93,348.7,3928.01]
[38,3928.01,365.63,15.55,350.08,3577.93]
[39,3577.93,365.63,14.16,351.47,3226.46]
[40,3226.46,365.63,12.77,352.86,2873.6]
[41,2873.6,365.63,11.37,354.25,2519.35]
[42,2519.35,365.63,9.9700000000000006,355.66,2163.69]
[43,2163.69,365.63,8.56,357.06,1806.63]
[44,1806.63,365.63,7.15,358.48,1448.15]
[45,1448.15,365.63,5.73,359.9,1088.26]
[46,1088.26,365.63,4.3099999999999996,361.32,726.94]
[47,726.94,365.63,2.88,362.75,364.19]
[48,364.19,365.63,1.44,364.19,0]