4
1
5Residual value year-end 2015 in AUD $186.2
1
6
1
1
8Vineyard value in Australian dollars $146 million
1
9
2
2
6
2
7Residual value year-end 2015 in euros €78.2
2
8
2
3
1
3
2Rows 4 to 6, 17, 20, 21, 29, plus cells B7 and B8 are data.
3
3The formula in cell C7 is: =B7*(1+C4). Then copy formula in cell C7 to cells D7, E7, F7, G7, and H7.
3
4The formula in cell C8 is: =B8*(1+C4). Then copy formula in cell C8 to cells D8, E8, F8, G8, and H8.
3
5The formula in cell C9 is: =C8*(1-C5). Then copy formula in cell C9 to cells D9, E9, F9, G9, and H9.
3
6The formula in cell B10 is: =B6*B7. Then copy formula in cell B10 to cells C10, D10, E10, F10, G10, and H10.
3
7The formula in cell C11 is: =-(C10-B10). Then copy formula in cell C11 to cells D11, E11, F11, G11, and H11.
3
8The formula in cell C13 is: =C9+C11. Then copy formula in cell C13 to cells D13, E13, F13, G13, and H13.
3
9The formula in cell G15 is: =H13/(B17-H4).
4
0The formula in cell B18 is: =NPV(B17,C13:G13)+G15/(1+B17)^5.
4
1The formula in cell B22 is: =1/B21.
4The formula in cell C23 is: =B23*(1+C20)/(1+C4). Then copy formula in cell 23 to cells D23, E23, F23, G23, and
14-9