Question
PLEASE SHOW IN EXCEL, AND ANSWER 1,2,and 3!!!!!!!!!!!!!!!!!!!!! A project requires an initial investment of $100,000 to purchase equipment. The equipment will be depreciated on
PLEASE SHOW IN EXCEL, AND ANSWER 1,2,and 3!!!!!!!!!!!!!!!!!!!!!
A project requires an initial investment of $100,000 to purchase equipment. The equipment will be depreciated on a straight-line basis over the five-year life of the project. The company expects the project to generate $50,000 of additional revenue per year and $15,000 of additional expenses per year. Management is also concerned about potential product liability losses. The companys risk manager developed the following annual loss distribution:
Loss Amount Probability
$0 70%
$5,000 20%
$10,000 8%
$50,000 2%
- Calculate the projects net present value assuming the company has a required return of 10% and faces a marginal tax rate of 40%.
- Should the company invest the $100,000 to buy the equipment? As part of your answer, explain the risk involved when using expected loss amounts in capital budgeting and how the cost of worry could be used to modify the calculation of net present value in part a.
- Calculate the breakeven cost of worry, that is, above this amount the project will not be accepted, and below this amount the project will be accepted.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started