Question

In: Finance

PLEASE SHOW CALCULATOR INPUTS Reynolds Metals is considering a project with a life of 4 years...

PLEASE SHOW CALCULATOR INPUTS

Reynolds Metals is considering a project with a life of 4 years that will produce annual operating cash flows of $57,000. During the life of the project, inventory will be lowered by $28,000, accounts receivable will increase by $15,000 and accounts payable will increase by $6,000. The project requires the purchase of equipment at an initial cost of $104,000 that will be depreciated straightline to a zero book value over the life of the project. Ignore bonus depreciation The equipment will be salvaged at the end of the project creating an aftertax cash inflow of $22,000. At the end of the project, net working capital will return to its normal level. What is the NPV of this project given a required return of 16%?

Solutions

Expert Solution

  1. Depreciation = cost/life
    • 104000/4 = 26000
  2. Change in Working capital investments = -28000+15000-6000 = -19000 that is it will be negative
  3. We can ignore the effect of taxes on the OCF as no tax rate is given
  4. NPV is calculated below:
    • Year CF Discount Factor Discounted CF
      0 $   -85,000.00 1/(1+0.16)^0= 1 1*-85000= $   -85,000.00
      1 $    57,000.00 1/(1+0.16)^1= 0.862068966 0.862068965517241*57000= $    49,137.93
      2 $    57,000.00 1/(1+0.16)^2= 0.743162901 0.743162901307967*57000= $    42,360.29
      3 $    57,000.00 1/(1+0.16)^3= 0.640657674 0.640657673541351*57000= $    36,517.49
      4 $    57,000.00 1/(1+0.16)^4= 0.552291098 0.552291097880475*57000= $    31,480.59
      4 $    22,000.00 1/(1+0.16)^4= 0.552291098 0.552291097880475*22000= $    12,150.40
      4 $   -19,000.00 1/(1+0.16)^4= 0.552291098 0.552291097880475*-19000= $   -10,493.53
      NPV = Sum of all Discounted CF $    76,153.17
    • Initial investment = 104000-19000 = -85000
    • OCF is not impacted by depreciation as there are no taxes
    • In the final year, the salvage value of the equipment is an inflow and the working capital investment which was and inflow earlier is now and outflow.
    • So the NPV = 76153.17 and as it is positive, we should invest in this project.

Related Solutions

PLEASE SHOW THE CALCULATOR INPUTS for the below work: Woods Company is considering the purchase of...
PLEASE SHOW THE CALCULATOR INPUTS for the below work: Woods Company is considering the purchase of some equipment. The initial investment will be $100,000. The estimated useful life of the equipment will be 5 years, at which point it will have a zero terminal salvage value. The annual savings in cash operating costs will equal $19,000, and the company has a minimum desired rate of return of 12%. Use straight-line depreciation and ignore income taxes. Compute: a. Net Present Value...
PLEASE SHOW CALCULATOR INPUTS A project has been assigned a discount rate of 12 percent. If...
PLEASE SHOW CALCULATOR INPUTS A project has been assigned a discount rate of 12 percent. If the project starts immediately, it will have an initial cost of $480 and cash inflows of $350 a year for three years. If the start is delayed one year, the initial cost will rise to $520 and the cash flows will increase to $385 a year for three years. What is the value of the option to wait?
The Down Towner is considering a project with a life of 4 years that will require...
The Down Towner is considering a project with a life of 4 years that will require $164,800 for fixed assets and $42,400 for net working capital. The fixed assets will be depreciated using the Year 2018 bonus depreciation method. At the end of the project, the fixed assets can be sold for $37,500 cash and the net working capital will return to its original level. The project is expected to generate annual sales of $195,000 and costs of $117,500. The...
draw a timeline, show the formula, and include your calculator inputs. Kevin is 35 years old,...
draw a timeline, show the formula, and include your calculator inputs. Kevin is 35 years old, and has decided to wait until his 36th birthday to start saving money for retirement. He plans to save $2,500 a year beginning at age 36 and continue until he is 65 years old (30 years). (Draw a timeline for this problem and treat as an ordinary annuity.) How much will Kevin have when he is 65 years old, assuming he will earn an...
Question 4 25 Marks Jimmy Reynolds is considering investing R12,000 in a project with the following...
Question 4 25 Marks Jimmy Reynolds is considering investing R12,000 in a project with the following cash revenues and expenses: Revenues Expenses Year 1 R20,000 R18,000 Year 2 R22,000 R19,000 Year 3 R22,000 R20,000 Year 4 R22,000 R17,000 Year 5 R25,000 R17,000 Jimmy requires a minimum rate of return of 8%. A. Calculate the net cash inflows in each of the 5 years. B. What is the payback period? C. What is the net present value of the investment?
You are considering an investment project. The project has a life of three years. Project Information:...
You are considering an investment project. The project has a life of three years. Project Information: Initial investment into a new machine, which would cost Rs.4,50,000. Machine is to be depreciated to zero over three years (straight line depreciation) with no salvage value at the end. Operating revenue is expected to be Rs. 6,00,000 per year. Operating costs for raw materials expected to be Rs.3,00,000 per year. Assume tax rate is 30% and the discount rate is 20%. a. Compute...
Brewsters is considering a project with a life of 5 years and an initial cost of...
Brewsters is considering a project with a life of 5 years and an initial cost of $120,000. The discount rate for the project is 12%. The firm expects to sell 2,100 units a year at a net cash flow per unit of $20. The firm will have the option to abandon this project after 3 years at which time it could sell the project for $50,000. The firm is interested in knowing how the project will perform if the sales...
Fool Proof Software is considering an expansion project having life for four years. The proposed project...
Fool Proof Software is considering an expansion project having life for four years. The proposed project has the following features: • Initial cost of the equipment is $200,000, with shipping cost $10,000 and installation cost of $30,000. • The equipment will depreciate over 4 years using MACRS at the following rates (33%, 45%, 15%, and 7%) respectively. • Inventories will increase by $25,000, and accounts payable will rise by $5,000 • The company will sell 100,000 units per year with...
Fool Proof Software is considering an expansion project having life for four years. The proposed project...
Fool Proof Software is considering an expansion project having life for four years. The proposed project has the following features: • Initial cost of the equipment is $200,000, with shipping cost $10,000 and installation cost of $30,000. • The equipment will depreciate over 4 years using MACRS at the following rates (33%, 45%, 15%, and 7%) respectively. • Inventories will increase by $25,000, and accounts payable will rise by $5,000 • The company will sell 100,000 units per year with...
You are also considering another project that has a physical life of 3 years; that is,...
You are also considering another project that has a physical life of 3 years; that is, the machinery will be totally worn out after 3 years. However, if the project were terminated prior to the end of 3 years, the machinery would have a positive salvage value. Here are the project’s estimated cash flows: (Please show work and Excel formulas for calculations) Year Initial Investment and Operating Cash Flows End-of-YearNet Salvage Value 0 -5,000 $5000 1 2100 3100 2 2,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT