4.5 Multiple Cash Flows

Up to this point, you have considered situations that have only a single loan or deposit and a repayment. There are, however, many cases in which there are many inflows and/or outflows to a particular individual or company. For example, consider the company that is developing a business and needs cash inflows (such as loans) early in its life and will balance these inflows with outflows later.

 

Example 4.5.1

Suppose, for instance, that a builder plans to finance a project through a bank and will borrow $150,000 now and $100,000 in three months, then repay $50,000 in six months and the rest in one year’s time. Interest is to be paid on the outstanding balance at 12% compounded monthly.

Then you can find the size of the last payment (denoted by x  above) by following through an account and adding interest every month.

Cash inflows to the builder are positive.

Time (months) Interest Cash Flow Balance
0 0.00 $150,000.00 $150,000.00
1 1,500.00 0.00 151,500.00
2 1,515.00 0.00 153,015.00
3 1,530.15 100,000.00 254,545.15
4 2,545.45 0.00 257,090.60
5 2,570.91 0.00 259,661.51
6 2,596.62 -50,000.00 212,258.12
7 2,122.58 0.00 214,380.70
8 2,143.81 0.00 216,524.51
9 2,165.25 0.00 218,689.76
10 2,186.90 0.00 220,876.65
11 2,208.77 0.00 223,085.42
12 2,230.85 0.00 225,316.27

 

A shorter way to check the account is to accumulate the future value on the outstanding balance only at the time of cash flows. For the above account, then, the result is as follows:

(source)