Question: In a situation such as Acrons, where a one-time cost is followed by a sequence of cash flows, the internal rate of return(IRR) is the

In a situation such as Acron’s, where a one-time cost is followed by a sequence of cash flows, the internal rate of return(IRR) is the discount rate that makes the NPV equal to 0. The idea is that if the discount rate is greater than the IRR, the company will not pursue the project, but if the discount rate is less than the IRR, the project is financially attractive.

a. Use Excel’s Goal Seek tool to find the IRR for the Acron model.

b. Excel also has an IRR function. Look it up in online help to see how it works, and then use it on Acron’s model. Of course, you should get the same IRR as in part a.

c. Verify that the NPV is negative when the discount rate is slightly greater than the IRR, and that it is positive when the discount rate is slightly less than the IRR.

Step by Step Solution

★★★★★

3.31 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Model Calculating NPV at Acron Inputs Devel... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b741233ad66_696396.pdf

180 KBs PDF File

1497_605896dd71e2c_696396.xlsx

300 KBs Excel File

1497_60b741233ad66_696396.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Henrietta Aguirre, CGA, is the newly hired director of corporate taxation for Mesa Incorporated, which is a publicly traded corporation. Aguirre's first job with Mesa was to review the company's...

The first-year training program for professional staff members of a large national accounting firm consists of classroom seminars and on-the-job training. The objectives of the training are to ensure...

The auditors for Weston University are conducting their audit for the fiscal year ended December 31, 2015. Specifically, the audit firm is now focusing on the audit of revenue from this season's home...

18. In a situation such as Acron's, where a one-time cost is followed by a sequence of cash flows, the internal rate of return (IRR) is the discount rate that makes the NPV equal to 0. The idea is...

In a situation such as Acrons, where a one-time cost is followed by a sequence of cash flows, the internal rate of return (IRR) is the discount rate that makes the NPV equal to

Net Present Value Net Present Value (NPV) is one of two discounting models that explicitly considers the time value of money and therefore, incorporates the concept of discounting cash inflows and...

[Answer with True (T) or False (F)] 1. For the dividend discount model (DDM) under supernormal growth (or non-constant growth model), the discount rate (r) during the initial supernormal growth...

ASSESSMENT INSTRUMENT BUS 330 Road King Trucks Introduction Michael Livingston has recently been hired as the CEO of Road King Trucks, Inc.Previously he had been the marketing manager for a large...

Background on Automaton, Inc. Automaton, Incorporated (Automaton) is a small, U.S. publicly-traded software company that manufactures quantum micro-processors used in the production of Artificial...

Hines Company has a production process that involves three processes. Units move through the processes in this order: cutting, stamping, and then polishing. The company had the following transactions...

Consider the probability for 5 heads out of 10 coin tosses using exact result (P ex ) and Gaussian distribution approximation (P G ). What is the relative error of the approximation ((P G -P ex )/P...

Y Co . , a public corporation, issues a 5 % stock dividend when the market price is $ 1 0 per share. An individual, Jesse, received 1 0 0 shares as a result of this dividend. What amount must Jesse...

5.4. A system has two components: A and B. The operating times until failure of the two components are independent and exponentially distributed random variables with parameters 2 for component A,...

What management, organization, and technology issues would have to be addressed if a company were thinking of equipping its workers with wearable computing devices?

What kinds of businesses are most likely to benefit from wearable computers? Select a business and describe how a wearable computing device could help that business improve operations or decision...

What business benefits do cloud computing services provide? What problems do they solve?

2 1 - Self Awareness is Understanding one's own emotions and how they affect others. A . True 1 3 . False 2 2 . Social Awareness is demonstrating empathy by recognizing others 'perspectives and...

I already understand how to do section a and b, but I do not know how to calculate the Par Yield for section C. Please show your work for this, and thank you for your help. The following table gives...

A stock with a beta of 0.7 is priced at exist118.50 and just paid a dividend of exist2.85. If the risk-free rate is 2% and the market risk premium is 7%, what growth rate does the market expect for...