Converting annual rate of return to quarterly equivalent?

I am having trouble coming up with a method to convert the annual total
return of an investment to the equivalent quarterly return that would
generate the same final value when compounded 4 times during the year--March
31, June 30, Sept 30, and Dec 31.

Suppose I start the year with 10,000 dollars and end the year with 11,000
dollars. The annual rate of return, compounded annual growth rate, or
whatever you want to call it is 10%, calculated by (11000/10000)-1=.1, or
10%.

What fixed quarterly rate would I have to earn for each of the 4 quarters to
generate the same 11,000 value on Dec 31, assuming quarterly compounding??
The quarterly ending dollar values (other than for Dec 31) are unknown and
irrelevant for this exercise.

Trial and error on a handheld tells me it's between 2.41% and 2.42% per
quarter, but how do I get there in Excel 2007?

I have fiddled with the Nominal and Effect functions to no avail and can't
see how IRR or XIRR would help. Maybe a mortgage or annuity function, about
which I am clueless?

Thanks for any help.

Carl


.

Relevant Pages

  • Re: Converting annual rate of return to quarterly equivalent?
    ... return of an investment to the equivalent quarterly return that would ... The annual rate of return, compounded annual growth rate, or ... I have fiddled with the Nominal and Effect functions to no avail and can't ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting annual rate of return to quarterly equivalent?
    ... return of an investment to the equivalent quarterly return that would ... The annual rate of return, compounded annual growth rate, or ... generate the same 11,000 value on Dec 31, assuming quarterly compounding?? ... I have fiddled with the Nominal and Effect functions to no avail and can't ...
    (microsoft.public.excel.worksheet.functions)
  • Re: rate of return on investment per annum
    ... If the "investment" were in the ... the answer would depend on the frequency of computing and ... investment in the money market, which typically compounds daily (in the ... the effect of compounding quarterly at some ...
    (microsoft.public.excel.misc)
  • Re: New User Quest. on Financial Formulas For Compount Interest, etc.
    ... length of investment ... number of compounding periods per year (e.g., 4, or quarterly ... The amount from the above example would be $3,290.66 ... to calculate the nominal quaterly rate provided by a 2.22% ...
    (microsoft.public.excel)
  • Re: Markets malaise?
    ... My investment guy was telling me about one guy who was so ... I locked in a 16% yield on CDs at the Credit ... Those funds built like you would not believe. ... and just keeps on a compounding away. ...
    (misc.invest.stocks)