Print
Published on by

How I have configured my HP15c for financial duties (III)

The NPV and IRR are other favourites. There is another program in the Advanced Functions Handbook, that allows for up to 24 groups of cashflows (assuming you do not have any other program in memory!) and using 68 steps. However, as I said before, in my company we limit Capital Expenditure Proposal analysis to 10 years, so that I set to make a shorter program for 10 cashflows.

Register 0 is for the initial investment. Register ,1 contains the number of years to calculate (good to limit the loop and increase speed). Registers 1 to ,0 contain the flows of each year.

The system takes X as discount rate (in %). It can be then used to find the IRR through the Solve feature, entering a bracket of guesses in X and Y.

screenshot.144.jpg
screenshot.145.jpg

Now we come to a weighted average calculator. In many occasions I need to get the average margin of all the brands we sell.

But the weighting in HP12c works inverse as I would do. It calculates the average of Y weighted by X, instead of the average of x weighted by Y.

The calculators is mine and I do as I want with it ;-), so I will put it here, together with a cash discount calculation/comparison. We assign the weighted average to the same key, i.e. GSB 0:




One of the typical decisions in my job is to decide on cash discounts - both when buying and selling. I want to compare the cash discount % with a yearly rate - and then decide. I put the standard payment days in Y, and the discount % in X, and get the equivalent yearly interest that I am getting (if I'm buying) or I'm paying (if I'm selling)

Here it is:

screenshot.146.jpg

 

Comments: 1
More about: HP 15c, hp ATMEL, hp15c, hp15c+

Comments: 1

Meg Sonteith |
RE: How I have configured my HP15c for financial duties (III)
i can still see this kind of calculator though of different brand in my grandmother's place. i guess i can ask for it as it may already have a huge value this days. just kidding. but perhaps this kind or type of calculator must be truly reliable considering that it's still being used sometimes by my uncle also. cheers.

<a href="http://buysoundcloud.com/">buy soundcloud plays</a>
Only registered users may post comments.
Sign in and post comment Register now