| Genesis Energy WACC |
| Item | Amount ($000) | % | Interest | Total | Weighted |
| | | Total | Rate | Iterest | Rate |
| Accounts Payable | 300,000 | 7.50% | 0% | 0% |
| Short-term Note Payable | 100,000 | 2.50% | 8% | $8,000.00 |
| Total Current Liabilities | 400,000 | 10.00% |
| Long-term Note Payable | 400,000 | 10.00% | 8% | $32,000.00 |
| Mortgage Payable | 1,200,000 | 30.00% | 6% | $72,000.00 |
| Total Liabilites | 1,600,000 |
| Common Stock Equity | 1,500,000 | 37.50% | 2% | $30,000.00 |
| Operating Equity | 500,000 | 12.50% | | 0.0% |
| Total Liabilities and Equity | 4,000,000 | 100.00% | | $142,000.00 | 3.55% |
| Genesis Energy Captial Projects | | | | | | | | |
| | Initial Investment | Cash Flow | Cash Flow | Cash Flow | Cash flow | Cash Flow | Cashflow | Cashflow | Cashflow | Cashflow | Cashflow |
| | | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 | NPV | IRR | PAYBACK PERIOD | MIRR | PI | DISCOUNTED PAYBACK | Capital Project | PV'S | Average FCF/Dividend |
| Project A: 25-emp facility | -2000 | -200 | -300 | -400 | 200 | 400 | 1000 | 1000 | 1000 | 1000 | 1000 | $1,463.77 | 10% | 6.70 | 7.95% | 1.73 | | Project A | $3,463.77 |
| | -2000 | -2200 | -2500 | -2900 | -2700 | -2300 | -1300 | -300 | 700 | 1700 | 2700 |
| FCF/Dividend | | -$0.01 | -$0.01 | -$0.01 | $0.01 | $0.01 | $0.03 | $0.03 | $0.03 | $0.03 | $0.03 | | | | | | | | | 0.0157 |
| Project B: 40-emp facility | -2500 | -200 | -200 | 100 | 400 | 400 | 1500 | 1500 | 1500 | 1500 | 1500 | $3,574.81 | 16% | 5.67 | 12.25% | 2.43 | | Project B | $6,074.81 |
| | -2500 | -2700 | -2900 | -2800 | -2400 | -2000 | -500 | 1000 | 2500 | 4000 | 5500 |
| FCF/Dividend | | -$0.01 | -$0.01 | $0.00 | $0.01 | $0.01 | $0.05 | $0.05 | $0.05 | $0.05 | $0.05 | | | | | | | | | 0.0267 |
| Project C: 75-emp facility | -3000 | -300 | -400 | -100 | 600 | 700 | 2000 | 2000 | 2000 | 2000 | 2000 | $4,931.03 | 17% | 5.75 | 12.61% | 2.64 | | Project C | $7,931.03 |
| | -3000 | -3300 | -3700 | -3800 | -3200 | -2500 | -500 | 1500 | 3500 | 5500 | 7500 |
| FCF/Dividend | | -$0.01 | -$0.01 | -$0.00 | $0.02 | $0.02 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | | | | | | | | | 0.0350 |
| Project A, B and C. | -7500 | -700 | -900 | -400 | 1200 | 1500 | 4500 | 4500 | 4500 | 4500 | 4500 | $2,899.41 | 15% | 5.49 | 11.33% | 2.33 | | Project A,B and C | $17,469.61 |
| | -7500 | -8200 | -9100 | -9500 | -8300 | -6800 | -2300 | 2200 | 6700 | 11200 | 15700 |
| FCF/Dividend | | -$0.02 | -$0.03 | -$0.01 | $0.04 | $0.05 | $0.15 | $0.15 | $0.15 | $0.15 | $0.15 | | | | | | | | | 0.0773 |
| Equipment 1 - fully automatic | -1500 | -100 | 100 | 200 | 400 | 200 | 800 | 800 | 800 | 800 | 800 | $2,222.32 | 18% | 4.13 | 12.99% | 2.48 | | Equipment 1 - fully | $3,722.32 |
| | -1500 | -1600 | -1500 | -1300 | -900 | -700 | 100 | 900 | 1700 | 2500 | 3300 |
| FCF/Dividend | | -$0.00 | $0.00 | $0.01 | $0.01 | $0.01 | $0.03 | $0.03 | $0.03 | $0.03 | $0.03 | | | | | | | | | 0.0160 |
| Equipment 1 - semi-automatic | -1000 | -50 | -100 | 200 | 200 | 300 | 600 | 600 | 600 | 600 | 600 | $1,736.73 | 19% | 4.25 | 13.58% | 2.74 | | Equipment 1 - semi | $2,736.73 |
| | -1000 | -1050 | -1150 | -950 | -750 | -450 | 150 | 750 | 1350 | 1950 | 2550 |
| FCF/Dividend | | -$0.00 | -$0.00 | $0.01 | $0.01 | $0.01 | $0.02 | $0.02 | $0.02 | $0.02 | $0.02 | | | | | | | | | 0.0118 |
| Equipment 1 - manual | -750 | 150 | 150 | 150 | 150 | 150 | 750 | 750 | 750 | 750 | 750 | $2,766.56 | 33% | 3.00 | 20.85% | 4.69 | | Equipment 1 - manual | $3,516.56 |
| | -750 | -600 | -450 | -300 | -150 | 0 | 750 | 1500 | 2250 | 3000 | 3750 |
| FCF/Dividend | | $0.01 | $0.01 | $0.01 | $0.01 | $0.01 | $0.03 | $0.03 | $0.03 | $0.03 | $0.03 | | | | | | | | | 0.0150 |
| Equipment 1 - all | -3250 | 0 | 150 | 550 | 750 | 650 | 2150 | 2150 | 2150 | 2150 | 2150 | $6,725.62 | 22% | 3.47 | 15.84% | 3.07 | | Equipment 1 - all | $9,975.62 |
| | -3250 | -3250 | -3100 | -2550 | -1800 | -1150 | 1000 | 3150 | 5300 | 7450 | 9600 |
| FCF/Dividend | | $0.00 | $0.01 | $0.02 | $0.03 | $0.02 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | | | | | | | | | 0.0428 |
| Equipment 2 - Standard | -800 | -175 | 200 | 250 | 250 | 300 | 700 | 700 | 700 | 700 | 700 | $2,563.02 | 28% | 3.08 | 17.85% | 4.20 | | Equipment 2 - Standard | $3,363.02 |
| | -800 | -975 | -775 | -525 | -275 | 25 | 725 | 1425 | 2125 | 2825 | 3525 |
| FCF/Dividend | | -$0.01 | $0.01 | $0.01 | $0.01 | $0.01 | $0.02 | $0.02 | $0.02 | $0.02 | $0.02 | | | | | | | | | 0.0144 |
| Equipment 2 - top of line | -1500 | -100 | 275 | 325 | 325 | 325 | 1500 | 1500 | 1500 | 1500 | 1500 | $5,188.79 | 29% | 4.77 | 19.67% | 4.46 | | Equipment 2 - top of line | $6,688.79 |
| | -1500 | -1600 | -1325 | -1000 | -675 | -350 | 1150 | 2650 | 4150 | 5650 | 7150 |
| FCF/Dividend | | -$0.00 | $0.01 | $0.01 | $0.01 | $0.01 | $0.05 | $0.05 | $0.05 | $0.05 | $0.05 | | | | | | | | | 0.0288 |
| Equipment 2 - all | -2300 | -275 | 475 | 575 | 575 | 625 | 2200 | 2200 | 2200 | 2200 | 2200 | $7,751.80 | 29% | 4.85 | 19.01% | 4.37 | | Equipment 2 - all | $10,051.80 |
| | -2300 | -2575 | -2100 | -1525 | -950 | -325 | 1875 | 4075 | 6275 | 8475 | 10675 |
| FCF/Dividend | | -$0.01 | $0.02 | $0.02 | $0.02 | $0.02 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | | | | | | | | | 0.0433 |
| Equipment 3 - 3-man machine | -700 | -200 | -150 | 250 | 300 | 350 | | | | | | ($252.97) | -4% | 0.00 | -2.11% | 0.64 | | Equipment 3 - 3-man | $447.03 |
| | -700 | -900 | -1050 | -800 | -500 | -150 |
| FCF/Dividend | | -$0.01 | -$0.01 | $0.01 | $0.01 | $0.01 | | | | | | | | | | | | | | 0.0037 |
| Equipment 3 - 2-man machine | -600 | -175 | -100 | 175 | 175 | 175 | | | | | | ($405.45) | -13% | 0.00 | -8.81% | 0.32 | | Equipment 3 - 2-man | $194.55 |
| | -600 | -775 | -875 | -700 | -525 | -350 |
| FCF/Dividend | | -$0.01 | -$0.00 | $0.01 | $0.01 | $0.01 | | | | | | | | | | | | | | 0.0017 |
| Equipment 3 - 5-man machine | -750 | -300 | -200 | 300 | 400 | 400 | | | | | | ($272.16) | -4% | 0.00 | -1.52% | 0.64 | | Equipment 3 - 5-man | $477.84 |
| | -750 | -1050 | -1250 | -950 | -550 | -150 |
| FCF/Dividend | | -$0.01 | -$0.01 | $0.01 | $0.01 | $0.01 | | | | | | | | | | | | | | 0.0040 |
| Equipment 3 - all | -2050 | -675 | -450 | 725 | 875 | 925 | | | | | | ($930.58) | -6% | 0.00 | -3.53% | 0.55 | | Equipment 3 - all | $1,119.42 |
| | -2050 | -2725 | -3175 | -2450 | -1575 | -650 |
| FCF/Dividend | | -$0.02 | -$0.02 | $0.02 | $0.03 | $0.03 | | | | | | | | | | | | | | 0.0093 |
| In-house inspection | -1800 | 100 | 500 | 500 | 300 | 300 | 800 | 800 | 800 | 800 | 800 | $2,755.72 | 22% | 4.88 | 13.63% | 2.53 | | In-house inspection | $4,555.72 |
| | -1800 | -1700 | -1200 | -700 | -400 | -100 | 700 | 1500 | 2300 | 3100 | 3900 |
| FCF/Dividend | | $0.00 | $0.02 | $0.02 | $0.01 | $0.01 | $0.03 | $0.03 | $0.03 | $0.03 | $0.03 |
| Contract inspection | | 200 | 200 | 200 | 100 | 100 | | | | | | $730.76 |
Lhmdr7020
m5_a2.xlsx
