CSC 2 OMBs revised Credit Subsidy Calculator for
CSC 2 OMB’s revised Credit Subsidy Calculator for the 2009 President’s Budget Tyler Curtis Sarah Lyberg CSC 2@omb. eop. gov
CSC 2 What we’ll cover What the CSC 2 is and when to use it n Goals of transition to the CSC 2, and challenges for implementation n CSC 2 Functionality and Output n ¨ Financing account interest ¨ Examples n Summary 2
Credit Subsidy Calculator 2 (CSC 2) OMB tool for performing credit calculations n Incorporates financing account interest and dollar reestimates functionality, previously in Consolidated Credit Tool (CCredit) and Balances Approach Reestimate Calculator (BARC) n 3
Credit Program Overview Agency C-Credit Interest repayment Program Account Subsidy + Reestimates Treasury CSC C-Credit or BARC Budget line Agency Borrowing Principal Loan Financing Account Principal repayment Loan repayment (P & I) Borrower/ Public Budget: Projecting future cashflows with the Public, reestimates Accounting: Recording actual cashflows, execution, financing account interest Different tools at different times meant sometimes inconsistent data used for credit calculations, & tools used simplified interest calculations. 4
CSC 2: Goals and Challenges n Goals ¨ Simplify and streamline process ¨ Reduce and reconcile errors ¨ Provide decision makers better information on the cost of providing credit assistance n Challenges ¨ Organization barriers ¨ Reconciliation ¨ Transparency 5
Shortfalls of the old process n Financing account interest calculations: No reconciliation with cashflows used to calculate reestimates ¨ No formal process for correcting for interest payments/earnings at budget assumption rates ¨ CSC 2—one cashflow for both, method for interest adjustments ¨ n Traditional approach or Balances approach reestimates: Methods for technical reestimates of cohort subsidy cost ¨ Traditional approach had no check on accounting errors— unexplained balances in financing accounts ¨ Balances approach could not distinguish between reestimates resulting from borrower performance and accounting errors ¨ CSC 2—agencies perform both at once, opportunity to reconcile ¨ 6
Goals: Streamline the process n Three separate tools combined into one CSC C-Credit BARC ¨ Budget subsidy rates ¨ Reestimates ¨ Financing Account Interest in C-Credit CSC 2 7
Goals: Reduce/reconcile errors Consistent data n Disconnects in financing account balances are transparent n Accounting differences are transparent n ¨ Subsidy execution ¨ Financing account interest earnings/costs ¨ Modifications 8
Goals: Better subsidy cost estimates for policy makers n Cost accurately reflects long term cost to government, borrower performance ¨ Transactions to and from public + Intra-governmental transactions = Financing account balance ¨ Corrects disconnects in previous methods Financing account interest consistent with discounting methodology n Method for financing account interest adjustments n 9
Challenges: Organization Barriers Agencies need to start building process ¨ Build in regular communication ¨ Ownership/roles clearly defined ¨ Documentation, record maintenance ¨ Identifying and resolving data issues 10
Challenges: Reconciliation n Calculates reestimates using traditional and balances approach ¨ Calculated vs reported cohort balances ¨ Balances approach (assets = liabilities) ¨ Traditional approach (cashflows to/from public) Financing Account Interest Adjustments n Differences will require explanation n 11
Challenges: Transparency Accounting mistakes uncovered sooner rather than later n Auditors will see differences n Key is to work now to identify and analyze discrepancies n One-time effort to transition existing cohorts is necessary n 12
CSC 2 Functionality Budget subsidy rates n Interest rate reestimates n Single effective rate/cohort interest rate n Financing account interest n Dollar Reestimates n Financing Account Interest Adjustments n 13
Financing Account Interest: Review n Credit financing accounts earn interest on balances ¨ Interest earnings are received from the Treasury Financial Management Service n Credit financing accounts pay interest on outstanding borrowings from Treasury ¨ Interest payments are made to the Treasury Bureau of the Public Debt n n Cohorts must use the same rate as used to discount cashflows These earnings and costs affect the deficit 14
CSC 2: Financing account interest FAIC n Simplified methods CSC 2 n ¨ Compound interest ¨ Actual cash flows ¨ Simple interest ¨ Average balances n Disconnects with reestimate cashflows Consistent with discounting n Aligned with reestimate cashflows Improved calculations, same requirements 15
Cohort Interest Rate n Financing accounts must earn and pay interest at the same rate used to discount the credit subsidy cash flows for each cohort ¨ For FY 1992 -2000 cohorts, this is the disbursementweighted average discount rate ¨ For FY 2001 and subsequent cohorts, this is the single effective rate, generated by the Credit Subsidy Calculator (in most cases, either budget formulation rate or final rate from the first technical reestimate after 90% disbursement) 16
CSC 2: Cohort Interest Rate n n n Methods for calculating cohort interest rates have not changed Comes from first technical reestimate after interest rate reestimate Cohorts that have established actual DWADR/SER continue to use established rate— No need to recalculate Cohorts substantially disbursed in 2007—use CSC 2 to calculate cohort rate Data requirements are the same as old CSC 17
CSC 2: Interest owed n Compute interest owed to the Treasury – Interest owed to the Treasury is based on two categories of transactions: n Debt to Treasury at the beginning of the year includes all borrowing outstanding at the beginning of the year. A full year of interest is paid on such debt. n Transactions with BPD include all borrowings and repayments during the year. Borrowings made during the year are back-dated to the beginning of the year and a full year of interest is paid on the borrowing. Debt repayment and end of year borrowing to pay interest take place at year-end and do not impact the interest calculation. Interest owed is adjusted for repayments that occur at the middle of the year. 18
CSC 2: Interest earned n Compute Interest due from the Treasury –based on three categories of transactions: n Cash balances include all cash on deposit with the Treasury at the beginning of the year. n Intra-governmental transfers with the financing account include transfers of subsidy, modification adjustment transfer, reestimates, interest on reestimates, financing account interest, and interest adjustments. Reestimates, interest on reestimate and interest adjustments are assumed to occur at the start of the year and earn a full year interest. Subsidy transfers and modifications have timing assigned by the user, and interest is earned or paid accordingly. Financing account interest is assumed to be paid at the end of the year. n Transactions with the public include all loan disbursements, claim payments, loan payments, fees, defaults, and recoveries. For these, interest is earned depending on the timing assumption indicated for the individual cash flow line. Outflows to the public reduce the interest earned; inflows from the public increase the interest earned. 19
CSC 2: Compound interest n Formula for the PV factor used to calculate interest is (1+ SER) ^ time SER is the cohort interest rate Time relative to the LCFY Example, for a cohort with a 5% rate, a cashflow to the financing account at the end of Q 1 would earn 3. 73% interest that year ¨ (1+0. 05)^0. 75= 1. 0373 ¨ ¨ ¨ n n n Debt and cash balances are end of year Borrowing, repayment, financing account interest and reestimate timing have fixed timing assumptions Timing for other cashflows are specified by the agency in the cashflow inputs 20
CSC 2: Calculating Financing Account Interest Can be calculated at the same time as reestimates n Can be calculated separately from reestimates n Requires an input cashflow formatted for the CSC 2 n 21
CSC 2—Required Cashflow Inputs n Latest completed fiscal year ¨ n Cohort Balances ¨ n Borrowings and repayments Budgetary Transactions ¨ n Debt to Treasury/Cash Balance with Treasury Transactions ¨ n Reference point--required for financing account interest and reestimate calculations Subsidy transfers, financing account interest, reestimates, and modifications—reconciling balances, financing account interest, and reestimates Historical cashflows with the public ¨ Cashflows in latest completed fiscal year required for ALL cohorts 22
CSC 2—Input Cashflows n n n Reestimate discount rate must be a number Latest completed fiscal year is a must! New keywords ¨ Timing for Balance sheet, borrowings, repayments, financing account interest, and reestimates are FIXED. ¨ Debt to Treasury EOY must be entered as a negative ¨ Cash Held by Treasury EOY must be positive ¨ Subsidy and modifications—must specify timing! ¨ Inflows to the financing account are positive ¨ Outflows from the financing account are negative ¨ Upward reestimates—positive, downward--negative 23
CSC 2 n n Input cashflow Key changes for input in purple 24
CSC 2 Output: CSC 2 Tab n 1) Present Value Calculations ¨ PVF relative to the point of disbursement ¨ PVF relative to the latest completed fiscal year ¨ Converted Cashflow—sum of all inflows and outflows to and from the financing account n 2) Reported balances compared to net Cashflows ¨ End of year balance calculated vs. reported ¨ Any difference must be explained 25
CSC 2 Output: CSC 2 Tab n 3) Financing Account Interest Calculation ¨ Interest owed—Debt balance SOY, borrowings backdated to 10/1, MOY repayment ¨ Interest earned—Cash balance SOY, borrowings backdated to 10/1, MOY repayment, cashflows to and from the account ¨ Net financing account interest—sum of interest owed and interest earned 26
CSC 2 Output: CSC 2 Tab n 4) Balances Approach Reestimate ¨ Assets vs. Liabilities approach ¨ NPV of cashflows after LCFY ¨ Net EOY debt or cash balance with interest ¨ Difference=reestimate ¨ Financing account interest adjustment included with reestimate 27
CSC 2 Output: CSC 2 Tab n 5) Traditional reestimate check ¨ Reestimated subsidy rate based off historical and future borrower cashflows ¨ Should generate the same result as BA reestimate n 6) Financing Account Interest Adjustment ¨ Calculates interest that should have been earned/paid on the financing account ¨ Compares to the sum of reported interest, plus section 3 net interest ¨ Any difference = financing account interest adjustment 28
CSC 2 Output: Summary Tab Financing account interest n Reestimate summary (Federal credit supplement) n Current year reestimate summary n 29
Summary CSC 2 replaces the C-Credit financing account interest calculator n Same data is needed, different format n Improved financing account interest calculations n 30
- Slides: 30