Efficiency measures translate into cash flows

Assignment Help Accounting Basics
Reference no: EM13857260

Google has invested $450 million + working capital of $50 million to convert an old paper mill in Hamina, Finland into a state-of-the-art data centre. The project has a lifespan of 10 years . The rationale for the investment is to increase capacity and position the company for a push into the cloud computing market where Amazon Web Services currently dominates.

1. Google's sales of cloud computing services are $800 million in 2013. Sales revenue is expected to grow at 20 percent p.a. even without the new data centre.

2. It is expected that the Hamina data centre will add 3.50 percent p.a. to sales revenue. Therefore, in year 1 (2014) sales revenue would be $960 million without the new centre. With the new centre it will be 3.50 percent more, or $993.6 million. Note: this is different than simply increasing the growth rate of sales by 3.50 percent to make a total of 23.50 percent p.a. Don't take my word for it, try it!

3. Wages are a variable cost. The data centre will employ 90 people in 2014. The wages cost will be $6,000,000 in 2014. Wages costs are expected to grow by 2 percent p.a. in each subsequent year.

4. Other variable costs associated with running the data centre will amount to $21,000,000 in 2014. These other variable costs will also grow at 2 percent p.a. in each subsequent year.

5. Fixed costs will amount to $2,000,000 in 2014. These are expected to grow by 3 percent p.a. in each subsequent year.
6. Further injections of working capital will be required in 2016 and 2019. $55,000,000 will be required in each of these years. All working capital is returned at the end of the project.

7. The depreciation rule that should be applied is ‘straight-line-to-zero'.

8. The taxation rate that should be applied throughout the analysis is the average corporate taxation rate in the United States. This is

25 percent.

9. If you record a negative EBIT in any given year, taxes should be set to $0.00 for that year.

10. The corporate finance team recommends a discount rate of 12.50 percent be used to evaluate the investment.
In Google's assessment, the key to the project is the savings that it may be able to obtain on electricity. Data centres require a lot of electricity. In 2010, for example, Google consumed 2.26 terawatt hours of electricity (about the equivalent of annual usage of 200,000 households). In fact, in 2010, data centres run by companies like Microsoft, Amazon and Facebook were responsible for 1.5% of the world's total electricity usage . Powering the internet consumes 10% of the world's electricity each year . Google is a leader in renewable energy. 34% of its annual power consumption comes from renewable sources .

The data centre in Finland has a number of electricity saving features:

1. Finland has a moderate climate. Air conditioning is not usually necessary even on the hottest summer days . Of course, winter becomes very cold.

2. The facility in Hamina used to be a paper mill. When Google acquired it, the facility had a seawater intake tunnel taking in cold water from the Gulf of Finland. This now forms the heart of a seawater cooling system that further reduces the need for air conditioning units.

