Home » HP Manuals » Calculators » HP 12C#ABA » Manual Viewer

HP 12C#ABA hp 12c_solutions handbook_English_E.pdf - Page 77

Seasonal Variation Factors Based on Centered Moving Averages

UPC - 492410746430

Add to My Manuals
Save this manual to your list of manuals

Page 77 highlights

00 131760 300500 271120 171,393.33 144,790.00 207,440.00 234,460.00 3-month average for March. 3-month average for April. 3-month average for May. 3-month average for June. Seasonal Variation Factors Based on Centered Moving Averages. Seasonal variation factors are useful concepts in many types of forecasting. There are several methods of developing seasonal moving averages, on the of more common ways being to calculate them as a ration of the periodic value to a centered moving average for the same period. For instance, to determine the sales for the 3rd quarter of a given year a centered moving average for that quarter would be calculated from sales figures from the 1st, 2nd, 3rd and 4th quarters of the year and the 1st quarter of the following year. The seasonal variation factor for that 3rd quarter would then be the ration of the actual sales in the 3rd quarter to the centered moving average for that quarter. While quarterly seasonal variations are commonly used, the HP 12C can also be programmed to calculate monthly seasonal variations using a centered 12 month moving averages. Programs for both of these calculations are represented here: An HP 12C program to calculate the quarterly seasonal variations based on a centered 4-point moving average is: KEYSTROKES DISPLAY CLEAR 1 2 2 1 3 00- 01- 45 1 02- 2 03- 10 04- 45 2 05- 44 1 06- 40 07- 45 3 76

Section	Page
Introduction	2
Real Estate	3
Refinancing	3
Wrap-Around Mortgage	4
Income Property Cash Flow Analysis	8
a. What is the Effective Gross Income?	8
b. What is the Net Operating Income?	8
c. What is the Cash Throw-Off to Equity?	8
Lending	21
Loan With a Constant Amount Paid Towards Principal	21
Add-On Interest Rate Converted to APR	22
APR Converted to Add-On Interest Rate.	23
a. Key in number of months of loan and press .	23
b. Key in APR and press .	23
c. Key in 100 and press .	23
Add-On Rate Loan with Credit Life.	24
Interest Rebate - Rule of 78's	28
Graduated Payment Mortgages	30
a. The current year. Then press to continue.	34
b. The monthly payment for the current year. Then press to continue.	34
c. The remaining balance to be paid on the loan at the end of the current year. Then press to ret...	34
Variable Rate Mortgages	35
a. Key in the previous remaining balance. If this is the first mortgage adjustment, this value is...	36
b. Key in the annual interest rate before the adjustment (as a percentage) and press .	36
c. Key in the number of years since the last adjustment. If this is the first mortgage adjustment...	36
d. Key in the monthly payment over this period and press .	36
e. Press to find the remaining balance, then press CLEAR .	36
a. Key in the remaining life of the mortgage (years) and press .	36
b. Press to find the new monthly payment.	36
c. Key in the present monthly payment and press .	36
d. Press 12 to find the remaining term of the mortgage in years.	36
Skipped Payments	37
Savings	39
Initial Deposit with Periodic Deposits	39
Number of Periods to Deplete a Savings Account or to Reach a Specified Balance.	40
Periodic Deposits and Withdrawals	40
Savings Account Compounded Daily	42
Compounding Periods Different From Payment Periods	45
Investment Analysis	48
Lease vs. Purchase	48
Break-Even Analysis	53
a. Key in the fixed costs, F and press 1.	57
b. Key in the variable costs per unit, V and press 2.	57
c. Key in the unit price, P (if known) and press 3.	57
d. Key in the sales volume, U, in units (if known) and press 4.	57
e. Key in the gross profit, GP, (if known) and press 5.	57
a. Store values as shown in 1a, 1b, and 1c.	57
b. Key in the desired gross profit (zero for break even) and press 5.	57
c. Press 10 to calculate the required volume.	57
a. Store values as shown in 1a, 1b, 1c, and 1d.	57
b. Press 05 to calculate gross profit.	57
a. Store values as shown in 1a, 1b, 1d, and 1e.	57
b. Press 16 to calculate the required sales price.	57
Operating Leverage	58
Profit and Loss Analysis	60
a. Key in the list price in dollars (if known) and press 1.	63
b. Key in the discount in percent (if known) and press 2.	63
c. Key in the manufacturing cost in dollars (if known) and press 3.	63
d. Key in the operating expense in percent (if known) and press 4.	63
e. Key in the net profit after tax in percent (if known) and press 5.	63
a. Do steps 2 and 3b, c, d, e above.	63
b. Press 3 1 14 00.	63
a. Do steps 2 and 3a, c, d, e above.	63
b. Press 3 29 .	63
a. Do steps 2 and 3a, b, d, e, above.	63
b. Press 13 01 .	63
a. Do steps 2 and 3a, b, c, e, above.	63
b. Press 12 38 .	63
a. Do steps 2 and 3a, b, c, d, above.	63
b. Press 12 43 .	64
Securities	66
After-Tax Yield	66
Discounted Notes	68
a. Key in the discount rate and press 5.	70
b. Press to calculate the purchase price.	70
c. Press to calculate the yield.	70
d. For a new case, go to step 3.	70
a. Key in the price and press 5.	70
b. Press 15 to calculate the yield.	70
c. For a new case, go to step 3.	70
Forecasting	72
Simple Moving Average	72
Seasonal Variation Factors Based on Centered Moving Averages.	77
a. Key in 1st quarter sales and press 1.	78
b. Key in 2nd quarter sales and press 2.	79
c. Key in 3rd quarter sales and press 3.	79
d. Key in 4th quarter sales and press 4.	79
e. Key in the 1st quarter sales for the next year and press 5.	79
Gompertz Curve Trend Analysis	83
Forecasting with Exponential Smoothing	88
Pricing Calculations	94
Markup and Margin Calculations	94
Calculations of List and Net prices With Discounts	96
Statistics	100
Curve Fitting	100
Standard Error of the Mean	107
Mean, Standard Deviation, Standard Error for Grouped Data	108
Chi-Square Statistics	111
Normal Distribution	114
Covariance	118
Permutation	120
Combination	122
Random Number Generator	123
Personal Finance	125
Homeowners Monthly Payment Estimator	125
Tax-Free Individual Retirement (IRA) of Keogh Plan.	128
Stock Portfolio Evaluation and Analysis	131
Canadian Mortgages	137
Periodic Payment Amount	137
Number of Periodic Payments to Fully Amortize a Mortgage	138
Effective Interest Rate (Yield)	138
Balance Remaining at End of Specified Period	138
Miscellaneous	140
Learning Curve for Manufacturing Costs	140
a. Key in C1, the cost of the first unit and press .	143
b. Key in Cn, the cost of the nth unit and press .	143
c. Key in n, the number of units and press to calculate r the learning factor.	143
a. Key in C1 and press 1. Key in r and press 2. (Note: This step may be skipped if step 2 has jus...	143
b. Key in the number of units, n and calculate Cn, the cost of the nth unit by pressing 16 .	143
a. Key in C1 and press 1. Key in r and press 2. (Note: This step may be skipped if step 2 has jus...	143
b. Key in the number of the last unit of the batch, j and press .	143
c. Key in the number of the first unit of the batch, i, and calculate the average cost per unit b...	143
Queuing and Waiting Theory	144
Appendix	151
Real Estate	151
Lending	152
Savings	153
Investment Analysis	154
Securities	155
Forecasting	155
Pricing Calculations	158
Statistics	160
Personal Finance	162
Canadian Mortgages	163