Reference no: EM131318882
Excel spreadsheets to analyze problem E1. On the spreadsheet please show all inputs and work clearly. E1) The Harris Company is evaluating the proposed acquisition of a spectrometer for the firm’s R&D department. The equipment’s base price is $140,000, and it would cost another $30,000 to modify it for special use by the firm. The spectrometer, which falls into the MACRS 3-year class, would be sold after 3 years for $60,000. Use of the equipment would require an increase in net working capital of $8,000. The spectrometer would have no effect on revenues, but it is expected to save the firm $50,000 per year in before-tax operating costs, mainly labor. The firm’s marginal federal-plus-state tax rate is 40%. (The MACRS percentages are specified in the formula sheet as well as at the end of the homework.)
a) What is the net cost of the spectrometer? (i.e., 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 (non-operating) cash flow in Year 3?
d) If the firm’s cost of capital is 12%, should the spectrometer be purchased?
|
Which will all be recovered at the end of the project
: Flemish Corp. is looking to invest in a new project that requires an initial investment of $100,000 in equipment. This equipment falls in the 3-year MACRS class for depreciation purposes. In addition to the initial investment, Flemish expects an init..
|
|
Describe elements of conflict resolution and peacemaking
: Locate an article concerning conflict resolution and peacemaking using the course readings, the University Library, and other resources. Prepare an 850-word paper in which you analyze your article. Describe elements of conflict resolution and peacem..
|
|
Medical expense insurance and disability income insurance
: Tax planning objectives should be subordinate to the primary objectives of estate planning because: What guidelines are available to the estate planner in determining whether an activity may constitute the unauthorized practice of law? Medical expens..
|
|
Paper - pros and cons of grade retention
: Choose one of the following topics and write a 1,050- to 1,400-word paper summarizing the current professional literature on the topics - Prematurity, medical interventions, and long-term outcomes, Pros and cons of grade retention and Language devel..
|
|
What is the net cost of the spectrometer
: Excel spreadsheets to analyze problem E1. On the spreadsheet please show all inputs and work clearly. E1) The Harris Company is evaluating the proposed acquisition of a spectrometer for the firm’s R&D department. What is the net cost of the spectrome..
|
|
Considering the replacement of riveting machine
: Tennessee River Shipyards is considering the replacement of an 8 year old riveting machine with a new one that will increase earnings before depreciation from $27,000 to $54,000 per year. The new machine will cost $82,500, and it will have an estimat..
|
|
What is the most she should have paid for the annuity
: Kay Mart has purchased an annuity to begin payment at the end of 2013 (the date of the first payment). Assume it is now the beginning of 2011. The annuity is for $27,000 per year and is designed to last ten years. If the discount rate for the calcula..
|
|
The law of one price states that equivalent investment
: The Law of One Price states that equivalent investment opportunities trading in different competitive markets will have the same price. Yet, one can find examples where that rule seems to be violated. It is a well-known fact that Americans pay a much..
|
|
What is the textbook expense variance
: School spent $100,000 on textbooks for the fall 2016 semester. It had expected to have a total enrollment of 450 students who would each have needed four books at a cost of $65 each. What is the textbook expense variance? IS it favorable or unfavorab..
|