Reference no: EM131054659
Prepare the following problems in Excel and ensure the formulas are present in the appropriate cells:
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 by your firm. The chromatograph, which falls into the MACRS year class, would be sold aftr 3 years for $30,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. Use of the equipment would require an increase in net working capital (spare parts inventory) of $4,000. The machine would have no effect on revenues, but it is expected to save the firm $25,000 per year in before tax operating cost, mainly labor. The firm's marginal federal plus state tax rate is 40%
a) What is the Year 0 net cash flow?
b) What are the net operating cash flows in Years 1,2,3?
c) What is the additional (nonoperatig) cash flow in Year 3?
d) If the project's cost of capital is 10%, should the chromatograph be purchased?
Fixed assets will be depreciated to zero book value
: A project has an initial requirement of $229,025 for new equipment and $9,004 for net working capital. The fixed assets will be depreciated to a zero book value over the 3-year life of the project and have an estimated salvage value of $82,095. All o..
|
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..
|