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

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

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...

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

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...

Creative Software Corporation is considering a new project whose data are shown below. The required equipment...

Creative Software Corporation is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciated by MACRS over 3 years. Revenues and other operating costs are expected to be constant over the project’s 3-year life. What is the project’s IRR and NPV? Briefly discuss your results. Equipment cost $65,000 Sales Revenue each year $60,000 Operating Costs $25,000 Salvage Value $15,000 Tax Rate 35%

Creative Software Corporation is considering a new project whose data are shown below. The required equipment...

Creative Software Corporation is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciated by MACRS over 3 years. Revenues and other operating costs are expected to be constant over the project’s 3-year life. What is the project’s NPV? Briefly discuss your results. Equipment cost $65,000 Sales Revenue each year $60,000 Operating Costs $25,000 Salvage Value $15,000 Tax Rate 35%

Clemson Software is considering a new project whose data are shown below. The required equipment has...

Clemson Software is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciated by the straight-line method over 3 years. Revenues and other operating costs are expected to be constant over the project's 3-year life. What is the project's Year 1 cash flow? Do not round the intermediate calculations and round the final answer to the nearest whole number. Equipment cost (depreciable...

Creative Software Corporation is considering a new project whose data are shown below. The required equipment...

Creative Software Corporation is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciated by MACRS over 3 years. Revenues and other operating costs are expected to be constant over the project’s 3-year life. The WACC is 8%. What is the project’s NPV? Briefly discuss your results. Equipment cost $65,000 Sales Revenue each year $60,000 Operating Costs $25,000 Salvage Value $15,000 Tax...

Subjects