Analytics Module
aujam253
04-02.xlsxSheet1
| Hurdle Rate | 0.02 | ||||||||||||||||||
| Inflation | 0.025 | ||||||||||||||||||
| Beginning of the Plan | 12/31/19 | ||||||||||||||||||
| Planning Period | Beginning of Year | ||||||||||||||||||
| Year | Inflow | Outflow | Netflow | Discounted Value | Year Since Beginning | PV Another | Decision Analysis 3 | Decision Analysis 4 | |||||||||||
| 2020 | $ 250,000.00 | $ (250,000.00) | $ (250,000.00) | 0 | ($250,000.00) | ||||||||||||||
| 2021 | 100,000.00 | (100,000.00) | $ (95,693.78) | 1 | ($95,693.78) | $ 396,648.86 | NPV | $ 396,648.86 | 150000 | 200000 | 250000 | 300000 | 350000 | 400000 | |||||
| 2022 | 80,000.00 | (80,000.00) | $ (73,258.40) | 2 | ($73,258.40) | 0.02 | 396648.857880611 | 0.02 | 496648.857880611 | 446648.857880611 | 396648.857880611 | 346648.857880611 | 296648.857880611 | 246648.857880611 | |||||
| 2023 | $ 200,000.00 | 200,000.00 | $ 175,259.32 | 3 | $175,259.32 | 0.03 | 355105.377399461 | 0.03 | 455105.377399461 | 405105.377399461 | 355105.377399461 | 305105.377399461 | 255105.377399461 | 205105.377399461 | |||||
| 2024 | 150,000.00 | 50,000.00 | 100,000.00 | $ 83,856.13 | 4 | $83,856.13 | 0.04 | $ 316,562.01 | 0.04 | 416562.00934268 | 366562.00934268 | 316562.00934268 | 266562.00934268 | 216562.00934268 | 166562.00934268 | ||||
| 2025 | 240,000.00 | 60,000.00 | 180,000.00 | $ 144,441.19 | 5 | $144,441.19 | 0.05 | 280765.606444241 | 0.05 | 380765.606444241 | 330765.606444241 | 280765.606444241 | 230765.606444241 | 180765.606444241 | 130765.606444241 | ||||
| 2026 | 230,000.00 | 70,000.00 | 160,000.00 | $ 122,863.32 | 6 | $122,863.32 | 0.06 | 247487.2971427 | 0.06 | 347487.2971427 | 297487.2971427 | 247487.2971427 | 197487.2971427 | 147487.2971427 | 97487.2971426997 | ||||
| 2027 | 150,000.00 | 50,000.00 | 100,000.00 | $ 73,482.85 | 7 | $73,482.85 | 0.07 | 216519.900309053 | 0.07 | 316519.900309053 | 266519.900309053 | 216519.900309053 | 166519.900309053 | 116519.900309053 | 66519.9003090528 | ||||
| 2028 | 120,000.00 | 10,000.00 | 110,000.00 | $ 77,350.36 | 8 | $77,350.36 | 0.08 | 187675.640701165 | 0.08 | 287675.640701165 | 237675.640701165 | 187675.640701165 | 137675.640701165 | 87675.640701165 | 37675.640701165 | ||||
| 2029 | 130,000.00 | 130,000.00 | $ 87,477.58 | 9 | $87,477.58 | 0.09 | 160784.127391996 | 0.09 | 260784.127391996 | 210784.127391996 | 160784.127391996 | 110784.127391996 | 60784.1273919961 | 10784.1273919962 | |||||
| 2030 | 79,000.00 | 79,000.00 | $ 50,870.29 | 10 | $50,870.29 | 0.10 | 135690.562487979 | 0.10 | 235690.562487979 | 185690.562487979 | 135690.562487979 | 85690.5624879787 | 35690.5624879788 | -14309.4375120212 | |||||
| Total | $ 1,299,000.00 | $ 670,000.00 | $ 629,000.00 | $ 396,648.86 | 0.11 | 112254.151800083 | 0.11 | 212254.151800082 | 162254.151800082 | 112254.151800083 | 62254.1518000825 | 12254.1518000825 | -37745.8481999175 | ||||||
| 0.12 | 90346.6928622469 | 0.12 | 190346.692862247 | 140346.692862247 | 90346.6928622469 | 40346.6928622468 | -9653.3071377532 | -59653.3071377532 | |||||||||||
| 0.13 | 69851.3189016315 | 0.13 | 169851.318901632 | 119851.318901632 | 69851.3189016315 | 19851.3189016315 | -30148.6810983685 | -80148.6810983685 | |||||||||||
| 0.14 | 50661.3801297818 | 0.14 | 150661.380129782 | 100661.380129782 | 50661.3801297818 | 661.3801297818 | -49338.6198702182 | -99338.619870218 | |||||||||||
| 0.15 | 32679.4461086094 | 0.15 | 132679.446108609 | 82679.4461086095 | 32679.4461086094 | -17320.5538913906 | -67320.5538913906 | -117320.553891391 | |||||||||||
| 0.16 | 15816.415005149 | 0.16 | 115816.415005149 | 65816.415005149 | 15816.415005149 | -34183.584994851 | -84183.584994851 | -134183.584994851 | |||||||||||
| 0.17 | -9.2826687413 | 0.17 | 99990.7173312587 | 49990.7173312587 | -9.2826687413 | -50009.2826687413 | -100009.282668741 | -150009.282668741 | |||||||||||
| 0.18 | -14872.3966917312 | 0.18 | 85127.6033082688 | 35127.6033082688 | -14872.3966917312 | -64872.3966917312 | -114872.396691731 | -164872.396691731 | |||||||||||
1. Assuming this is the Lorain location cashflow in next 11 years. Is this project still a "go"? 2. When considers average annual inflation rate of 2.5% and hurdle rate as 14%, is this location still a better choice? 3. Quick review different outcome (NPV) under different hurdle rates [.02, .18] 4. In conjunction with question 3, please also review NPV under different amount of seed cost (first year outflow) range [150000, 400000] in 50,000 increment.
