Question

In: Finance

Needs to be done in excel showing all the work The Campbell Company is considering adding...

Needs to be done in excel showing all the work

The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $920,000, and it would cost another $20,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $500,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $15,500. The sprayer would not change revenues, but it is expected to save the firm $304,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 25%.

a. What is the Year-0 cash flow?

b. What are the cash flows in Years 1, 2, and 3?

c. What is the additional Year-3 cash flow (i.e., the after-tax salvage and the return of working capital)?

d. If the project's cost of capital is 12%, what is the NPV?

Solutions

Expert Solution

All figures are rounded. If you want to round it to 2 decimals, let me know will do that. Earlier whenever i did this type of sum, all figures are asked to rounded.


Related Solutions

Please explain steps taken. Or screenshots of excel. Thank you The Campbell Company is considering adding...
Please explain steps taken. Or screenshots of excel. Thank you The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,200,000, and it would cost another $16,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $664,000. The machine would require an increase in net working capital (inventory) of...
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper...
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper company, which would require an initial investment of $300 million. Wansley estimates that the paper company would provide net cash flows of $40 million at the end of each of the next 20 years. The cost of capital for the paper company is 13%. a. Should Wansley purchase the paper company? b. Wansley realizes that the cash flows in Years 1 to 20 might...
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper...
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper company, which would require an initial investment of $300 million. Wansley estimates that the paper company would provide net cash flows of $40 million at the end of each of the next 20 years. The cost of capital for the paper company is 13%. a. Should Wansley purchase the paper company? b. Wansley realizes that the cash flows in Years 1 to 20 might...
The Campbell Company is considering adding a robotic paint sprayer to its production line.
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer’s base price is $1,080,000, and it would cost another $22,500 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $605,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $15,500. The sprayer would not change revenues, but...
The Campbell Company is considering adding a robotic paint sprayer to its production line.
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,050,000, and it would cost another $20,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $485,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $17,000. The sprayer would not change revenues, but...
The Campbell Company is considering adding a robotic paint sprayer to its production line.
FIN - 650 --- Problem 11-06 (New-Project Analysis)The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $830,000, and it would cost another $18,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $490,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $18,000....
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $940,000, and it would cost another $19,500 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $591,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $20,000. The sprayer would not change revenues, but...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,030,000, and it would cost another $25,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $490,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $18,000. The sprayer would not change revenues, but...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $850,000, and it would cost another $21,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $532,000. The machine would require an increase in net working capital (inventory) of $13,000. The sprayer would not change revenues, but it is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT