Reference no: EM13753103
Activity 1. Memo from Bob:
I need to help our client, Rondo, make a decision on whether or not to go ahead with a project. I'd like you to do a net present value (NPV) analysis on this special production project. The project will require an initial investment in a piece of manufacturing equipment. The product will be sold exclusively to the client over the next three years.
Please prepare an NPV analysis of the Rondo project. I have compiled the following cost and sales estimates from engineering and marketing.
1. Project life is 3 years.
2. Initial investment is $7,550,000 for equipment invoice, transportation, and installation.
3. Worker training for operating new equipment is $18,000.
4. First-year sales are projected to be $4,500,000 escalated at 3.5% each year thereafter.
5. Operating overhead (excluding depreciation) is estimated at 27% of annual sales.
6. Administrative overhead is estimated at 35% of annual sales.
7. Depreciation is straight line, 5 years.
8. The tax rate is 40%.
9. The new equipment can be salvaged at the end of the project (end of YR 3) for $2,500,000.
10. Cost of capital is 10%.
You'll need to create an Excel cash flow spreadsheet and calculate the NPV and IRR. Make your recommendation on the project.
A few observations:
1. Please do not forget how to treat the depreciation: first as an item for the net income and then to add it back for the cash flows; and it is straight line depreciation.
2. Worker training to be expensed in period 0. But keep in mind that you would want to view it on an after tax basis.
3. Please do not forget the terminal cash flow which depends on the salvage value and the remaining book value of the asset!
Activity2: Calculation of the Outcomes of the Calls and Puts Held Long and Short
Bob needs your opinion. You receive a voice mail.
In order to make the decision on the best course of action, two tables of calculations are needed:
1. One table for calculations on:
a. The possible outcomes of buying a call option for $2.10, exercise price $37.50
b. Possible price ranges for the underlying stock: 25 30 35 40 45 50 55 60
2. A second table for calculations on:
a. The possible outcomes of buying a put option for $1.65, exercise price $37.50
b. Possible price ranges for the underlying stock: 25 30 35 40 45 50 55 60
Deliverables
1. A worksheet showing your calculations of the outcomes for the suggested stock price ranges for the call option buying strategy;
2. A worksheet showing your calculations of the outcomes for the suggested stock price ranges for the put option buying strategy.
|
Identifying and correcting internal control
: Suppose a car dealership is opening a Regional office in Texas. Linda barnes the office manager, is designing the internal control system. The manager purposes the following procedures for credit checks on new customers, sales on account, cash collec..
|
|
Business organizational forms subjects
: 1. Which of the following business organizational forms subjects the owner(s) to unlimited liability?
|
|
Prepare an amortization schedule
: Aspen Mining and Milling, Inc. contracted with Raoul Corporation to have constructed a custom-made lathe. The machine was completed and ready for use on January 1, 2014. Aspen paid for the lathe by issuing a $600,000, 3-year note that specified 2% in..
|
|
Make a decision on whether or not to go ahead
: Rondo, make a decision on whether or not to go ahead with a project. I'd like you to do a net present value (NPV) analysis on this special production project. The project will require an initial investment in a piece of manufacturing equipment. The p..
|
|
Calculate individual consultants pay based on the tasks
: Principles of database design, as demonstrated by the database design for project - Designing and creating the following basic (master) tables for the application and "Employee" table, to hold the details of employees
|
|
Timbers stock acquisition
: On January 1, 2014, The Timber Company acquired a 12% interest in the Twig Corporation through the purchase of 72,000 shares of Twigs common stock, paying $422,000. During 2014, Twig paid $28,000 in total dividends and reported net income of $95,675...
|
|
Amount of annual depreciation is revised
: True or False: When the amount of annual depreciation is revised because of a change in the estimated useful life of an asset, prior years' financial statements should be restated.
|
|
Tax costs of operating in low-versus high-tax countries
: Growco, a domestic corporation, is a tire manufacturer. Growco is planning to build a new production facility, and has narrowed down the possible sites for this new plant to either Happystan (a low-tax foreign country) or Sadstan (a high-tax foreign ..
|