Attachment A.1- Sample Report-FY 2024 H4H Re-estimate CSC2_input.xls

XLS spreadsheet 185 KB Posted

Attached to
Risk Management & Capital Assessment Projections (RMCAP)
Solicitation number
24-0003
Issued by

About this file

This federal solicitation requests risk management, budgeting, and policy support services for the Department of Housing and Urban Development's Single-Family Mortgage Insurance program. The contractor shall provide statistical models, cash flow projections, and valuations arising from the mortgage insurance and financial transactions of FHA loan programs using econometric, actuarial, and database techniques. Models include the NPV, ROA, and CSR approaches. The contractor must record transactions in FHA insurance funds accounts and report aggregate cash flows and net assets on a monthly basis. Underwriting, servicing, and property disposition data reside across multiple systems. The competitive contract requirement is for risk management and capital assessment projections support services to be performed at the contractor's site with a response deadline of March 17, 2024.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

All cohorts

Name:CSC2
Description:2024 H4H Reestimate
Program Type:Guarantee
Purpose:Reported Balance Reestimate
Maturity of Loans30
Budget Year:2024
Latest completed fiscal yearN/A
*****Cohort Description
Cohort2009
Original Subsidy Rate23.27
Interest Rate Reestimated Sub Rate0
Reestimate Discount Rate0
2024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19Year 20Year 21Year 22Year 23Year 24Year 25Year 26Year 27Year 28Year 29Year 30Year 31Year 32Year 33Year 34Year 35Year 36Year 37Year 38Year 39Year 40Year 41Year 42Year 43Year 44Year 45Year 46Year 47Year 48Year 49
Commitments (+)4,239,047
TimingAnnual, beginning
Disbursements (+)4,239,047
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cash balance EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Borrowings from Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt MOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Budget Data
Financing Account Interest- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Financing Account Interest Adjustments- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Interest on Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subsidy transfer [annual,end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification [annual, end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification Adjustment transfer- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Annual Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Premiums Fees (+)310000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Inflows (Other) (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Default Payments (+)10,3533,5282,3881,6441,24599979161848538329922817112690431- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Recoveries on Defaults (-)(1,510)(2,188)(1,614)(1,199)(917)(753)(621)(519)(436)(369)(319)(267)(225)(190)(189)(1,057)(21)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** ROA Activity- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** Recoveries on Defaults (-)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*****Cohort Description
Cohort2010
Original Subsidy Rate17.55
Interest Rate Reestimated Sub Rate0
Reestimate Discount Rate0
2024202520262027202820292030203120322033203420352036203720382039204020412042000000000000000000000000000000
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19000000000000000000000000000000
Commitments (+)19,751,454
TimingAnnual, beginning
Disbursements (+)19,751,454
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cash balance EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Borrowings from Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt MOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Budget Data
Financing Account Interest- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Financing Account Interest Adjustments- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Interest on Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subsidy transfer [annual,end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification [annual, end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification Adjustment transfer- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Annual Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Premiums Fees (+)519211000000000000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Inflows (Other) (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Default Payments (+)53,70021,30114,90910,5658,2126,6985,4394,3213,4192,7172,1451,6581,2569416955072357- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Recoveries on Defaults (-)(8,159)(12,177)(9,014)(6,844)(5,383)(4,505)(3,881)(3,313)(2,873)(2,505)(2,195)(1,967)(1,688)(1,480)(1,302)(1,440)(9,245)(146)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** ROA Activity- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** Recoveries on Defaults (-)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*****Cohort Description
Cohort2011
Original Subsidy Rate10.9
Interest Rate Reestimated Sub Rate
Reestimate Discount Rate
2024202520262027202820292030203120322033203420352036203720382039204020412042000000000000000000000000000000
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commitments (+)101,317,524
TimingAnnual, beginning
Disbursements (+)101,317,524
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cash balance EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Borrowings from Treasury EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt MOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Repayments of Treasury Debt EOY- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Budget Data
Financing Account Interest- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Financing Account Interest Adjustments- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Interest on Reestimate SOY [annual, beginning]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subsidy transfer [annual,end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification [annual, end]- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Modification Adjustment transfer- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Annual Fees (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Premiums Fees (+)609103811100000000000- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Inflows (Other) (+)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Default Payments (+)219,39290,84165,97348,18838,49132,01626,56421,77817,64414,30911,5159,1077,0915,4614,1753,2022,3951,10529- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Recoveries on Defaults (-)(35,406)(52,296)(40,859)(31,196)(25,399)(21,861)(19,164)(17,050)(14,998)(13,351)(11,918)(10,696)(9,714)(8,534)(7,602)(6,769)(7,870)(46,383)(717)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** ROA Activity- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
*** Recoveries on Defaults (-)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Name:cohort2015
Description:Reestimate traditional and balances approach
Program Type:Guarantee
Purpose:
Maturity of Loans35
Budget Year:2017
Latest completed fiscal year2015
*****Cohort Description
Cohort2015
Original Subsidy Rate-0.40
Interest Rate Reestimated Sub Rate-2.33
Reestimate Discount Rate3.26
2015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19Year 20Year 21Year 22Year 23Year 24Year 25Year 26Year 27Year 28Year 29Year 30Year 31Year 32Year 33Year 34Year 35Year 36Year 37Year 38Year 39Year 40Year 41Year 42Year 43Year 44Year 45Year 46
Commitments (+)15,988,470,296
TimingAnnual, end
Disbursements (+)15,988,470,296
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY-
Cash balance EOY222,372,706
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]
Borrowings from Treasury EOY-
Repayments of Treasury Debt MOY
Repayments of Treasury Debt EOY
****Budget Data
Financing Account Interest9,563,108
Financing Account Interest Adjustments
Reestimate SOY [annual, beginning]-
Interest on Reestimate SOY [annual, beginning]-
Subsidy transfer [annual,end](63,953,881)
Modification [annual, end]
Modification Adjustment transfer
****Cashflows
TimingANNUAL, End
Upfront Fees (+)
Annual Fees (+)
Premiums Fees (+)$ 84,640,622$ 90,699,460$ 93,864,347$ 96,180,979$ 97,280,709$ 96,713,064$ 92,453,410$ 82,428,641$ 63,818,702$ 42,028,179$ 23,251,391$ 13,607,638$ 9,021,398$ 5,862,199$ 3,627,468$ 2,319,701$ 1,562,590$ 1,188,212$ 1,012,417$ 913,659$ 838,750$ 774,341$ 711,168$ 650,150$ 589,283$ 529,454$ 470,993$ 414,296$ 359,984$ 308,385$ 260,678$ 216,674$ 177,135$ 141,998$ 111,065$ 85,423$ 64,378$ 46,483$ 32,675$ 22,040$ 14,767$ 8,130$ 4,403$ 1,648$ - 0
Inflows (Other) (+)
Default Payments (+)$ 4,577,933$ 5,471,422$ 7,816,646$ 43,418,090$ 159,089,248$ 425,240,740$ 906,970,195$ 1,578,604,880$ 1,822,646,244$ 1,543,506,524$ 789,450,049$ 381,645,827$ 265,364,189$ 196,375,490$ 121,278,468$ 76,025,246$ 43,069,178$ 27,107,622$ 21,626,493$ 15,770,459$ 19,820,469$ 7,074,333$ 2,709,092$ 1,382,853$ 1,006,570$ 875,132$ 776,122$ 672,944$ 580,965$ 494,541$ 415,152$ 346,358$ 284,722$ 227,495$ 181,478$ 138,260$ 104,060$ 79,469$ 56,825$ 39,822$ 24,870$ 20,028$ 10,582$ 7,095$ 4,076
Recoveries on Defaults (-)$ - 0$ (150,822)$ (508,534)$ (1,096,466)$ (8,637,457)$ (31,818,883)$ (86,363,935)$ (173,203,586)$ (303,016,161)$ (394,344,145)$ (490,827,100)$ (549,330,976)$ (586,402,334)$ (610,934,997)$ (578,148,616)$ (544,845,081)$ (512,650,438)$ (482,187,591)$ (453,426,489)$ (426,348,894)$ (400,710,613)$ (376,042,892)$ (351,791,432)$ (327,712,980)$ (303,521,608)$ (279,230,645)$ (254,765,261)$ (230,190,006)$ (205,788,430)$ (181,717,625)$ (158,387,366)$ (136,082,249)$ (115,162,633)$ (95,798,366)$ (78,188,716)$ (62,107,228)$ (48,438,664)$ (36,926,207)$ (27,883,656)$ (19,886,077)$ (13,868,783)$ (9,426,950)$ (6,339,888)$ (4,431,057)$ (1,886,744)
*** ROA Activity
Recoveries on Defaults (-)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Name:cohort2011
Description:Reestimate traditional and balances approach
Program Type:Guarantee
Purpose:Reestimate
Maturity of Loans30
Budget Year:
Latest completed fiscal year
*****Cohort Description
Cohort2011
Original Subsidy Rate10.90
Interest Rate Reestimated Sub Rate
Reestimate Discount Rate
2024202520262027202820292030203120322033203420352036203720382039204020412042
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19
Commitments (+)101,317,524
TimingAnnual, beginning
Disbursements (+)101,317,524
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY
Cash balance EOY
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]
Borrowings from Treasury EOY
Repayments of Treasury Debt MOY
Repayments of Treasury Debt EOY
****Budget Data
Financing Account Interest
Financing Account Interest Adjustments
Reestimate SOY [annual, beginning]
Interest on Reestimate SOY [annual, beginning]
Subsidy transfer [annual,end]
Modification [annual, end]
Modification Adjustment transfer
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)
Annual Fees (+)
Premiums Fees (+)$ 609$ 103$ 8$ 1$ 1$ 1$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ - 0$ - 0
Inflows (Other) (+)
Default Payments (+)$ 219,392$ 90,841$ 65,973$ 48,188$ 38,491$ 32,016$ 26,564$ 21,778$ 17,644$ 14,309$ 11,515$ 9,107$ 7,091$ 5,461$ 4,175$ 3,202$ 2,395$ 1,105$ 29
Recoveries on Defaults (-)$ (35,406)$ (52,296)$ (40,859)$ (31,196)$ (25,399)$ (21,861)$ (19,164)$ (17,050)$ (14,998)$ (13,351)$ (11,918)$ (10,696)$ (9,714)$ (8,534)$ (7,602)$ (6,769)$ (7,870)$ (46,383)$ (717)
*** ROA Activity
*** Recoveries on Defaults (-)
Name:cohort2010
Description:Reestimate traditional and balances approach
Program Type:Guarantee
Purpose:Reestimate
Maturity of Loans30
Budget Year:
Latest completed fiscal year
*****Cohort Description
Cohort2010
Original Subsidy Rate17.55
Interest Rate Reestimated Sub Rate
Reestimate Discount Rate
2024202520262027202820292030203120322033203420352036203720382039204020412042
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19
Commitments (+)19,751,454
TimingAnnual, beginning
Disbursements (+)19,751,454
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY
Cash balance EOY
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]
Borrowings from Treasury EOY
Repayments of Treasury Debt MOY
Repayments of Treasury Debt EOY
****Budget Data
Financing Account Interest
Financing Account Interest Adjustments
Reestimate SOY [annual, beginning]
Interest on Reestimate SOY [annual, beginning]
Subsidy transfer [annual,end]
Modification [annual, end]
Modification Adjustment transfer
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)
Annual Fees (+)
Premiums Fees (+)$ 51$ 9$ 2$ 1$ 1$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ - 0$ - 0
Inflows (Other) (+)
Default Payments (+)$ 53,700$ 21,301$ 14,909$ 10,565$ 8,212$ 6,698$ 5,439$ 4,321$ 3,419$ 2,717$ 2,145$ 1,658$ 1,256$ 941$ 695$ 507$ 235$ 7
Recoveries on Defaults (-)$ (8,159)$ (12,177)$ (9,014)$ (6,844)$ (5,383)$ (4,505)$ (3,881)$ (3,313)$ (2,873)$ (2,505)$ (2,195)$ (1,967)$ (1,688)$ (1,480)$ (1,302)$ (1,440)$ (9,245)$ (146)
*** ROA Activity
*** Recoveries on Defaults (-)
Name:cohort2009
Description:Reestimate traditional and balances approach
Program Type:Guarantee
Purpose:Reestimate
Maturity of Loans30
Budget Year:
Latest completed fiscal year
*****Cohort Description
Cohort2009
Original Subsidy Rate23.27
Interest Rate Reestimated Sub Rate
Reestimate Discount Rate
202420252026202720282029203020312032203320342035203620372038203920402041
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18
Commitments (+)4,239,047
TimingAnnual, beginning
Disbursements (+)4,239,047
*****Balance Sheet
TimingAnnual, end
Debt to Treasury EOY
Cash balance EOY
****Treasury Data
TimingAnnual, end
Borrowings from Treasury SOY [annual, beginning]
Borrowings from Treasury EOY
Repayments of Treasury Debt MOY
Repayments of Treasury Debt EOY
****Budget Data
Financing Account Interest
Financing Account Interest Adjustments
Reestimate SOY [annual, beginning]
Interest on Reestimate SOY [annual, beginning]
Subsidy transfer [annual,end]
Modification [annual, end]
Modification Adjustment transfer
****Cashflows
TimingANNUAL, Middle
Upfront Fees (+)
Annual Fees (+)
Premiums Fees (+)$ 3$ 1$ 0$ 0$ 0$ 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Inflows (Other) (+)
Default Payments (+)$ 10,353$ 3,528$ 2,388$ 1,644$ 1,245$ 999$ 791$ 618$ 485$ 383$ 299$ 228$ 171$ 126$ 90$ 43$ 1
Recoveries on Defaults (-)$ (1,510)$ (2,188)$ (1,614)$ (1,199)$ (917)$ (753)$ (621)$ (519)$ (436)$ (369)$ (319)$ (267)$ (225)$ (190)$ (189)$ (1,057)$ (21)
*** ROA Activity
*** Recoveries on Defaults (-)

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .