1
3
1
1
5
16
The formula in cell C4 is: =SLN($B$3,0,5), where 5 is the depreciation life. Then copy formula in
cell C4 to cells D4, E4, F4, and G4.
17 The values in row 5 and 6 are data.
18
The formula in cell B7 is: =B5*(1-B6). Then copy formula in cell B7 to cells C7, D7, E7, F7, and
G7.
1
9The formula in cell C8 is: =C4*C6. Then copy formula in cell C8 to cells, D8, E8, F8, and G8.
20
The formula in cell B9 is: -B7-B8+B3. Then copy formula in cell B9 to cells C9, D9, E9, F9, and
G9.
21 The formula in cell B12 is: =B11*(1-B6).
22 The formula in cell B14 is: =B9 + NPV(B12,C9:G9).
2
3
2
4Cash flows to Foster Now Year 1 Year 2 Year 3 Year 4 Year 5
2
5
3
0
3
1The values in rows 26, 27, and 28 are the same as in rows 3, 8, and 7 respectively.
3
2
The formula in cell B29 is: =B27+B28-B26. Then copy formula in cell B29 to cells C29, D29,
E29, F29, and G29.
a.
The net advantage to leasing is negative for Thorenberg Inc.: –$3,646. Thus, the firm should buy
rather than lease the equipment.
9-4