3. Usually, electricity usage suffers from ‘leakage'. Google's data centre will run at 80% efficiency (only 20% ‘leakage') versus an industry average of 40% (60% leakage) :

The standard measurement of data centre efficiency is called power usage effectiveness, or PUE. A perfect number is XXXXX meaning all the power drawn by the facility is put to use. Experts considered 2.0-indicating half the power is wasted-to be a reasonable number for

a data centre. Google was getting an unprecedented 1.2.

3. The final efficiency feature takes advantage of the renewable energy initiatives that have been developed in many European countries over the past several decades in tandem with Scandinavia's integrated electricity grid that connects countries like Finland with nearby Sweden. In particular, Google will access 72 MW p.a. of wind power from a facility in Sweden.

These efficiency measures translate into cash flows:

1. Google will save $48,000,000 in 2014 electricity generation costs by shifting capacity from existing data centres to Hamina. This saving is expected to grow by 11% per year. This comes from two sources. First, as electricity gradually becomes more expensive, the efficiencies become worth more in dollar terms. Second, the Finnish government will provide tax concessions for efficient electricity generation.
Your Task

1. Use the financial information given below to compute a NPV and IRR for the investment in the Hamina data centre.

2. Perform a ‘sensitivity analysis' on your results by reworking the NPV and IRR calculations across a range of operating cash flows: - 20 percent, - 10 percent, + 10 percent, + 20 percent of the original operating cash flow numbers .

3. Drawing on your initial analysis (point 1) and your sensitivity analysis (point 2), explain whether the project is likely to create market value for Google

Reference no: EM13857260

Questions Cloud

Statements about writing job specifications : Which of the following statements about writing job specifications is false
Estimate the steady state mass flux of flavor : The concentration of flavor within the sphere is 100% and mass diffusivity for the flavor compound within the liquid food is 7.8 X 10^-9 m2/s. Estimate the steady state mass flux of flavor into liquid food from surface of time-release sphere. The ..
Explain how higher quality can lead to lower costs : Why is it good or bad to operate an IT support services system (help desk) on a strictly, first come, first-served basis? Explain how higher quality can lead to lower costs
What would be the fraction converted in a half-hour run : A 10-minute experimental run shows that 75% of liquid reactant is converted to product by a half-order rate. What would be the fraction converted in a half-hour run.
Efficiency measures translate into cash flows : efficiency measures translate into cash flows
Explain type of data you plan touse for your dissertation : Explain the type of data you plan touse for your dissertation, and how you plan to collect that data. Describe a type of analysis you might use to analyze your data and explain the reason(s) for your selection.
Which activities are computed differently using : Which activities are computed differently using the two methods of formatting a statement of cash flows?
Draw and label a flow diagram : Draw and label a Flow diagram with the given information shown in brackets and with calculated recovery per stream. Draw and label a Flow diagram with the middlings returned to the rougher.
Electrical wholesale business : Brian is closing down his electrical wholesale business. Amongst the stock remaining in his warehouse are 400 television sets. He agrees to sell 300 of these televisions to Ian who pays for them in full by cheque and agrees to collect them the follow..

Reviews

Write a Review

Accounting Basics Questions & Answers

  Prepare the sales revenues section of the income statement

the adjusted trial balance of zambrana company shows the following data pertaining to sales at the end of its fiscal

  Disadvantages of absorption or traditional costing

Compare the advantages and disadvantages of absorption or traditional costing and activity based costing

  Replacing the asset by using nvp methodology

The new machine will cut operating costs by $10,000 each year for the next five years. Taylor's cost of capital is 8 percent. Should the firm replace the asset? (Use NPV methodology to solve this problem)

  Name the four areas in which standards of ethical conduct

name the four areas in which standards of ethical conduct exist for management accountants in the united states. what

  Difference in asset basis problem

Analysis of the assets and liabilities of Marie Corp. on December 31, 2011, disclosed assets with a tax basis of $1,000,000 and a book basis of $1,300,000. There was no difference in the liability basis. The difference in asset basis arose from te..

  Tax and consulting services problem

Precision Tax Service offers tax and consulting services to individuals and small businesses. Data for fees and costs of three types of tax returns follow. Precision provides services in the ratio of 5:3:2 (easy, moderate, business).

  Journal entries of transactions involving the purchase

Assuming that the US Corp. has a December 31 year end, prepare the necessary journal entries to account for the series of transactions involving the purchase.

  For the year ended december 31 2013 fidelity engineering

for the year ended december 31 2013 fidelity engineering reported pretax accounting income of 977000. selected

  A company has prepared the operational budget and the cash

a company has prepared the operational budget and the cash budget is now preparing the budgeted balance sheet. to

  Prepare a tabular analysis of the above transactions

Prepare a tabular analysis of the above transactions

  Abc corp bought a production machine on january 1 2011 for

abc corp bought a production machine on january 1 2011 for 30000. the company elected out of section 179 expensing and

  In looking at accounts receivables and bad debts for this

in looking at accounts receivables and bad debts for this weeks discussion review the following web addressthere are

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