Reference no: EM13878236
Capital Budgeting with Sum-of-Years'-Digits Depreciation Bernie Company purchased a new machine, with an estimated useful life of five years and no salvage value, for $45,000. The machine is expected to produce net cash inflows from operations, before income taxes, as follows:
|
1st year
|
$ 9,000
|
|
2nd year
|
12,000
|
|
3rd year
|
15,000
|
|
4th year
|
9,000
|
|
5th year
|
8,000
|
Bernie will use the sum-of-the-years'-digits method to depreciate the new machine. Bernie uses 10 percent for evaluating capital investments and is currently in a 24 percent income tax bracket.
Required: Set up an Excel spreadsheet to determine:
1. The payback period of the proposed investment (assume that cash inflows occur evenly throughout the year).
2. The net present value (NPV) of the proposed investment.
3. The internal rate of return (IRR) of the proposed investment.
4. The discounted payback period of the proposed project.
5. The modified internal rate of return (MIRR) of the proposed investment. Explain the difference between IRR and MIRR.
|
Explain the difference between a projects irr and its mirr
: Modified internal rate of return (MIRR) also, explain the difference between a project's IRR and its MIRR. What is the minimum (or maximum) savings that AC1 must have without altering your decision in requirement 2?
|
|
What is a major emphasis of the dow theory
: Given the following financial data, compute the return on assets and return on equity: net income/sales = 8%, sales/total assets = 2.5X, and debt/total assets = 15%. Explain the role of a specialist. What is a major emphasis of the Dow Theory? Which ..
|
|
What would the common stock be worth on per share basis
: Suppose that Unkempt Inc. common stock paid an annual dividend last year of $2.13, has a cost of common equity of 14%, and had a dividend growth rate of 1%, what would the common stock be worth on a per share basis? If there are 100 million shares ou..
|
|
Why is teamwork important in supply chain
: Why is teamwork important in supply chain/logistics and what are some best practices associated with teamwork?
|
|
Determine discounted payback period of the proposed project
: Determine The discounted payback period of the proposed project and The payback period of the proposed investment (assume that cash inflows occur evenly throughout the year).
|
|
What impact did dividends have on GEs calculated returns
: Suppose that you bought GE 6 years ago at a price of $128 per share. The price has decreased to $75. What is Standard Return for GE's Stock over the entire 6 year period assuming that GE paid no dividends over the 6 years? What is the Log Return for ..
|
|
Differences in quality of healthcare
: Differences in Quality of Healthcare A lower percentage of African Americans and Hispanics report being satisfied with the quality of their healthcare than Caucasians. In the light of this, answer the questions
|
|
Capital budgeting and investment analysis
: Who will benefit most from the machine if the technology underlying the machine is not proprietary and what are some of the things the manufacturer can do to earn higher returns from this machine even without patent protection?
|
|
Convert the standard return into a log return
: Suppose that, over a 125 day period, Mike Inc.'s stock price experienced (positive) Standard Returns of 12%. Convert the Standard Return into a Log Return. What would the annualized Standard Return be?
|