{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Loan Max Worksheet","Detail per employee"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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 Max Worksheet","index":0,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[7,1,7,4],[1,1,1,4],[39,1,39,4],[21,0,21,4],[11,0,11,4],[6,2,6,4],[9,1,9,4],[8,1,8,4],[18,1,18,2],[12,0,12,4],[34,1,35,4],[31,1,31,2]]}
[null,"SBA Paycheck Protection Program - 1st Draw"]
[null,"Estimated Maximum Loan Availability"]
[null,"Worksheet"]
[]
[null,null,"**Complete the \"Detail per employee\" tab and all green highlighted cells"]
[null,null,"Figures entered in the \"Detail per employee\" tab will auto populate the corresponding cells on this page"]
[null,"Borrower:"]
[null,"Represents the annual period of 2019 or 2020"]
[]
[]
[]
["Total Compensation"]
["(US residents only and excluding independent contractors)"]
[]
[null,"Employees Gross Pay",null,{"$f":"'Detail per employee'!B31","v":0},"from Details tab"]
[null,"Group Health Insurance - Employer Contribution",null,{"$f":"'Detail per employee'!C31","v":0},"from Details tab"]
[null,"Retirement Benefit Costs - Employer Contribution",null,{"$f":"'Detail per employee'!D31","v":0},"from Details tab"]
[null,"State/Local Taxes - Paid by Employer",null,{"$f":"'Detail per employee'!E31","v":0},"from Details tab"]
[null,"Outstanding amounts of any EIDL obtained on or after January 31, 2020"]
[null,null,"Total Compensation:",{"$f":"SUM(D15:D19)","v":0}]
[]
["Exclusions:"]
[null,"Employee Gross Pay in excess of $100,000",null,{"$f":"'Detail per employee'!G31","v":0},"from Details tab"]
[null,"Federal Taxes/Contributions paid by Employer, if included above"]
[null,null,"Total Exclusions:",{"$f":"SUM(D23:D24)","v":0}]
[]
[null,null,"Net Payroll Costs:",{"$f":"D20-D25","v":0}]
[null,null,"Average Monthly Payroll Costs:",{"$f":"D27/12","v":0}]
[null,null,"Multiplier:",2.5]
[null,null,"Subtotal",{"$f":"D28*D29","v":0}]
[]
[null,"MAXIMUM LOAN AMOUNT [Lesser of Subtotal or $10 million]",null,{"$f":"IF(D30<10000000,D30,10000000)","v":0}]
[]
[]
[null,"All information provided in connection with SBA Form 2483 and this Loan Max Calculator Worksheet is true, complete and accurate.  Any false statement whether willful or negligent may result in civil liability or criminal penalty."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2021-01-15"]

{"sheet":"Detail per employee","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Detailed List of Employees (US Residents Only and excluding Independent Contractors)"]
["Name/Number","Employee Gross Pay (includes salary, Bonus, OT, Vacation, Sick, separation, tips)","Health Care Benefits (including insurance premiums) - Employer Contribution","Retirement Benefits - Employer Contribution","State/Local Taxes - Employer Paid (not income tax withholding, which is included in Employee Gross Pay)","TOTAL EMPLOYEE COMPENSATION","Exclusions (Employee Gross Pay capped at $100,000)"]
[null,null,null,null,null,{"$f":"SUM(B3:E3)","v":0},{"$f":"IF(B3>100000,B3-100000,0)","v":0}]
[null,null,null,null,null,0,{"$f":"IF(B4>100000,B4-100000,0)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["Totals*",{"$f":"SUM(B3:B30)","v":0},0,0,0,0,0]
[]
["*Must provide source documents"]
["Use CTL+d to Add Rows (Macros needs to be enabled)"]