fix =SUM(B18:K18)/10 A В С D Е F G Н K L 10 11 12 13 14 15 1.1 2019 2016 16 Year 2018 2017 2015 2014 2013 2012 2011 2010 2009 Operating P/L[=EBIT] 35,011,000 24,157,000 20,363,000| 27,780,000 20,489,000 42,933,000 31,315,000 26,236,000 26,556,000 21,763,000 27,161,000 17 18 0.1935889617 0.04609127881 0.1863183224 GR 0.2262717432 0.1180265049 0.2804919713 -0.2624550036 0.2202361807 -0.1987408416 0.1243531896 19 AAGR 0.09341823073, 2221

Question

Question: Calculate the average annual growth rate of Microsoft from the fiscal year ending 2009 until the fiscal year ending.

EBIT 2009 - 2019:

2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009
42,933,000 35,011,000 31,315,000 26,236,000 20,489,000 27,780,000 26,556,000 21,763,000 27,161,000 24,157,000 20,363,000

Is 9.34% correct?

fix
=SUM(B18:K18)/10
A
В
С
D
Е
F
G
Н
K
L
10
11
12
13
14
15
1.1
2019
2016
16
Year
2018
2017
2015
2014
2013
2012
2011
2010
2009
Operating P/L[=EBIT]
35,011,000
24,157,000 20,363,000|
27,780,000
20,489,000
42,933,000
31,315,000
26,236,000
26,556,000
21,763,000
27,161,000
17
18
0.1935889617
0.04609127881
0.1863183224
GR
0.2262717432 0.1180265049
0.2804919713
-0.2624550036
0.2202361807
-0.1987408416
0.1243531896
19
AAGR
0.09341823073,
2221
Expand
Transcribed Image Text

fix =SUM(B18:K18)/10 A В С D Е F G Н K L 10 11 12 13 14 15 1.1 2019 2016 16 Year 2018 2017 2015 2014 2013 2012 2011 2010 2009 Operating P/L[=EBIT] 35,011,000 24,157,000 20,363,000| 27,780,000 20,489,000 42,933,000 31,315,000 26,236,000 26,556,000 21,763,000 27,161,000 17 18 0.1935889617 0.04609127881 0.1863183224 GR 0.2262717432 0.1180265049 0.2804919713 -0.2624550036 0.2202361807 -0.1987408416 0.1243531896 19 AAGR 0.09341823073, 2221

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: Which do factors and insurance companies have in common?   Both are primary participants in money ...

A: The correct answer is the third option i.e. 3) Both allow extending credit to customers without putt...

Q: XYZ company has the following expected cash flows for three scenarios that could occur:            ...

A: In an levered firm, there is no debt amount therefore no interest amount is payable that is 0. The E...

Q: Global Internet company is looking to expand their operations. They are evaluating their cost of cap...

A: 1)The computation of cost of capital is as follows:

Q: (1) The standard deviation of a portfolio that has 40% of its value invested in a risk-free asset an...

A: Standard Deviation: It refers to the stand-alone risk associated with the securities. It measures ho...

Q: Can someone please just give me the right answer to the right decimal places for the last part, "How...

A: Calculation of interest was earned during the third quarter of the 4th year:The interest was earned ...

Q: It is now January 1, 2019, and you are considering the purchase of an outstanding bond that was issu...

A: We will find the Yield to maturity, YTM and yield to call, YTC using the RATE function of excel.

Q: Savickas Petroleum’s stock has a required return of 12%, and the stock sells for $43 per share. The ...

A: Dividend = $1.00Growth Rate for 4 years = 30 % or 0.3 Calculation of Present Value of Dividend for 4...

Q: Suppose that you deposit $10 at the end of each day into a savings account that pays 2% interest com...

A: Accumulated value can be defined as the sum of investment and interest earned on investment over a s...

Q: Explain how a firm that never files for bankruptcy can still suffer from indirect bankruptcy costs. ...

A: Indirect Bankruptcy Costs:Those costs which occur on a firm and pressurized the firm to file the ban...

Q: An assisted living has actual total revenues of 1.68 million, expenses of 1 million in 2018. The bud...

A: Budgets are useful measure of control. They are used in performance evaluation. How budgeted amount ...

Q: If you invest $900 in a bank in which it will earn 8 percent compounded quarterly, how much will it ...

