{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Forgiveness Cal Form 3508 ","PPP Schedule A","Sch  A Worksheet","Owner Comp Worksheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Forgiveness Cal Form 3508 ","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
[]
[{"$nulls":4},"Greyed out fields have formulas and you should not overwrite them"]
[{"$nulls":4},"Blue fields are to be  entered by you"]
[]
[]
[]
[null,"PPP Loan Forgiveness Calculation:"]
[]
[null,"Payroll and Nonpayroll Costs"]
["Line 1"," Payroll Costs (enter the amount from PPP Schedule A, line 10):",{"$f":"+'PPP Schedule A'!C29","v":81155}]
["Line 2"," Business Mortgage Interest Payments: ",15000]
["Line 3"," Business Rent or Lease Payments:",45000,null,null,{"$f":"+C11+C12+C13","v":70000}," =Total Non-payroll costs"]
["Line 4"," Business Utility Payments:",10000]
[]
[null,"Adjustments for Full-Time Equivalency (FTE) and Salary/Hourly Wage Reductions"]
["Line 5"," Total Salary/Hourly Wage Reduction (enter the amount from PPP Schedule A, line 3):",{"$f":"+'PPP Schedule A'!C14","v":6000}]
["Line 6"," Add the amounts on lines 1, 2, 3, and 4, then subtract the amount entered in line 5: ",{"$f":"+C10+C11+C12+C13-C16","v":145155}]
["Line 7"," FTE Reduction Quotient (enter the number from PPP Schedule A, line 13):",{"$f":"+'PPP Schedule A'!C41","v":0.5}]
[]
[null,"Potential Forgiveness Amounts"]
["Line 8.","Modified Total (multiply line 6 by line 7):",{"$f":"+C17*C18","v":72577.5}]
["Line 9.","PPP Loan Amount:",200000]
["Line 10.","Payroll Cost 75% Requirement (divide line 1 by 0.75):",{"$f":"+C10/0.75","v":108206.66666666667}]
[]
[null,"Forgiveness Amount"]
["Line 11"," Forgiveness Amount (enter the smallest of lines 8, 9, and 10):",{"$f":"MIN(C21:C23)","v":72577.5}]
[]
[null,"Amount not forgiven and due in 24 months from loan disbursement date",{"$f":"+C22-C26","v":127422.5}]

{"sheet":"PPP Schedule A","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,1,6,2],[4,0,4,1],[5,0,5,1],[0,2,0,3]]}
[]
[]
[]
[]
["Greyed out fields have formulas and you should not overwrite them"]
["Blue fields are to be  entered by you"]
[null,"PPP Schedule A"]
[null," Read All Instructions to Form 3508, Schedule A and Schedule A Worksheet Before Completing"]
[null,"This Worksheet is prepared for use only by a non-seasonal employer"]
[null,"PPP Schedule A Worksheet, Table 1 Totals"]
[]
["Line 1.","Enter Cash Compensation (Box 1) from PPP Schedule A Worksheet, Table 1:",{"$f":"+'Sch  A Worksheet'!J19:J19","v":22000}]
["Line 2.","Enter Average FTE (Box 2) from PPP Schedule A Worksheet, Table 1:",{"$f":"+'Sch  A Worksheet'!L19","v":3}]
["Line 3.","Enter Salary/Hourly Wage Reduction (Box 3) from PPP Schedule A Worksheet, Table 1:",{"$f":"+'Sch  A Worksheet'!N19","v":6000}]
[null,"If the average annual salary or hourly wage for each employee listed on the PPP Schedule A Worksheet, Table 1 during the Covered Period or the Alternative Payroll Covered Period was at least 75% of such employee’s average annual salary or hourly wage between January 1, 2020 and March 31, 2020, check here       and enter 0 on line 3."]
[null,"PPP Schedule A Worksheet, Table 2 Totals"]
["Line 4.","Enter Cash Compensation (Box 4) from PPP Schedule A Worksheet, Table 2:",{"$f":"+'Sch  A Worksheet'!J35","v":30770}]
["Line 5.","Enter Average FTE (Box 5) from PPP Schedule A Worksheet, Table 2:",{"$f":"+'Sch  A Worksheet'!L35","v":2}]
[null,"Non-Cash Compensation Payroll Costs During the Covered Period or the Alternative Payroll Covered Period"]
["Line 6"," Total amount paid by Borrower for employer contributions for employee health insurance:",3000]
["Line 7"," Total amount paid by Borrower for employer contributions to employee retirement plans:",8000,null,15]
["Line 8"," Total amount paid by Borrower for employer state and local taxes assessed on employee compensation:",2000]
[]
[null,"Compensation to Owners"]
["Line 9"," Total amount paid to owner-employees/self-employed individual/general partners from Owner Comp Worksheet:",{"$f":"+'Owner Comp Worksheet'!I19","v":15385}]
[null,"This amount may not be included in PPP Schedule A Worksheet, Table 1 or 2. If there is more than one individual included, attach a separate table that lists the names of and payments to each."]
[]
[null,"Total Payroll Costs"]
["Line 10"," Payroll Costs (add lines 1, 4, 6, 7, 8, and 9): ",{"$f":"+C12+C17+C20+C21+C22+C25","v":81155}]
[null,"Full-Time Equivalency (FTE) Reduction Calculation"]
[null,"If you have not reduced the number of employees or the average paid hours of your employees between"]
[null,"January 1, 2020 and the end of the Covered Period, check the box , skip lines 11 and 12 and enter 1.0 on line 13."]
[]
[null,"Reference period for FTE Denominator"]
[null,"Option 1: The average number of FTE employees on payroll per month employed by the Borrower between February 15, 2019 and June 30, 2019",10]
[null,"Option 2: The average number of FTE employees on payroll per month employed by the Borrower between January 1, 2020 and February 29, 2020",15]
[]
["Line 11"," Average FTE during the Borrower’s chosen reference period:",{"$f":"MIN(C34:C35)","v":10}]
[]
["Line 12"," Total Average FTE during the covered period (add lines 2 and 5): ",{"$f":"+C13+C18","v":5}]
["Line 13"," FTE Reduction Quotient (divide line 12 by line 11) or enter 1.0 if FTE Safe Harbor is met:",{"$f":"+C40/C38","v":0.5}]

{"sheet":"Sch  A Worksheet","index":2,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[25,12,25,14],[4,0,4,14],[25,0,25,5],[25,6,25,7],[23,0,23,14],[24,0,24,14],[18,0,18,5],[18,6,18,7],[21,0,21,5],[21,6,21,7],[21,8,21,10],[16,0,16,5],[16,6,16,7],[33,0,33,5],[33,6,33,7],[34,0,34,5],[34,6,34,7],[29,6,29,7],[30,0,30,5],[30,6,30,7],[31,0,31,5],[31,6,31,7],[32,0,32,5],[32,6,32,7],[29,0,29,5],[26,0,26,5],[26,6,26,7],[27,0,27,5],[27,6,27,7],[28,0,28,5],[28,6,28,7],[44,0,44,14],[38,0,38,3],[39,0,39,14],[41,0,41,14],[42,0,42,14],[43,0,43,14],[17,0,17,5],[17,6,17,7],[14,0,14,5],[14,6,14,7],[15,0,15,5],[15,6,15,7],[9,0,9,5],[9,6,9,7],[12,0,12,5],[12,6,12,7],[13,0,13,5],[13,6,13,7],[10,0,10,5],[10,6,10,7],[11,0,11,5],[11,6,11,7],[0,13,0,14],[6,0,6,14],[7,0,7,14],[8,0,8,5],[8,6,8,7],[2,0,2,14],[3,0,3,14],[1,0,1,14]]}
[{"$nulls":16},"Greyed out fields have formulas and you should not enter data"]
["PPP Schedule A Worksheet ",{"$nulls":15},"Blue fields are to be  entered by you"]
["Read All Instructions to Form 3508, Schedule A and Schedule A Worksheet Before Completing"]
["•Do not include in Table 1 or Table 2 below owner-employees (shareholders working in the business), general partners including active LLC members and member managers and self-employed (i.e. sole proprietors).  All of these individuals are not counted in the FTE formula and their cash compensation during the covered period is reported on PPP Schedule A, Line 9."]
["•Do not enter more than $15,385 in Cash Compensation in Table 1 or Table 2 for any individual employee."]
["Table 1:  List employees who:"]
[" • Were employed by the Borrower at any point during the Covered Period or the Alternative Payroll Covered Period whose principal place of residence is in the United States; and"]
[" • Received compensation from the Borrower at an annualized rate of less than or equal to $100,000 for all pay periods in 2019 or were not employed by the Borrower at any point in 2019."]
["Employee's Name",{"$nulls":5},"Employee Identifier",null,null,"Cash Compensation During Covered Period",null,"\nAverage FTE                 ",null,"Salary / Hourly Wage Reduction"]
[{"$nulls":9},10000,null,1,null,2000]
[{"$nulls":9},8000,null,1,null,1000]
[{"$nulls":9},4000,null,1,null,3000]
[]
[]
[]
[]
[]
["FTE Reduction Exceptions:",{"$nulls":8},0]
["Totals:",{"$nulls":7},"Box 1",{"$f":"SUM(J10:J18)","v":22000},"Box 2",{"$f":"SUM(K10:L18)","v":3},"Box 3",{"$f":"SUM(M10:N18)","v":6000}]
[]
["Insert additional rows if needed by in Table 1 if needed"]
[]
["Table 2: List employees who:"]
["  • Were employed by the Borrower at any point during the Covered Period or the Alternative Payroll Covered Period  whose principal place of residence is in the United States; and"]
["  • Received compensation from the Borrower at an annualized rate of more than $100,000 for any pay period in 2019"]
["Employee's Name",{"$nulls":5},"Employee Identifier",null,null,"Cash Compensation During Covered Period",null,"\nAverage FTE                 ","Do not enter more than $15,385 in Cash Compensation in Table 1 or Table 2 for any individual employee"]
[{"$nulls":9},15385,null,1]
[{"$nulls":9},15385,null,1]
[]
[]
[]
[]
[]
[]
["Totals:",{"$nulls":7},"Box 4",{"$f":"SUM(J27:J34)","v":30770},"Box 5",{"$f":"SUM(K27:L34)","v":2}]
[]
["Insert additional rows if needed by in Table 2 if needed"]
[]
["FTE Reduction Safe Harbor:"]
["Step 1.    Enter the borrower’s total average FTE between February 15, 2020 and April 26, 2020.  Follow the same method that was used to calculate Average FTE in the PPP Schedule A Worksheet Tables.  Sum across all employees and enter:"]
[]
["Step 2.    Enter the borrower’s total FTE in the Borrower’s pay period inclusive of February 15, 2020.  Follow the same method that was used in step 1: "]
["Step 3.    If the entry for step 2 is greater than step 1, proceed to step 4.  Otherwise, the FTE Reduction Safe Harbor is not applicable and the Borrower must complete line 13 of PPP Schedule A by dividing line 12 by line 11 of that schedule."]
["Step 4.    Enter the borrower’s total FTE as of June 30, 2020:--------------------------------------------------------------------->"]
["Step 5.  If the entry for step 4 is greater than or equal to step 2, enter 1.0 on line 13 of PPP Schedule A; the FTE Reduction Safe Harbor has been satisfied. Otherwise, the FTE Reduction Safe Harbor does not apply and the borrower must complete line 13 of PPP Schedule A by dividing line 12 by line 11 of that schedule."]

{"sheet":"Owner Comp Worksheet","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,0,9,5],[12,0,12,5],[12,6,12,7],[13,0,13,5],[13,6,13,7],[14,0,14,5],[14,6,14,7],[24,0,24,2],[0,7,0,9],[9,6,9,7],[10,0,10,5],[10,6,10,7],[11,0,11,5],[11,6,11,7],[18,0,18,5],[18,6,18,7],[6,0,6,8],[15,0,15,5],[15,6,15,7],[16,0,16,5],[16,6,16,7],[17,0,17,5],[17,6,17,7]]}
[{"$nulls":10},"Greyed out fields have formulas and you should not enter data"]
[{"$nulls":10},"Blue fields are to be  entered by you"]
[]
[]
[]
[]
["Compensation to Owners Worksheet"]
[]
[]
["Owner Employee/General Partner/Active LLC Member/Self Employed Individual",{"$nulls":5},"Employee Identifier",null,"Cash Compensation During Covered Period"]
[{"$nulls":8},15385]
{"$rows_empty":7}
["Totals:",{"$nulls":7},{"$f":"SUM(I11:I18)","v":15385}]
[]
["Do insert additional rows as needed "]