Consider the cost alternatives

Assignment Help Financial Management
Reference no: EM131185137

Consider the following cost alternatives with 10 year useful lives. The company has a MARR = 15%.

_________________________________________

initial          | Annual | Salvage |Alternative

investment | O&M   | value      |

                      | costs |                 |

________________________________________

50000          | 10000|35000     |   A

_____________________________________

55000          |9000    | 38000     |    B       

_____________________________________

60000          | 8300   | 41000     |      C

____________________________________

65000          | 7200   | 44000      |      D

____________________________________

70000          | 6600   | 47000      |      E

___________________________________

75000          | 5500   | 50000     |      F

____________________________________

a) Using suitable Excel functions, perform an incremental IRR analysis to determine the best alternative. Clearly lay out each step of the analysis and its conclusion.

b) Using suitable Excel functions, perform an incremental ERR analysis to determine the best alternative. Use an external borrowing/re-investment rate of ε = 12%. Clearly lay out each step of the analysis and its conclusion.

c) Compare the results of your analyses in Parts (a) and (b) and discuss the reason behind any differences.

Reference no: EM131185137

Questions Cloud

What was maccarones fully diluted earnings per share : Maccarone Incorporated had earnings of $1,500,000 last year. On average, 1 million shares were outstanding during the year. Had all holders of the company=s options exchanged them for stock at the beginning of the year, there would have been 1,250,00..
Expansion project-requires an initial fixed asset investment : Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.64 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be w..
Computer-based order entry system : Your firm is contemplating the purchase of a new $555,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $55,000 at the end of that time. You will save $285,000 before..
Interest in semi annual payments : Bills bonds pays 8% yearly interest in semi annual payments for 10 years. The current yield on similar bonds is 11%. To determine the market value of this bond, you must: a. Find the interest factors for 10 periods at 7%, b. Find the interest factor ..
Consider the cost alternatives : Consider the following cost alternatives with 10 year useful lives. The company has a MARR = 15%. Using suitable Excel functions, perform an incremental IRR analysis to determine the best alternative. Clearly lay out each step of the analysis and its..
What interest rate would make : What interest rate would make it worthwhile to incur a compensating balance of $28,000 in order to get a 1 percent lower interest rate on a 1 year, pure discount loan of $315,000?
List a way low income might interfere with your life : One out of five older older adults have income from earnings . In 2014 ,the median annual income of the four-fifths of people age 65 and older and older who are fully retired was $18,096.Use this figure to develop a monthly budget ($1500 a month) wha..
Assuming constant rate of inflation : Suppose there exists a bank that offers an APR of 5.4% indefinitely on current deposits. If you wanted to setup an account that would pay monthly instalments of $3000 indefinitely, how much should your initial deposit be?
Contracts with businesses will be governed by common law : You are the manager of Acme Fireworks, a fireworks retailer who sells fireworks, puts on ground display fireworks, and large aerial display fireworks. The company started in the owner’s garage two years ago and now has 15 employees that you manage. D..

Reviews

Write a Review

Financial Management Questions & Answers

  Compute risk of a portfolio consisting of equal proportions

Furthermore, the correlation of returns between the securities is -1.0. Determine the risk (standard deviation) of a portfolio consisting of equal proportions of Securities A and B.

  Company generate in order to reach the break-even point

Ritz Furniture has a contribution margin ratio of 0.17. If fixed costs are $167,300, how many dollars of revenue must the company generate in order to reach the break-even point?

  Current market price of the bond

Fresh Water, INC. Sold an issue of 23-year $1,000 par value bonds to the public. The bonds have a 9.90% coupon rate and pay interest annually. The current market rate of interest on the Fresh Water, INC bonds 9.17%. What is the current market price o..

  Prices will have gone down to a more reasonable level

You want to buy a new 3D/UHD television in 3 years, when you think prices will have gone down to a more reasonable level. You anticipate that at that time the television will cost $2,400. If you can invest your money at 8% compounded annually, how mu..

  Bonds two years ago at a coupon rate

Heginbotham Corp. issued 10-year bonds two years ago at a coupon rate of 8.7 percent. The bonds make semi annual payments. If these bonds currently sell for 108 percent of par value, what is the YTM?

  What is the degree of operating leverage

At an output level of 50,000 units, you calculate that the degree of operating leverage is 3.50. Suppose fixed costs are $290,000. What is the operating cash flow at 44,000 units? What is the degree of operating leverage?

  Failure of one firm can cause other firms to fail is called

A firm has a WACC of 10% and $50,000,000 in assets. They feel that that they can reduce their WACC to 9% by doing a better job of managing risk. How much should they be willing to pay for risk reduction? The idea that the failure of one firm can caus..

  What is the equipments after-tax salvage value

Southern California Gas Co. is selling off some old equipment it no longer needs because its associated project has come to an end. The equipment originally cost $27,500, of which 75% has been depreciated. The firm can sell the used equipment today f..

  Analyst should be careful when evaluating a ratio analysis

The analyst should be careful when evaluating a ratio analysis that: a. the dates of the financial statements being compared are the same b. pre-audited statements are used c. neither a or b d. both a and b

  Preferred stock with cumulative fixed dividends

Factors that should be considered in taking a stock option position include: Advantages of investing in tax-exempt bond funds include all of the following EXCEPT: Preferred stock with cumulative fixed dividends

  Compute the weighted average cost of capital for a firm

Compute the weighted average cost of capital for a firm of your choosing (they must have bonds and common stock outstanding, preferred stock is optional). You should use current market information to determine the firm’s current cost of equity, cost ..

  Consider discounted cash flow analysis on the stock

Provide a relative valuation analysis for ONE of the following stocks: Google (Ticker: GOOG) Morgan Stanley (Ticker: MS) Johnson & Johnson (Ticker: JNJ) We will refer to the chosen stock as “the stock” Identify two major limitations of the above anal..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd