HP 12c Calculator Logo

Related Topics:

Evgenia McLean Posted on Apr 04, 2011

How to Calculate IRR? - HP 12c Calculator

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 8 Answers
  • Posted on Apr 04, 2011
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Apr 04, 2011
Answers
8
Questions
0
Helped
7113
Points
26

To calculate IRR and NPVEnter the cash flows as follows, remembering the sign convention:

  • Clear previous data by pressing fXY and fCLX.
  • Enter the cash flow at time zero using # gPV [# CF0].
  • Enter subsequent cash flows using # gPMT [# CFj].
  • If a cash flow is repeated, enter the number of times it is repeated (including the first time you just entered) using # gFV [# Nj]. For example, three equal flows in a row would be entered as3 Nj.
  • When you have entered your last cash flow:
    • If you are calculating an NPV, enter your interest rate as # i (consistent with interval between cash flows) followed by fPV [NPV].

    • If you are calculating an IRR, enter fFV [IRR].
This is an excerpt from http://luna.pepperdine.edu/faculty/mkinsman/calculators/hp12c.html
I did not come up with this solution. Just found it for you.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
2answers

I invest 2000k in year 1, 2500k in year 2, 1500k in year 3 and 2000k in year 4. I received 10500k in return. What is my IRR and how do you calculate this?

https://www.mathsisfun.com/money/internal-rate-return.html
you have to guess what it is and I guess it to be 34.696 percent
From finance theory this is the finance formula
fv=pv(1+int)^n+pv2(1+int)^n2+pv3(1+int)^n3+pv4(1+int)^n4
10500=2000*(1.34696)^4+2500*(1.34696)^3+1500*(1.34696)^2+2000*(1.34696)^1
but I just used a spreadsheet and calculated the interest earned each year

calc-gxryzi4omhfnrc3u5p0h0fhq-2-0.png So in cell c2 formula is =b2+(b2*$b$9/100) d2 you copy cell c2 to it and the interest rate will not alter its cell position
f6 formula is =sum(f1:f5)
then when you finish you just keep altering irr value to get 10500.

The reason for irr is to compare putting your money say in a bank account or in the government bonds market and comparing it to the IRR for your investment in question to see if it is worthwhile .
A true outlook would be to also factor in inflation over this time frame however the other investments are also affected by deflation so you are comparing like returns
0helpful
1answer

Could you please help me .. Is it possible to calculare irr with casio fx 82 ms? Thank you very much

Internal Rate of Return (IRR) Calculation Using Casio MS ...

? 2:32
https://www.youtube.com/watch?v=7Lvqp_E54Y0
Apr 13, 2015 - Uploaded by Nurul Amin
Internal Rate of Return (IRR) Calculation Using Casio MS Scientific Calculator ... +Nurul Amin i have a casio fx-82ms can ialso calculate IRR?

Discounting Basics on Casio fx-991ES and fx-82MS ...

? 7:24
https://www.youtube.com/watch?v=Xs7rq4JI3mg
Feb 14, 2014 - Uploaded by Sujoy Krishna Das
Discount calculations on Casio fx-991ES and fx-82MS calculators .... Internal Rate of Return (IRR) Calculation Using Casio MS Scientific ...

0helpful
1answer

How to use irr function in it?

As you can easily verify by reading the user's guide this calculator does not have a financial utility, so you cannot calculate the Internal Rate of Return (IRR). Sorry to disappoint you.
1helpful
1answer

Hoe do I calculate the IRR (internal rate of return) on sharp EL531WH

Can anyone provide the steps for calculating IRR on the Sharp EL-531WH?
1helpful
1answer

Casio fx-991ES, how to calculate NPV and IRR

At a blank screen, enter your IRR formula in terms of the variables using ALPHA and ')' for variable X. For example: -1000 200/((1 X)^1) 200/((1 X)^2) ... rest of subsequent years. Then, press CALC. It will prompt you to enter values of your variable (X in this example). Don't worry if there's already a value displayed - this is just the most recent value that has been stored as that letter. Simply enter your value (in terms of your IRR guess) and then press [=]. You will have to repeat this for each IRR guess until you reach almost ZERO.
1helpful
1answer

Excel 2007

The IRR function is provided by Excel so you can calculate an internal rate of return for a series of values. The IRR is the interest rate accrued on an investment consisting of payments and income that occur at the same regular periods. In the values provided to the function, you enter payments you make as negative values and income you receive as positive values.
For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.
Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:
=IRR(D4:D8)
The function returns an IRR of 19.49%.
The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:
=IRR(D4:D8, -5%)
This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.
1helpful
1answer

How can I calculate IRR in MS Excel

=IRR(H29:O30,H35)

Where H29:O30 is your range of cells and estimate is H35.
0helpful
2answers

Calculating out npv and irr

Are you using the finance app?

[APPS] [1] [ENTER]

For NPV, choose "7:npv("
Then use:
npv(interest rate, cost {cash flows}, {frequencies of cash flows})

For IRR, choose "8:irr("
Then use:
irr(interest rate, cost {cash flows}, {frequencies of cash flows})
0helpful
1answer

Quaterly IRR

if your analysis is based annually, yes. if it is based quarterly, then you have to raise the derived irr to the 4th power (4 consecutive quarters) to arrive at the annualized irr.
4helpful
1answer

Calculating out npv and irr

Use the "FINANCE" app:

[APPS] [1] [ENTER]

for npv: select "7:NPV"
now you should get "npv(" on your screen.
use: npv(interest rate, cost {cash flows}, {frequencies of cash flows})


for irr: select "8: irr"
"irr(" will come up.
use: irr(interest rate, cost {cash flows}, {frequencies of cash flows})
Not finding what you are looking for?

2,622 views

Ask a Question

Usually answered in minutes!

Top HP Office Equipment & Supplies Experts

Cindy Wells

Level 3 Expert

6688 Answers

k24674

Level 3 Expert

8093 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Are you a HP Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...