Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the required rate of return the project given. To evaluate, set up the cash flow estimation in the excel spreadsheet posted. Your company has
- Using the required rate of return the project given. To evaluate, set up the cash flow estimation in the excel spreadsheet posted. Your company has raised $5,000,000 to invest in an expansion project. All 4 projects will have to begin at the same time, so evaluate the costs of the projects to check for mutually exclusiveness of the projects. Depending on the costs and returns, it is possible to invest in multiple projects. Each project will have its pros and cons, and each project to choose from will have percentages of costs and returns for Expected and Bad Economies. You will need the cash flows for each economy and do a weighted average. Set up excel using formulas.
- This project is over the course of 4 years. You will need an investment of $5 million in year 0, $2.5 million for equipment, and $2.5 million to produce inventory for year 1. Depreciation is straight line over the 4 years, and the new equipment purchased is sold at the end of the project for a salvage value of $250,000. Fixed costs are $500,000 per year and the variable costs are 25% of sales revenues. Total inventory produced will be 85,000 units. Sales for year 1 are 15,000, year 2 are estimated to be 20,000 units at $200 each and Year 3 and 4 at 25,000 units at $125 each. The estimated tax rate is 35%. There is a 30% chance that the Economy worsens by Year 2. If so, sales are estimated to decrease 25% less than the previous year each year with no change in price after year 2 and inventory to be liquidated will be at a loss of 25%.
- This is supposed to be one table side by side, but the image became blurry. Thank you so much in advance!!
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