|
|
|
||||||||||||||||
|
|
|
|
|||||||||||||||
in association with
Pocket WorkSheet Samples
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Sample Depreciation
This example is specific to Pocket Worksheet for Pocket PC 2002. This sample worksheet computes depreciation of an asset based on the following formula:: B * (1-R)^(k-1) * R. A factor is used to specify the rate at which the asset depreciates. A factor of 2 yields results for the double-declining balance method.
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 Depreciation
0 C ShortDepreciation
B X (1-R)^(k-1) X R
BASIC
VALUES
$ 100,000.00 + Initial Cost
0 - Prior Period Depreciation
$ 100,000.00 = B (Adjusted Cost Basis)*
0 C
10 + N (Life of Asset in Years)*
0 C
10 + k (Period to Solve for in Years)*
0 C
Factor (2 for DDB; must be > 0)
2 + Factor*
0 C
COMPUTE
VALUES OF
EXPRESSIONS
100 + Depreciation Percent
2 X *Factor
100 / Convert Percent to decimal number
10 / *N (Life of Asset in Years)
$ 0.20 = R*
0 C
10 + *k (Period to Solve for in Years)
1 -
9 = k - 1*
0 C
1 +
$ 0.20 - *R
$ 0.80 = 1 - R*
0 C
$ 0.80 + *1 - R
9 Pwr *k - 1
0.134217728 = (1-R)^(k-1)*
0 C
APPLY THE
FORMULA
100,000 + *B (Adjusted Cost Basis)
0.134217728 X *(1-R)^(k-1)
$ 0.20 X *R
THE RESULT
$ 2,684.35 = Depreciation
Sample Depreciation with Full Commentary Text
0 C SampleDepreciation
Pocket WorkSheet (c) Publish or Perish Software
Press, 2002
SAMPLE
DEPRECIATION
This sample worksheet computes depreciation of an
asset based on the following formula:
B X (1-R)^(k-1) X R
A factor is used to specify the rate at which the asset
depreciates. A factor of 2 yields results for the
double-declining balance method.
The instructions describe how to edit basic values
required for the computation.
BASIC
VALUES
Tap the row below labeled "Initial Cost" to select it
and tap the Edit button. Change the value and tap
the Enter button on the calculator's Keypad to
complete the edit.
$ 100,000.00 + Initial Cost
0 - Prior Period Depreciation
$ 100,000.00 = B (Adjusted Cost Basis)*
0 C
Tap the row below labeled "N(Life of Asset...)" to
select it then tap the Edit Button. Change the value
and tap the Enter button.
10 + N (Life of Asset in Years)*
0 C
Tap the row below labeled "k(Period to Solve for
...)" to select it then tap the Edit button. Change the
value and tap the Enter button.
10 + k (Period to Solve for in Years)*
0 C
The FACTOR Factor (2 for DDB; must be
> 0)
2 + Factor*
0 C
COMPUTE
VALUES OF
EXPRESSIONS
R
100 + Depreciation Percent
2 X *Factor
100 / Convert Percent to decimal number
10 / *N (Life of Asset in Years)
$ 0.20 = R*
0 C
k - 1
10 + *k (Period to Solve for in Years)
1 -
9 = k - 1*
0 C
1 - R
1 +
$ 0.20 - *R
$ 0.80 = 1 - R*
0 C
(1-R)^(k-1)
$ 0.80 + *1 - R
9 Pwr *k - 1
0.134217728 = (1-R)^(k-1)*
0 C
APPLY THE
FORMULA
100,000 + *B (Adjusted Cost Basis)
0.134217728 X *(1-R)^(k-1)
$ 0.20 X *R
THE RESULT
$ 2,684.35 = Depreciation
Copyright © 2004 Publish or Perish Software Press. All rights reserved.
