Why a Timeline Comes Before a Cash-Flow Calculation
An irregular cash-flow problem may list receipts and payments on several dates, sometimes before and sometimes after the date of interest. Before calculating anything, organize the transactions so that their dates, directions, and signs are unambiguous. A timeline makes it easier to see whether a payment occurs at the valuation date, whether two transactions happen on the same date, and whose cash flows are being described.
The timeline is a representation, not a valuation calculation. Its first job is to put every amount in the right place. Only after that can a separate calculation move the amounts to a common date. In particular, amounts occurring at different times should not be added as if they were all measured on the same date.
Set the Reference Date, Unit, and Perspective
A useful timeline begins with four decisions. First, state whose cash flows are being recorded: for example, the borrower, lender, project sponsor, or investor. Second, identify the valuation date and label it \(t=0\). Third, choose a time unit, such as years or months. Fourth, assign each transaction a signed amount from that party’s perspective.
If \(D_0\) is the valuation date, a transaction on date \(D_j\) is placed at the relative time \(t_j\). The meaning of \(t_j\) depends on the chosen unit. For instance, if the unit is years, \(t_j=-0.5\) means six months before the valuation date, and \(t_j=1.25\) means one year and three months after it. Negative time does not mean a negative cash amount: it only means the date precedes \(t=0\).
For every date \(t_j\), let \(C_j\) be the signed cash flow from the stated perspective. A receipt has \(C_j>0\), while a payment has \(C_j<0\). If the perspective changes to the other side of the same transaction, the sign reverses. For example, a loan advance is positive to the borrower and negative to the lender.
Use one time unit throughout a timeline. If dates are stated in months, either keep all positions in months or convert all of them to years. Do not label one date as \(t=6\) in months and another as \(t=1\) in years without explicitly converting; those labels would not be comparable.
Name the party whose receipts and payments determine the signs.
Set that date to \(t=0\), even if other transactions occur earlier.
Place every date before or after \(t=0\) using that same unit.
Include each transaction once, check its direction from the chosen perspective, and identify any same-date flows.
Worked Examples: Constructing and Checking Timelines
Worked Example: A Project Sponsor’s Timeline Around the Valuation Date
A project sponsor evaluates a hypothetical equipment project on January 1, 2027. The sponsor paid a $12,000 design fee on October 1, 2026, expects to pay $30,000 for equipment on January 1, 2027, and expects receipts of $8,000 on April 1, 2027 and $40,000 on January 1, 2028. Construct the timeline from the sponsor’s perspective. Assume an effective annual interest rate of \(i=8\%\); no interest conversion or cash-flow valuation is requested here.
Method. Set January 1, 2027 as \(t=0\), use years as the unit, and record receipts as positive and payments as negative. The October 1 date is three months before the valuation date, or \(t=-0.25\). April 1 is three months after it, or \(t=0.25\). January 1, 2028 is one year after it, or \(t=1\).
The design fee and equipment purchase are both payments by the sponsor, so their signed amounts are \(-\$12{,}000\) and \(-\$30{,}000\). The two project receipts are positive. The timeline is therefore:
Check. The date \(t=0\) is the equipment-purchase date, not the project’s start date. The negative time for the design fee records that it has already been paid relative to the chosen valuation date; it does not change the fee into a receipt. The stated interest rate does not alter the signs or time positions.
Common mistake avoided: treating every amount before \(t=0\) as negative. Time position and cash-flow sign are separate pieces of information: the design fee is at negative time and is also a negative cash flow, but a receipt before \(t=0\) would have negative time and a positive amount.
Worked Example: A Lender’s Perspective on a Loan Timeline
A lender advances $50,000 on January 1, 2025. It receives a $4,000 payment on July 1, 2025 and a final $48,000 payment on January 1, 2027. Construct the timeline from the lender’s perspective using January 1, 2026 as the valuation date and years as the time unit. The contract states an effective annual rate of \(i=9\%\), but the task is only to organize the cash flows.
Method. The lender pays out the advance, so it is negative. The two later receipts are positive. Relative to January 1, 2026, January 1, 2025 is one year earlier, July 1, 2025 is half a year earlier, and January 1, 2027 is one year later.
Check. There is no transaction at \(t=0\), because no cash flow is dated January 1, 2026. The advance is not positive merely because the lender initially owns the funds; from the lender’s perspective, the advance is money paid out. The \(9\%\) rate would matter in a later valuation calculation, but it does not move a transaction to a different date.
Common mistake avoided: assigning signs from the borrower’s point of view while labeling the result as the lender’s timeline. Reversing perspective reverses every cash-flow sign: the borrower receives the advance and pays the installments, whereas the lender pays the advance and receives the installments.
Worked Example: A Borrower’s Timeline with a Payment at \(t=0\)
A borrower receives a loan advance of $18,000 on January 1, 2026. The borrower makes a $600 payment on July 1, 2026 and another $600 payment on January 1, 2027. Use July 1, 2026 as the valuation date, measure time in months, and work from the borrower’s perspective. The loan has a nominal annual rate of \(i^{(12)}=6\%\), convertible monthly; no balance or interest calculation is requested.
Method. The advance occurred six months before the valuation date, so it is at \(t=-6\). The first payment occurs on the valuation date, so it is at \(t=0\). The second payment is six months after the valuation date, so it is at \(t=6\). The advance is money received by the borrower and is positive. Both payments are money paid by the borrower and are negative.
Check. The sign of the $18,000 advance is positive because the perspective is the borrower’s, even though the advance occurs at negative time. The payment at \(t=0\) is included; it should not be omitted just because it coincides with the valuation date. The nominal rate is stated with monthly conversion, but no interest amount is needed to place these dated cash flows.
Common mistake avoided: treating the loan advance as negative because a lender would record it that way. The amount is positive for the borrower and negative for the lender; the date alone cannot determine its sign.
Why Same-Date Flows Can Be Netted
A timeline can list two or more transactions at the same date as separate entries, or combine them into one net entry when the purpose is to represent the total cash movement for the chosen party at that date. This is valid because the transactions occur at the same time: their signed amounts contribute to the same date’s total. For example, a $1,200 receipt and a $700 payment on one date produce a net receipt of $500 at that date.
The justification is ordinary signed addition. Let \(R\) be the total receipts and \(P\) the total payments for one party on a particular date, with both written as nonnegative dollar amounts before applying signs. The signed total at that date is \(R-P\). Listing the receipt as \(+R\) and the payment as \(-P\) gives the same result:
The netting applies only to flows on the same date. A receipt today and a payment later do not form a single date’s net cash flow, even if their dollar amounts are equal. If the valuation date is changed, the relative time labels change, but the actual dates and the signs from a fixed party’s perspective do not. This distinction is useful for checking a timeline before any subsequent calculation.
Common Timeline Errors and Practical Checks
Most timeline errors are not arithmetic errors; they are errors of interpretation. A clean-looking calculation can still be wrong if its cash-flow signs belong to the other party or if its dates use inconsistent units. Before proceeding from a timeline to a value calculation, check the following:
- Perspective: Every sign should answer the same question: “Is this money received or paid by the named party?”
- Reference date: \(t=0\) must correspond to the stated valuation date, not automatically to the first transaction.
- Direction of time: Dates before the valuation date have negative time positions; dates after it have positive positions.
- Time unit: Convert months, quarters, and years consistently. A six-month interval is \(0.5\) years or \(6\) months, not both without labels.
- Payment timing: A payment at the valuation date belongs at \(t=0\). Do not silently treat it as occurring at the beginning or end of some other period.
- Completeness: Include initial advances, fees, interim payments, and final receipts if they are part of the described cash flows.
- Same-date transactions: Keep separate entries when their source matters; net them only after verifying they occur on exactly the same date.
A useful final check is to read the timeline from left to right and narrate it aloud from the stated party’s perspective. For example: “One year before the valuation date, the lender pays $50,000; six months before, it receives $4,000; one year after, it receives $48,000.” If the narrative conflicts with a sign or position on the timeline, correct the timeline before calculating.
Check Your Understanding
For each problem, state the perspective and time unit, then check that each date and sign is consistent with the description.
- A consultant values a contract on January 1, 2026. From the consultant’s perspective, it received $1,200 on October 1, 2025, paid $350 on January 1, 2026, and expects to receive $900 on April 1, 2026. Use years. Give the signed timeline. (Answer: \(t=-0.25:+\$1{,}200;\ t=0:-\$350;\ t=0.25:+\$900\).)
- A company uses July 1, 2026 as its valuation date and measures time in months. From the company’s perspective, it pays $5,000 on June 1, receives $1,200 on July 1, pays $700 on July 1, and receives $4,000 on December 1, 2026. Give the separate entries and the net entry at \(t=0\). (Answer: \(t=-1:-\$5{,}000;\ t=0:+\$1{,}200,-\$700\), net \(+\$500;\ t=5:+\$4{,}000\).)
- A lender advances $50,000 on January 1, 2025, receives $4,000 on July 1, 2025, and receives $48,000 on January 1, 2027. Use January 1, 2026 as the valuation date and years as the unit. Give the timeline from the lender’s perspective. (Answer: \(t=-1:-\$50{,}000;\ t=-0.5:+\$4{,}000;\ t=1:+\$48{,}000\).)
- A borrower receives $18,000 on January 1, 2026, pays $600 on July 1, 2026, and pays $600 on January 1, 2027. Use July 1, 2026 as the valuation date and months as the unit. Give the timeline from the borrower’s perspective. (Answer: \(t=-6:+\$18{,}000;\ t=0:-\$600;\ t=6:-\$600\).)
- An equipment operator evaluates cash flows on October 1, 2026 and uses months. From the operator’s perspective, it pays $2,400 on July 1, receives $900 on October 1, pays $250 on October 1, and receives $1,600 on January 1, 2027. State the timeline, including the net flow on the valuation date. (Answer: \(t=-3:-\$2{,}400;\ t=0:+\$900,-\$250\), net \(+\$650;\ t=3:+\$1{,}600\).)