[go: up one dir, main page]

0% found this document useful (0 votes)
38 views7 pages

Property Hub Tools BTL Calculator 2025

The document outlines a financial analysis for a property investment, detailing purchase costs, running costs, rental income, and key metrics such as cash invested, mortgage amount, and yields. It includes assumptions about loan-to-value ratios, interest rates, and management percentages, as well as a breakdown of monthly cash flow. Additionally, it presents projections for property value and equity over time, along with return on investment calculations.

Uploaded by

bobaj66883
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
38 views7 pages

Property Hub Tools BTL Calculator 2025

The document outlines a financial analysis for a property investment, detailing purchase costs, running costs, rental income, and key metrics such as cash invested, mortgage amount, and yields. It includes assumptions about loan-to-value ratios, interest rates, and management percentages, as well as a breakdown of monthly cash flow. Additionally, it presents projections for property value and equity over time, along with return on investment calculations.

Uploaded by

bobaj66883
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Address

Link
Last updated: 03/01/2025

Purchase costs

Purchase price
Stamp duty
Refurb
Fees
Furnishing

Running costs

Ground rent and service charge (per month)


Insurance (per month)
Bills per unit per month (if included)
Other

Rental income

Lettable units
Monthly rent per unit

Assumptions

LTV
Interest rate
Management %
Repairs %
Voids (weeks)
Example

£250,000.00
£12,500.00
£3,000.00
£2,000.00
£1,000.00

£100.00
£0.00
£0.00
£0.00

1
£1,200.00

75.00%
4.50%
12.00%
5.00%
2
Key metrics

Cash invested £81,000.00


Mortgage amount £187,500.00
Annual cashflow £1,760.65
Monthly cashflow £146.72
Gross yield 5.76%
Net yield 0.70%
ROI 2.17%

Monthly cashflow breakdown

Total monthly rent £1,200.00


Mortgage payment £703.13
Management fee £144.00
Repairs allowance £60.00
Service charge and ground rent £100.00
Insurance £0.00
Bills £0.00
Other £0.00
Purchase price £ 250,000.00
Property value
0% 1% 2% 3% 4%
1 £ 250,000 £ 252,500 £ 255,000 £ 257,500 £ 260,000
2 £ 250,000 £ 255,025 £ 260,100 £ 265,225 £ 270,400
3 £ 250,000 £ 257,575 £ 265,302 £ 273,182 £ 281,216
4 £ 250,000 £ 260,151 £ 270,608 £ 281,377 £ 292,465
5 £ 250,000 £ 262,753 £ 276,020 £ 289,819 £ 304,163
6 £ 250,000 £ 265,380 £ 281,541 £ 298,513 £ 316,330
7 £ 250,000 £ 268,034 £ 287,171 £ 307,468 £ 328,983
8 £ 250,000 £ 270,714 £ 292,915 £ 316,693 £ 342,142
9 £ 250,000 £ 273,421 £ 298,773 £ 326,193 £ 355,828
10 £ 250,000 £ 276,156 £ 304,749 £ 335,979 £ 370,061
11 £ 250,000 £ 278,917 £ 310,844 £ 346,058 £ 384,864
12 £ 250,000 £ 281,706 £ 317,060 £ 356,440 £ 400,258
13 £ 250,000 £ 284,523 £ 323,402 £ 367,133 £ 416,268
14 £ 250,000 £ 287,369 £ 329,870 £ 378,147 £ 432,919
15 £ 250,000 £ 290,242 £ 336,467 £ 389,492 £ 450,236
16 £ 250,000 £ 293,145 £ 343,196 £ 401,177 £ 468,245
17 £ 250,000 £ 296,076 £ 350,060 £ 413,212 £ 486,975
18 £ 250,000 £ 299,037 £ 357,062 £ 425,608 £ 506,454
19 £ 250,000 £ 302,027 £ 364,203 £ 438,377 £ 526,712
20 £ 250,000 £ 305,048 £ 371,487 £ 451,528 £ 547,781

