Annual costs-cash flow and cumulative cash flow

Assignment Help Financial Management
Reference no: EM131323944

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: EM131323944

Questions Cloud

Nominal return on your investment : You want to have $5 million in real dollars in an account when you retire in 40 years. The nominal return on your investment is 13 percent and the inflation rate is 4.4 percent. What real amount must you deposit each year to achieve your goal?
What would you expect to be the percentage change in price : Assume that you have a liability portfolio of Duration = 5.125 years and a yield to maturity of 8.50%. If interest rates decrease by 1.0%, what would you expect to be the percentage change in the price?
Bond is currently selling for price greater than face value : A bond is currently selling for a price greater than face value. If the bond’s yield to maturity remains constant, which of the following statements is most correct:
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.

Reviews

Write a Review

Financial Management Questions & Answers

  Typical of the average corporation and is risk-adverse

Mountain Ski Corp. was set up to take large risks and is willing to take the greatest risk possible. Lake ways Train Co. is more typical of the average corporation and is risk-adverse. Which of the following four projects should Mountain Ski Corp. ch..

  What tools would management use to mount such a defense

Sometimes the management of a target firm fights a takeover attempt even when that attempt appears to be in the best interest of the shareholders. Why would management take this stance? What tools would management use to mount such a defense?

  What must the expected return on this stock

A stock has a beta of 1.18, the expected return on the market is 11.2 percent, and the risk-free rate is 4.85 percent. What must the expected return on this stock be?

  A project has an initial cost and produces cash inflows

A project has an initial cost of $8,700 and produces cash inflows of $2,600, $5,000, and $1,600 over the next three years, respectively. What is the discounted payback period if the required rate of return is 7 percent?

  What is the STRIPS price

A STRIPS traded on May 1 2014, matures in 16 years on May 1 2030. Assuming a 5.2 percent yield to maturity, what is the STRIPS price? (Use Excel to answer this question. Enter your answer as a percentage of par value. Round your answer to 4 decimal p..

  What is the value at year eight of perpetual stream

Given an interest rate of 6.0 percent per year, what is the value at Year 8 of a perpetual stream of $3,050 payments that begin at Year 19?

  What was the firms operating profit

Larry’s Window Company had sales of $1,500,000 and cost of goods sold of $1,200,000. Selling and administrative expenses represented 5 percent of sales. Depreciation was 5 percent of the total assets of $1,000,000. What was the firm’s operating profi..

  When company changes its capital structure

When a company changes its capital structure, what happens? The Weighted Average Cost of Captial (WACC) changes. The discount rate does not change. Investors buy or sell shares.

  Using ratios to construct financial statements

Using ratios to construct financial statements [LO2] The Griggs Corporation has credit sales of $908,950. Total assets turnover 2.65 times Cash to total assets 1.95 % Accounts receivable turnover 10 times Inventory turnover 14 times Current ratio 1.7..

  Public corporation from the private corporation

What differentiates the public corporation from the private corporation? How does the not-for-profit corporation differ in purpose and structure from the for-profit? What is the primary characteristic of the closely held corporation?

  The average annual return over the period

The average annual return over the period 1886-2006 for stocks that comprise of the S and P 500 is 10% and the standard deviations of returns is 20%. Based on these numbers, what is a 95% confidence interval for 2007 returns?

  The contract size for platinum futures

The contract size for platinum futures is 50 troy ounces. Sup-pose you need 300 troy ounces of platinum and the current futures price is $2,025 per ounce. How many contracts do you need to purchase? How much will you pay for your platinum? What is yo..

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