Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $ 200,000 2) New equipment cost ($200,000) 9) Sales increase
1) Life Period of the Equipment = 4 years | 8) Sales for first year (1) | $ 200,000 | |||||
2) New equipment cost | ($200,000) | 9) Sales increase per year | 5% | ||||
3) Equipment ship & install cost | ($35,000) | 10) Operating cost (60% of Sales) | $ (120,000) | ||||
4) Related start up cost | ($5,000) | (as a percent of sales in Year 1) | -60% | ||||
5) Inventory increase | $25,000 | 11) Depreciation | Use 3-yr MACRIS | ||||
6) Accounts Payable increase | $5,000 | 12) Marginal Corporate Tax Rate (T) | 35% | ||||
7) Equip. salvage value before tax | $15,000 | 13) Cost of Capital (Discount Rate) | 10% |
Investments: | |||
1) Equipment cost | |||
2) Shipping and Install cost | |||
3) Start up expenses | |||
Total Basis Cost (1+2+3) | $ - | ||
4) Net Working Capital | |||
Total Initial Outlay | $ - |
Operations: | |||||||
Sales | |||||||
Operating Cost | negative | $ - | $ - | ||||
Depreciation | $ - | $ - | $ - | $ - | |||
EBIT | $ - | $ - | $ - | $ - | |||
Taxes | $ - | $ - | $ - | $ - | |||
Net Income | $ - | $ - | $ - | $ - | |||
Add back Depreciation | $ - | $ - | $ - | $ - | |||
Total Operating Cash Flow | $ - | $ - | $ - | $ - |
Terminal values: | |||||||
1) Change in net WC | |||||||
2) Salvage value (after tax) | |||||||
Total | $ - | ||||||
Project Net Cash Flows | $ - | $ - | $ - | $ - | $ - | ||
NPV = | $0.00 | IRR = | #NUM! | Payback= | 0.00 | ||
Profitability Index = | #DIV/0! | Discounted Payback = | 0.00 |
Payback Period | ||||
Year | Projected CF | Cummulative CF | Count | |
0 | $ - | $ - | ||
1 | $ - | $ - | ||
2 | $ - | $ - | ||
3 | $ - | $ - | ||
4 | $ - | $ - | ||
Payback period | 0.00 | years |
Discounted Payback Period | ||||||
Present Value | ||||||
Year | Projected CF | Discount factor | Discounted CF | Cummulative CF | Count | |
0 | $ - | 1 | $0 | $ - | ||
1 | $ - | $0 | $ - | |||
2 | $ - | $0 | $ - | |||
3 | $ - | $0 | $ - | |||
4 | $ - | $0 | $ - | |||
Payback period | 0.00 | years |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started