Your equity
0% 1% 2% 3% 4%
1 £ 62,500 £ 65,000 £ 67,500 £ 70,000 £ 72,500
2 £ 62,500 £ 67,525 £ 72,600 £ 77,725 £ 82,900
3 £ 62,500 £ 70,075 £ 77,802 £ 85,682 £ 93,716
4 £ 62,500 £ 72,651 £ 83,108 £ 93,877 £ 104,965
5 £ 62,500 £ 75,253 £ 88,520 £ 102,319 £ 116,663
6 £ 62,500 £ 77,880 £ 94,041 £ 111,013 £ 128,830
7 £ 62,500 £ 80,534 £ 99,671 £ 119,968 £ 141,483
8 £ 62,500 £ 83,214 £ 105,415 £ 129,193 £ 154,642
9 £ 62,500 £ 85,921 £ 111,273 £ 138,693 £ 168,328
10 £ 62,500 £ 88,656 £ 117,249 £ 148,479 £ 182,561
11 £ 62,500 £ 91,417 £ 123,344 £ 158,558 £ 197,364
12 £ 62,500 £ 94,206 £ 129,560 £ 168,940 £ 212,758
13 £ 62,500 £ 97,023 £ 135,902 £ 179,633 £ 228,768
14 £ 62,500 £ 99,869 £ 142,370 £ 190,647 £ 245,419
15 £ 62,500 £ 102,742 £ 148,967 £ 201,992 £ 262,736
16 £ 62,500 £ 105,645 £ 155,696 £ 213,677 £ 280,745
17 £ 62,500 £ 108,576 £ 162,560 £ 225,712 £ 299,475
18 £ 62,500 £ 111,537 £ 169,562 £ 238,108 £ 318,954
19 £ 62,500 £ 114,527 £ 176,703 £ 250,877 £ 339,212
20 £ 62,500 £ 117,548 £ 183,987 £ 264,028 £ 360,281

Return On Investment (annualised)


0% 1% 2% 3% 4%
1 0% 3.09% 6% 9% 12%
2 0% 3.10% 6.23% 9.40% 13%
3 0% 3.12% 6.30% 9.54% 13%
4 0% 3.13% 6.36% 9.68% 13%
5 0% 3.15% 6.42% 9.83% 13%
6 0% 3.16% 6.49% 9.98% 14%
7 0% 3.18% 6.56% 10.14% 14%
8 0% 3.20% 6.62% 10.29% 14%
9 0% 3.21% 6.69% 10.45% 15%
10 0% 3.23% 6.76% 10.61% 15%
11 0% 3.25% 6.83% 10.78% 15%
12 0% 3.26% 6.90% 10.95% 15%
13 0% 3.28% 6.97% 11.12% 16%
14 0% 3.30% 7.04% 11.30% 16%
15 0% 3.31% 7.12% 11.48% 16%
16 0% 3.33% 7.19% 11.66% 17%
17 0% 3.35% 7.27% 11.85% 17%
18 0% 3.36% 7.34% 12.04% 18%
19 0% 3.38% 7.42% 12.24% 18%
20 0% 3.40% 7.50% 12.44% 18%
5% 6% 7% 8% 9% 10%
£ 262,500 £ 265,000 £ 267,500 £ 270,000 £ 272,500 £ 275,000
£ 275,625 £ 280,900 £ 286,225 £ 291,600 £ 297,025 £ 302,500
£ 289,406 £ 297,754 £ 306,261 £ 314,928 £ 323,757 £ 332,750
£ 303,877 £ 315,619 £ 327,699 £ 340,122 £ 352,895 £ 366,025
£ 319,070 £ 334,556 £ 350,638 £ 367,332 £ 384,656 £ 402,628
£ 335,024 £ 354,630 £ 375,183 £ 396,719 £ 419,275 £ 442,890
£ 351,775 £ 375,908 £ 401,445 £ 428,456 £ 457,010 £ 487,179
£ 369,364 £ 398,462 £ 429,547 £ 462,733 £ 498,141 £ 535,897
£ 387,832 £ 422,370 £ 459,615 £ 499,751 £ 542,973 £ 589,487
£ 407,224 £ 447,712 £ 491,788 £ 539,731 £ 591,841 £ 648,436
£ 427,585 £ 474,575 £ 526,213 £ 582,910 £ 645,107 £ 713,279
£ 448,964 £ 503,049 £ 563,048 £ 629,543 £ 703,166 £ 784,607
£ 471,412 £ 533,232 £ 602,461 £ 679,906 £ 766,451 £ 863,068
£ 494,983 £ 565,226 £ 644,634 £ 734,298 £ 835,432 £ 949,375
£ 519,732 £ 599,140 £ 689,758 £ 793,042 £ 910,621 £ 1,044,312
£ 545,719 £ 635,088 £ 738,041 £ 856,486 £ 992,576 £ 1,148,743
£ 573,005 £ 673,193 £ 789,704 £ 925,005 £ 1,081,908 £ 1,263,618
£ 601,655 £ 713,585 £ 844,983 £ 999,005 £ 1,179,280 £ 1,389,979
£ 631,738 £ 756,400 £ 904,132 £ 1,078,925 £ 1,285,415 £ 1,528,977
£ 663,324 £ 801,784 £ 967,421 £ 1,165,239 £ 1,401,103 £ 1,681,875

