|
|
|
||||||||||||||||
|
|
|
|
|||||||||||||||
in association with
Pocket WorkSheet Samples
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Sample National Debt
This example is specific to Pocket Worksheet for Pocket PC 2002. This worksheet computes the National Debt and US Population for a future date. It then uses a Loan Payment calculation to determine the Monthly Debt Payment per Person to pay off the National Debt within 30 years of the future date (assuming the Debt total "freezes" after payment starts!).
A short and long form of the worksheet are shown below. Commentary text is removed in the short form to emphasize functional content.
Short Sample National Debt
0 C ShortNationalDebt
SAMPLE
NATIONAL
DEBT
BASELINE
DATA
$ 6,019,332,312,247.55 + National Debt May 31, 2002*
0 C
5/31/2002 + Baseline Date*
0 C
$ 1,111,000,000.00 + Average Daily Increase Since Sep 28, 2001*
0 C
287,170,000 + Population on Baseline Date*
0 C
1 + Person
11 / Every N Seconds
0.09 = Population Increase/Second*
0 C
AVERAGE
DAILY
POPULATION
INCREASE
0.09 + *Population Increase/Second
60 X Seconds/Minute
60 X Minutes/Hour
24 X Hours/Day
7,776 = Avg Daily Population Increase*
0 C
FUTURE
DATE
1/1/2003 + Future Date
5/31/2002 - *Baseline Date
D 215 = ( 7 Mos 1 Day )*
0 C
PROJECTED
DEBT
215 + *( 7 Mos 1 Day )
$ 1,111,000,000.00 X *Average Daily Increase Since Sep 28, 2001
$ 238,865,000,000.00 = Increase in National Debt
$ 6,019,332,312,247.55 + *National Debt May 31, 2002
$ 6,258,197,312,247.55 = Projected National Debt*
0 C
PROJECTED
POPULATION
7,776 + *Avg Daily Population Increase
215 X *( 7 Mos 1 Day )
1,671,840 = Projected Population Increase
287,170,000 + *Population on Baseline Date
288,841,840 = Projected Population*
0 C
DEBT
PAYMENT
$ 33,595,356,382.91 + Payment (5%, *6258197312247.55, 30 Yrs, End)
288,841,840 / *Projected Population
MONTHLY
PAYMENT
PER
PERSON
$ 116.31 = Monthly Debt Payment/Person
Sample National Debt with Full Commentary Text
0 C SampleNationalDebt
Pocket WorkSheet (c) Publish or Perish Software
Press, 2002
SAMPLE
NATIONAL
DEBT
This worksheet computes the National Debt and US
Population for a future date. It then uses a Loan
Payment calculation to determine the Monthly Debt
Payment/Person to pay off the National Debt within 30
years of the future date (assuming the Debt total
"freezes" after payment starts).
This example explains how to modify baseline data,
loan parameters, and the date. Basic understanding
of the calculator is assumed. The SampleBudget
worksheet is a good introduction to basic
calculator concepts.
BASELINE
DATA
First we entered some baseline values which will
be "Used" later in the worksheet.
Each entry is followed by a CLEAR (C).
This is a simple technique to create a set of defined
values which can be "Used" later in one or more
places. If we want to change the values, we just
need to change them here, and the calculations Using
them will be automatically updated.
See the website www.publicdebt.treas.gov/opd/oddpenny.htm
for Public Debt data
$ 6,019,332,312,247.55 + National Debt May 31, 2002*
0 C
5/31/2002 + Baseline Date*
0 C
$ 1,111,000,000.00 + Average Daily Increase Since Sep 28, 2001*
0 C
See the website www.census.gov/cgi-bin/popclock
for Population Data
287,170,000 + Population on Baseline Date*
0 C
To change the population growth rate, tap the row
below labeled "Every N Seconds" to select it. This
is the number of seconds it takes for the population to
increase by one person.
Tap the Edit button. Change the value to the current
value. Tap the Enter button to complete the Edit.
1 + Person
11 / Every N Seconds
0.09 = Population Increase/Second*
0 C
AVERAGE
DAILY
POPULATION
INCREASE
0.09 + *Population Increase/Second
60 X Seconds/Minute
60 X Minutes/Hour
24 X Hours/Day
7,776 = Avg Daily Population Increase*
0 C
FUTURE
DATE
Here you can change the future date for projecting
a new National Debt amount.
Tap the row labeled "Future Date" to select it. Tap the
Edit button. Change the Date and tap the Enter
button on the Calendar.
1/1/2003 + Future Date
5/31/2002 - *Baseline Date
D 215 = ( 7 Mos 1 Day )*
0 C
PROJECTED
DEBT
NOTE
Date results, such as the number of days difference
computed above, must be "Used" outside of a date
context, because the date context restricts
operations to + and -. We want to multiply the number
of days by average daily increases.
215 + *( 7 Mos 1 Day )
$ 1,111,000,000.00 X *Average Daily Increase Since Sep 28, 2001
$ 238,865,000,000.00 = Increase in National Debt
Add the baseline National Debt.
$ 6,019,332,312,247.55 + *National Debt May 31, 2002
Display the Projected National Debt.
$ 6,258,197,312,247.55 = Projected National Debt*
0 C
PROJECTED
POPULATION
7,776 + *Avg Daily Population Increase
215 X *( 7 Mos 1 Day )
1,671,840 = Projected Population Increase
287,170,000 + *Population on Baseline Date
288,841,840 = Projected Population*
0 C
DEBT
PAYMENT
Next we calculate the monthly payment by each US
resident using the menu View/Financial. We use an
interest rate of 5% and a payment period of 30 years
and assume the debt does not increase.
You can change values, like the interest rate (we used
5%) or the peiod.
Tap the row below labeled "Payment ..." to select it.
Tap the Edit button. The Financial View will
automaticaly open.
Change the percent from 5 to 6. Tap the Enter button
on the Financial View and tap the Enter button again
on the Standard Keypad to complete the Edit.
The new payment amount will be updated.
$ 33,595,356,382.91 + Payment (5%, *6258197312247.55, 30 Yrs, End)
Divide by the population
288,841,840 / *Projected Population
MONTHLY
PAYMENT
PER
PERSON
The following result represents the monthly
payment to be made by every man, woman, and child
regardless of age or ability to pay!!!
$ 116.31 = Monthly Debt Payment/Person
Copyright © 2004 Publish or Perish Software Press. All rights reserved.
