SBA_Loan_Calculator__807781

	A	B	C	D	E	F	G
1	CORONAVIRUS AID, RELIEF AND ECONOMIC SECURITY ACT (CARES ACT)
2	PAYCHECK PROTECTION PROGRAM LOAN (PPPL)
3	ELIGIBILITY REQUIREMENTS
4	1. Entity Types - Small Business Concerns, Non-Profit and Veteran Organizations and Tribal Business Concerns
5	2. Employment Limit - 500 Employees; or if applicable, the number of employees the SBA has established as the size standard for the business’s primary (see link in comment for the North American Industry Classification System (NAICS) code.
6	3. Includes Sole Proprietors, Independent Contractors, and Eligible Self-Employed Individuals
7	4. Businesses and Entities must have been in in operation on February 15, 2020
8	5. Good Faith Certification from Borrower that States
9	I	the uncertainty of current economic conditions makes necessary the loan request to support the ongoing operations of the eligible recipient
10	II	Acknowledging that Funds used will be used to retain workers and maintain payroll or make mortgage payments, lease payments and utility payments
11	III	That the eligible recipient does not have an application pending for a SBA loan for the same purpose and duplicative of amounts applied for or received under a covered loan
12	IV	And during the period beginning on February 15, 2020 and ending on December 31, 2020, that the eligible recipient has not received amounts from the SBA for the same purpose and duplicative of amounts applied for or received under a covered loan
13	ESTIMATED MAXIMUM ALLOWABLE PAYCHECK PROTECTION PROGRAM LOAN CALCULATION
14	(The Average total Monthly payments for payroll costs incurred during the 1-year period before date on which loan is made)
15	PAYROLL COSTS		1-YEAR PERIOD PRIOR TO PPPL			COST INCURRED	NOTES
16	Gross Wages Paid		4/1/2019	-	3/31/2020		This should include salaries, and/or wages. Payroll, and income taxes are excluded
17	Add'l Wages - tips, or equivalent		4/1/2019	-	3/31/2020
18	Less Wages >100k To an individual employee		4/1/2019	-	3/31/2020		The maximum allowable amount is $100k per employee
19	Self-Employment Income to Proprietor/Partners		4/1/2019	-	3/31/2020		Not to exceed 100K per Individual
20	State and Local taxes on Compensation		4/1/2019	-	3/31/2020
21	State Unemployment insurance		4/1/2019	-	3/31/2020
22	Health Insurance		4/1/2019	-	3/31/2020		Employer paid portion only
23	NYS Disability & Paid-Family Leave		4/1/2019	-	3/31/2020		This includes payment for vacation, parental, family, medical, or sick leave
24	Retirement Plan Contributions		4/1/2019	-	3/31/2020
25	Sub-Total					-
26	Average Monthly Payroll Costs					-
27	PPPL Multiplier					2.50
28	Tentative Estimated PPPL based upon Payroll Costs					-
29	Covered Loan Balance						Outstanding Amount of an SBA Loan that was made between January 31, 2020 and date of Covered Loan
30	Tentative PPPL					-
31	Maximum Allowable					10,000,000.00
32	Estimated PPPL Amount					-
33	Note: Different Calculations required for Seasonal Employers
34	ALLOWABLE USES OF PPPL
35	1. Payroll Costs
36	2. Costs related to the continuation of group health care benefits during perios for paid sick leave, medical or family leave & insurance premiums
37	3. Employee salaries, commissions or similar compensation
38	4. Payments of interest on any mortgage obligation incurred before February 15, 2020 (which shall not include any prepayment of or payment of principal on mortgage obligation)
39	5. Rent under leasing agreement that were in place prior to February 15, 2020
40	6. Utilities including Electricity, gas, water, transportation, telephone or internet access for which services began before February 15, 2020.
41	PPPL COVERED LOAN FORGIVENESS CALCULATION
42	BASED UPON PAYMENTS DURING COVERED PERIOD (8 week period beginning on date of the origination of PPPL)
43	ALLOWABLE USE PAYMENTS		8 WEEK COVERED PPPL PERIOD			COST INCURRED & PAID	NOTES
44	Gross Wages Paid		4/1/2020	-	5/31/2020		This should include salaries, and/or wages. Payroll, and income taxes are excluded
45	Add'l Wages - tips, or equivalent		4/1/2020	-	5/31/2020
46	Less Wages >100k To an individual employee		4/1/2020	-	5/31/2020
47	Self-Employment Income to Proprietor/Partners		4/1/2020	-	5/31/2020
48	State Unemployment insurance		4/1/2020	-	5/31/2020
49	Health Insurance		4/1/2020	-	5/31/2020
50	NYS Disability & Paid-Family Leave		4/1/2020	-	5/31/2020
51	Retirement Plan Contributions		4/1/2020	-	5/31/2020
52	Mortgage Interest		4/1/2020	-	5/31/2020
53	Rent Payments		4/1/2020	-	5/31/2020
54	Gas & Electric		4/1/2020	-	5/31/2020
55	Water & Sewer		4/1/2020	-	5/31/2020
56	Telephone -Land Line		4/1/2020	-	5/31/2020
57	Telephone - Business Cell		4/1/2020	-	5/31/2020
58	Internet Connection		4/1/2020	-	5/31/2020
59	Total Covered Costs Paid					-
60	Potential Loan Forgiveness Amount					-
61	Reduction Based Upon Reduction in Number of FTE's Computed Below					-
62	Reduction Based Upon Reduction in Payroll Costs as Computed Below					-
63	Adjusted Estimated Loan Forgiveness Amount					-
64	Estimated Remaining Covered Loan Amount (Up to 10 Year Repayment Term At Rate not to Exceed 4%)					-
65	Note eligible recipient will need to submit documentation verifying the number of full-time equivalents and payroll rates for the covered period including payroll tax filings with the IRS and State agencies, cancelled checks, payment receipts, transcripts of account or other documents verifying payments on covered mortgage obligations, covered leases and covered utility payments. Along with a certification from a representative of the eligible recipient authorized to make such certifications that
66	A	The Documentation presented is true and correct
67	B	The amount for which forgiveness is requested was used to retain employees, make interest payments on a covered mortgage obligation, make payments on a covered rent obligation, or make covered utility payments.
68	C	Any other documentation the SBA determines necessary
69	PPPL POTENTIAL FORGIVENESS REDUCTION CALCULATION
70	BASED UPON AVERAGE FULL TIME EQUIVALENTS (FTE's)
71	Period		COVERED PERIOD DATES			# Of FTE'S	NOTES
72	Covered Period From		4/1/2020	-	4/30/2020
73	Covered Period From		5/1/2020	-	5/31/2020
74	Average Number of FTE's During Covered Period					0
75	Comparison Period Option 1
76	Period From		2/15/2019	-	2/28/2019
77	Period From		3/1/2019	-	3/31/2019
78	Period From		4/1/2019	-	4/30/2019
79	Period From		5/1/2019	-	5/31/2019
80	Period From		6/1/2019	-	6/30/2019
81	Average Number of FTE's During Option Period #1					0
82	Comparison Period Option 2
83	Period From		1/1/2020	-	1/31/2020
84	Period From		2/1/2020	-	2/29/2020
85	Average Number of FTE's During Option Period #2					0
86	AVERAGE FTE PPPL FORGIVENESS REDUCTION CALCULATION
87	Average # of FTE's During Covered Period					0
88	Average # of FTE's During Comparison Period #				2	0
89	PPPL Reduction Quotient					0.00%
90	Potential PPPL Forgiveness Amount					-
91	Loan Reduction Amount					-
92	Note: The average number of full-time equivalent is determined by calculating the average number of full-time equivalent employees for each pay period falling within the month.
93	PPPL POTENTIAL FORGIVENESS REDUCTION CALCULATION
94	BASED UPON REDUCTION RELATING TO SALARY & WAGES
95	Employee Name					Salary/Wage Reduction > 25%	NOTES
96
97
98
99
100