Spreadsheet: 813723d1673957287-vlookup-not-producing-the-answer-im-looking-for-excel-check
Sheet: Input - General

Input - General
Capital Repayment Schedules |  | Month: | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | Summary of Int. Paid
 | TERM | APR
 | 1 | 0.4097381412982941 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25625
22 | 22 | 0.1207076370716095 | 0.04086371847814969 | 0.04127235566293119 | 0.04168507921956049 | 0.0421019300117561 | 0.04252294931187366 | 0.0429481788049924 | 0.04337766059304232 | 0.04381143719897275 | 0.04424955157096248 | 0.0446920470866721 | 0.04513896755753882 | 0.04559035723311421 | 0.04604626080544535 | 0.04650672341349981 | 0.0469717906476348 | 0.04744150855411115 | 0.04791592363965226 | 0.04839508287604879 | 0.04887903370480927 | 0.04936782404185736 | 0.04986150228227593 | 0.05036011730509871 |  |  |  |  |  | 579307.6007491119
6 | 6 | 0.1543109953403473 | 0.1629728634322538 | 0.1644328286671677 | 0.1659058727573111 | 0.1673921128674287 | 0.1688916672118661 | 0.1704046550639724 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154136.6420146976
23 | 23 | 0.1207076370716095 | 0.03888584005671841 | 0.0392746984572856 | 0.03966744544185846 | 0.04006411989627704 | 0.04046476109523981 | 0.04086940870619221 | 0.04127810279325413 | 0.04169088382118667 | 0.04210779265939853 | 0.04252887058599252 | 0.04295415929185245 | 0.04338370088477097 | 0.04381753789361868 | 0.04425571327255487 | 0.04469827040528043 | 0.04514525310933322 | 0.04559670564042655 | 0.04605267269683082 | 0.04651319942379913 | 0.04697833141803712 | 0.04744811473221749 | 0.04792259587953966 | 0.04840182183833507 |  |  |  |  | 579307.6007491119
3 | 3 | 0.20142942070961 | 0.3283829602081947 | 0.3333087046113177 | 0.3383083351804874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77207.91357396125
24 | 24 | 0.20142942070961 | 0.03781159300418317 | 0.03812668961255137 | 0.0384444120259893 | 0.03876478212620587 | 0.03908782197725759 | 0.03941355382706807 | 0.03974200010896031 | 0.04007318344320164 | 0.04040712663856165 | 0.040743852693883 | 0.04108338479966536 | 0.04142574633966257 | 0.04177096089249309 | 0.04211905223326386 | 0.04247004433520774 | 0.04282396137133446 | 0.04318082771609558 | 0.04354066794706305 | 0.04390350684662191 | 0.04426936940367709 | 0.0446382808153744 | 0.04501026648883585 | 0.04538535204290948 | 0.04576356330993373 |  |  |  | 603713.2049503688
[NAME] | 2400000
Bad Debt Write Off | 0.01
w/o % Thereafter
Loss Pool Provision | 0
Fee on Commencement | 0.01
Fee on Redemption Charges | 0.01 | Net of VAT
Rollover Fee | 0 | Net of VAT
Litigation Fee Provision | 0.01 | Incl. VAT
Tech Platform Charges |  | Incl. VAT
Monthly Loan Charge |  | Incl. VAT
Collection Cost
Charge per Arrears Agreement |  | Incl. VAT
Disbursements Cost |  |  |  | Client Acquisition Cost
Contingency Collection Charge | 0 | Incl. VAT |  | Term | Split | Cost
Arrears | 0.25 |  |  |  | 0 | 0
 |  |  |  | 12 | 0
Interest Earned | 0 |  |  | 24 | 0
 |  |  |  | 36 | 0
Interest Payable | 0.06 |  |  | 48 | 1
Fee on Arrears Charges | 0 | Net of VAT |  | 60 | 0
Client Acquisition Cost Year 1 |  | Net of VAT
Client Acquisition Cost Year 2 |  | Net of VAT
IT Platform  ONLY
Once off Charge |  | Incl. VAT
Monthly Charge |  | Incl. VAT
Internal Costs
CAPEX
Underwriting
Collections
 |  |  | 2023-01-31 00:00:00
Capital Injection | GBP |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Collections Efficient First 12 Months
Collections Efficiency Thereafter
 |  |  | 2023
CPI |  |  | 0 | 0.025 | 0.025 | 0.025 | 0.025 | 0.025 | 0.025 | 0.025 | 0.025 | 0.025
Payroll Increase |  |  | 0 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04