Texas Instruments BA-20 Profit Manager User Manual - Page 96

Gross Profit Margin, Selling Price, Profit Margin, Breakeven, Days between Dates

Page 96 highlights

where: OLD =old value NEW =new value %CH =percent change #PD =number of periods Profit Margin Gross Profit Margin = S----e--l--l--i-n----g----P---r--i--c---e---------C----o---s---t Selling Price × 100 Breakeven PFT = P Q N (FC + VC Q) where: PFT =profit P =price FC =fixed cost VC =variable cost Q =quantity Days between Dates With the Date worksheet, you can enter or compute a date within the range January 1, 1950, through December 31, 2049. Actual/actual day-count method Note: The method assumes the actual number of days per month and per year. DBD (days between dates) = number of days II - number of days I Number of Days I= (Y1 - YB) Q 365 + (number of days MB to M1) + DT1 + (---Y----1----------Y---B-----) 4 Number of Days II=(Y2 - YB) Q 365 + (number of days MB to M2) + DT2 + (---Y----2----------Y---B-----) 4 92 Appendix - Reference Information

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114

92
Appendix — Reference Information
where:
OLD
=old value
NEW
=new value
%CH
=percent change
#PD
=number of periods
Profit Margin
Breakeven
PFT
=
P Q
N
(
FC
+
VC
Q
)
where:
PFT
=profit
P
=price
FC
=fixed cost
VC
=variable cost
Q
=quantity
Days between Dates
With the Date worksheet, you can enter or compute a date within the
range January 1, 1950, through December 31, 2049.
Actual/actual day-count method
Note:
The method assumes the actual number of days per month and
per year.
DBD
(days between dates) =
number of days II
-
number of days I
Number of Days I
= (
Y
1
-
YB
)
Q
365
+ (
number of days MB to M1
)
+
DT
1
+
Number of Days II
=(
Y
2
-
YB
)
Q
365
+ (
number of days MB to M2
)
+
DT2
+
Gross Profit Margin
Selling Price
Cost
Selling Price
-----------------------------------------------
100
×
=
Y
1
YB
(
)
4
------------------------
Y
2
YB
(
)
4
------------------------