0% found this document useful (0 votes)
32 views10 pages

Yp

The document contains various financial calculations including future value (F.V.), present value (P.V.), and annual rent calculations based on different interest rates and time periods. It presents detailed data on net rent, capitalized value, and yield percentages (Y.P.) for different scenarios. Additionally, it includes calculations for virtual annual rent and capitalized value based on specified interest and redemption rates.

Uploaded by

Rajwinder SIngh
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)
32 views10 pages

Yp

The document contains various financial calculations including future value (F.V.), present value (P.V.), and annual rent calculations based on different interest rates and time periods. It presents detailed data on net rent, capitalized value, and yield percentages (Y.P.) for different scenarios. Additionally, it includes calculations for virtual annual rent and capitalized value based on specified interest and redemption rates.

Uploaded by

Rajwinder SIngh
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/ 10

r 0.

08
n 60
F.V. 101.257

P.V. 0.01

S 1253.213
0.000798 0.125
r 0.08
n 60
F.V. 101.257

P.V. 0.01

S 1253.213
Ic 0.00100
24.422
0.004762 116.2952
r 12%
n 41
360000 F.V. 104.217 360000
62235000
P.V. 0.01

2062500 S 860.142 309651120


Ic 0.001
Yp (single) 8.25 4

0.133333 Y.P. ( Dual) 8.264 3.859


41333.33 8.333333
2.665836 9129547 4125000

2144800 0.125
2152800 8000 1to5
1to10
5to10

YP for 5 years @ 9%

412500
247500
2475
414975
1 600000 0.926 555600
2 610000 0.858 523380
3 620000 0.794 492280

=1/((𝑟+𝐼𝑐))
Y.P. (Dual) 4 630000 0.735 463050
5 640000 0.681 435840
6 650000 0.63 409500
7 660000 0.583 384780
8 670000 0.54 361800
0.53242982 9 680000 0.5 340000
10 690000 0.463 319470
11 700000 0.429 300300
12 710000 0.397 281870
13 720000 0.368 264960
14 730000 0.34 248200
0.942009 15 740000 0.315 233100
16 750000 0.292 219000
17 760000 0.27 205200
3.889 50000 194450 18 770000 0.25 192500
6.422 19 780000 0.232 180960
2.533 30000 75990 20 790000 0.215 169850
270440 21 800000 0.199 159200
22 810000 0.184 149040
3.889 50000 194450 8/10/2024 23 820000 0.17 139400
3.889 30000 116670 10.08.2029 24 830000 0.158 131140
75835.5 25 840000 0.146 122640
26 850000 0.135 114750
27 860000 0.125 107500
28 870000 0.116 100920
29 880000 0.107 94160
30 890000 0.099 88110
22350000 7788500
2.869615
Virtual Annual Rent Calculation assuming rate of interest 9% and
redemption rate @ 3%.
Time Rent TDS Net Rent
0-3 Years 182800 18280 164520
3-6 Years 210220 21022 189198
6-9 Tears 241753 24175.3 217577.7

Capitalised Value

Rate of
Time Interest & YP
Redemtion
Rate Net Rent
0-3 Years 8%,5% 2.525 2077342.08685843
3-6 Years 8%,5% 1.88 2373478.08685843
6-9 Tears 9%,5% 1.12 2714034.48685843
After 9
Years 10% 4.24 2714034.48685843
Total
Y.P. Dual Rate AE=548400/YP Dual
assuming rate of interest 9% and Total
rate @ 3%. Annual
Annual Rent Rent
1974240 5.319 103102.086858432 2077342
2270376 5.319 103102.086858432 2373478
2610932.4 5.319 103102.086858432 2714034

Capitalised Value

5245288.76931754
4462138.80329385
3039718.62528144

11507506.2242797
24254652.4221726
r 0.1
1 0.909091 26
2 0.798186 27
3 1.037368 28
4 0.908029 29
5 1.057737 30
6 0.932961 31
7 1.061225 32
8 0.939415 33
9 1.06175 34
10 0.941163 35
11 1.061795 36
12 0.941642 37
13 1.061784 38
14 0.941773 39
15 1.061776 40
16 0.941809 41
17 1.061773 42
18 0.941819 43
19 1.061772 44
20 0.941822 45
21 1.061771 46
22 0.941822 47
23 1.061771 48
24 0.941823 49
25 1.061771 50
26 0.941823
27 1.061771
28 0.941823
29 1.061771
30 0.941823
31 1.061771
32 0.941823
33 1.061771
34 0.941823
35 1.061771
36 0.941823
37 1.061771
38 0.941823
39 1.061771
40 0.941823
41 1.061771
42 0.941823
43 1.061771
44 0.941823
45 1.061771
46 0.941823
47 1.061771
48 0.941823
49 1.061771
50 0.941823
PV = ₹ -21,005.65
r 8%
Capitalised Value = PV/r
262570.625

You might also like