That has absolutely nothing to do with anything I said.
I've seen about 50 posts from you today with the same tired trend.
He's ****ing selling up. Be happy.
This seems to have been a common theme today!
@Kat_r what do you actually want?
I've no idea how much Ron will actually receive from the flats, but let's say it's £50m. A hell of a lot of money.
But he's funded the club with a hell of a lot of money for 25 years. He said that it has cost him £1m a year. If you calculate what that would be with a compound return of 5% over the period, he would, after 25 years, have £50m-odd. He has lost £25m instead, so he is £75m away from where he could have been today.
And has to wait a few more years to collect his money, which won't all be in one lump sum and there will be costs, debts and taxes to repay and pay.
Here's some figures as to what £1m a year looks like at that rate over 25 years, and then onto 40 years with putting nothing more in. This is just a crude calculation based on the interest being calculated annually as opposed to daily, and the same amount going into the pot every year and with no withdrawals, but you can see the point.
None of this takes account of inflation, which further devalues the early monies by over 50%.
So getting £50m eventually isn't a great return is it? Although it is a load of money.
I hope the columns line up - it looks ok on my screen. As a key, c/f is carried forward and the interest is just a straight annual calculation based on the c/f figure plus £1m until year 25, when the additional monies stop going in. I've taken it forward to 40 years, just for fun.
So unless you're of the opinion that it's completely wrong for RM to recover any of his monies and he also shouldn't make a profit, I really don't see what point you're driving at.
Year | c/f | Input | Interest | Total |
| | | 5% | |
| | | | |
1 | | £ 1,000,000.00 | £ 50,000.00 | £ 1,050,000.00 |
2 | £ 1,050,000.00 | £ 1,000,000.00 | £ 102,500.00 | £ 2,152,500.00 |
3 | £ 2,152,500.00 | £ 1,000,000.00 | £ 157,625.00 | £ 3,310,125.00 |
4 | £ 3,310,125.00 | £ 1,000,000.00 | £ 215,506.25 | £ 4,525,631.25 |
5 | £ 4,525,631.25 | £ 1,000,000.00 | £ 276,281.56 | £ 5,801,912.81 |
6 | £ 5,801,912.81 | £ 1,000,000.00 | £ 340,095.64 | £ 7,142,008.45 |
7 | £ 7,142,008.45 | £ 1,000,000.00 | £ 407,100.42 | £ 8,549,108.88 |
8 | £ 8,549,108.88 | £ 1,000,000.00 | £ 477,455.44 | £ 10,026,564.32 |
9 | £ 10,026,564.32 | £ 1,000,000.00 | £ 551,328.22 | £ 11,577,892.54 |
10 | £ 11,577,892.54 | £ 1,000,000.00 | £ 628,894.63 | £ 13,206,787.16 |
11 | £ 13,206,787.16 | £ 1,000,000.00 | £ 710,339.36 | £ 14,917,126.52 |
12 | £ 14,917,126.52 | £ 1,000,000.00 | £ 795,856.33 | £ 16,712,982.85 |
13 | £ 16,712,982.85 | £ 1,000,000.00 | £ 885,649.14 | £ 18,598,631.99 |
14 | £ 18,598,631.99 | £ 1,000,000.00 | £ 979,931.60 | £ 20,578,563.59 |
15 | £ 20,578,563.59 | £ 1,000,000.00 | £ 1,078,928.18 | £ 22,657,491.77 |
16 | £ 22,657,491.77 | £ 1,000,000.00 | £ 1,182,874.59 | £ 24,840,366.36 |
17 | £ 24,840,366.36 | £ 1,000,000.00 | £ 1,292,018.32 | £ 27,132,384.67 |
18 | £ 27,132,384.67 | £ 1,000,000.00 | £ 1,406,619.23 | £ 29,539,003.91 |
19 | £ 29,539,003.91 | £ 1,000,000.00 | £ 1,526,950.20 | £ 32,065,954.10 |
20 | £ 32,065,954.10 | £ 1,000,000.00 | £ 1,653,297.71 | £ 34,719,251.81 |
21 | £ 34,719,251.81 | £ 1,000,000.00 | £ 1,785,962.59 | £ 37,505,214.40 |
22 | £ 37,505,214.40 | £ 1,000,000.00 | £ 1,925,260.72 | £ 40,430,475.12 |
23 | £ 40,430,475.12 | £ 1,000,000.00 | £ 2,071,523.76 | £ 43,501,998.87 |
24 | £ 43,501,998.87 | £ 1,000,000.00 | £ 2,225,099.94 | £ 46,727,098.82 |
25 | £ 46,727,098.82 | | £ 2,336,354.94 | £ 49,063,453.76 |
26 | £ 49,063,453.76 | | £ 2,453,172.69 | £ 51,516,626.45 |
27 | £ 51,516,626.45 | | £ 2,575,831.32 | £ 54,092,457.77 |
28 | £ 54,092,457.77 | | £ 2,704,622.89 | £ 56,797,080.66 |
29 | £ 56,797,080.66 | | £ 2,839,854.03 | £ 59,636,934.69 |
30 | £ 59,636,934.69 | | £ 2,981,846.73 | £ 62,618,781.43 |
31 | £ 62,618,781.43 | | £ 3,130,939.07 | £ 65,749,720.50 |
32 | £ 65,749,720.50 | | £ 3,287,486.02 | £ 69,037,206.52 |
33 | £ 69,037,206.52 | | £ 3,451,860.33 | £ 72,489,066.85 |
34 | £ 72,489,066.85 | | £ 3,624,453.34 | £ 76,113,520.19 |
35 | £ 76,113,520.19 | | £ 3,805,676.01 | £ 79,919,196.20 |
36 | £ 79,919,196.20 | | £ 3,995,959.81 | £ 83,915,156.01 |
37 | £ 83,915,156.01 | | £ 4,195,757.80 | £ 88,110,913.81 |
38 | £ 88,110,913.81 | | £ 4,405,545.69 | £ 92,516,459.50 |
39 | £ 92,516,459.50 | | £ 4,625,822.97 | £ 97,142,282.47 |
40 | £ 97,142,282.47 | | £ 4,857,114.12 | £ 101,999,396.60 |