Reference no: EM131830367
Focus on an Expansionary Problem:
Develop a capital budgeting decision model showing cash flows, cost of capital and decision metrics (i.e., npv, irr and payback). Form a conclusion based upon the analysis. Begin with the example problem on age 408 and 409 of the textbook, Table 12.1. Modify the problem in the following fashion and develop the analysis within an Excel spreadsheet. (Please include Formulas): Initial investment cost is 10,000,000 and the life of the project is 5 years.
Assume the units sold are 2,700,000 in year 2013 and they grow each subsequent year at 5%.
o Assume each unit will sell for $2.10
o Assume the variable cost of producing each unit is 1.10.
o Assume straight-line depreciation.
o The cost of capital is calculated based upon funding from retained earnings and from debt. The company is assumed to fund itself with 50% debt and 50% retained earnings. The cost of debt capital, rD, is 7%. The cost of capital from retained earnings, rS, is based upon the capital asset pricing model. The risk free rate in the market is 5% and the difference between the expected return on the market and the risk free rate is 5%. The beta for the company is 2.0. The tax rate is assumed to be 40%.
o Complete a sensitivity analysis in which you reevaluate the model considering the selling price per unit is 1.90, 2.00, 2.10, 2.20 and 2.30. Present and comment on the results.
Assume all other assumptions as given. Please include excel formulas.
|
Who is to say what can and cannot be posted on the web
: There are concerns about Web content at levels. Parents want to protect their children from pornography. Who is to say what can and cannot be posted on the Web?
|
|
What is the value of the fifth central moment
: If X has a uniform distribution on the interval (a, b), what is the value of the fifth central moment of X?
|
|
Determine the total bond interest expense
: The bonds are issued at a price of $1,505,001. Determine the total bond interest expense to be recognized over the bonds' life
|
|
How has the traditional foreclosure process failed
: How has the traditional foreclosure process failed under these unusual circumstances? Please discuss that question and at least 1 of the 3 points above.
|
|
Develop capital budgeting decision model showing cash flows
: Develop a capital budgeting decision model showing cash flows, cost of capital and decision metrics (i.e., npv, irr and payback).
|
|
How can we as citizens help monitor accuracy of web content
: Have you taken what you found, used the information, and not checked the content for accuracy? How can we as citizens help monitor the accuracy of Web content?
|
|
Compute depreciation expense using the straight-line method
: Compute 2012 depreciation expense using the straight-line method assuming the machinery was purchased on September 1, 2012
|
|
How do the structures all relate to one another
: Can a tree ever be a list? Can a tree ever be a graph? Can a graph ever be a tree? How do the structures all relate to one another?
|
|
What is present value of the annuity
: A 10-year annuity pays $3,300 per month, and payments are made at the end of each month. What is the present value of the annuity?
|