Version 1.02 HCV Program Budgeting & 2-year Forecast
Purpose:
General
Instruction:
Contact:
Methodologies Used
All Estimated Unit HAP and PUC data for calculations are derived from the
actual HAP & UML data, entered on the 'Raw Data' worksheet or if the '3
checkbox is checked the 3-month PUC Avg. and HAP and unit data will be
is entered in the PUC Over-ride box on the 'Fund & Unit Analysis' W/S, the
take 1st precedence. The PUC chosen will affect all estimated months of d
and following years before any variables are entered or voucher issuance
that monthly entries on the HAP & UML Table are considered actual data
no variable entries or voucher additions will be reflected in these months
Outstanding Vouchers will be assumed to be leased at 50% of the allocati
success rate in the first month and 50% in the second month after the mo
drop-down box). Port-ins absorbed will be considered under lease in the
the drop-down box.
All of the proposed, outstanding, port-ins absorbed and other projected a
subtractions of vouchers in the current CY will be added to the beginning
following CY, thus allowing for two distinct and separate years of budgeti
Instructions
MACROS MUST be enabled or the workbook will NOT function. This is
compatible with any Excel version before 2002.
Look for additional instruction and information in comment boxes when y
over cells showing a red triangle in the upper right corn
Look for RED colored cells indicating various flags such as over-leasing o
Data may only be entered in cells with bright yellow fil
Raw Data' is the main and only entry page that is required to be comple
There are also 2 PUC over-ride entries ( 'Fund & Unit Analysis' W/S) to u
HAP cost for projections for the current and/or the following calendar
monthly PUC over-rides and unit additions and deletions are available o
Page. The "New ACC Units' Page is used to enter any new HCV
Raw Data Worksheet
New ACC Units
Fund & Unit Analysis
Data Tables
Projections
Issue Calcs
Admin Fees
Optional Variables Utilized
Annual Attrition rate %
Avg. No. Months from Issued to HAP Eff. Date
Success rate %
* NOTE - The 'success rate' and 'Avg. No. Months from Issued to HAP Eff. Date' variab
voucher issuances and therefore, by changing these variables, the effect upon the ove
change accordingly.
Uncontracted
Number of vouchers to be issued Uncontracted Vouchers on the
Vouchers on the
Rides
and issuance month street (Cont'd)
street
PUC Over-
Additional notes for
Voucher Issuances
Outstanding
'on the street'
Voucher Avg.
PUC Estimate
Potential Termination PUC
Estimate
The 'Projections' Worksheet offers important information for the current and followi
and HAP calculations. For estimations of funding (Rebenchmarking), it calculates the e
for the next CY by using current CALENDAR YEAR actual & estimated HAP cost and UM
current draft Appropriations Bill (the Federal Fiscal Year was used in the past).
Also added to the base new year funding calculation will be any funding for proposed
vouchers, uncontracted 'on the street' vouchers and Port-ins. Any new ACC units liste
Units' Page will be funded for the number of months assumed not to be in the base of
expenses (*all units assumed to be leased after 3 full months from the effective date o
increment) at the maximum of the average PUC for the current CY or the original fund
funding allowed for the new CY will be the baseline number of units available multipli
estimated HAP PUC. The baseline UMA and monthly HAP obligation at the start (Janu
uses the December current year base numbers with variables applied.
*Note that the new year's funding calculation uses the current 2010 funding methodo
entered on the VMS Table ONLY funded for the unit months that are NOT projected to
estimates of the current CY used for projecting the following CY funding (Uses a 3-mon
ACC effective date to lease-up of additional units). Otherwise, the projected funding w
'double-counting' the new units.
Features & additional methodologies
Annual attrition variable applied using a base period (January) and applying the annua
and converting to an 'estimated monthly vouchers leaving program' figure. The Annu
following CY uses December of the current CY as a base from which to attrite monthly
methodology is sound and simulates actual annual attrition rate. Any new issues, incl
outstanding vouchers and proposed issuances are NOT part of the attrition calculation
however; the new attrition base for the following CY includes these units.
Data Validation is used for most data entry cells to limit the potential for errors in dat
not allowed and certain limits are put on variables to disallow unreasonable variable u
A "Professional" quality appearance is utilized and transferred to print-outs.
Conditional formatting alerts user by color code to over-utilization of HAP and\or unit
terminations for current and future years.
Additional comments are added in several cells to further instruct and\or explain data
Allows user to choose latest month known that uncontracted (on the street with fami
port-in vouchers accepted in the program. This helps pinpoint when the additional vo
begin during the CY.
Includes useful graphs for current and following year estimated leasing in contrast to
units and the number of units supported at the calculated PUC.
Admin Fees' Worksheet will calculate the monthly and total estimated UNA balances f
years and project the increases in fees generated by the issuance of additional vouche
Included Button Macro on top of page that allows the naming and saving of any numb
projection scenarios on separate worksheets in the same workbook. These separate w
print out with the same professional appearance and quality as the main 'HCV Project
Relevant and Latest Notices (Links)
Tip : If you cannot open the link by double-clicking, try putting the cursor over the
clicking and then choosing 'Open Hyperlink' on the pop-up me
General HUD PIH Notices by Year
Implementation of the Federal Fiscal Year 2010 Funding Provisions for
PIH 09-51 PHA Determinations of Rent Reasonableness in the Housing Ch
Program - Comparable Unassisted Units in the Premise
PIH 09-44 Cost- Savings Measures in the Housing Choice Voucher (
Notice PIH 2008-9 (HA) - Financial Reporting Requirements for the
.
V Program Budgeting & 2-year Forecasting Tool
This tool shows a PHA's monthly utilization and YTD utilization based on 2010
funding and current HAP Cost & Monthly Units Leased (UML) data. In
addition, it makes projections throughout the current calendar year (CY) and
the following CY based on current actual data with optional real-world
variables applied to help pin-point the optimum number of voucher issuances
to make without over-spending available HAP funding or over-leasing the
baseline number of vouchers in a calendar Year (CY).
Use the yellow boxes to type in PHA data and projection variables (explained
below). Note that 'Data Validation' has been used to help limit accidental
input of ineligible data such as text of unreasonable assumptions which will
invoke an error message upon entry.
If you need technical assistance, please contact Michael Carney at (305)520-
5071 or via email michael.j.carney@hud.gov.
Methodologies Used
d Unit HAP and PUC data for calculations are derived from the 'Current' month of
& UML data, entered on the 'Raw Data' worksheet or if the '3-month' PUC Avg.
checked the 3-month PUC Avg. and HAP and unit data will be used. If an amount
n the PUC Over-ride box on the 'Fund & Unit Analysis' W/S, the Over-ride PUC will
cedence. The PUC chosen will affect all estimated months of data for the current
ng years before any variables are entered or voucher issuances proposed. *Note
y entries on the HAP & UML Table are considered actual data for that month so
entries or voucher additions will be reflected in these months.
g Vouchers will be assumed to be leased at 50% of the allocation at the entered
in the first month and 50% in the second month after the month selected (in the
box). Port-ins absorbed will be considered under lease in the month selected in
wn box.
oposed, outstanding, port-ins absorbed and other projected additions or
s of vouchers in the current CY will be added to the beginning base of units for the
Y, thus allowing for two distinct and separate years of budgeting.
Instructions
S MUST be enabled or the workbook will NOT function. This is NOT backwards
compatible with any Excel version before 2002.
ditional instruction and information in comment boxes when you move the cursor
over cells showing a red triangle in the upper right corner.
ED colored cells indicating various flags such as over-leasing or data entry issues.
Data may only be entered in cells with bright yellow fill.
' is the main and only entry page that is required to be completed and updated.
also 2 PUC over-ride entries ( 'Fund & Unit Analysis' W/S) to use an optional Avg.
t for projections for the current and/or the following calendar years. Optional
UC over-rides and unit additions and deletions are available on the 'Data Tables'
Page. The "New ACC Units' Page is used to enter any new HCV ACC data.
Raw Data Worksheet
This is the main Data Entry worksheet used for entering PHA info, Funding,
Baseline Unit & Program Variable Entries and Proposed new voucher
issuances. Also, the monthly HAP Costs and units leased data is entered here.
The 'Current' HAP cost and units under contract MUST be entered and
updated regularly as the projections for the estimated months are based upon
the latest current data. Also, any additions to NRA such as interest earned,
fraud recoveries and FSS escrow recaptures should be updated each month
(Line 3) to reflect the total received since the first of January.
The Voucher Issuance Table should be used when your PHA shows an under-
leased or under HAP-utilized situation as noted on the 'Projections' W/S. You
may also enter potential planned issuances for the following CY that will have
an effect upon the projected HAP costs for that year.
*Note that the current HAP and Unit data may vary from the latest month's
data entries because of items such as HAP landlord payment holdbacks that
may not be included in the current month but, in all likelihood, will be paid in
a future month.
New ACC Units
Enter any new ACC project increments that will increase the budget and unit
allocation of the HCV Program. Enter the number of units and total annual
ABA for the increment(s) in the appropriate month and calendar year. For
calculation purposes, the baseline number of units and funding for new
increments are pro-rated for the number of months they are effective in the
current and following calendar years. For example, if a new increment is
effective in June, only half of the units and HAP funding (6 months) will be
used for baseline and funding calculations.
The spreadsheet uses the current methodology for estimating funding for
new project increments that become effective after the first of the year. The
new units are considered leased-up and in VMS after 3 months from the
effective date and will be funded in the following year for the months not
assumed to be in the base year (CY) of expenses.
Fund & Unit Analysis
Provides additional funding, unit and HAP cost analyses. Allows HAP cost
Over-ride to determine projections of costs for units leased in all estimated
months for the current and following calendar years. Will provide important
HAP funding availability and units supported information given projected HAP
costs.
Data Tables
Provides data and utilization details for each month of the current and
following calendar years. Proposed unit additions and deletions may also be
entered for any estimated month of data. Individual PUC monthly Over-rides
are available on this worksheet.
Projections
This is the main projection sheet showing all of the variables used for
projection and providing critical spending and leasing projections. Line 10 of
the 'Projections' W/S identifies the estimated number of vouchers the current
CY funding will support if the issuance takes place on the 1st of the month
following the last actual month of Unit and HAP cost data entered on the 'Raw
Data' W/S. It should only be used as a starting reference NOT as a firm
number of vouchers to issue.
TIP - Use the button at the top of the page to save the current worksheet to a
separate page. This allows the creation, printing and side-by-side analyses of
several scenarios using different variables.
Issue Calcs
This shows the monthly and the annual unit lease-up and HAP cost
projections for new unit proposals entered on the 'Raw Data' Worksheet for
the current and following calendar years.
Admin Fees
This is a calculator AND a forecasting tool to determine the monthly
administrative fees earned based upon the current funding methodology
using the PHA's Table rates. It uses an entered pro-ration % based upon any
reductions to eligible Fees earned by HUD due to total Congressional funding
availability for the calendar year.
It will forecast Admin. Costs based upon the last month of costs entered and
it will determine the estimated increase in Admin. Fees earned due to any
new units leased forecasted through the current and following calendar years.
It also estimates any Unrestricted Net Assets (UNA) due to any surplus or
deficit of earned admin. fees over the actual and estimated admin. costs for
the current and following calendar years.
Optional Variables Utilized
The Attrition Rate is based on the January unit leased data, turned into a number of
monthly vouchers that will be projected lost through the estimated months remaining in
the CY. For example if January shows a UML of 120 units and the Attrition rate entered is
10%, the formula will take 12 units and divide this number by 12 months to get 1 voucher
lost through attrition each month and applied ONLY to the remaining months. If data in
the VMS table goes through February, then there will be 10 remaining months left of
estimation, so 10 X 1 voucher is 10 total vouchers lost through the CY. The base of attrition
for the following CY is based upon the December projected UML's for December of the
current CY. Any new Proposed, Outstanding, and Ports to be absorbed are not attrited in
the current year but are added to the base for the following year for attrition.
This is an estimate of the average time in number of months [Note - decimals may be used
(e.g. 2.6)] it takes from voucher issuance to a family to getting a lease signed. This applies
to the 'Actual and\or Proposed Voucher Issuances' Table below and determines the
amount of funded unit months in the current and following CY. For Example, if a proposed
voucher issuance of 20 vouchers is made in May and the success rate entered in the
variable above is 50% and the number of average months entered for this variable is 3,
then the assumption would be that these 10 (20 * 50% success) vouchers will be leased in
August because that is the third month after May. From August until December, there are
5 months remaining, so there would be 5 X 10 vouchers or 50 total unit months and
associated HAP calculated through the year. For HAP utilization purposes, this number is
multiplied by the 'Avg. HAP PUC (shown on line 12 on the 'Fund & Unit Analysis' W/S) for
the Remaining Estimated Months w\variables applied.
There is also an optional voucher monthly distribution table that allows estimated
percentages of vouchers leased after issue by month. If the percentages entered equals
100%, this distribution to determine new issue impact is used instead of the 'Avg. No. of
Months for families with new vouchers to obtain Lease' entered on line 9 of the Variables
Table. The 'Issue Calcs' Worksheet shows the impact of the new issues on the calculations
in units leased and HAP through the current and following calendar years based upon
either the Avg. no. of months OR the Optional Table % distribution.
If using the Actual or Proposed Voucher Issuance Table, a number for a percentage MUST
be entered for this variable to allow any entries in this table to have an effect upon the
estimated months of data through the CY. This is an estimate of the number of newly
issued voucher holders that end up with a lease.
success rate' and 'Avg. No. Months from Issued to HAP Eff. Date' variables impact these
nces and therefore, by changing these variables, the effect upon the overall projections will
dingly.
This is the actual or estimated active NEW vouchers (DO NOT COUNT vouchers issued to
tenants in transition), currently actively searching. The units and associated HAP estimated
to be utilized are calculated by determining the remaining months left in the year after
these outstanding vouchers are brought to lease. The default value built into the formula
is an assumption that one half (50%) of the allocation in the month after the month
selected as outstanding and 50% in the second month will be brought to lease. For
example if 10 units are estimated to be outstanding at the beginning of April, 5 will be
included in May and 5 in June for calculations.
For example, 100 vouchers are entered for this variable with a success rate of 80% entered
in the variable above and it is determined that the beginning of April was the last month
that these vouchers were known to be outstanding The calculation for this example is to
take 100 vouchers multiplied by 80% success rate to arrive at 80 vouchers. These 80
vouchers will be considered leased by June 1st (50% in May & 50% in June). Please note
that the variable of 'Avg. no. Months from Issued to HAP Eff. date' is NOT used because,
unlike the 'Actual or Proposed NEW' voucher issuances, there is not enough information
available to determine when these vouchers were issued (Aging) so the formulas assume
that the uncontracted vouchers will be leased within 2 months from the current month
selected in the drop-down box. Note that it is VERY important to keep current on updating
this number if using for calculation purposes. Also, it is recommended to use the following
month as a start date if the known voucher outstanding data is in the middle or late in a
month as the methodologies always assume leasing as of the first of the month.
These are optional entries on the 'Fund & Unit Analysis' W/S to determine the HAP costs'
effect on the HCV Program for all actual and proposed new voucher issuances going
forward into the estimated months. If no amount is entered, then the default PUC of the
'Current Month' ('Raw Data' W/S) or the latest 3-month Avg., if box is checked, is used to
determine HAP costs for the estimated months before variables are applied.
This should be completed (Line 11 of the 'Projections' W/S) after ALL other variables and
current funding, cost and unit data is entered. Unless, over-spending or over-leasing is
projected, this worksheet predicts (BEFORE entering a number) an approximate
MAXIMUM (Not necessarily OPTIMUM) number of vouchers that a PHA can issue based
upon the month highlighted in the drop-down box that will not result in an over-leasing or
over-spending in the CURRENT Calendar Year.
However, if this number results in the projected over-spending or over-leasing in the
following CY, RED flag conditions will be noted with details given below on the page.
Different voucher issuance amounts and the month of proposed issuance may then be
entered to arrive at an OPTIMUM amount within the "Safe Zone" chosen by your PHA. This
Safe Zone is displayed in the following year's projected use of funds and units leased in
relation to the projected funding and unit months available. This is displayed as a percent
AND a number of dollars and units projected to be retained after the estimated costs and
units leased are projected for the new CY.
* The 'Safe Zone' or retainages should be sufficient to account for the unpredictability of
the program variables and possibility of future funding methodology changes or
reductions. Often a PHA may NOT be able to lease the maximum amount of units available
in the current year because over-spending of funding and over-leasing of units may occur in
the following year. This often happens when a PHA tries to play "Catch-up" because of
often severe under-leasing in the early months of the year so larger than normal voucher
issuances are then made to compensate. However, economic factors and program attrition
may not allow the program to be reduced sufficiently in the following year to stay within
the unit and funding constraints, leaving the PHA with, often material NRA deficits.
This is an optional entry to determine the HAP costs' effect on the HCV Program for the
Vouchers Outstanding (NEW Families issued a voucher but still searching). If no amount is
entered, then the default PUC of the average of all estimated months of data for the year is
used to determine HAP costs. However; the default estimated PUC often has no
correlation to the outstanding voucher Avg. PUC which can often be estimated with
accuracy using the data available to the PHA (Tenant application, voucher BR size, etc.).
This is an Override amount entered that will be used to determine how many (if over-
leased) vouchers may be lost. The formulas used for calculations take the total amount of
negative funding available at the end of the year (all variables included) shown in table
above and divides by the number of 'remaining months of cost measures' and multiplied
this total by either the Avg. HAP PUC the user enters in this box or, if no entry is made, the
estimated Avg. PUC for all remaining months of data. However; the default estimated PUC
often has no correlation to the potentially terminated voucher Avg. PUC which can often be
estimated with accuracy using the data available to the PHA (Tenant application, voucher
BR size, etc.). The 'remaining months of cost measures' is assumed to be the greater of
either zero (0) or the calculated remaining number of estimated months minus 3 months
for an assumption that it will take approximately 3 months to complete the process and
terminate these families' assistance.
ns' Worksheet offers important information for the current and following years' estimated unit
lations. For estimations of funding (Rebenchmarking), it calculates the estimated base funding
Y by using current CALENDAR YEAR actual & estimated HAP cost and UML's as anticipated in the
Appropriations Bill (the Federal Fiscal Year was used in the past).
the base new year funding calculation will be any funding for proposed or newly issued
ontracted 'on the street' vouchers and Port-ins. Any new ACC units listed on the 'New ACC
ll be funded for the number of months assumed not to be in the base of the current CY
units assumed to be leased after 3 full months from the effective date of the project
the maximum of the average PUC for the current CY or the original funded PUC. The maximum
ed for the new CY will be the baseline number of units available multiplied by the overall yearly
P PUC. The baseline UMA and monthly HAP obligation at the start (January) of the following CY
mber current year base numbers with variables applied.
e new year's funding calculation uses the current 2010 funding methodology with any new units
e VMS Table ONLY funded for the unit months that are NOT projected to be in the HAP cost
he current CY used for projecting the following CY funding (Uses a 3-month assumption from
date to lease-up of additional units). Otherwise, the projected funding would be overstated by
ing' the new units.
Features & additional methodologies
on variable applied using a base period (January) and applying the annual factor to this unit data
g to an 'estimated monthly vouchers leaving program' figure. The Annual attrition for the
uses December of the current CY as a base from which to attrite monthly units. This
is sound and simulates actual annual attrition rate. Any new issues, including absorbed ports,
ouchers and proposed issuances are NOT part of the attrition calculations for the current CY;
new attrition base for the following CY includes these units.
on is used for most data entry cells to limit the potential for errors in data-entry. Non-values are
nd certain limits are put on variables to disallow unreasonable variable use.
al" quality appearance is utilized and transferred to print-outs.
rmatting alerts user by color code to over-utilization of HAP and\or unit data and potential
for current and future years.
mments are added in several cells to further instruct and\or explain data entry to user.
o choose latest month known that uncontracted (on the street with families searching) and any
ers accepted in the program. This helps pinpoint when the additional vouchers and HAP will
he CY.
ul graphs for current and following year estimated leasing in contrast to the baseline number of
number of units supported at the calculated PUC.
Worksheet will calculate the monthly and total estimated UNA balances for two full calendar
ject the increases in fees generated by the issuance of additional vouchers.
on Macro on top of page that allows the naming and saving of any number of financial
narios on separate worksheets in the same workbook. These separate worksheets appear and
the same professional appearance and quality as the main 'HCV Projection" Worksheet.
Relevant and Latest Notices (Links)
cannot open the link by double-clicking, try putting the cursor over the Hyperlink then right
clicking and then choosing 'Open Hyperlink' on the pop-up menu.
General HUD PIH Notices by Year
entation of the Federal Fiscal Year 2010 Funding Provisions for the HCV Program
PHA Determinations of Rent Reasonableness in the Housing Choice Voucher (HCV)
Program - Comparable Unassisted Units in the Premises
09-44 Cost- Savings Measures in the Housing Choice Voucher (HCV) Program
ce PIH 2008-9 (HA) - Financial Reporting Requirements for the HCV Program
Actualnd\orPpse
VoucherIsan
PHA Name: PHA Number: 1/20/2012 0:09
comments:
Calendar Year (CY) Ending Date
Month Day Year
December 31 2010
1 Annual Budget Authority (ABA): Optional Voucher Success
2 Net Restricted Assets (NRA) as of January 1st: Distribution Table
3 Any additional NRA - year-to-date (update monthly): Days from issue to lease % of Issue to success
4 Calculated Months Remaining in Calendar Yr: 12 0-30
5 Calculated Ending NRA Balance for CY: $0 31-60
Optional - OFFSET percentage of CY 2011 funding
6 61-90
eligibility ($0 est. reduction in funding):
7 Starting Baseline Number of Units under ACC: 91-120
8 Annual Attr. % Rate 121-150
Avg. No. of Months for families with new vouchers to Calculated Avg.
9 151-180
obtain Lease: Mths to Lease-up:
10 Success Rate of new voucher-holders to obtain lease: Total: 0% 0.00
No. outstanding vouchers - still
11 1st of this month- Aug
searching / Avg. PUC:
No. of Port-Ins to absorb in
12 1st of this month- Aug
month selected
Actual New and\or Proposed Voucher Issuances Optional Avg. HAP Actual New and\or Proposed Voucher Optional Avg. HAP
(Assumes 1st of Month) PUC for new issues Issuances (Assumes 1st of Month) PUC for new issues
Jan 2010 Jan 2011
Feb 2010 Feb 2011
Mar 2010 Mar 2011
Apr 2010 Apr 2011
May 2010 May 2011
June 2010 June 2011
July 2010 July 2011
Aug 2010 Aug 2011
Sept 2010 Sept 2011
Oct 2010 Oct 2011
Nov 2010 Nov 2011
Dec 2010 Dec 2011
Total Used: 0 Total Used: 0
Check the box on right if you want to use the latest 3-month HAP PUC below for Est.
costs for future months before the variables are applied. $0.00 check to use 3-Mth PUC Avg. in calcs
Current HAP Burden & Units
$0.00 0.00% 0.00%
under Contract
Current CY HAP Cost Units leased Current Avg. PUC Unit Lease % HAP Utilized %
January $0.00 0.00% 0.00%
February $0.00 0.00% 0.00%
March $0.00 0.00% 0.00%
April $0.00 0.00% 0.00%
May $0.00 0.00% 0.00%
June $0.00 0.00% 0.00%
July $0.00 0.00% 0.00%
August $0.00 0.00% 0.00%
September $0.00 0.00% 0.00%
October $0.00 0.00% 0.00%
November $0.00 0.00% 0.00%
December $0.00 0.00% 0.00%
TOTALS $0 0 $0.00 0.00% 0.00%
All Annual Budget Authority (ABA) + Budgeted NRA funding for Baseline Units (on a PUC basis) $0.00
PHA's average PUC spent calendar year to date $0.00
MUST ENTER HAP COST AND UNITS LEASED DATA FOR THE CURRENT MONTH IN TABLE ABOVE $0.00
CURRENT MONTH DATA IN TABLE ABOVE NOT ENTERED $0.00
CURRENT MONTH DATA IN TABLE ABOVE NOT ENTERED $0.00
Is there enough funding to reach the baseline number of units using the Avg HAP & Unit data entered in table above YES
PLANNED ISSUANCES
UMLs Derived Remaining Months eventual vouchers
0 12 leased
0 12.00 0 0.00
0 11 0 11.00 0 0.00
0 10 0 10.00 0 0.00
0 9 0 9.00 0 0.00
0 8 0 8.00 0 0.00
0 7 0 7.00 0 0.00
0 6 0 6.00 0 0.00
0 5 0 5.00 0 0.00
0 4 0 4.00 0 0.00
0 3 0 3.00 0 0.00
0 2 0 2.00 0 0.00
0 1 0 1.00 0 0.00
0 0 0
Second Year Second Year Second Year HAP from Avg. Mths Dist.--->
UMLs Derived Remaining Months eventual vouchers 0
leased [NYUM]
Second Year Second Year equals new units for next year not attrited current year will be next CY
0 12 0 12.00 0 -
0 11 0 11.00 0 -
0 10 0 10.00 0 -
0 9 0 9.00 0 -
0 8 0 8.00 0 -
0 7 0 7.00 0 -
0 6 0 6.00 0 -
0 5 0 5.00 0 -
0 4 0 4.00 0 -
0 3 0 3.00 0 -
0 2 0 2.00 0 -
0 1 0 1.00 0 -
0 0 $ -
[NYVUMS]
$ -
[NYVHAP]
Created by Michael Carney -(305)-520-5071
email michael.j.carney@hud.gov
Section 8 HCV Leasing Worksheet - Fund Analysis
PHA:
CYE: 12/31/2010 1/20/2012 0:09
1 Annual Budget Authority: $0
2 Beginning NRA Balance plus any additions entered : $0
3 Prorated additional annual funding for new units: $0
4 Total Available Funding: $0
5 Total HAP Costs YTD: $0
6 Total Remaining for the Next 12 Months: $0
7 Months Remaining in FY: 12
8 Monthly Remaining to Spend: $0
9 Current Total Monthly HAP Costs: $0.00
PUC Over-ride
10 Number of Units Currently Under Lease: 0
Current CY
MUST ENTER HAP COST AND UNITS LEASED DATA FOR
11 $0.00
THE CURRENT MONTH IN TABLE ABOVE
PUC Over-ride
Next CY
12 PUC used for the following Calendar Year $0.00
13 Avg Number units funding will support through CY: 0
14 Baseline (BL) number of units at start of current CY: 0
15 0 New UMs added to Baseline during the year / 12 mths: 0
16 Total BL number of units available: 0
17 Variance from Baseline: 0
18 Additional Funds Needed to meet BL # Units (monthly): $0
19 Additional Funds Needed to meet BL # Units (Annual): $0
20 Additional Annual NRA NOT Budgeted & Available for Use: $0
Est. - WILL be Able to Fund up to Baseline Number of Units.
0
PHA:
CYE: 12/31/2010 1/20/2012 0:09
Current year pro- Current year pro- New Pro-rated
ACC Start Date New Units New Annual HAP Funded PUM
rated UMs rated HAP HAP monthly
January 1, 2010 $0.00 0 $0 $0
February 1, 2010 $0.00 0 $0 $0
March 1, 2010 $0.00 0 $0 $0
April 1, 2010 $0.00 0 $0 $0
May 1, 2010 $0.00 0 $0 $0
June 1, 2010 $0.00 0 $0 $0
July 1, 2010 $0.00 0 $0 $0
August 1, 2010 $0.00 0 $0 $0
September 1, 2010 $0.00 0 $0 $0
October 1, 2010 $0.00 0 $0 $0
November 1, 2010 $0.00 0 $0 $0
December 1, 2010 $0.00 0 $0 $0
Total: 0 $0 $0.00 0 $0 $0
Current year pro- Current year pro- New Pro-rated
ACC Start Date New Units New Annual HAP Funded PUM
rated UMs rated HAP HAP monthly
January 1, 2011 $0.00 0 $0 $0
February 1, 2011 $0.00 0 $0 $0
March 1, 2011 $0.00 0 $0 $0
April 1, 2011 $0.00 0 $0 $0
May 1, 2011 $0.00 0 $0 $0
June 1, 2011 $0.00 0 $0 $0
July 1, 2011 $0.00 0 $0 $0
August 1, 2011 $0.00 0 $0 $0
September 1, 2011 $0.00 0 $0 $0
October 1, 2011 $0.00 0 $0 $0
November 1, 2011 $0.00 0 $0 $0
December 1, 2011 $0.00 0 $0 $0
Total: 0 $0 $0.00 0 $0 $0
Created by Michael Carney -(305)-520-5071 ; email
michael.j.carney@hud.gov
Baseline Supported
Number
UMLs
PHA: CYE: 12/31/2010 Jan 2010
Feb 2010
Section 8 Worksheet to Determine the Number of Vouchers to Issue Mar 2010
Objective is to Fully utilize ABA & budgeted NRA WITHOUT Over-spending or Over-leasing units in current & following CY. Apr 2010
Status CY 2010: Projected Under-leasing of Vouchers. Under-spending of HAP $ May 2010
Jun 2010
1a Funds Support up to Baseline No. of Units: 0 Jul 2010
b Total No. of Units Funding supports: 0 Aug 2010
Sep 2010
2 Average Leasing (Year to Date): 0 Oct 2010
Nov 2010
3 Outstanding 'on the street' Vouchers: 0 Dec 2010
4 Port-ins to absorb In January: 0 RAW DATA ENTRY is REQUIRED for PROJECTIONS Jan 2011
5 Months to achieve lease-up: 0 Feb 2011
Mar 2011
6 Turnover Last 12 months: 0.00 Apr 2011
7 Average Monthly Turnover: 0.00 May 2011
8 Annual Turnover Rate (Attrition): 0.00% Jun 2011
Jul 2011
9 Success Rate of families with 'New Issuances' to obtain Lease Contract: NA Aug 2011
10 Approx. Vouchers need to Issue in January to reach Baseline No. of Units: 0.00 Sep 2011
11 New Issuances from Table on 'Raw Data' W/S: 0.00 Oct 2011
12 ... Results in this many vouchers-holders reaching lease: 0.00 Nov 2011
13 ...Results in this many 'NEW' voucher unit months added in CY: 0 Dec 2011
14 Data required and/or Voucher Success Rate Required on 'Raw Data W/S!' NA
15 Data required and/or Voucher Success Rate Required on 'Raw Data W/S!' NA
16 Data required and/orVoucher Success Rate Required on 'Raw Data W/S!' NA
17 Data required and/or Voucher Success Rate Required on 'Raw Data W/S!' NA
Funds Support up to Baseline No. of Units: 0
Min (Baseline or # Supported) in total UMA's: 0
1/20/2012 0:09
Pace of vouchers leased (Avg. to date Annualized): 0
Pace of vouchers leased less 0 UM's lost thru Attrition: 0
Est. UML's including new, port-ins & outstanding issuances: 0
0 UMs added during the
Est. Annual HAP Costs (@$.0 PUC) equate to NA Util. Rate: $0 CY due to new,
Annual HAP Funding ABA plus all NRA: $0 outstanding & Port-in
vouchers.
Estimated Ending NRA Balance at the end of the Calendar Year: $0
1
1
1
1
1 UML's
1
0 Units Supported
0
Baseline Units
0
0
-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010
Status CY 2011: NOT Over-leased or Over-spent
Dollars Baseline Units /UMA
NOT ENOUGH DATA TO CALCULATE FUTURE YEAR FUNDING!: $0 /
Calculated NRA Ending Balance for Current CY: $0 Units/UML supported at $.0
Avg. PUC
Estimated funding for new units: $0
Possible Offset of current CY Ending NRA Balance (@%0): $0
Total Projected Calculated HAP Funding Availability: $0 Units/UML Projected
$0 /
Total 5% retention 'safety net': $0
5% Safety Net uses $ of
Available for retention: $0
funding for projections.
Additional funds needed to reach 5% Projected retention of Funds: $0
1.00
0.90
0.80
0.70
0.60 UML's
0.50
0.40 Units Supported
0.30
Baseline Units
0.20
0.10
0.00
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011
1
1
1
1
1 UML's
1
0 Units Supported
0
Baseline Units
-
0
0
Jan 2010
Feb…
Mar…
Apr…
May…
Jun 2010
Jul 2010
Aug…
Sep…
Oct…
Nov…
Dec…
Jan 2011
Feb…
Mar…
Apr…
May…
Jun 2011
Jul 2011
Aug…
Sep…
Oct…
Nov…
Dec…
Baseline Units
PHA: 1/20/2012 0:09
CYE: 12/31/2010
Baseline Units
PUC (if
Units Adj for
Outstanding
projections
Vouchers
Act. Base Unit none Cum. Cum.
Total ABA Base HAP Unit Portable HAP adj. for Unit Util
Year Month Or Est. Base UMLs Base PUC PUC additions or entered, Add/Del Add/Del Cum. Att. New Issues PUC HAP Util %
+ NRA Exp.s Attrition Units Projections %
Data Over-ride (deletions) uses Base Unit Effect HAP Effect
PUC)
2010 Jan Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Feb Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Mar Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Apr Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 May Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00% #DIV/0!
2010 Jun Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Jul Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Aug Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Sep Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Oct Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Nov Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
2010 Dec Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0.0 $0 $0.00 0.00% 0.00%
Totals: 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0 0 $0 $0.00 0.00% 0.00%
Baseline Units
PUC (if
Units Adj for
Outstanding
projections
Vouchers
Act. Base Unit none Cum. Cum.
Total ABA Base HAP Unit Portable HAP adj. for Unit Util
Year Month Or Est. Base UMLs Base PUC PUC additions or entered, Add/Del Add/Del Cum. Att. New Issues PUC HAP Util %
+ NRA Exp.s Attrition Units Projections %
Data Over-ride (deletions) uses Base Unit Effect HAP Effect
PUC)
2011 Jan Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Feb Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Mar Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Apr Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 May Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Jun Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Jul Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Aug Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Sep Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Oct Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Nov Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
2011 Dec Est. 0 $0 0 $0 $0.00 0 $0 0.0 0.0 0 0 0.0 $0 $0.00 0.00% 0.00%
Totals: 0 $0 0 $0 $0.00 0 $0 0 0 0 0 0 $0
$0.00 0.00% 0.00%
Outstanding
Outstanding
Vouchers
Vouchers
Act. Cum. Add'l Mthly HAP Calculated Cumulative NRA NRA redistributed
Add'l Mthly Cumulative New PUC New Portable PUC
PUC
Year Month Or Est. Unit Attrition at HAP New Issues Outstanding HAP Port CY 2010 Monthly Available starting in evenly over all
HAP Attrition HAP Attrition Issues issues Units Portable
Data Attrition Base PUC Vouchers NRA NRA EST. mths months of estimation
2010 Jan Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Jan $0 $0 $0 $0
2010 Feb Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Feb $0 $0 $0 $0
2010 Mar Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Mar $0 $0 $0 $0
2010 Apr Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Apr $0 $0 $0 $0
2010 May Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 May $0 $0 $0 $0
2010 Jun Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Jun $0 $0 $0 $0
2010 Jul Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Jul $0 $0 $0 $0
2010 Aug Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Aug $0 $0 $0 $0
2010 Sep Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Sep $0 $0 $0 $0
2010 Oct Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Oct $0 $0 $0 $0
2010 Nov Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Nov $0 $0 $0 $0
2010 Dec Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 Dec $0 $0 $0 $0
Projected Ending NRA Includes $0 in
Totals: 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 0 $0.00 $0 $0
additional NRA entered:
Outstanding
Outstanding
Vouchers
Vouchers
Act. Add'l Mthly Calculated Cumulative NRA NRA redistributed
Unit Add'l Mthly Cumulative New PUC New HAP Portable PUC
PUC
Year Month Or Est. Attrition at HAP New Issues HAP Port CY 2011 Monthly Available starting in evenly over all
Attrition HAP Attrition HAP Attrition Issues issues Outstanding Units Portable
Data Base PUC NRA NRA EST. mths months of estimation
2011 Jan Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Jan $0 $0 $0
2011 Feb Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Feb $0 $0 $0 $0
2011 Mar Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Mar $0 $0 $0 $0
2011 Apr Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Apr $0 $0 $0 $0
2011 May Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 May $0 $0 $0 $0
2011 Jun Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Jun $0 $0 $0 $0
2011 Jul Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Jul $0 $0 $0 $0
2011 Aug Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Aug $0 $0 $0 $0
2011 Sep Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Sep $0 $0 $0 $0
2011 Oct Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Oct $0 $0 $0 $0
2011 Nov Est. 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Nov $0 $0 $0 $0
2011 Dec Est. 0 $0.00 $0 $0 0 $0.00 $0 0 $0.00 $0 Dec $0 $0 $0 $0
Totals: 0 $0.00 $0 $0.00 0 $0.00 $0 0 $0.00 $0 Projected Ending NRA Balance: $0
2-year Totals PHA: CYE: 12/31/2010 1/20/2012 0:09
UM's added 0
HAP exp. $0 Month and Number of New and/or Proposed UM's & HAP in Effect
Months CUM. New
New UMS Feb 2010 Mar 2010 Apr 2010 May 2010 Jun 2010 Jul 2010 Aug 2010 Sep 2010 Oct 2010 Nov 2010 Dec 2010 Jan 2011 Feb 2011 Mar 2011 Apr 2011 May 2011 Jun 2011 Jul 2011 Aug 2011 Sep 2011 Oct 2011 Nov 2011 Dec 2011
Affected UMs
Jan 2010 - -
Feb 2010 - - -
Mar 2010 - - - -
Apr 2010 - - - - -
May 2010 - - - - - -
Jun 2010 - - - - - - -
Jul 2010 - - - - - - -
Aug 2010 - - - - - - -
Sep 2010 - - - - - - -
Oct 2010 - - - - - - -
Nov 2010 - - - - - - -
Dec 2010 - - - - - - -
Total: - - - - - - - - - - - -
Jan 2011 - - - - - - -
Feb 2011 - - - - - - -
Mar 2011 - - - - - - -
Apr 2011 - - - - - - -
May 2011 - - - - - - -
Jun 2011 - - - - - - -
Jul 2011 - - - - - - -
Aug 2011 - - - - - - -
Sep 2011 - - - - - - -
Oct 2011 - - - - - - -
Nov 2011 - - - - - - -
Dec 2011 - - - - - - -
Total: - - - - - - - - - - - - - - - - -
Months CUM.
HAP Exp. Feb 2010 Mar 2010 Apr 2010 May 2010 Jun 2010 Jul 2010 Aug 2010 Sep 2010 Oct 2010 Nov 2010 Dec 2010 Jan 2011 Feb 2011 Mar 2011 Apr 2011 May 2011 Jun 2011 Jul 2011 Aug 2011 Sep 2011 Oct 2011 Nov 2011 Dec 2011
Effected HAP Exp.
Jan 2010 - -
Feb 2010 - - -
Mar 2010 - - - -
Apr 2010 - - - - -
May 2010 - - - - - -
Jun 2010 - - - - - - -
Jul 2010 - - - - - - -
Aug 2010 - - - - - - -
Sep 2010 - - - - - - -
Oct 2010 - - - - - - -
Nov 2010 - - - - - - -
Dec 2010 - - - - - - -
Totals: - - - - - - - - - - - -
Jan 2011 - - - - - - -
Feb 2011 - - - - - - -
Mar 2011 - - - - - - -
Apr 2011 - - - - - - -
May 2011 - - - - - - -
Jun 2011 - - - - - - -
Jul 2011 - - - - - - -
Aug 2011 - - - - - - -
Sep 2011 - - - - - - -
Oct 2011 - - - - - - -
Nov 2011 - - - - - - -
Dec 2011 - - - - - - -
Totals: - - - - - - - - - - - - - - - - -
Created by Michael Carney -(305)-520-5071
email michael.j.carney@hud.gov
PHA: Enter Est. Pro-ration %
1/20/2012 0:09 CYE: 12/31/2010
Administrative Fee Calculation 12/31/2010
This shows an Administative Fee Table to determine Fee per UML
increase in Admin.
Fees Earned, due to A B C The Admin Fee Earned is based upon the current funding methodology where the first
600 units are funded at the 'Column A' rate and any additional units leased are funded
an increase in new
units leased, in the 0.00 0.00 at the 'Column B' rate.
amounts of $0 & $0 Enter Override if values
Enter Beginning CY UNA Balance:
for the current and above not correct
following Calendar Estimated Admin Fee Estimated Admin Fee Additional estimated Potential Unrestricted Net
Years, respectively. Earned @ 100.0% - Earned @ 100.0% - Admin. Fees earned due Assets (UNA) - uses
Attrition applied - no New Attrition applied - with to any new or proposed projections w/ New Units
Actual Admin Costs Estimated Admin. Costs units New units new units projected & Attrition applied
January 2010 $0 $0 $0 $0
February 2010 $0 $0 $0 $0 $0
March 2010 $0 $0 $0 $0 $0
April 2010 $0 $0 $0 $0 $0
May 2010 $0 $0 $0 $0 $0
June 2010 $0 $0 $0 $0 $0
July 2010 $0 $0 $0 $0 $0
August 2010 $0 $0 $0 $0 $0
September 2010 $0 $0 $0 $0 $0
October 2010 $0 $0 $0 $0 $0
November 2010 $0 $0 $0 $0 $0
December 2010 $0 $0 $0 $0 $0
Est. Total: $0 $0 $0 $0 $0 $0
Est. Totals for CY 2011: $0 $0 $0 $0 $0