ATTACHMENT_H_Pricing_Spreadsheet_Reviewed_Per_Amendment_A00003.xls

XLS spreadsheet 49 KB Posted

Attached to
New Requirement:Real Estate Owned and Portfolio Services Contract (RPSC)
Solicitation number
VA119A17R0010
Issued by

About this file

Attachment H - Pricing Spreadsheet.

View the file

Other files

File Type Posted
VA119A-17-R-0010_A00003.pdf PDF
VA119A-17-R-0010_A00002.pdf PDF
VA119A-17-R-0010_A00001.pdf PDF
ATTACHMENT_K_Answers_to_RPSC_Questions.docx DOCX document
ATTACHMENT_J_Past_Performance_Questionnaire.docx DOCX document
ATTACHMENT_D_Reporting_Library.pdf PDF
ATTACHMENT_G_Fee_Attorney_Contract_Provisions.pdf PDF
ATTACHMENT_I_TECHNICAL_EVALUATION_MATRIX.xls XLS spreadsheet
ATTACHMENT_F_PROPERTY_PRESERVATION_FLAT_FEE.docx DOCX document
VA119A-17-R-0010_Final.docx DOCX document
ATTACHMENT_A_RPSC_Related_Documents.pdf PDF
ATTACHMENT_B_Background_Investigation_Worksheet.docx DOCX document
ATTACHMENT_H_Pricing_Spreadsheet.xls XLS spreadsheet
ATTACHMENT_C_Schedule_of_Deliverables.docx DOCX document
ATTACHMENT_E_QASP.docx DOCX document
VA119A-17-R-0010-000.docx DOCX document
Show all 16

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

Total Est. Cost Outlay

OFFEROR PRICING SPREADSHEET

ATTACHMENT H

Annual CostsCosts
Base Period Cost (FY'17)$92,181,514
Option Period 1 (FY'18)$117,312,039
Option Period 2 (FY'19)$121,679,982
Option Period 3 (FY'20)$129,460,973
Option Period 4 (FY'21)$137,725,531
Option Period 5 (FY'22)$143,762,441
Option Period 6 (FY'23)$151,293,797
Option Period 7 (FY'24)$159,242,705
Option Period 8 (FY'25)$167,638,230
Option Period 9 (FY'26)$176,512,208
Option Period 10 (FY'27)$100,172,799
Total Cost of Contract$1,496,982,219
CLIN/Description0001/Property Preservation
FFP0002/Acquisition, Management, and Disposition Expenses
FFP0003/Performance Bonds
T&M0004/Service Performing Loans
FFP0005/Service Non-Performing Loans
FFP0006/Taxes
T&M0007/Incentive & Disincentives
FFP (These amounts are fixed and not subject to modification by the bidder)0008/T&M Reimbursable (ex. Servicing/Foreclosure Advances, Grass Cutting, HOA Fees)0009/T&M Reimbursable for User FeesTotals
Base Period Cost (FY'17)$ - 0$ - 0$ 127,628.00$ - 0$ - 0$ 21,073,653.33$ - 0$ 70,245,511.11$ 734,721.32$ 92,181,513.77
Option Period 1 (FY'18)$ - 0$ - 0$ 134,009.40$ - 0$ - 0$ 25,085,340.00$ 2,700,000.00$ 87,798,690.00$ 1,593,999.23$ 117,312,038.63
Option Period 2 (FY'19)$ - 0$ - 0$ 140,709.87$ - 0$ - 0$ 26,339,607.00$ 2,900,000.00$ 90,450,210.44$ 1,849,454.72$ 121,679,982.03
Option Period 3 (FY'20)$ - 0$ - 0$ 147,745.36$ - 0$ - 0$ 27,656,587.35$ 3,100,000.00$ 96,410,863.50$ 2,145,777.25$ 129,460,973.46
Option Period 4 (FY'21)$ - 0$ - 0$ 155,132.63$ - 0$ - 0$ 29,039,416.72$ 3,300,000.00$ 102,741,456.35$ 2,489,524.81$ 137,725,530.51
Option Period 5 (FY'22)$ - 0$ - 0$ 162,889.26$ - 0$ - 0$ 30,491,387.55$ 3,500,000.00$ 106,719,856.44$ 2,888,307.66$ 143,762,440.91
Option Period 6 (FY'23)$ - 0$ - 0$ 171,033.73$ - 0$ - 0$ 32,015,956.93$ 3,700,000.00$ 112,055,849.26$ 3,350,957.37$ 151,293,797.29
Option Period 7 (FY'24)$ - 0$ - 0$ 179,585$ - 0$ - 0$ 33,616,754.78$ 3,900,000.00$ 117,658,641.72$ 3,887,723.08$ 159,242,704.99
Option Period 8 (FY'25)$ - 0$ - 0$ 188,564.68$ - 0$ - 0$ 35,297,592.52$ 4,100,000.00$ 123,541,573.81$ 4,510,499.28$ 167,638,230.29
Option Period 9 (FY'26)$ - 0$ - 0$ 197,992.92$ - 0$ - 0$ 37,062,472.14$ 4,300,000.00$ 129,718,652.50$ 5,233,090.22$ 176,512,207.78
Option Period 10 (FY'27)$ - 0$ - 0$ 112,261.98$ - 0$ - 0$ 21,014,421.70$ 2,500,000.00$ 73,550,475.97$ 2,995,639.22$ 100,172,798.87
Total 10 Year Cost of Contract$ 1,496,982,218.53
Assumptions:

&CSOURCE SELECTION SENSITIVE INFORMATION (SEE FAR 2.101 AND 3.104)

In the "B" column plug in the avg Rate for each labor type

Per Usage Fee

CLINDescriptionPer Usage Fee
2009AOrigination fee chargeable to purchaser for Vendee and reimbursed by VA to Contractor.$
2009BFee chargeable to owner of direct loan and reimbursable to Contractor by VA.
2009BaInsufficient Funds$
2009BbPay by phone$
2009BcPay by teller$
2009BdPay online suborigination fees$
2009BeSuborigination fess$
2009BfAssumption fees$
2009BgPartial release fees$
2009BhRelease of lien$
2009BiPayoff statement$
2009BjSpecial appraisal$

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