Learning path 5 · Topic 24 of 30

Make the external rate explicit

External rate of return accounts directly for a specified reinvestment/discount rate. Use the separate positive and negative net-flow convention stated here.

Change a scenario. Watch the consequence.
0123Receipts (+)Expenses (−)

Period 0: −$10,000.00. This is the time-zero cash flow. Periods use the payment interval stated in the model.

BucketEquivalent amount ($)
Outflows at 016,350.66
Inflows at 313,478.40
ERR in percent · %PE=16350.657928,FR=13478.4,ERR=(FRPE)1/3−1=−6.236379%P_E=16350.657928,\quad F_R=13478.4,\quad ERR=\left(\frac{F_R}{P_E}\right)^{1/3}-1=-6.236379\%

Under this convention, discount net negative cash flows and compound net positive cash flows using the stated external rate.

Follow the reasoning

Separate positive and negative NET cash flows at each date.

Cash-flow dates and signs are part of the answer. Model values retain precision; displays round money to cents. Illustrative assumptions exclude taxes and inflation unless stated.

01

What the model means

At each date first form NET cash flow. Discount negative net flows to time 0 at ε; compound positive net flows to year N at ε. Define these positive magnitudes as P_E and F_R, then solve P_E(1+ERR)ᴺ=F_R.

02

Build the calculation

When the external rate equals a compatible IRR root, the constructions agree. In general ERR changes with ε. Some conventions use different finance and reinvestment rates or a project-balance method; state the convention before comparing results.

PE=∑CFt<0−CFt(1+ϵ)t,FR=∑CFt>0CFt(1+ϵ)N−t,ERR=(FR/PE)1/N−1P_E=\sum_{CF_t<0}\frac{-CF_t}{(1+\epsilon)^t},\quad F_R=\sum_{CF_t>0}CF_t(1+\epsilon)^{N-t},\quad ERR=(F_R/P_E)^{1/N}-1
Practice with feedback

Set up. Calculate. Explain.

Answer unit: %

Rebuild the starting scenario

External reinvestment rate: 8 %; Terminal cleanup: 8000 $. Calculate the ERR in percent.

Setup hint

Separate positive and negative NET cash flows at each date.

Open the visual solutionPE=16350.657928,FR=13478.4,ERR=(FRPE)1/3−1=−6.236379%P_E=16350.657928,\quad F_R=13478.4,\quad ERR=\left(\frac{F_R}{P_E}\right)^{1/3}-1=-6.236379\%
  1. Separate positive and negative NET cash flows at each date.
  2. Discount all negatives to 0 at ε; accumulate positives to year 3 at ε.
  3. Bridge these two equivalent totals over 3 periods. ERR can be negative and changes with the external rate.
0123Receipts (+)Expenses (−)

Period 0: −$10,000.00. This is the time-zero cash flow. Periods use the payment interval stated in the model.

BucketEquivalent amount ($)
Outflows at 016,350.66
Inflows at 313,478.40
ERR in percent · %PE=16350.657928,FR=13478.4,ERR=(FRPE)1/3−1=−6.236379%P_E=16350.657928,\quad F_R=13478.4,\quad ERR=\left(\frac{F_R}{P_E}\right)^{1/3}-1=-6.236379\%

Under this convention, discount net negative cash flows and compound net positive cash flows using the stated external rate.

Visual solution

Separate positive and negative NET cash flows at each date.

Cash-flow dates and signs are part of the answer. Model values retain precision; displays round money to cents. Illustrative assumptions exclude taxes and inflation unless stated.

Checks allow 0.1% numerical rounding (minimum $0.05 or 0.001 in the stated nonmonetary unit). Interpolated factors and rates are approximations; keep table precision consistent.

Answer unit: %

Transfer the idea to a new scenario

For −$10,000 now, +$6,000 at years 1 and 2, and −$5,000 at year 3, use external rate 10% and calculate ERR.

Setup hint

Separate positive and negative NET cash flows at each date.

Open the visual solutionPE=13756.574005,FR=13860,ERR=(FRPE)1/3−1=0.249984%P_E=13756.574005,\quad F_R=13860,\quad ERR=\left(\frac{F_R}{P_E}\right)^{1/3}-1=0.249984\%
  1. Separate positive and negative NET cash flows at each date.
  2. Discount all negatives to 0 at ε; accumulate positives to year 3 at ε.
  3. Bridge these two equivalent totals over 3 periods. ERR can be negative and changes with the external rate.
0123Receipts (+)Expenses (−)

Period 0: −$10,000.00. This is the time-zero cash flow. Periods use the payment interval stated in the model.

BucketEquivalent amount ($)
Outflows at 013,756.57
Inflows at 313,860.00
ERR in percent · %PE=13756.574005,FR=13860,ERR=(FRPE)1/3−1=0.249984%P_E=13756.574005,\quad F_R=13860,\quad ERR=\left(\frac{F_R}{P_E}\right)^{1/3}-1=0.249984\%

Under this convention, discount net negative cash flows and compound net positive cash flows using the stated external rate.

Visual solution

Separate positive and negative NET cash flows at each date.

Cash-flow dates and signs are part of the answer. Model values retain precision; displays round money to cents. Illustrative assumptions exclude taxes and inflation unless stated.

Checks allow 0.1% numerical rounding (minimum $0.05 or 0.001 in the stated nonmonetary unit). Interpolated factors and rates are approximations; keep table precision consistent.

Explain the distinction

Which rate compounds interim receipts to the final date in this ERR convention?

Can you defend your setup?

Can you place each amount on the timeline, match the interest period, calculate the equivalent quantity, and state the decision or limitation?

Completion is saved on this browser.