ABCDEFGHIJKLMNOPQ
1
Please make a copy of this sheet for your own use
2
 Site Detail Time Periods Months
3
 Site Address - Loan Term 6
4
 Type of Deal -
Rental Income Duration PA
12
5
 Agent/Developer Name -
6
 Date Enquired 1/1/2022 Plot Floor Level Unit Description Beds sq. ft GDV Rent Gross Yield GDV / sq. ft Rent / sq. ft
7
 Date Offered Terms 12/1/20221Room 111600£800,000£8,4001.1%£500£5
8
 Loan Type Refurbishment 2Room 21£8,400---
9
3Room 31£8,400---
10
 Return Metrics £ 4Room 41£8,400---
11
 Purchase Price 525,000 5Room 51£8,400---
12
 Asking Price 525,000 6Room 61£8,400---
13
7---
14
 Refurbishment Costs Sq. Ft £ / sq. ft £ 8---
15
 Refurbishment 1,600 40 63,500 9---
16
 Furniture - 10---
17
 Commercial - 11---
18
 Fittings: - 12---
19
 Demolition: - 13---
20
 Site Clearance: - 14---
21
 Subtotal Refurb Cost: 1,600 40 63,500 15---
22
 Contingency: 10% 6,350 16---
23
 Total Refurb Cost: 1,600 44 69,850 17---
24
18---
25
 Finance Cost £ 18661,600 sq. ft £800,000 £50,400 6.3% £500 £32
26
Target Arrangement Fees (Bridging)
2.0% 11,550
27
Arrangement Fee for Cash Flow (Bridging)
11550 Debt Metrics Total Project Cost £
28
Actual Arrangement Fee (Bridging)
11550 Lender Interest Rate 10.0%
Net Initial Mortgage - Credit
426,675
29
Target Arrangement Fee (Development Facility)
2.0% 9,120
Gross LTV (Bridging Loans Only)
110.0% Finance Facility 29,325
30
Survey Cost 1,500
Net LTV Day 1 (Bridging Loans Only)
102.5%
Total Capital Required - Equity
 205,175
31
Interest Retained 20,205
Gross LTGDV (Refurbishment Loans Only)
57.0% Refinance Cost 4,500
32
Broker Fee 500
Net LTGDV (Refurbishment Loans Only)
53.3% Legal 1,000
33
Exit0.0% -
Net LTV Day 1 (Refurbishment Loans Only)
68.0% Total Project Costs 666,675
34
 Total Finance Cost 31,325
35
Retained Interest Loan Breakdown
Refinance Costs
36
Transaction and Red Tape Cost
£
Gross Loan Amount
456,000 Refinance Lender Interest 4.0%
37
 HMO Licence 1,000
Acquisition Facility Net Day 1
 356,825 Arrangement Fees 0.0% -
38
 Solicitor Fee 2,000 Development Facility 69,850 Survey Cost 500
39
Total Transaction Cost
3,000
Finance Facility (Int.+ Arrangement Fee & Exit Fees)
29,325 Solicitor Fee 1,500
40
 Net Loan Amount 426,675 Exit Fees 0.0% -
41
Monthly Lender Charges For Serviced Loans - DAY 1
£ Broker Fee 500
42
 Bank Interest PCM - Income Metrics £ Bank Interest PCM 2,000
43
 Insurance - Rent PCM 4,200 Total Finance Cost 4,500
44
 Service Charge - Rent PA 50,400
45
 Bills -
Refinance Metrics & Costs
46
 Void + Maintenance -
Monthly Running Cost Post Refurbishment
£ GDV 800,000
47
Total Monthly Bank Charges
- Management Fees 10% 420 Remortgage LTV 75%
48
 Maintenance 100 Remortgage 600,000
49
Total Capital Invested Summary
£ Gas and Electric 200 Released Funds 144,000
50
 Deposit 168,175 Water 50 Money Left In 69,175
51
 Property Type Residential Broadband 50
52
 SDLT 32,000 Council Tax -
Total Monthly Cost after Refurbishment & Refinance
2,884
53
 Refurb Cost - Insurance 50
54
 Finance Cost 2,000 TV Licence 14
Return Summary After Refinance
55
 Transaction Cost 3,000
Total Monthly Running Cost Post Refurbishment
884 Levered ROCE 23%
56
 Total Capital Invested 205,175 Net Income PCM 1,316
57
 Net Income PA 15,792
58
Monthly Running Cost Inc. Finance
884 Money Left In 69,175
59
60
61
62
63
64
65
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157