## Thursday, July 14, 2016

### HP 12C Programming Part II: Weekday Number, Gross Up Calculation

HP 12C Programming Part II:  Weekday Number, Gross Up Calculation

Here is Part II of the HP 12C programming series.

HP 12C Weekday Number

This program determines (“extracts” in a sense) the workday number of a given date.  I have this program set to work properly after January 6, 1800, which was a Monday.  The results translate as follows:

1 = MON
2 = TUE
3 = WED
4 = THU
5 = FRI
6 = SAT
7 = SUN

The HP 12C is assumed to be use the United States date format (M.DY – [ g ] [ 5 ]).

Program:
 STEP CODE KEY COMMENT 01 1 1 02 48 . Decimal point 03 0 0 04 6 6 05 1 1 06 8 8 07 34 X<>Y 08 43, 26 ΔDYS Days between dates function 09 7 7 10 10 ÷ 11 43, 24 FRAC 12 7 7 13 20 * 14 1 1 15 40 + 16 43, 33, 00 GTO 00

Input:  Date in MM.DDYYYY format, [R/S]
Result: Date indicator

Test 1: May 22, 1999.
Input:  5.221999 [R/S]
Result:  6 (Saturday)

Test 2:  July 11, 2016

Result:  1 (Monday)

HP 12C Gross Up Calculation

We have to pay a person, and the person lives outside of your tax jurisdiction (outside of your state or the United States).  Tax withholding may be required.  However, you or someone else that is requesting the payment wants the face amount.  In order to give the face amount and fulfill the tax requirement at the same time, the payment is must be grossed up.

Link to the Investopedia article:  http://www.investopedia.com/terms/g/gross-up.asp

Formulas:
Gross up Amount = Face Amount/(1 – Tax Rate%)
Amount of Tax = Gross up Amount – Face Amount

Program:
 STEP CODE KEY COMMENT 01 44, 0 STO 0 Store Tax Rate 02 34 X<>Y 03 44, 1 STO 1 Store Face Value 04 45, 0 RCL 0 05 1 1 06 25 % 07 1 1 08 30 - 09 16 CHS 10 45, 1 RCL 1 11 34 X<>Y 12 10 ÷ 13 31 R/S Display Gross up Amount 14 45, 1 RCL 1 15 30 - 16 43, 33, 00 GTO 00 Display Tax

Input:  face value, [R/S], tax rate, [R/S]
Result: gross amount, [R/S], tax

Part 1:  Face Value:  \$1,000, Tax Rate:  30%.
Input:  1000 [R/S], 30 [R/S]
Result:  1428.57 [R/S], 428.57 [R/S]
The gross up amount is \$1,428.57 (total amount to be paid), and corresponding tax is \$428.57.

Part 2:  Face Value:  \$2,500, Tax Rate:  7%.
Input:  2500 [R/S], 7 [R/S]
Result:  2688.17 [R/S], 188.17 [R/S]
The gross up amount is \$2,688.17 (total amount to be paid), and corresponding tax is \$188.17.

Another note, I will be taking some time off and plan to be back within two weeks.  I want to thank all of you readers and those who commentators, this blog would not be the success that it is without you.  Enjoy summer (or winter if you are in the Southern Hemisphere) and we'll talk again.

Eddie

This blog is property of Edward Shore, 2016.