Cumulative cash flow as line graph for upgrade project

Assignment Help Financial Management

Reference no: EM131323941

As a large construction company IT manager you have been asked to decide if the company should invest in an upgrade to the servers that support your engineering department. If you stick with the current system, annual energy costs are $85,320, annual maintenance costs are $190,000, and the annual software licenses are $26,500 per year. For the upgrade, the investment required is $469,480 and the company’s cost of capital is 7%. The investment would cut all of your annual costs by 52% for 5 years. Include a cash flow table from your excel spreadsheet, include investments, annual costs, cash flow, and cumulative cash flow throughout the duration of 5 years. Graph your annual cash flow as a bar graph and cumulative cash flow as a line graph for this upgrade project. What is the return on investment on this upgrade project and what is the payback period? Should you do it?

Make sure to include a cash flow table from your excel spreadsheet, include investments, annual costs, cash flow, and cumulative cash flow throughout the duration of 5 years. Graph your annual cash flow as a bar graph and cumulative cash flow as a line graph for this upgrade project please.

Reference no: EM131323941

Questions Cloud

Portfolio will be invested in the zero coupon bonds : Assume that you have only two assets from which to choose: one-year zero coupon bonds; and junk bonds with a duration of 9.0 years. If you have a liability portfolio with duration = 5.125 years has a present value of $3 million, what percentage of yo..

Annual costs-cash flow and cumulative cash flow : As a large construction company IT manager you have been asked to decide if the company should invest in an upgrade to the servers that support your engineering department. Make sure to include a cash flow table from your excel spreadsheet, include i..

Who is entitled to receive the interest you pay : You have a corporate (not a Treasury) bond which has a 7% coupon and pays interest on January 1 and July 1 of each year. Who is entitled to receive the interest you pay?

Same exercise price and expiration date as call option : The current price of a stock is $34, and the annual risk-free rate is 3%. A call option with a strike price of $32 and 1 year until expiration has a current value of $7.40. What is the value of a put option written on a stock with the same exercise p..

Cumulative cash flow as line graph for upgrade project : As a large construction company IT manager you have been asked to decide if the company should invest in an upgrade to the servers that support your engineering department. Graph your annual cash flow as a bar graph and cumulative cash flow as a line..

The riskiness of debt financing to lenders : What do we mean by call provision? What impact does this have on the riskiness of debt financing to lenders? How about to borrowers? Any examples/application to the healthcare financing industry would be greatly appreciated.

What was the yield to maturity : On October 25 of last year the market price of Braves Corporation's 10 percent coupon, 11 years to maturity bonds was $1,213.17. A 10 percent coupon interest rate is paid semiannually, and the par value is equal to $1,000. What was the Yield To Matur..

What is its coupon rate today : Considering the same bond as in the previous question, On October 25 of this year now the Braves Corporation's 10 percent coupon, 10 years to maturity (it's a year later, now has a Yield to Maturity of 11 percent. What is its coupon rate today?

Common stocks in terms of total asset growth : Which one of the following statements is a WRONG application of the total asset growth anomaly once it is determined that the common stock of Altria Group belongs to the bottom decile among all common stocks in terms of total asset growth?

User Account

All Pages