Question

In: Finance

Show all working and formulas used whether on excel or paper. Answer all parts The project...

Show all working and formulas used whether on excel or paper. Answer all parts

The project management team is evaluating proposals from their engineering staff. The staff has proposed two mutually exclusive project options (meaning only one project can be selected).

Option B – “Midsize Capacity”

Initial Investment

$60,000

Operating & Maintenance (Annual)

$ 7,000

Salvage Value

$ 8,000

Life-span

4 Years

Option C – “Large Capacity”

Initial Investment

$140,000

Operating & Maintenance (Annual)

$ 12,000

Salvage Value

$ 24,000

Life-span

6 Years

  
Each option represents a new direction for the company and as such the initial revenues from sales of product will have to be developed but once the product market is established we expect to be able to maintain sales revenues at the level of capacity that each option provides. Thus, the revenues will increase (ramp) during the first three years to a steady-state condition starting at the end of year three Revenues are expected to steady-state as long as production is continued.

The project management team uses a MARR rate of 6.00%.

The production revenues for each option are:

Production Revenue (Years 1 & 2) & Steady-State Production (Year 3+)

Year

Option B

Option C

0

-

-

1

$10,000 / yr

$10,000 / yr

2

$20,000 / yr

$25,000 / yr

3

$30,000 / yr

$50,000 / yr

Years (3+)

$30,000 / yr

$50,000 / yr


Questions:

  1. Draw Cash flow diagrams OR provide a clear table showing an appropriate planning horizon for comparing the options and the cash flows for each.
  2. Based on a LCM planning horizon the NPV for option B is  and the NPV for option C is
  3. The corresponding AW for Option B is  and the AW for Option C is .
  4. Based on the analysis which project would be recommended?

Solutions

Expert Solution

Answer:

NPV of option B = - $1733.72, AW of option B = - $500.34

NPV of option C = $3791.61, AW of option C = $771.07

NPV of B < NPV of C, hence option C (Large Capacity) should be selected.

Find full solution below.


Related Solutions

Show all working and formulas used whether with excel or on paper A distillation column is...
Show all working and formulas used whether with excel or on paper A distillation column is designed, purchased and installed for a cost of $1.2 million. The equipment has a depreciable life of ten (10) years with a final salvage value of $50,000 in year 10. For this equipment determine … a. The book value and depreciation allowance for each year using straight-line (SLN) depreciation. b. Book values and depreciation allowances for each year using double-declining (DDB) depreciation.
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
PLEASE ANSWER ALL PARTS AND LABEL THEM WITH FORMULAS International Paper (IP), a Memphis based paper...
PLEASE ANSWER ALL PARTS AND LABEL THEM WITH FORMULAS International Paper (IP), a Memphis based paper conglomerant, is considering expanding its production capacity by purchasing a new machine, the TJ-50. The cost of the TJ-750 is $2.75 million. Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $50,000 feasibility study to analyze the decision to buy the TJ-50, resulting in the following estimates: ■ Marketing: Once the TJ-50 is operating...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just​ completed, Grips earned $4.25 per share and paid cash dividends of ​$2.55 per share ​(D0=$2.55). Grips' earnings and dividends are expected to grow at 25​% per year for the next 3​ years, after which they are...
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
Show all work in Excel With formulas used in cells Question Set 2. A manufacturing operation...
Show all work in Excel With formulas used in cells Question Set 2. A manufacturing operation must periodically purchase bulk quantities of washers. The washers are purchased in boxes of 1000 and are consumed at a constant rate. The operation expects to purchase 20,000 boxes over the coming year. Each box costs $120, the annual holding cost per box is $15, and the cost of placing an order is $120 (regardless of the quantity ordered). For the following questions, use...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT