1 00:00:00,180 --> 00:00:05,040 Now, again, we have to help John with his investment choice. 2 00:00:06,120 --> 00:00:12,690 He has two options and the first option, he can buy a car for ten thousand dollars. 3 00:00:13,760 --> 00:00:21,110 Which will give him around two thousand dollars for the next five years and at the end of fifth year, 4 00:00:21,230 --> 00:00:24,830 he can sell that car for four thousand dollars. 5 00:00:26,580 --> 00:00:34,800 Now, the second investment opportunity is that he can invest eight thousand dollars today and at the 6 00:00:34,800 --> 00:00:43,110 end of sixth year he will be getting the development or sixteen thousand dollars for his investment. 7 00:00:45,760 --> 00:00:54,730 Now, to find out which option is better, we will use both Ayata and MPV to evaluate these options. 8 00:00:56,900 --> 00:01:05,690 So I have listed a few of the important parameters here, the principal amount or be an option one is 9 00:01:05,690 --> 00:01:06,440 10000. 10 00:01:07,440 --> 00:01:12,710 Are our discount rate is zero point zero six or six percent. 11 00:01:14,130 --> 00:01:21,870 And the salvage value in option one is four thousand dollars, salvage values means this is the amount 12 00:01:21,870 --> 00:01:24,900 he will receive after the end of the investment term. 13 00:01:26,130 --> 00:01:31,140 And option B, the B or principal amount is eight thousand dollars. 14 00:01:32,050 --> 00:01:40,930 The discount rate is the same, which is six percent and the salvage value is zero, at the end of this 15 00:01:40,930 --> 00:01:44,380 investment term, he will get sixteen thousand dollars. 16 00:01:45,780 --> 00:01:52,110 But unlike God, there is no option to sell any asset for any further cash or value. 17 00:01:54,360 --> 00:01:58,800 Now, let's first calculate the IRR for option one. 18 00:02:00,230 --> 00:02:06,020 So to calculate error, we have to include the initial investment in the formula as well. 19 00:02:07,550 --> 00:02:15,050 So for the 08 year or for the starting of last year, John is investing ten thousand dollars in option 20 00:02:15,050 --> 00:02:15,280 one. 21 00:02:15,290 --> 00:02:17,930 So I will write minus ten thousand. 22 00:02:22,070 --> 00:02:24,620 In the other one, he will get 2000. 23 00:02:27,940 --> 00:02:30,910 Now, for the next five year, he will get 2000. 24 00:02:32,890 --> 00:02:39,890 And for the last year, he will get 2000 plus an additional 4000 for selling the car. 25 00:02:40,450 --> 00:02:44,620 So in total, at the end of the year, he will get six totaling. 26 00:02:47,550 --> 00:02:48,990 Now, to calculate accurate. 27 00:02:49,980 --> 00:02:52,620 We have to just straight equal to Iara. 28 00:02:56,140 --> 00:03:01,750 Now, if you want help with this formula, you can click on this button Oriya, which will give you 29 00:03:02,500 --> 00:03:05,590 some more details about the parameters we have to use. 30 00:03:08,320 --> 00:03:16,060 So for values, we can just select all the cash transactions we have listed over here, so at the Zero 31 00:03:16,070 --> 00:03:21,960 Theater we are investing 10000 and we are getting this cash inflow for the next two years. 32 00:03:23,050 --> 00:03:26,290 So just select all the values and enter. 33 00:03:27,930 --> 00:03:37,140 In some cases, there may be two or more error rates for which we have to use this gas variable, but 34 00:03:37,140 --> 00:03:41,120 in this case there is only one error rate which is possible. 35 00:03:41,610 --> 00:03:44,110 So we will ignore the gas parameter. 36 00:03:44,490 --> 00:03:52,530 But for some complex transactions in which we have some initial investment and then some other investment 37 00:03:52,530 --> 00:03:58,710 down the road, in those cases we can have multiple layers and we have to use this gas. 38 00:03:58,710 --> 00:03:59,160 What even. 39 00:04:00,380 --> 00:04:03,990 But for most of the transactions, you can ignore this parameter. 40 00:04:04,730 --> 00:04:07,720 So just select all the values and make. 41 00:04:10,140 --> 00:04:11,640 So this is Diora value. 42 00:04:13,040 --> 00:04:16,250 Ayata for option one is 10 percent. 43 00:04:17,300 --> 00:04:21,860 Now, let's calculate the accurate value for our option B. 44 00:04:23,290 --> 00:04:27,870 And option B as well, our initial investment is eight thousand. 45 00:04:28,020 --> 00:04:31,690 All right, minus eight thousand minus means investment. 46 00:04:32,470 --> 00:04:36,640 And then for the next five years, we are not getting anything. 47 00:04:37,660 --> 00:04:43,240 So this will be zero and the sixth year we are getting 16000. 48 00:04:45,750 --> 00:04:49,950 Again, to calculate IRR, we can use equal to accurate. 49 00:04:51,060 --> 00:04:53,310 And then select all this cash flows. 50 00:04:55,710 --> 00:04:56,970 If we had enter. 51 00:04:58,270 --> 00:05:01,360 We are getting Ayata for our option B. 52 00:05:01,480 --> 00:05:02,830 S 12 percent. 53 00:05:03,820 --> 00:05:10,630 So just by comparing error, you can see that we are getting higher return on our option B. 54 00:05:11,860 --> 00:05:17,930 We can also calculate the NPV of both of these options for NPV. 55 00:05:18,280 --> 00:05:20,020 We do not include. 56 00:05:21,180 --> 00:05:26,190 The initial investment sought to calculate we cannot equal to NPV. 57 00:05:28,310 --> 00:05:33,260 Then first, the rate is zero point zero six and then the values. 58 00:05:36,090 --> 00:05:45,030 Here we are not selecting minus 10000 because this was the investment at the start for Ayata. 59 00:05:45,060 --> 00:05:49,200 We have to select our investment at the site for NPV. 60 00:05:49,230 --> 00:05:51,330 We don't have to select investment. 61 00:05:53,060 --> 00:05:59,090 So the NPB in this case is around eleven thousand four hundred and thirteen dollar. 62 00:06:00,060 --> 00:06:06,990 Now, similarly, we can calculate the NPV for option B as well, we just have to write and bevvy. 63 00:06:08,930 --> 00:06:11,390 And then we have to select all the cash flows. 64 00:06:12,650 --> 00:06:14,750 From first to sixth year. 65 00:06:17,510 --> 00:06:23,630 So the NPV in our option B is eleven thousand two hundred and seventy nine. 66 00:06:25,180 --> 00:06:28,960 Now, remember an option when we invest 10000. 67 00:06:30,520 --> 00:06:38,050 And we are getting around eleven thousand four hundred and thirteen an option B, we invested only eight 68 00:06:38,050 --> 00:06:41,870 thousand and we are getting almost identical amount. 69 00:06:41,890 --> 00:06:44,380 That is eleven thousand two hundred and seventy nine. 70 00:06:45,610 --> 00:06:54,160 You can also subtract this investment from this net present value to see how profitable these options 71 00:06:54,160 --> 00:06:54,400 are. 72 00:06:58,000 --> 00:07:04,570 So the rate equal to this minus the present value of our investment, that is tantalising. 73 00:07:06,960 --> 00:07:10,860 And it is coming to be fourteen hundred and thirteen dollars. 74 00:07:12,410 --> 00:07:13,910 For option to Israel. 75 00:07:18,370 --> 00:07:21,730 We are getting around three thousand two hundred and seventy nine. 76 00:07:23,510 --> 00:07:32,180 So clearly, you can see that the net value we are getting from option B is much more than the net value 77 00:07:32,180 --> 00:07:34,250 we are getting from option A.. 78 00:07:36,000 --> 00:07:45,450 So from both the methods by comparing error and by comparing and NPV, we can say that Option B is much 79 00:07:45,450 --> 00:07:47,180 better than option A. 80 00:07:49,070 --> 00:07:57,560 So in this way, you can evaluate multiple investment options, IRR, and we both will tell you which 81 00:07:57,560 --> 00:07:59,660 one is better investment for you.