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.
jeff jeffy answered 6 months agoRelated 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
Latest Questions
- Use the bond term's below to answer the question Maturity 7 years Coupon Rate 4% Face...
- What experience have you had with Organization Development or with Change Management? Describe the organization, the...
- 1. Renfro Rentals has issued bonds that have a 12% coupon rate, payable semiannually. The bonds...
- Given an array of positive integers a, your task is to calculate the sum of every...
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
ADVERTISEMENT