A: PV = $ 900; r = 8% compounded quarterly; m = frequency of compounding = 4 (as there are four quarter...

Q: Gillette's most recent annual dividend was $8 per share. The company expects the growth of its divid...

A: Part A& B:Calculation of Current Value of Stock and Dividend Growth Rate:Excel Spreadsheet:

Q: Assess the estimation techniques of long term corporate investment in your answer focus on the relat...

A: Stock valuation is one of the method used to determine the theoretical value or intrinsic value of t...

Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and financin...

A: Calculation of Monthly Payment:The monthly payment is $710.04.Excel Spreadsheet:

Q: Wildcat engineering decides to take a $10,000 interest only lona. The loan is to be paid montly over...

A: Interest only loan can be described as the loan on which borrower only pays the interest payments du...

Q: Please show all equations and work as needed. Make the correct answer clear. If possible, please typ...

A: The computation of net amount is as follows:Hence, the net amount of funds from the loan is $511560....

Q: On March 9, 2009, the Dow Jones Industrial Average reached a new low at a close of 6,847.20, which w...

A: Calculate the return on stock market as follows:

Q: 4. You plan to lease (Begin Mode!!!) a new care today. The dealership's finance office quotes you a ...

A: Calculation of interest rate and future value:Answer: Interest rate is 3% and future value is $19,93...

Q: The Data General Company is expected to pay an annual dividend of $2.53 at the end of the year. Thei...

A: Computation of required rate of return:Required rate of return is 15.81%.Excel spread sheet:

Q: XYZ company has just paid a dividend of $1.15. The required rate of return on the stock is 13.4%, an...

A: 1.Calculation of Current Stock Value:The current stock value is $21.30.

Q: A Brazilian company called Netshoes completed its IPO on April 12, 2017, and listed on the NYSE. Net...

A: Excel spread sheet:

Q: Which would provide a bank holding company with guidance on the types of nonbanking activities it ca...

A: Bank Holding Companies are governed by Bank Holding Company Act (BHC Act) of 1956, which gives Feder...

Q: 12. You are considering the purchase of a tract of timber land today as an investment. Last years ti...

A: Calculate the current price of the land as follows:

Q: Suppose that some commercial bank has $100M in deposits and $20M in capital. Assuming a 10% minimum ...

A: Calculation of maximum amount of loan and securities bank can hold:Answer:The maximum amount of loan...

Q: Barry Inc. is considering a project that has the following cash flow and WACC data. What is the proj...

A: We will make use of the MIRR function of excel to get the desired MIRR

Q: Joey realizes that he has charged too much on his credit card and has racked up $4,300 in debt. If h...

A: Given that the loan amount is $4300, the payment per month is $125, annual percentage rate is 18%, a...

Q: 10 &ercent Suppose that you earned a bachelor's degree and now you' re teaching middle school. The s...

A: $1500 is deposited every three months for a period of 11 years at a rate of 5.5% compounded quarterl...

Q: Which of the following eliminates settlement risk?   Trans-European Automated Real-Time Gross Sett...

A: Continuous Linked Settlement (CLS) is a type of payment system which eliminates settlement risk when...

Q: Need help with NPV and IRR

A: Reinvestment Rate = 3% or 0.03Cash Flow = Old Cash Flow × (1 + Reinvestment Rate) Calculation of NPV...

Q: (Solving for i of an annuity) You lend a friend $30,000, which your friend will repay in five equal ...

A: We can solve the rate of return using the Financial calculator or excel. I will demonstrate both the...

Q: 11. A company just paid a dividend of $4 and anticipates increasing its dividend at a constant rate ...

A: Calculate the required rate of return as follows:

Q: Optimal corporation wants to expand their manufacturing facilities. They have two choices, first to ...

A: 1. The net present value of option 1:Computation of net present value:Hence, the net present value i...

Q: If an investor wanted to grow a continuously compounded investment of $1000 to $1250 in 3 years, wha...

A: Computation of rate of interest:

Q: A certain project requires an immediate cash outflow of $4 million. At the end of each of the next f...

A: Net present value represents the present worth of the future cash inflows. It is used to analyze the...

Q: Fran Powers created following budget and reported actual spending listed. Calculate the variance for...

A: Variance:The variance can be defined as the anticipation of the squared unconventionality of a rando...

Q: I am struggling with this problem as well and how to approach setting it up in excel. I'm using the ...

A: Initial Investment of New Product = Decrease in Firm’s FCFs of Current Year = $36 MillionCash Flow o...

Q: A pension fund manager is considering three mutual funds.  The first is a stock fund, the second is ...

A: Calculation of Expected Return, Standard Deviation, Sharpe Ratio, Weight of Stock and Weight of Bond...

Q: An investment has a cost of $3500. The investment will have a payout at the end of the first year.  ...

A: Approach: Let's assume the desired minimum payout is P.We will roll out the yearly payout projection...

Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and financin...

A: Calculation of Interest Paid over the New Loan:The interest paid over the new loan is $137,184.85.Ex...

Q: Smooth Sailing Warehouse wants to issue 15-year, zero coupon bonds that yield 7.50% with semi-annual...

A: Calculate the bond price as follows:

Q: Consider the following data for a one-factor economy. All portfolios are assumed to be well diversif...

A: Before we get into the question, it's imperative to note that beta of a portfolio comprising of two ...

Q: Hello, It is a three part question. However, I would like to know how the amount of 122, 265, was ca...

A: 3.Calculate the net present value as follows:

Q: Approximately how many years are needed to double a $100 investment when interest rates are 5.50 per...

A: Future value is the value of the asset at a particular time. The present value of the asset when bei...

Q: One-year Treasury bills currently earn 2.50 percent. You expect that one year from now, 1-year Treas...

A: As per the  liquidity premium hypothesis, an investor will hold bonds with long term maturity if the...

Q: What is the explanation for the mechanics of compounding?

A: Compound interest can be defined as the interest earned on principal amount and on all previous inte...

Q: Please show all equations and work as needed. Make the correct answer clear. If possible, please typ...

A: Note: Calculations are typed as per request for your convenienceWhen an IPO is priced below the poss...

Q: Optimal corporation wants to expand their manufacturing facilities. They have two choices, first to ...

A: It is given that firm must incur $290,000 for two years, if it chooses option 1. The second option i...

Q: Alshon, Inc. has 6.00% coupon bonds that have 11 years left until maturity. The bonds make annual pa...

A: Compute the current bond price:The current bond price is $897.08.Excel spread sheet:The future value...

Q: You would like to have $59,000 in 5 years for the down payment on a new house following graduation b...

A: Future Value= $59,000; No. of periods= 5*4= 20 years, Interest rate per period = 4.24/4= 1.0625.Sinc...

Q: Assume that in 2018, a copper penny struck at the Philadelphia mint in 1795 was sold for $405,000. ...

A: Calculation of rate of return on investment:Answer:The rate of return on investment is 8%Note:1cent ...