Reference no: EM133375399
Case Study: J. Morgan of SparkPlug Incorporated has been approached to take over a production facility from B.R. Machine Company. The acquisition will cost $1,620,000, and the after-tax net cash inflows will be $248,000 per year for 12 years.
SparkPlug currently uses 8% as its after-tax cost of capital. Tom Morgan, production manager, is very much in favor of the investment. He argues that the total after-tax net cash inflows is more than the cost of the investment, even if the demand for the product is somewhat uncertain. "The project will pay for itself even if the demand is only half the projected level." Cindy Morgan (corporate controller) believes that the cost of capital should be 11% because of the declining demand for SparkPlug products.
Required:
1. What is the estimated NPV of the project if the after-tax cost of capital (discount rate) is 8%? Use the built-in NPV function in Excel. (Negative amounts should be indicated by a minus sign. Round your answer to the nearest whole dollar amount.)
2. What is the estimated NPV of the project if the after-tax cost of capital (discount rate) is 11%? Use the built-in NPV function in Excel. (Negative amounts should be indicated by a minus sign. Round your answer to the nearest whole dollar amount.)
3. Use the built-in function in Excel to estimate the project's IRR. (Round your answer to 1 decimal places.)
4. Use a sensitivity analysis by using GOAL SEEK to determine, given estimated cash inflows, the original investment outlay that would result in an IRR of 11%. (Round your answer to nearest whole dollar amount.)
|
What is the value of the quick ratio
: Bunky 's Boutique has cash of $100, accounts receivable of $190, accounts payable of $200, short-term notes payable of $140, LTD of $200, Common Stock of $150
|
|
Determine how much cash the company can borrow
: determine how much cash the company can borrow with this agreement. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables
|
|
Describe the elements of strategic reasoning
: describe the elements of strategic reasoning. For each provide a specific example of what can be missed if the element is not used.
|
|
Why does an intra-entity sale of a depreciable asset
: Why does an intra-entity sale of a depreciable asset (such as equipment or a building) require subsequent adjustments to depreciation expense within
|
|
What is the estimated npv of the project if the after-tax
: What is the estimated NPV of the project if the after-tax cost of capital (discount rate) is 8%? Use the built-in NPV function in Excel.
|
|
How are the financial impacts hcos face
: Who benefits from moving healthcare from volume to value? What are the factors a healthcare administrator must take into consideration when deciding
|
|
Calculates that the value of an asset is
: calculates that the value of an asset is $7,500. The asset produces year-end annual cash flows of $X the first year, $2,000 the second year, $3,000 the third
|
|
What is the value today of a perpetuity that makes its first
: What is the value today of a perpetuity that makes its first payment of $3,317.76 at the end of year 5 if the discount rate is 20%?
|
|
Discuss any similarities as well as any differences
: share your experiences on international finance. Consider the areas in which will be most applicable in retail companies. Discuss any similarities as well as
|