ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
CAR RENTAL BUSINESS
3
4
5
6
7
8
TATA NEXON1303458Interest Paid-$19,928.53
9
SBI Interest Rate7.40%Cost of Debt 7.40%
10
Tenure IN Years7Inflation 0.07
11
12
EMI-$19,928.53Particular Year 1Year 2Year 3Year 4Year 5Year 6Year 7
13
Total EMI For 1 year-$239,142.35Revenue 1512000151200015120001512000151200015120001512000
14
Total EMI For 7 year-$1,673,996.43Petrol Cost497417.1429497417.1429497417.1429497417.1429497417.1429497417.1429497417.1429
15
Driver Salary per day500Insurance cost00000160000160000
16
Mileage (kmpl)14Service cost53400534005340053400534005340053400
17
Daily Runs200Driver salary 180000180000180000180000180000180000180000
18
Yearly running 72000Total Cost 730817.1429730817.1429730817.1429730817.1429730817.1429890817.1429890817.1429
19
Working Day per month27PBITDA781182.8571781182.8571781182.8571781182.8571781182.8571621182.8571621182.8571
20
Charge per KM21Dep260691.6208553.28166842.624133474.0992106779.279485423.4234968338.73879
21
Insurance Charges160000PBIT520491.2571572629.5771614340.2331647708.7579674403.5778535759.4337552844.1184
22
Annual Revenue1512000EMI-$239,142.35-$239,142.35-$239,142.35-$239,142.35-$239,142.35-$239,142.35-$239,142.35
23
Revenue for 7 years10584000PBT$281,348.91$333,487.23$375,197.89$408,566.41$435,261.23$296,617.09$313,701.77
24
Service cost per 45K KM26700GST272160272160272160272160272160272160272160
25
Petrol Rate per year96.72PAT$9,188.91$61,327.23$103,037.89$136,406.41$163,101.23$24,457.09$41,541.77
26
Req Petrol per year 5142.857143
27
Cash flow $269,880.51$269,880.51$269,880.51$269,880.51$269,880.51$109,880.51$109,880.51
28
29
30
Depriciation 20% DepInsurancepv for 1st year(8%)$252,224.78
31
after 1 Year, value of car1042766.4260691.6For first 5 years, included in pricepv for 2nd year(8%)$235,724.09
32
after 2Year, value of car834213.12208553.286th 160000pv for 3rd year(8%)$220,302.89
33
after 3 Year, value of car667370.496166842.6247th160000pv for 4th year(8%)$205,890.55
34
after 4Year, value of car533896.3968133474.0992Total320000pv for 5th year(8%)$192,421.07
35
after 5 Year, value of car427117.1174106779.2794pv for 6th year(8%)$73,218.02
36
after 6 Year, value of car341693.69485423.42349Service cost per year53400pv for 7th year(8%)$68,428.06
37
after 7 Year, value of car273354.955268338.73879For 7 years186900PV For total 7 years$1,248,209.46
38
pv for terminal value554756.1458
39
40
NPV$1,802,965.61
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100