Exercise 2: A new IS project has been proposed that is expected to produce not only...

Exercise 2: A new IS project has been proposed that is expected to produce not only cost savings but also an increase in revenue. The initial capital cost to establish the system is estimated to be $500,000. The remaining cash flow data is presented in Table 2.10. Using a spreadsheet program, calculate the payback period, internal rate of return, and net present value for this project. Assume that the cost of capital is 7% and the effective tax rate is 40% How would the payback, internal rate of return, and net present value change if the capital cost for the project was $750,000 and the cost saving and increased revenue were decreased by 25% each year. Table:(1 2 3 4 5 6) = years Capital 500,000 Incresed Revenue $50 $75 $100 $115 $130 Cost Savings 110 125 125 125 125 Depreciation expense 150 125 100 75 50 Operating and maintenance epanse 75 50 50 50 50 all amounts are in hundreds and thousands Years are 2-6 values. Year 1 is starting with 500,000.

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A firm has a proposed 5-year project. If accepted today (t=0), the project is expected to...

A firm has a proposed 5-year project. If accepted today (t=0), the project is expected to generate positive net cash flows for each of the following five years(t=1 through t=5). A new machine will be put in service, and to implement this project, an old machine will be sold. Note the following items. The new machine costs $1,000,000. Shipping and installation will cost an additional $500,000. Thus the Installed Cost is $1,500,000.This new machine will be sold five years from...

The following information is for a proposed project that will provide the capability to produce a...

The following information is for a proposed project that will provide the capability to produce a specialized product estimated to have a short market (sales) life before new technology, known to be in the R&D stage, makes it obsolete: • Capital investment of $1,000,000, composed of $420,000 of depreciable equipment and $580,000 of non-depreciable capital (land, working capital, etc.) • Assume that the depreciable property is in the MACRS (GDS) three-year property class. • The study period is 3 years...

Suppose a company has proposed a new 4-year project. The project has an initial outlay of...

Suppose a company has proposed a new 4-year project. The project has an initial outlay of $25,000 and has expected cash flows of $7,000 in year 1, $9,000 in year 2, $12,000 in year 3, and $13,000 in year 4. The required rate of return is 11% for projects at this company. What is the net present value for this project? (Answer to the nearest dollar.)

Suppose a company has proposed a new 4-year project. The project has an initial outlay of...

Suppose a company has proposed a new 4-year project. The project has an initial outlay of $17,000 and has expected cash flows of $8,000 in year 1, $9,000 in year 2, $10,000 in year 3, and $14,000 in year 4. The required rate of return is 15% for projects at this company. What is the profitability index for this project? (Answer to the nearest hundredth, e.g. 1.23)

Suppose a company has proposed a new 4-year project. The project has an initial outlay of...

Suppose a company has proposed a new 4-year project. The project has an initial outlay of $29,000 and has expected cash flows of $7,000 in year 1, $8,000 in year 2, $11,000 in year 3, and $13,000 in year 4. The required rate of return is 14% for projects at this company. What is the profitability index for this project? (Answer to the nearest hundredth, e.g. 1.23)

a. Project X has an up-front cost of $20 million. The project is expected to produce...

a. Project X has an up-front cost of $20 million. The project is expected to produce after-tax cash flows of $7.5 million at the end of each of the next 3 years (t = 1, 2, and 3). The project has a WACC=10%. What is the project’s NPV? b. However, if the company waits a year they will find out more about the project’s expected cash flows. If they wait a year, there is a 50% chance the market will...

A project has an initial cost of $148,400 and is expected to produce cash inflows of...

A project has an initial cost of $148,400 and is expected to produce cash inflows of $56,500, $69,540, and $97,867 over the next three years, respectively. What is the discounted payback period if the required rate of return is 10 percent? A. 2.12 years B. 2.54 years C. 2.91 years D. 1.88 years

10. Suppose a company has proposed a new 4-year project. The project has an initial outlay...

10. Suppose a company has proposed a new 4-year project. The project has an initial outlay of $60,000 and has expected cash flows of $18,000 in year 1, $23,000 in year 2, $26,000 in year 3, and $34,000 in year 4. The required rate of return is 14% for projects at this company. What is the Payback for this project? (Answer to the nearest tenth of a year, e.g. 1.2) 11. Suppose a company has proposed a new 4-year project....

An individual has a nice project of a new product, but needs money for that. She can only produce if she raises the amount

An individual has a nice project of a new product, but needs money for that.She can only produce if she raises the amount of money required (noted "K")She has the possibility of raising K if she participates on a given program (let's say, a government program).The probability of raising K through this money is p.However, to participate on this program, she needs to incur some costs c < K.The problem is that there is a probability (1 - p) that...

8. Project R has a cost of $ 10,000 and in expected to produce cash flows...

8. Project R has a cost of $ 10,000 and in expected to produce cash flows per year of $ 4,000 for 3 years. Project S has a cost of $20,000 and in expected to produce cash flows of $ 7,000 per year for 4 years. Calculate the 2 projects' NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 11%. Which project should be selected ?

Subjects