Homework Answers
IRR is that rate of return at which the NPV is zero. This can be solved using excel Solver or using the IRR() function or by trial and error.
| Year (n) | Cash flow | PW of CF |
| 0 | -4,50,000 | -4,50,000.00 |
| 1 | -42,500 | -35,008.87 |
| 2 | 92,800 | 62,968.94 |
| 3 | 3,86,000 | 2,15,752.04 |
| 4 | 6,14,600 | 2,82,975.85 |
| 5 | -2,02,200 | -76,687.96 |
| IRR | 21.40% | - |
IRR for the given series of cash flows = 21.40%
NPW vs IRR graph:
| IRR | PW |
| 10% | 1,72,295.14 |
| 20% | 17,540.51 |
| 30% | -91,356.73 |
| 40% | -1,69,950.17 |
| 50% | -2,27,943.21 |
| 60% | -2,71,577.00 |
| 70% | -3,04,976.79 |
| 80% | -3,30,936.72 |
| 90% | -3,51,391.22 |
| 100% | -3,67,706.25 |
The IRR is much higher than the MARR of 10% so this project should be undertaken.
Add Answer to:
Problem I: A new product line is proposed for investment. The summary of the projected and annual...
Problem 10-3 Calculating Projected Net Income [LO1] A proposed new investment has projected sales of $550,000....
Problem 10-3 Calculating Projected Net Income [LO1] A proposed new investment has projected sales of $550,000. Variable costs are 40 percent of sales, and fixed costs are $130,500; depreciation is $50,750. Prepare a pro forma income statement assuming a tax rate of 23 percent. What is the projected net income? (Input all amounts as positive values. Do not round intermediate calculations.)
9. (10 marks) A firm is considering the purchase of a new machine to increase the...
9. (10 marks) A firm is considering the purchase of a new machine to increase the productivity of existing production process. All the alternatives have a life of 10 years and they have negligible market value after 10 years. Use the IRR method (incrementally) to make your recommendation. The firm's MARR is 10% per year. Alternative Capital Investment Annual Operating Cost $100,000 $20,000 $110,000 $18,500 $125,000 $17,000 $130,000 $15,500 $150,000 $10,000 k=0 Internal Rate of Return (IRR) method Formally, (using...
A company is considering constructing a plant to manufacture a proposed new product. The land costs...
A company is considering constructing a plant to manufacture a proposed new product. The land costs $350,000, the building costs $600,000, the equipment costs $250,000, and $150,000 additional working capital is required. It is expected that the product will result in sales of $900,000 per year for 10 years, at which time the land can be sold for $450,000, the building for $400,000, and the equipment for $50,000. All of the working capital would be recovered at the EOY 10....
Case Study Description A $6M investment is considered by an electric bike manufacturing company to add a new productio...
Case Study Description A $6M investment is considered by an electric bike manufacturing company to add a new production line for its new product, electric skateboards. The company has commissioned an exploratory study of where to place the new production line and which type of equipment to use. There are three types of machines to choose from for the company to install on the new assembly line. The machines have zero salvage value at the end of 10-year planning horizon....
Turner Hardware is adding a new product line that will require an investment of $1,418,000. Managers estimate that this...
Turner Hardware is adding a new product line that will require an investment of $1,418,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $335,000 the first year, $295,000 the second year, and $260,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Full years + C Amount to complete...
Sikes Hardware is adding a new product line that will require an investment of $1,460,000. Managers...
Sikes Hardware is adding a new product line that will require an investment of $1,460,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $330,000 the first year, $280,000 the second year,, and $225,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Amount to complete recovery in next year...
Sikes Hardware is adding a new product line that will require an investment of $1.520,000. Managers...
Sikes Hardware is adding a new product line that will require an investment of $1.520,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $320,000 the first year, $270,000 and $255,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. Round your answer to two decimal places Full years . Amount to complete recovery in next year...
How Do I solve Gibson Hardware is adding a new product line that will require an...
How Do I solve
Gibson Hardware is adding a new product line that will require an investment of $1,520,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $305,000 the first year, $290,000 the second year, and $235,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Full years +1...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20 million. Furthermore, the net working capital requirements of the project requires are equal to 20% of the projected annual sales at the beginning of each year. The base scenario concerning the project assumes also the following Product selling price first year 45,000 per unit Variable costs first year 35,000 per unit Fixed costs first year 2 million After first year, price, variable and fixed...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20 million. Furthermore, the net working capital requirements of the project requires are equal to 20% of the projected annual sales at the beginning of each year. The base scenario concerning the project assumes also the following Product selling price first year 45,000 per unit Variable costs first year 35,000 per unit Fixed costs first year 2 million After first year, price, variable and fixed...
9. (10 marks) A firm is considering the purchase of a new machine to increase the productivity of existing production process. All the alternatives have a life of 10 years and they have negligible market value after 10 years. Use the IRR method (incrementally) to make your recommendation. The firm's MARR is 10% per year. Alternative Capital Investment Annual Operating Cost $100,000 $20,000 $110,000 $18,500 $125,000 $17,000 $130,000 $15,500 $150,000 $10,000 k=0 Internal Rate of Return (IRR) method Formally, (using...
A company is considering constructing a plant to manufacture a proposed new product. The land costs $350,000, the building costs $600,000, the equipment costs $250,000, and $150,000 additional working capital is required. It is expected that the product will result in sales of $900,000 per year for 10 years, at which time the land can be sold for $450,000, the building for $400,000, and the equipment for $50,000. All of the working capital would be recovered at the EOY 10....
Turner Hardware is adding a new product line that will require an investment of $1,418,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $335,000 the first year, $295,000 the second year, and $260,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Full years + C Amount to complete...
Sikes Hardware is adding a new product line that will require an investment of $1,460,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $330,000 the first year, $280,000 the second year,, and $225,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Amount to complete recovery in next year...
Sikes Hardware is adding a new product line that will require an investment of $1.520,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $320,000 the first year, $270,000 and $255,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. Round your answer to two decimal places Full years . Amount to complete recovery in next year...
How Do I solve
Gibson Hardware is adding a new product line that will require an investment of $1,520,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $305,000 the first year, $290,000 the second year, and $235,000 each year thereafter for eight years. The investment has no residual value. Compute the payback period. First enter the formula, then calculate the payback period. (Round your answer to two decimal places.) Full years +1...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20 million. Furthermore, the net working capital requirements of the project requires are equal to 20% of the projected annual sales at the beginning of each year. The base scenario concerning the project assumes also the following Product selling price first year 45,000 per unit Variable costs first year 35,000 per unit Fixed costs first year 2 million After first year, price, variable and fixed...
Ross corporation examines the introduction of a new product. The initial investment is estimated at 20 million. Furthermore, the net working capital requirements of the project requires are equal to 20% of the projected annual sales at the beginning of each year. The base scenario concerning the project assumes also the following Product selling price first year 45,000 per unit Variable costs first year 35,000 per unit Fixed costs first year 2 million After first year, price, variable and fixed...
Most questions answered within 3 hours.
-
The random variable X is exponentially distributed, where X
represents the time it takes for a...
asked 10 seconds from now -
MATLAB
write a MATLAB function (1) output a third-order polynomial
function with the coefficients as the...
asked 7 minutes ago -
A z-score
communicates a raw score’s "relative standing"
under the normal curve in relation to:
asked 15 minutes ago -
An object is vibrating on a spring with the following equation
of motion:
?=(30 ??)cos((2?)/(160)?)
a)...
asked 15 minutes ago -
Vulcan Flyovers offers scenic overflights of Mount St. Helens,
the volcano in Washington State that explosively...
asked 17 minutes ago -
If organizations do not adapt fast enough and move incrementally
from the twentieth-century model to the...
asked 18 minutes ago -
A helium balloon with 2.5L of gas has a gauge pressure of 10,000
Pa. The balloon...
asked 22 minutes ago -
What is responsible for Jupiter's enormous magnetic field?
asked 38 minutes ago -
At the end of the year, a company offered to buy 5,000 units of
a product...
asked 39 minutes ago -
Implement C++ program for each of the following.
Let D = [-48, -14, -8, 0, 1,...
asked 59 minutes ago -
Consider a labor market in which LD = 400 – 4W and LS = 250 +...
asked 1 hour ago -
Let’s say you are teaching a typically-developing young child
how to eat with a spoon. Describe...
asked 57 minutes ago