Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please show in excel, and answer 1,2,and 3!!!!!!!!

PLEASE SHOW IN EXCEL, AND ANSWER 1,2,and 3!!!!!!!!!!!!!!!!!!!!! A project requires an initial investment of...

60.1K

Verified Solution

Question

Accounting

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%

  1. Calculate the projects net present value assuming the company has a required return of 10% and faces a marginal tax rate of 40%.
  2. 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.
  3. 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.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students