hw3_solution

hw3_solution - 115.57 2140.51 1227.83 1570.73 130.16...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
question 1 age price interest rate cost profit pdv of profit at r=0.08 1 30 0.08 20 1300 1203.7 2 0.12 1846.76 1583.3 3 2266.31 1799.07 4 2620 1925.78 5 2931.61 1995.2 6 3213.33 2024.94 7 3472.39 2026.11 8 3713.52 2006.3 9 3940 1970.98 10 4154.21 1924.2 11 4357.94 1869.05 12 4552.61 1807.91 13 4739.33 1742.64 14 4918.99 1674.72 15 5092.34 1605.32 16 5260 1535.34 17 5422.5 1465.53 18 5580.29 1396.46 19 5733.75 1328.58 20 5883.22 1262.23 21 6029 1197.7 22 6171.35 1135.16 23 6310.5 1074.77 24 6446.65 1016.63 25 6580 960.8 26 6710.71 907.3 27 6838.92 856.14 28 6964.78 807.31 29 7088.42 760.78 30 7209.94 716.5 NOTE: if U want the column to stay constant when using autocomplete I put a $ sign in front o Likewise, I can do the same for the row, by putting $ in front of the row eg E$6, or
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
question 2 question 3 question 4 pdv of profit at r=0.12 PDV of green tourism PDV of total profits expected pdv of profits 1160.71 23.15 1226.85 1107.41 1472.23 44.58 1627.88 1340.11 1613.11 64.43 1863.5 1400.91 1665.06 82.8 2008.58 1379.61 1663.47 99.82 2095.02 1315 1627.97
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 115.57 2140.51 1227.83 1570.73 130.16 2156.27 1130.26 1499.83 143.67 2149.97 1029.67 1420.8 156.17 2127.15 930.62 1337.54 167.75 2091.95 835.85 1252.8 178.47 2047.52 746.94 1168.54 188.4 1996.31 664.71 1086.13 197.59 1940.24 589.45 1006.52 206.11 1880.83 521.16 930.35 213.99 1819.3 459.6 858.02 221.28 1756.63 404.4 789.76 228.04 1693.57 355.13 725.66 234.3 1630.76 311.32 665.73 240.09 1568.67 272.49 609.89 245.45 1507.69 238.18 558.04 250.42 1448.12 207.92 510.02 255.02 1390.18 181.3 465.64 259.28 1334.05 157.92 424.72 263.22 1279.85 137.43 387.06 266.87 1227.67 119.49 352.45 270.25 1177.55 103.81 320.7 273.38 1129.52 90.12 291.61 276.28 1083.59 78.18 264.99 278.96 1039.74 67.78 240.65 281.44 997.95 58.73 of the column name e.g. in the PDV of profit formula r I can keep the entire cell constant eg $E$6...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

hw3_solution - 115.57 2140.51 1227.83 1570.73 130.16...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online