Genesis Energy Capital Plan Report
mschmaltzCapitalBudgetSpreadsheet.xlsx
Sheet1
Genesis Energy WACC | ||||||||
Item | Amount ($000) | % | Interest | Weighted | ||||
Total | Rate | Rate | ||||||
Accounts Payable | 300,000 | 7.50% | ||||||
Short-term Note Payable | 100,000 | 2.50% | ||||||
Total Current Liabilities | 400,000 | |||||||
Long-term Note Payable | 400,000 | 10.00% | ||||||
Mortgage Payable | 1,200,000 | 30.00% | ||||||
Total Liabilites | 1,600,000 | |||||||
Common Stock Equity | 1,500,000 | 37.50% | ||||||
Operating Equity | 500,000 | 12.50% | ||||||
Total Liabilities and Equity | 4,000,000 | 100.00% | ||||||
Genesis Energy Captial Projects | ||||||||
Initial Investment | Cash Flow | Cash Flow | Cash Flow | Cash flow | Cash Flow | Cashflow | ||
Y1 | Y2 | Y3 | Y4 | Y5 | Y6-10 | |||
Project A: 25-emp facility | 2000 | -200 | -300 | -400 | 200 | 400 | 1000 | |
Project B: 40-emp facility | 2500 | -200 | -200 | 100 | 400 | 400 | 1500 | |
Project C: 75-emp facility | 3000 | -300 | -400 | -100 | 600 | 700 | 2000 | |
Equipment 1 - fully automatic | 1500 | -100 | 100 | 200 | 400 | 200 | 800 | |
Equipment 1 - semi-automatic | 1000 | -50 | -100 | 200 | 200 | 300 | 600 | |
Equipment 1 - manual | 750 | 150 | 150 | 150 | 150 | 150 | 750 | |
Equipment 2 - Standard | 800 | -175 | 200 | 250 | 250 | 300 | 700 | |
Equipment 2 - top of line | 1500 | -100 | 275 | 325 | 325 | 325 | 1500 | |
Equipment 3 - 3-man machine | 700 | -200 | -150 | 250 | 300 | 350 | ||
Equipment 3 - 2-man machine | 600 | -175 | -100 | 175 | 175 | 175 | ||
Equipment 3 - 5-man machine | 750 | -300 | -200 | 300 | 400 | 400 | ||
In-house inspection | 1800 | 100 | 500 | 500 | 300 | 300 | 800 | |
Contract inspection | 200 | 200 | 200 | 100 | 100 | |||