Set the cell with phase 0? The formula for calculating the net present value is =C4/( 1+$M$4*C3) (simple interest)

Drag backward to calculate the npv value of each period accordingly? . So let b5=SUM(C5:K5)? That is, the total npv value is obtained. it is quite easy to do so. The formula of compound interest and simple interest is different. )

Beg? irr？ Used? Single? Variable solution? ,

1. Use another line? , as in the previous step, or find the npv corresponding to each cell and the cell sum b6 formula? s？ Hmm (C6:K6)

2. tools? -"Univariate solution ... pop-up dialog box,? What is the target irr cell? B6 cell

3. What is the target value? Input? 0

4. Variable cells? Click? Cell M6, the interest rate used in the irr line, is variable.

5. Click OK. You can get the calculation result as shown in the figure. In the case of simple interest calculation, irr=46.27502%.

The compound interest calculation uses the same operation, but the formula is different. You can try it yourself. Internal rate of return =29.5025%