| Genesis WACC |
| Item | Amount ($000) | % | Interest | Weighted |
| | | Total | Rate | Rate |
| Accounts Payable | 300,000 | 7.50% | 8% |
| Short-term Note Payable | 100,000 | 2.50% | 8% |
| Total Current Liabilities | 400,000 |
| Long-term Note Payable | 400,000 | 10.00% | 9% |
| Mortgage Payable | 1,200,000 | 30.00% | 10% |
| Total Liabilites | 1,600,000 |
| Common Stock Equity | 1,500,000 | 37.50% | 10% |
| Operating Equity | 500,000 | 12.50% | 15.5% |
| Total Liabilities and Equity | 4,000,000 | 100.00% |
| Genesis Captial Projects | (uneven cash flow) | | | | | | | |
| | Initial Investment | Cash Flow | Cash Flow | Cash Flow | Cash flow | Cash Flow | Cashflow | Cashflow | Cashflow | Cashflow |
| | | Y1 | Y2 | Y3 | Y4 | Y5 | Y6-10 | Y7 | Y8 |
| Project A: 25-emp facility | 2000 | -200 | -300 | -400 | 200 | 400 | 1000 | 1000 | $1,000 |
| Cumulative net cash Inflow | | -200 | -500 | -900 | -700 | -300 | 700 | 1700 | $2,700 |
| NPV |
| IRR |
| Project B: 40-emp facility | 2500 | -200 | -200 | 100 | 400 | 400 | 1500 | 1500 | $1,500 |
| Payback | | -200 | -400 | -300 | 100 | 500 | 2000 |
| NPV |
| IRR |
| Project C: 75-emp facility | 3000 | -300 | -400 | -100 | 600 | 700 | 2000 | 1000 |
| payback | | -300 | -700 | -800 | -200 | 500 | 2500 | 3500 |
| NPV |
| IRR |
| PROJECT 2 |
| Equipment 1 - fully automatic | 1500 | -100 | 100 | 200 | 400 | 200 | 800 |
| Payback | | -100 | 0 | 200 | 600 | 800 | 1600 |
| NPV |
| IRR |
| Equipment 1 - semi-automatic | 1000 | -50 | -100 | 200 | 200 | 300 | 600 |
| payback | | -50 | -150 | 50 | 250 | 550 | 1150 |
| NPV |
| IRR |
| Equipment 1 - manual | 750 | 150 | 150 | 150 | 150 | 150 | 750 |
| payback | | 150 | 300 | 450 | 600 | 750 |
| NPV |
| IRR |
| PROJECT 3 |
| Equipment 2 - Standard | 800 | -175 | 200 | 250 | 250 | 300 | 700 |
| payback | | -175 | 25 | 275 | 525 | 825 |
| NPV |
| IRR |
| Equipment 2 - top of line | 1500 | -100 | 275 | 325 | 325 | 325 | 1500 |
| payback | | -100 | 175 | 500 | 825 | 1150 | 2650 |
| NPV |
| IRR |
| PROJECT 4 |
| Equipment 3 - 3-man machine | 700 | -200 | -150 | 250 | 300 | 350 |
| payback | | -200 | -350 | -100 | 200 | 550 |
| NPV |
| IRR |
| Equipment 3 - 2-man machine | 600 | -175 | -100 | 175 | 175 | 175 |
| payback | | -175 | -275 | -100 | 75 | 250 |
| NPV |
| IRR |
| Equipment 3 - 5-man machine | 750 | -300 | -200 | 300 | 400 | 400 |
| payback | | -300 | -500 | -200 | 200 | 600 |
| NPV |
| IRR |
| PROJECT 5 |
| In-house inspection | 1800 | 100 | 500 | 500 | 300 | 300 | 800 |
| paybank | | 100 | 600 | 1100 | 1400 | 1700 | 2500 |
| NPV |
| IRR |
| Contract inspection | | 200 | 200 | 200 | 100 | 100 |
| payback |
| NPV |
| IRR |
may180
auo_b6022_m5_a2_capital_budget_5w.xlsx
