a Complete the spreadsheet below by estimating the project 's annual after tax cash flow b What is the investment 's net present value at a discount rate of 10 percent c What is the investment 's internal rate of return d How does the internal rate of return change if the discount rate equals 20 percent e How does the internal rate of return change if the growth rate in EBIT is 8 percent instead of 3 percent Facts and Assumptions Depreciable life yrs Expected life yrs Salvage value $ 10 SO EBIT in year 1 28,000 Growth rate in Discount rate 3 EBIT 10 3 5 Year 6 10 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Annual depreciation 28,000 28,840 29,705 30,596 31,514 32,460 33,433 34,436 35,470 36,534 EBIT

Question: a. Complete the spreadsheet below by estimating the project's annual after tax cash flow. b. What is the investment's net present value at a discount

a. Complete the spreadsheet below by estimating the project's annual after tax cash flow.
b. What is the investment's at a discount rate of 10 percent?
c. What is the investment's How does the change if the discount rate equals 20 percent?
e. How does the change if the growth rate in EBIT is 8 percent instead of 3 percent?

Facts and Assumptions Depreciable life yrs. Expected life yrs. Salvage value $ 10 SO EBIT in year 1 28,000 Growth rate in Discount rate 3% EBIT 10% 3 5 Year 6 10 50,000 50,000| 50,000 50,000 50,000 50,000 50,000 Annual depreciation 28,000 28,840 29,705 30,596 31,514 32,460 | 33,433 34,436 35,470 36,534 EBIT

Step by Step Solution

★★★★★

3.39 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The following table shows the calculations for Annual AfterTax Cash Flow NPV and IRR Year 0 1 2 3 4 5 6 7 8 9 10 Initial cost 350000 Annual deprecia... 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 (1 attachment)

1019-B-C-A-S-S(1295).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

Read the information regarding a possible new investment available from McGraw-Hills Connect or your course instructor. a. Complete the spreadsheet to estimate the projects annual after tax cash...

A particular investment proposal has a positive net present value of $20 when a discount rate of 8 percent is used. The same proposal has a negative net present value of $2,000 when a discount rate...

The following table presents the initial cash outlay and cash flow projections for a new line of digital cameras that DigiCam, Inc., is evaluating. Initial cash outlay ....... $2,350,000 Net pretax...

Chapter 7 Problem 12 a). Complete the spreadsheet below by estimating the project's annual after tax cash flow. b). What is the investment's net present value at a discount rate of 10 percent? c)....

EXTENDING YOUR KNOWLEDGE EYK12-1. Business Decision Case New Haven Corporation recently identified an investment oppon involving the purchase of a patent that will permit the company to modify its...

Question 3 Net present value method The following data are accumulated by Geddes Company in evaluating the purchase of $130,000 of equipment, having a four-year useful life: Net Income Net Cash Flow...

Question 1 Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present...

PLEASE HELP....THIS PROJECT IS DUE THE 26th AND I DONT KNOW WHAT OR HOW TO DO IT AND I REALLY WANT A GOOD GRADE!! Adams Industrial is a leading manufacturing corporation. The company produces a wide...

Adams Industrial is a leading manufacturing corporation. The company produces a wide range of products ranging from pipes to aircraft engines. The company is considering a new project to produce a...

pls also explain how the answer . a). Complete the spreadsheet below by estimating the project's annual after tax cash flow. b). What is the investment's net present value at a discount rate of 10...

Three groups that participate in the process of establishing GAAP are users, preparers, and auditors. These groups are represented by various organizations. For each organization listed below,...

Determine the number of roots of f(z) = z7 11z3 + 12 inside D(0, 2), the disc of center the origin and radius 2.

compound interest To rasie the rest amount of money, your company borrows $ 1 2 0 , 0 0 0 from the bank with an monthly interest of 5 . 5 % for a year. For the interest, compound interest is applied....

2. How would you describe the procurement strategy of the Canadian government?

Calculate the following: (a) The bubble-point temperature of an Equimolar mixture of liquid n-hexane and n-heptanes at 1.0 atm and the composition (mole fractions) of the vapor in equilibrium with...

A liquid mixture contains N components (N may be any number from 2 to 10) at pressure P(mm Hg). The mole fraction of the ith component is x i (i = 1. 2...., N), and the vapor pressure of that...

A vapor mixture of n-butane (B) and n-hexane (H) contains 50.0 mole% butane at 120C and 1.0 atm, A stream of this mixture flowing at a rate of 150.0 L/s is cooled and compressed, causing some but not...

A.) Are dividends relevant in determining share values? Identify one factor that indicates they are, and one that indicates they are not. Give your opinion on this question and why you hold it. B.)...

Rory works as a financial adviser in a practice with three other advisers. They each own 25% of the business, and while they each look after their own clients, they do share back office, paraplanning...

If a company has both an inflow and outflow of cash related to property, plant, and equipment, the