post university fin 201 unit 4 case problem 4

Question # 00004349 Posted By: spqr Updated on: 12/02/2013 12:57 AM Due on: 12/28/2013
Subject Finance Topic Finance Tutorials:
Question
Dot Image

Bender Guitar Corporation, a manufacturer of custom electric guitars, is contemplating a $1,000,000 investment in a new production facility. The economic life of the facility is estimated to be five years, after which the facility will be obsolete and have no salvage value.

To make the new facility operational, building improvements costing $400,000 will be required. In addition, a $50,000 increase in working capital will be needed.

Bender's accounting and marketing departments have provided the following information: the firm will use the straight-line method of depreciation; the Company is in the 30% tax bracket; the weighted average cost of capital is 8%.

Here are Earnings before Interest and Taxes (EBIT) estimates for the new facility:

Year 1.........$80,000

Year 2.......$100,000

Year 3.......$120,000

Year 4........$140,000

Year 5.......$165,000

Your assignment is to answer the following questions:

  1. Diagram the cash flows for the project using a time line. For each of Years 1 through 5, include the following data on your diagram (in this order) : EBIT, tax, depreciation, Operating Cash Flow (OCF), and discounted OCF.
  2. Indicate the initial investment cost, the present value, the Net Present Value (NPV), and the payback (measured in years based on non-discounted OCF numbers).
  3. Evaluate the project's efficacy. Is this facility worthwhile, based upon your calculations ? Why or why not ? What does the NPV decision rule indicate for this project ? If you were Bender's financial manager, what other factors would you consider before deciding whether or not to recommend construction of the production facility?
Dot Image
Tutorials for this Question
  1. Tutorial # 00004145 Posted By: spqr Posted on: 12/02/2013 12:59 AM
    Puchased By: 4
    Tutorial Preview
    new facility operational, building improvements ...
    Attachments
    Case_Problem_4.xlsx (11.15 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    tr...irl Rating Gives best advice and strategies 08/27/2014
    jj...982 Rating Responsible services at good prices 05/06/2014

Great! We have found the solution of this question!

Whatsapp Lisa