Question

In: Finance

Safeco Insurance is considering a software equipement at a cost of $4,133,250. They expect this equipment...

Safeco Insurance is considering a software equipement at a cost of $4,133,250. They expect this equipment to produce cash flows of $822,432 , $463,965, $937,250, $1,017,112, $1,212,960, and $1,300,000 over the next six years. If the appropriate discount rate is 12 percent, what is the NPV of this investment? Would they go ahead with the project? If each cashflow is reduced by 20%, what is the new NPV at 12%? If each cashflow is increased by 20% , what is the new NPV at 12%? Share the results in a table, with the best case scenario, normal scenario and worst case scenario. Comment on these scenarios.

Solutions

Expert Solution

If the appropriate discount rate is 12 percent, what is the NPV of this investment?
=-4133250+822432/1.12+463965/1.12^2+937250/1.12^3+1017112/1.12^4+1212960/1.12^5+1300000/1.12^6=-368670.0194

Would they go ahead with the project?
No

If each cashflow is reduced by 20%, what is the new NPV at 12%?
=-4133250+(822432/1.12+463965/1.12^2+937250/1.12^3+1017112/1.12^4+1212960/1.12^5+1300000/1.12^6)*0.8=-1121586.016

If each cashflow is increased by 20% , what is the new NPV at 12%?
=-4133250+(822432/1.12+463965/1.12^2+937250/1.12^3+1017112/1.12^4+1212960/1.12^5+1300000/1.12^6)*1.2=384245.9767

Share the results in a table, with the best case scenario, normal scenario and worst case scenario.

The project is only acceptable in best case scenario.

NPV
Best Case 384246
Base Case -368670
Worst Case -1121586

Related Solutions

Lease Equipment Cost and INSURANCE ON PLANT BUILDING of a Manufacturing Company is a Manufacturing Cost...
Lease Equipment Cost and INSURANCE ON PLANT BUILDING of a Manufacturing Company is a Manufacturing Cost or a Non Manufacturing Cost (Period Cost) ? Explain With Example
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of $500,000, replacing equipment with a scrap value of $50,000. This will reduce defect costs by $150,000 a year. At the end of 7 years, the equipment will be replaced and will have a scrap value of $100,000. The interest charges for financing the purchase will be $25,000 a year. The new system will be housed in a building that is currently unused, with an...
ool Proof Software is considering a new project whose data are shown below. The equipment that...
ool Proof Software is considering a new project whose data are shown below. The equipment that will be used has a 3-year class life and will be depreciated by the MACRS depreciation system. Revenues and Cash operating costs are expected to be constant over the project's 10-year life. What is the Year 1 after-tax net operating cash flow? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your...
Software Inc. is considering the purchase of new computer equipment totaling $150,000 with an estimated salvage...
Software Inc. is considering the purchase of new computer equipment totaling $150,000 with an estimated salvage value of $25,000 after three years. Maintenance, repairs, supplies, and other operating costs are estimated to be $13,000 per year. Determine the following: The annual cost based on the depreciation. The annual cost using a desired ROI of 15%. If the funds to purchase the equipment are borrowed at a rate of 8% for three years, what is the effect on the annual costs?...
Nona Sports is considering the purchase of new production equipment. The equipment will cost $135,000. It...
Nona Sports is considering the purchase of new production equipment. The equipment will cost $135,000. It has an expected useful of life of 5 years, but will require refurbishing at the end of 3 years. The refurbishment will cost $5,000. The estimated salvage value at the end of the useful life is $10,000. The increased annual net income from the equipment is projected to be $40,000. Using a hurdle rate of 12%, calculate the NPV for the equipment. *If you...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment would result in an annual increase in net income of $200000. the equipment will have an initial cost of $1200000 and have an 8 year life. the salvage value of the equipment is estimated to be $200000. the hurdle rate is 10%. what is accounting rate of return? b) what is the payback period? c) what is the net present value? d) what would...
Elemental is considering another project which requires new equipment at a cost of $70,000. The equipment...
Elemental is considering another project which requires new equipment at a cost of $70,000. The equipment has a 3 year tax life and will be fully depreciated by the straight-line method over 3 years. When the project closes down at the end of the third year, it is expected to sell for $5000 before taxes. The project will require new working capital of $10000, and is expected to be fully recovered at the end of the project's life. Project revenues...
Perez Electronics is considering investing in manufacturing equipment expected to cost $310,000. The equipment has an...
Perez Electronics is considering investing in manufacturing equipment expected to cost $310,000. The equipment has an estimated useful life of four years and a salvage value of $ 18,000. It is expected to produce incremental cash revenues of $155,000 per year. Perez has an effective income tax rate of 40 percent and a desired rate of return of 10 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)     Required Determine the net present...
Bi-Coastal Railroad Inc. is considering acquiring equipment at a cost of $384,000. The equipment has an...
Bi-Coastal Railroad Inc. is considering acquiring equipment at a cost of $384,000. The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $48,000. The company’s minimum desired rate of return for net present value analysis is 10%. Present Value of an Annuity of $1 at Compound InterestYear6%10%12%15%20%10.9430.9090.8930.8700.83321.8331.7361.6901.6261.52832.6732.4872.4022.2832.10643.4653.1703.0372.8552.58954.2123.7913.6053.3532.99164.9174.3554.1113.7853.32675.5824.8684.5644.1603.60586.2105.3354.9684.4873.83796.8025.7595.3284.7724.031107.3606.1455.6505.0194.192 Compute the following: a. The average rate of return, assuming the annual earnings are equal to the net cash flows...
Spanish Peaks Railroad Inc. is considering acquiring equipment at a cost of $480,000. The equipment has...
Spanish Peaks Railroad Inc. is considering acquiring equipment at a cost of $480,000. The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $60,000. The company's minimum desired rate of return for net present value analysis is 10%. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT