1
00:00:00,360 --> 00:00:09,480
No, till now, we have calculated MPB and Ayata for transactions, which were either at the start of

2
00:00:09,480 --> 00:00:12,180
the year or at the end of the.

3
00:00:13,450 --> 00:00:22,090
But practically, we often get payment in between the year, so suppose if you are getting a payment

4
00:00:22,270 --> 00:00:23,740
at the end of January.

5
00:00:24,650 --> 00:00:32,300
And in the second case, you are getting a payment at the start of December, not present value for

6
00:00:32,300 --> 00:00:38,140
these two payments will be different because of the difference in days and months.

7
00:00:39,620 --> 00:00:48,260
So if you have a parent town where you have debt and the amount that you are getting, you can use formula

8
00:00:48,290 --> 00:00:54,970
such as Exxon, Peevey and Zaatar to include the effect of this as well.

9
00:00:56,430 --> 00:00:58,610
Now, again, let's take an example.

10
00:00:59,500 --> 00:01:05,910
Here we have to help John in deciding whether this investment is good for him or not.

11
00:01:07,790 --> 00:01:16,670
He want to invest ten thousand dollars on first then or 2021, and in return he will get for payout's

12
00:01:17,240 --> 00:01:20,480
first payout on 16th of May 22.

13
00:01:22,050 --> 00:01:35,820
Second, build on 28 of September 3rd, build on 9th of 2025 and last built on 24th of June 2026.

14
00:01:36,830 --> 00:01:41,570
Now, how can we calculate IRR and NPV in such case?

15
00:01:43,610 --> 00:01:52,760
So when you have dates along with the cash flow details, you have to use X and NPV and X IRR formula.

16
00:01:53,790 --> 00:01:55,310
Let's see how to do that.

17
00:01:58,170 --> 00:02:01,740
We will ride equal to X NPV.

18
00:02:04,840 --> 00:02:07,600
And then select the right.

19
00:02:09,870 --> 00:02:15,660
Then we'll select the values and at last we will select the dates.

20
00:02:17,940 --> 00:02:25,440
Now, one thing you have to note here is that in NPB here, we have to account for investment as well.

21
00:02:25,950 --> 00:02:29,810
Earlier, we were ignoring the initial investment while taking NPV.

22
00:02:30,510 --> 00:02:34,790
But here you have to account for this initial investment as well.

23
00:02:36,800 --> 00:02:45,860
You can see that the net present value of this complete transaction is one thousand and 185 dollars.

24
00:02:46,940 --> 00:02:49,670
Similarly, we can calculate IRR as well.

25
00:02:51,160 --> 00:02:53,380
The formula is x ayata.

26
00:02:54,860 --> 00:02:58,100
And again, first, we have to select the values.

27
00:02:59,370 --> 00:03:02,010
And then we have to select the dates.

28
00:03:05,050 --> 00:03:05,950
If you were to enter.

29
00:03:07,710 --> 00:03:12,720
You can see that the irony in this investment is that only nine percent.

30
00:03:14,030 --> 00:03:22,250
So since the IRR rate is greater than six percent or the discount rate and the NPV is also positive.

31
00:03:23,390 --> 00:03:26,810
John should invest in this investment opportunity.

32
00:03:28,740 --> 00:03:36,180
In this way, if you have cash flows on particular dates, you can still calculate NPV and Iara.