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

Q

Cite your results for the change in carbon dioxide concentration in Procedure II as a reference...

Biology
Q

You are on a hiring committee for an attending physician at a major hospital in the...

Psychology
Q

Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales...

Accounting
Q

Business law (1) Can a small-holding (minor) shareholder have an influence on how a company is managed?...

Accounting
Q

Which of the following events does NOT occur during a normal meiosis O Two haploid...

Biology
Q

ck here to watch the video Ive the system of equations by th 2x 3y...

Calculus
Q

If f x then x 0 t 4t 7 dt

Calculus
Q

Question 7 Please create a spreadsheet for the following question. You will need to save...

Accounting
Q

Statutes relating to a shareholder s right to inspect corporate records usually DO NOT include......

Accounting
Q

Skysong, Inc. incurs these expenditures in purchasing a truck: cash price $29,000, accident insurance (during...

Accounting
Q

You are offered $100,000 today or $400,000 in 10 years. Assuming that you can earn...

Finance
Q

What is the price (in \$) of a 10-year bond with a 7% annual coupon...

Finance