> %$ Fɀ\pjeffreyf Ba==]("8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_) + ) , * ) ! # # @ @ @ @ $@ @
d""@ @ ) " 8@@ 8@ 8 @ 8 @ 8 8 !P) ! `q
present value$Sheet2%Sheet3 ;2 `i
1)2)3)5)Calculating IRR in ExceljThis worksheet demonstrates examples of using an Excel function to find the internal rate of return (IRR).gFollow these steps to use Excel's IRR function to find the internal rate of return for this investment:"%Click the function button (fx), select All in the left pane to display all Excel functions, and doubleclick IRR in the right pane. '*mpThis example assumes an estimated cost of $70,000 for beginning a business, and income of $12,000, $15,000, $18,000, $21,000, and $26,000 in the five years that follow.Excel displays the result in the output cell. The result for this example is 8.66%, which indicates the expected return on the $70,000 initial investment after five years.QZvNote: When you click on IRR, the formula is shown at the bottom of the Paste Function dialog box: =IRR(values,guess). btThe IRR formula [=IRR(values,guess)] consists of two fields. Values is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return. Guess is a number that you guess is close to the result of IRR.$=CJSelect the output cell for the solution. (For this example, use cell J34.)DH>The formula bar should now contain the formula: =IRR(J28:J33).0=WIRR is the internal rate of return of a cash flow stream associated with an investment.IRR is the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. IRR is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods. The "Values" field must contain at least one positive value and one negative value in order to calculate IRR. If there is no cash flow for an individual period within the investment duration, it must be represented as zero. IRR will return a periodic interest rate which may need to be annualized in order to compare to the cost of capital in making investment decisions.(The cursor automatically appears in the "Values" field, prompting you for the required data. To select the data range for this calculation, select the fields (click and drag) that constitute your data range. This data range appears in the "values" field. (For this example, the range is J28:J33.)&'3After you have entered the required data, click OK.024)Leave the "Guess" field blank.2Copyright 2001 UNext.com LLC. All rights reserved.e
{
Fɀ5)#
dMbP?_*+%MHP LaserJet 4050 Series PSS
oUXXLetterPRIV0''''\KhC"UXX??U}}I}I}}m} 5
@ @ @
@
,,,,,,,,
#$$$$$%&'''''(
""""""
"""""""""""""" """""""
""""""""""""""
"""""""""""""""""""""""""""""""""""""""""""""""""
""""""""""""""
""""""""""""""
)))))))~
~
p@
"""""""~
L@"""""""~
@~
@BXX&$&&&&0BB*
!
"
#
$
%
&
'
(
)
*
@+
,

.
/
0 1 2 3 4
+
""""""~
d@!"""""""! ""
#
#"#""""""$"""""""%"""""""&"""""""'(
(*
(******)
*
*+
,
,*,******.
." .""""""/"""""""0 1
1!1 2 3 4.<<$4.
2
00>@<dr./ #&((,, !7
Fɀ$
dMbP?_*+%"??U>@7
Fɀ%
dMbP?_*+%"??U>@7
Oh+'0HPdx
goodmanm jeffreyf Microsoft Excel@
{@c&ؔ@n5L՜.+,0$ PXlt
UNext.comvA
present valueSheet2Sheet3'present value'!Print_AreaWorksheets
Named Ranges
!"#Root Entry FWorkbook&SummaryInformation(DocumentSummaryInformation8