How to Calculate your Eligible Revenue Loss
[Pages:2]How to Calculate your Eligible Revenue Loss
The Federal Government has developed the following calculation to determine the eligible revenue loss for ARPA funding:
[Base Year Revenue*(1+Growth Adjustment)(n/12)] - Actual General Revenue
For your convenience, ACF has developed a spreadsheet that will calculate your eligible loss when you plug in your organization's numbers as described below.
Base Year Revenue Because the Base Year Revenue is defined as the "General Revenue collected in the most recent full fiscal year prior to the COVD-19 public health emergency," that year is most likely FY19, for Fiscal Years running July to June, October to September, or January to December. As an example, Sample Organization's general revenue in FY19 was $750,000. Enter this number into B3 in the Excel
Growth Adjustment Growth Adjustment is equal to the greater of 4.1 percent (or 0.041) and the recipient's average annual revenue growth over the three full fiscal years prior to the COVID-19 public health emergency. If your organization's growth over the FY17, FY18, and FY19 years was over 4.1%, use that metric. Otherwise, use a growth rate of 4.1%. As an example, Sample organization's growth rate was 6.2% (written in the formula as 0.062), so as that number is greater than 4.1%, it will be used in the formula.
n n equals the number of months elapsed from the end of the base year to December 31, 2020. The number of months elapsed since end of your fiscal year would be:
Fiscal Year June to July October to September January to December
Months Included July 2019 ? June 2020 October 2019 ? September 2020 January 2020 ? December 2020
Total Months = n 18 15 12
Our sample organization is on a July to June fiscal year, and so will use the 18 month calculation in the formula.
Actual General Revenue Actual General Revenue is a recipient's actual general revenue collected during 12-month period ending on the calculation date. If calculating on September 1, 2021, include the general revenue collected from September 1, 2020 through August 31, 2021. As an example, Sample Organization's general revenue during the 12 month period was $580,000.
Calculation We will plug the numbers shared above into the formula. Here is the prescribed formula: [Base Year Revenue*(1+Growth Adjustment)(n/12)] - Actual General Revenue
Here is what the formula looks like with our sample numbers plugged in:
Formula Plug In: [$750,000*(1+0.062)(18/12)] ? $580,000
Step 1 of Calculation: [$750,000*(1.062)(1.5)] ? $580,000
Step 2 of Calculation: [$750,000*1.593] ? $580,000
Final Calculation: $1,194,750 ? $580,000
Result: $614,750
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- modeling and accounting methods for estimating
- compustat tools for transfer pricing
- coronavirus state and local fiscal recovery funds
- financial ratio formula sheet fuqua school of business
- cp 43 back to basics with revenue revenue recognition in
- how to calculate your eligible revenue loss
- s p capital iq s excel plug in v 8 x frequently used
- arpa revenue loss calculation
- ebitda calculation excel sheet
- excel add in desktop guide i
Related searches
- how to calculate your annual gross income
- how to calculate your annual income
- how to calculate your hourly rate
- how to calculate your grade average
- how to calculate your class rank
- how to calculate your car payment
- how to calculate your average grade
- how to calculate your grade
- how to calculate your overall grade
- how to calculate your grades avg
- how to calculate your gross income
- how to calculate your hourly rate salary