5% 6% 7% 8% 9% 10%
£ 75,000 £ 77,500 £ 80,000 £ 82,500 £ 85,000 £ 87,500
£ 88,125 £ 93,400 £ 98,725 £ 104,100 £ 109,525 £ 115,000
£ 101,906 £ 110,254 £ 118,761 £ 127,428 £ 136,257 £ 145,250
£ 116,377 £ 128,119 £ 140,199 £ 152,622 £ 165,395 £ 178,525
£ 131,570 £ 147,056 £ 163,138 £ 179,832 £ 197,156 £ 215,128
£ 147,524 £ 167,130 £ 187,683 £ 209,219 £ 231,775 £ 255,390
£ 164,275 £ 188,408 £ 213,945 £ 240,956 £ 269,510 £ 299,679
£ 181,864 £ 210,962 £ 242,047 £ 275,233 £ 310,641 £ 348,397
£ 200,332 £ 234,870 £ 272,115 £ 312,251 £ 355,473 £ 401,987
£ 219,724 £ 260,212 £ 304,288 £ 352,231 £ 404,341 £ 460,936
£ 240,085 £ 287,075 £ 338,713 £ 395,410 £ 457,607 £ 525,779
£ 261,464 £ 315,549 £ 375,548 £ 442,043 £ 515,666 £ 597,107
£ 283,912 £ 345,732 £ 414,961 £ 492,406 £ 578,951 £ 675,568
£ 307,483 £ 377,726 £ 457,134 £ 546,798 £ 647,932 £ 761,875
£ 332,232 £ 411,640 £ 502,258 £ 605,542 £ 723,121 £ 856,812
£ 358,219 £ 447,588 £ 550,541 £ 668,986 £ 805,076 £ 961,243
£ 385,505 £ 485,693 £ 602,204 £ 737,505 £ 894,408 £ 1,076,118
£ 414,155 £ 526,085 £ 657,483 £ 811,505 £ 991,780 £ 1,202,479
£ 444,238 £ 568,900 £ 716,632 £ 891,425 £ 1,097,915 £ 1,341,477
£ 475,824 £ 614,284 £ 779,921 £ 977,739 £ 1,213,603 £ 1,494,375

5% 6% 7% 8% 9% 10%
15% 19% 22% 25% 28% 31%
16% 19% 22% 26% 29% 32%
16% 20% 23% 27% 30% 34%
17% 20% 24% 28% 32% 36%
17% 21% 25% 29% 33% 38%
17% 22% 26% 30% 35% 40%
18% 22% 27% 31% 37% 42%
18% 23% 28% 33% 38% 44%
19% 24% 29% 34% 40% 47%
19% 24% 30% 36% 42% 49%
20% 25% 31% 37% 44% 52%
20% 26% 32% 39% 47% 55%
21% 27% 33% 41% 49% 58%
22% 28% 35% 43% 52% 62%
22% 29% 36% 45% 54% 65%
23% 30% 38% 47% 57% 69%
23% 31% 39% 49% 60% 74%
24% 32% 41% 51% 64% 78%
25% 33% 43% 54% 67% 83%
26% 34% 44% 56% 71% 88%

You might also like