Reference no: EM131054658
Prepare the following problems in Excel and ensure the formulas are present in the appropriate cells:
The Cambell 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 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 it is expected to save the firm $380,000 per year in before tax operating cost, mainly labor, Cambell's marginal tax rate is 35%.
a) What is the Year 0 net cash flow?
b) What are the net operating 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%, should the machine be purchased?
|
Equipment that is classified as seven-year property
: A project requires $353,268 of equipment that is classified as 7-year property. What is the book value of this asset at the end of year 3 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.9..
|
|
The market return on similar bonds
: BioMax Inc. offers a 10 percent coupon bond that has a $1,000 par value, semiannual coupon payments and 20 years of its original 25 years left to maturity. Which of the following statements is true if the market return on similar bonds is 8.5%?
|
|
What if rates suddenly fall by two percent instead
: Bond J has a coupon rate of 4 percent and Bond K has a coupon rate of 10 percent. Both bonds have 13 years to maturity, make semiannual payments, and have a YTM of 7 percent. If interest rates suddenly rise by 2 percent, what is the percentage price ..
|
|
What are the net operating cash flows in years
: The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's R&D department. The equipment's basic price is $70,000 and it would cost another $15,000 to modify it for special use b..
|
|
The after tax salvage and the return of working capital
: The Cambell 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. What is the Year 0 net cash flow? What is the additional Year 3 cash fl..
|
|
How will you fully hedge your portfolio for one year horizon
: Suppose that: S&P 500 index is trading at 2000; index stocks do not pay any dividends; and you can borrow and lend at 5% per annum. An index futures contract with a multiplier of 100 matures in a year – this means one futures contract represents an i..
|
|
Characteristic of the self-attribution bias
: Which one of the following is a characteristic of the self-attribution bias?
|
|
Raised the maximum amount of short-term funds
: The Nelson Company has $1,035,000 in current assets and $450,000 in current liabilities. Its initial inventory level is $360,000, and it will raise funds as additional notes payable and use them to increase inventory. How much can Nelson's short-term..
|
|
Liquidate some equipment that iis being replaced
: Allen Air Lines must liquidate some equipment that iis being replaced. The equipment originally cost $12 million, of which 75% has been depreciated. The used equipment can be sold for $4 million, and tax rate is 40%. What is the equipment's after tax..
|