Question: please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS LAWNE Enterprises has a project which has the

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

LAWNE Enterprises has a project which has the following cash flows:

Year Cash Flow

0 -$200,000

1 50,000

2 100,000

3 150,000

4 40,000

5 25,000

The cost of capital is 10%. What is the project's discounted payback period?
  • A. 3.0973 years
  • B. 1.3620 years
  • C. 2.3333 years
  • D. 2.6380 years
  • E. 1.7624 years

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS The cash flows and Net salvage value of Project X are given the following...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS A tire manufacturing firm is considering Projects S and L, whose cash flows...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS Flint Fruits is considering two equally risky, mutually exclusive projects,...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS please help with excel step-by-step (detailed) much appreciated **IMPORTANT**...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS OWNIS Mills Corp. is considering producing two mutually exclusive machine...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS TEL Corp is considering a project that has the following cash flows: Year...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS AI intelligence, a new artificial intelligent for medical devices company, is...

Q:

JB Hunt Corp. has annual sales of $80,000,000; its average inventory is $20,000,000; and its average accounts receivable is $16,000,000. The firm buys all raw materials on terms of net 35 days with...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS JB Hunt Corp. has annual sales of $80,000,000; its average inventory is...

Q:

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS Fergusun Inc. has annual sales of $36,500,000, or $100,000/day on a 365-day...

Q:

The armature of a small generator consists of a flat, square coil with 120 turns and sides with a length of 1.60 cm. The coil rotates in a magnetic field of 0.0750 T. What is the angular speed of the...

Q:

Success Systems sells upscale modular desk units and office chairs in the ratio of 3:2 (desk unit: chair). The selling prices are $1,250 per desk unit and $500 per chair. The variable costs are $750...

Q:

In your opinion, what was the most important cause of Shells transformation? Do you believe the company was motivated more by external pressures or by internal pressures? Why do you think so?

Q:

Case Problem Analysis: Sources of Law 1 of 1 Attempts left: 0 AOL, LLC , mistakenly made public the personal information of six hundred fifty thousand of its members. The members filed a suit in...

Q:

1 To what extent do you think worker reactions to reward strategies relate to national and organisational culture? Sinoelectronics is a large manufacturer, with over 7,000 employees, producing...

Q:

1 Which aspects of the approach at John Lewis might be exported to companies with different business models? The John Lewis Partnership is a well- known retailer in the UK. Staff are partners in the...

Q:

=+Part 4 Start by creating a strictly transit-oriented campaign. Consider using: Taxi cabs: outside top of cabs; inside. Bus: sides; benches; shelters. Subways: interiors; exteriors; platforms....