Reference no: EM133057249
Penn Printing is considering opening a new production facility near Erie, PA. In deciding whether to proceed with the project, the company has gathered the following information:
-The estimated up-front cost of constructing the facility at t = 0 is $10 million. For tax and accounting purposes, these costs will be depreciated using a MACRS five (5) year schedule.
-The company will operate the facility for 4 years. It estimates today that the facility can be sold at the end of the project's life for $2.2 million.
-If the facility is opened, Penn will have to increase its inventory by $3.0 million at t = 0. In addition, its accounts payable will increase by $1.6 million at t = 0.
-The new facility will increase the company's yearly sales by $7.8 million.
-The annual operating costs (excluding depreciation) of the new facility are expected to equal 58% of annual revenues.
-The company's tax rate is 25%.
-The project's cost of capital is 10.5%.a. Set up a spreadsheet and calculation of projected cash flows
b. Calculate NPV (using excel function)
c. Calculate IRR (using excel function)
d. Calculate MIRR (using excel function)
e. Calculate payback period
f. Calculate discounted payback period
g. Answer to whether the company should accept the project and why.
h. Graph the NPV profile for the project (using excel)
|
Contrast bank rates versus bmw dealership financing
: Compare and contrast bank rates versus BMW dealership financing. A table showing the options would be helpful here. Cite your references.
|
|
What is the present value of a 3-year annuity
: What is the present value of a 3-year annuity of $200 if the discount rate is 5%? (Do not round intermediate calculations. Round your answer to 2 decimal places
|
|
Calculate the full price-the accrued interest
: A 5.25% US corporate bond is priced for settlement on 27th July, 2015. The bondmakes semiannual coupon payments on 15th June and 15 December each year and matur
|
|
What are the key drivers of value in model
: What are the key drivers of value in your model? Free cash ?ow forecasts, WACC, and the terminal value because that is how you ?nd out the debt and equity and s
|
|
Calculate discounted payback period
: Penn Printing is considering opening a new production facility near Erie, PA. In deciding whether to proceed with the project, the company has gathered the foll
|
|
What is the expected return of portfolio
: If American Airlines stock has an expected return of 8.1% and Southwest stock has an expected return of 11.6%, what is the expected return of your portfolio?
|
|
Determining the target debt-equity ratio
: Blue Angel, Inc., a private firm in the holiday gift industry, is considering a new project. The company currently has a target debt-equity ratio of .30, but th
|
|
How much can mary deposit to her tfsa in 2020
: Mary was born in 1992. She made the following deposits and withdrawals to her TFSA: Year 2009 2010 2011 2012 2013 2014 2015 2016 Withdrawal $1,000 $1,500 So $4,
|
|
Calculate the percentage of ownership in the company
: Assume a venture capitalist requires a 40 percent rate of return per year. If the venture capitalist thinks that a company will be worth $50 million in 5 years,
|