Done in Excel

ASSIGNMENT 4

MGF 301

Corporation Finance

Spring 2016

You may work in a group of up to 4 on this Assignment. Please indicate clearly on all submitted Assignments who the members of the group are. Please note, all assignments submitted with more than 4 group members will automatically receive a 0 grade.

No late assignments will be accepted. You may hand in the assignment in person in Jacobs 365 (put it under the door if no one is there) or submit it by email to the link in UBLearns before the time it is due. All electronic submissions must be to the link in UBLearns (Note: please follow all the Digital Submission rules (see Syllabus).

________________________________________________________________________________________________________

Answer all of the following questions. For each answer, show your work to get full points (stating the answer alone is not sufficient).

1. Suppose Palmer Properties is considering investing $3.6 million today (i.e., C₀ = -3,600,000) on a new project that is expected to last for 9 years. The project is expected to generate annual cash flows of C₁ = -200,000; C₂ = 400,000, C₃ = 600,000 and then $900,000 for period C₄ through C_9. If the discount rate is 8% and managements payback period cutoff is 7 years:

(a) What is the payback period for the project? Show your work

(b) What is the net present value of the project ? Show your work

(c) What is the internal rate of return on the project ? Show your work

(d) Under which method(s) above should the company accept the project (applying the acceptance rules)? Explain

2. The company is choosing between machine A and B (they are mutually exclusive and the company can only pick one). The initial cost of machine A is $1,400,000 and it will last for 7 years before it needs to be replaced. The cost of operating machine A each year is $150,000. The initial cost of Machine B is $800,000 and it will last for 5 years before it needs to be replaced. The cost of operating machine B is $230,000 in cash flow per year. If the required rate of return is 10%,

(a) Calculate the 7 year and 5 year annuity factors at 10% annual interest.

(b) Using the annuity factors, find the PV of Machine A and Machine B including all costs (initial + operating).

(c) Which machine is a better choice for the company after considering the different lives of the projects? (Note: be sure to use the equivalent annual annuity method)

3. BMT has developed a new product. It can go into production for an initial investment of $4,400,000. The equipment will be depreciated using straight-line depreciation over 4 years to a value of zero. The firm believes that net working capital at each date will equal 25 percent of next years forecast sales. The firm estimates that variable costs are equal to 40% of sales and fixed costs are $600,000 per year. Sales forecasts in dollars are below. The project will come to an end after 4 years, when the product becomes obsolete. The firms tax rate is 35 percent, and the discount rate is 9 percent. Calculate the NPV.

Year 0 1 2 3 4

Sales forecast (in $): 0 3,200,000 3,600,000 4,000,000 4,400,000

4. In problem 3, perform scenario analysis by assuming the following changes take place at the same time. Find the revised NPV.

(a) sales are 10% lower each year than predicted above

(b) the discount rate is 8 percent

(c) variable costs are 45% of sales

ASSIGNMENT 4 MGF 301 Corporation Finance Spring 2016 DUE: Thursday, April 21st at 7:00pm in Jacobs 365 You may work in a group of up to 4 on this Assignment. Please indicate clearly on all submitted Assignments who the members of the group are. Please note, all assignments submitted with more than 4 group members will automatically receive a 0 grade. No late assignments will be accepted. You may hand in the assignment in person in Jacobs 365 (put it under the door if no one is there) or submit it by email to the link in UBLearns before the time it is due. All electronic submissions must be to the link in UBLearns (Note: please follow all the Digital Submission rules (see Syllabus). ________________________________________________________________________________________________________ Answer all of the following questions. For each answer, show your work to get full points (stating the answer alone is not sufficient). 1. Suppose Palmer Properties is considering investing $3.6 million today (i.e., C0 = -3,600,000) on a new project that is expected to last for 9 years. The project is expected to generate annual cash flows of C1 = -200,000; C2 = 400,000, C3 = 600,000 and then $900,000 for period C4 through C9. If the discount rate is 8% and management's payback period cutoff is 7 years: (a) What is the payback period for the project? Show your work (b) What is the net present value of the project ? Show your work (c) What is the internal rate of return on the project ? Show your work (d) Under which method(s) above should the company accept the project (applying the acceptance rules)? Explain 2. The company is choosing between machine A and B (they are mutually exclusive and the company can only pick one). The initial cost of machine A is $1,400,000 and it will last for 7 years before it needs to be replaced. The cost of operating machine A each year is $150,000. The initial cost of Machine B is $800,000 and it will last for 5 years before it needs to be replaced. The cost of operating machine B is $230,000 in cash flow per year. If the required rate of return is 10%, (a) Calculate the 7 year and 5 year annuity factors at 10% annual interest. (b) Using the annuity factors, find the PV of Machine A and Machine B including all costs (initial + operating). (c) Which machine is a better choice for the company after considering the different lives of the projects? (Note: be sure to use the equivalent annual annuity method) 3. BMT has developed a new product. It can go into production for an initial investment of $4,400,000. The equipment will be depreciated using straight-line depreciation over 4 years to a value of zero. The firm believes that net working capital at each date will equal 25 percent of next year's forecast sales. The firm estimates that variable costs are equal to 40% of sales and fixed costs are $600,000 per year. Sales forecasts in dollars are below. The project will come to an end after 4 years, when the product becomes obsolete. The firm's tax rate is 35 percent, and the discount rate is 9 percent. Calculate the NPV. Year 0 Sales forecast (in $): 0 1 3,200,000 2 3,600,000 3 4,000,000 4 4,400,000 4. In problem 3, perform scenario analysis by assuming the following changes take place at the same time. Find the revised NPV. (a) sales are 10% lower each year than predicted above (b) the discount rate is 8 percent (c) variable costs are 45% of sales