Reference no: EM131869610
Project Assignment
You will complete a capital budgeting Excel spreadsheet solution based on:
• Cost of new equipment
• Shipping and installation
• Unit sales
o Year 1 70,000
o Year 2 120,000
o Year 3 120,000
o Year 4 80,000
o Year S 70,000
$14,800,000
200,000
• Sales price = $300 / unit in years 1-4 and $250/unit in year 5
• Variable cost = $140 / unit
• Fixed cost = $700,000 per year for all 5 years
• Working capital : $200,000 at start of project, recovered at end
• Depreciation = straight line over 5 years
• Tax rate = 34%
• Cost of capital = 15%
You must complete this project using an Excel spreadsheet. Your assignment specifically:
1. Lay out the cash flows for years 1-5
2. Calculate the project NPV, using the Excel NPV function (write the function on your submitted spreadsheet)
3. Calculate the project IRR, using the Excel NPV function (write the function on your submitted spreadsheet)
|
Calculate the cost of each capital component
: Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method.
|
|
What are the decision variables
: Eastern Alabama Trust invests in various types of securities. They have $5 million for immediate investment and wish to maximize interest earned over the next.
|
|
What effect do creators of the video wish to have on viewer
: What effect do the creators of this video wish to have on the viewer? In other words, what is the video's purpose? Who do you think is the intended audience?
|
|
What does plunge in technology spending mean
: "In early 2001, the global IT business slowdown and the dotcom bust altered the situation. Reportedly, Cisco failed to foresee the changing trends.
|
|
Calculate the project irr using the excel npv function
: Calculate the project IRR, using the Excel NPV function (write the function on your submitted spreadsheet)
|
|
Which supplier should win the business
: Dusty is evaluating three bids to supply fence hardware for the 5 acres of pasture that need to be fenced. Breezy submits a bid of $40 per unit with a defect.
|
|
Which production level is best
: In December, pizza crust orders (from retailers) increases. You service 200 retailers, and during this time there is a 60% chance that any one retailer.
|
|
Forecast what the exchange rate will be for each currency
: Forecast what the exchange rate will be for each currency on March 20,and April 20, 2018.
|
|
Define key learnings from the case related to recruitment
: Elaborate on two key learnings from the case related to recruitment, selection, and legal considerations. Be sure to clearly state the two key learnings.
|