{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CBC provided 1st PPP loan","Loan Max Worksheet","Detail per employee","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"CBC provided 1st PPP loan","index":0,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[7,2,7,4],[8,1,8,4],[50,1,52,4],[40,0,40,4],[11,1,11,2],[15,0,15,4],[16,0,16,4],[22,1,22,2],[26,0,26,4],[36,1,36,2]]}
[null,"SBA Paycheck Protection Program - 2nd Draw"]
[null,"Maximum Loan Amount Confirmation &"]
[null,"Revenue Reduction Worksheet"]
[]
[null,null,"**Initial PPP Loan with CBC, and previous Loan Max Calc Wkst was based on 2019 Payroll**"]
[null,null,"**Complete all green highlighted cells**"]
[]
[null,"Borrower:"]
[]
[]
[]
[null,"NAICS Code for Borrower begins with \"72\"  (Accommodation and Food Services):"]
[]
[]
[]
["Maximum Loan Amount Confirmation (2nd Draw Only)"]
["*Below information is based on 2019 numbers*"]
[]
[null,"Employees Gross Pay",null,null,"from original wkst"]
[null,"Group Health Insurance - Employer Contribution",null,{"$f":"'Detail per employee'!C32","v":0},"from original wkst"]
[null,"Retirement Benefit Costs - Employer Contribution",null,{"$f":"'Detail per employee'!D32","v":0},"from original wkst"]
[null,"State/Local Taxes - Paid by Employer",null,{"$f":"'Detail per employee'!E32","v":0},"from original wkst"]
[null,"Outstanding Amt of EIDL obtained on or after 1/1/2020 (NOT INCLUDED IN 1st PPP LOAN)"]
[null,null,"Total Compensation (from original wkst*):"]
[null,null,"*Exclude any EIDL Amount on original wkst"]
[]
["Exclusions:"]
[null,"Employee Gross Pay in excess of $100,000",null,{"$f":"'Detail per employee'!G32","v":0},"from original wkst"]
[null,"Federal Taxes/Contributions paid by Employer, if included above",null,null,"from original wkst"]
[null,null,"Total Exclusions (from original wkst):"]
[]
[null,null,"Net Payroll Costs:",{"$f":"D24-D30","v":0}]
[null,null,"Average Monthly Payroll Costs:",{"$f":"D32/12","v":0}]
[null,null,"Multipler:",{"$f":"IF(D12=\"Yes\", 3.5, 2.5)","v":2.5}]
[null,null,"Subtotal",{"$f":"D33*D34","v":0}]
[]
[null,"MAXIMUM LOAN AMOUNT [Lesser of Subtotal or $2 million]",null,{"$f":"IF(D35<2000000,D35,2000000)","v":0}]
[]
[]
[]
["Revenue Reduction Test"]
[null,null,"Date Range - PLEASE UPDATE AS NEEDED"]
[null,"Quarterly* Revenue (2020)","2Q 2020 (Defaulted) - Please update as needed"]
[null,"Comparative Quarterly* Revenue","2Q 2019 (Defaulted) - Please update as needed"]
[null,"*Please ensure totals are for calendar Quarter-To-Date (QTD) revenue and not Year-To-Date (YTD)"]
[null,null,"% REVENUE DECREASE [Must be a decrease of 25% or more]",{"$f":"(D43-D44)/D44","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Source Documentation may be requested from you in connection to your application."]
[]
[null,"All information provided in connection with SBA Form 2483-SD and this Loan Max Calculator Confirmation 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":"Loan Max Worksheet","index":1,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,1,53,4],[24,0,24,4],[15,0,15,4],[7,2,7,4],[9,1,9,4],[16,0,16,4],[48,1,49,4],[34,1,34,2],[38,0,38,4],[12,1,12,2],[4,1,4,4],[0,1,0,4],[2,1,2,4],[8,1,8,4],[1,1,1,4]]}
[null,"SBA Paycheck Protection Program - 2nd Draw"]
[null,"Maximum Loan Amount Calculation &"]
[null,"Revenue Reduction Worksheet"]
[]
[null,"**Initial PPP Loan was provided by another bank, OR previous Loan Max Calc was not based on 2019 payroll**"]
[null,null,"**Complete all green highlighted cells**"]
[]
[null,"Borrower:"]
[null,"Represents the annual period of 2019 or 2020"]
[]
[]
[]
[null,"NAICS Code for Borrower begins with \"72\"  (Accommodation and Food Services):"]
[]
[]
["Total Compensation"]
["(US residents only and excluding independent contractors)"]
[]
[null,"Employees Gross Pay",null,{"$f":"'Detail per employee'!B32","v":0},"from Details tab"]
[null,"Group Health Insurance - Employer Contribution",null,{"$f":"'Detail per employee'!C32","v":0},"from Details tab"]
[null,"Retirement Benefit Costs - Employer Contribution",null,{"$f":"'Detail per employee'!D32","v":0},"from Details tab"]
[null,"State/Local Taxes - Paid by Employer",null,{"$f":"'Detail per employee'!E32","v":0},"from Details tab"]
[null,null,"Total Compensation:",{"$f":"SUM(D19:D22)","v":0}]
[]
["Exclusions:"]
[null,"Employee Gross Pay in excess of $100,000",null,{"$f":"'Detail per employee'!G32","v":0},"from Details tab"]
[null,"Federal Taxes/Contributions paid by Employer, if included above"]
[null,null,"Total Exclusions:",{"$f":"SUM(D26:D27)","v":0}]
[]
[null,null,"Net Payroll Costs:",{"$f":"D23-D28","v":0}]
[null,null,"Average Monthly Payroll Costs:",{"$f":"D30/12","v":0}]
[null,null,"Multipler:",{"$f":"IF(D13=\"Yes\", 3.5, 2.5)","v":2.5}]
[null,null,"Subtotal",{"$f":"D31*D32","v":0}]
[]
[null,"MAXIMUM LOAN AMOUNT [Lesser of Subtotal or $2 million]",null,{"$f":"IF(D33<2000000,D33,2000000)","v":0}]
[]
[]
[]
["Revenue Reduction Test"]
[null,null,"Date Range - PLEASE UPDATE AS NEEDED"]
[null,"Quarterly* Revenue (2020)","2Q 2020 (Defaulted) - Please update as needed"]
[null,"Comparative Quarterly* Revenue","2Q 2019 (Defaulted) - Please update as needed"]
[null,"*Please ensure totals are for calendar Quarter-To-Date (QTD) revenue and not Year-To-Date (YTD)"]
[null,null,"% REVENUE DECREASE [Must be a decrease of 25% or more]",{"$f":"(D41-D42)/D42","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Source Documentation may be requested from you in connection to your application."]
[]
[null,"All information provided in connection with SBA Form 2483 and this Loan Max Caluclator 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":2,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["**COMPLETE ONLY IF:  Initial PPP Loan was provided by another bank, OR previous Loan Max Calc was not based on 2019 payroll*"]
["Detailed List of Employees (US Residents Only and excluding Independent Contractors)"]
["Name/Number","Employee Gross Pay (includes salary, Bonus, OT, Vacation, Sick, separatation, tips)","Health Care Benefits (including insurance premiums) - Employer Contribution","Retirement Benefits - Employer Contribution","State/Local Taxes - Employer Paid (not income tax witholding, 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(B4:E4)","v":0},{"$f":"IF(B4>100000,B4-100000,0)","v":0}]
[null,null,null,null,null,0,{"$f":"IF(B5>100000,B5-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(B4:B31)","v":0},0,0,0,0,0]
[]
["*Must provide source documents"]
["Use CTL+d to Add Rows (Macros needs to be enabled)"]

{"sheet":"Sheet2","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Yes"]
["No"]