Formulas for Break-Even Analysis Spreadsheet

Everything HP200LX: Knowledge, Products, Service

Archives
9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Links
Most useful, up-to-date Web sites devoted to the HP 200LX

Downloads
Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

Privacy Policy

Formulas for Break-Even Analysis Spreadsheet

`Formulas for Break-Even Analysis Spreadsheet`

B1: [W8] ' BREAK-EVEN ANALYSIS
A2: [W5] \-
B2: [W8] \-
C2: \-
D2: \-
E2: \-
A3: [W5] ' SELLING PRICE PER UNIT : $
D3: (C2) U 29.95
A5: [W5] ' TOTAL FIXED COSTS : $
D5: (,0) U +<<COSTS.WK1>>FIXCOSTS
A7: [W5] ' VARIABLE COST PER UNIT : $
D7: (C2) U +<<COSTS.WK1>>VARCOSTS
A8: [W5] \-
B8: [W8] \-
C8: \-
D8: \-
E8: \-
A10: [W5] ' BREAK EVEN QUANTITY:
D10: (,0) @IF(D3=0,0,+D5/(D3-D7))
B13: [W8] ^ X
C13: ^ A
D13: ^ B
B14: [W8] ^ BE
C14: "SALES
D14: " COST
B15: (F1) [W8] 0
C15: (F1) +B15*$D$3
D15: (F1) +$D$5+(B15*$D$7)
B16: (F1) [W8] 0.1*(2*$D$10)
C16: (F1) +B16*$D$3
D16: (F1) +$D$5+(B16*$D$7)
B17: (F1) [W8] 0.2*(2*$D$10)
C17: (F1) +B17*$D$3
D17: (F1) +$D$5+(B17*$D$7)
B18: (F1) [W8] 0.3*(2*$D$10)
C18: (F1) +B18*$D$3
D18: (F1) +$D$5+(B18*$D$7)
B19: (F1) [W8] 0.4*(2*$D$10)
C19: (F1) +B19*$D$3
D19: (F1) +$D$5+(B19*$D$7)
B20: (F1) [W8] 0.5*(2*$D$10)
C20: (F1) +B20*$D$3
D20: (F1) +$D$5+(B20*$D$7)
B21: (F1) [W8] 0.6*(2*$D$10)
C21: (F1) +B21*$D$3
D21: (F1) +$D$5+(B21*$D$7)
B22: (F1) [W8] 0.7*(2*$D$10)
C22: (F1) +B22*$D$3
D22: (F1) +$D$5+(B22*$D$7)
B23: (F1) [W8] 0.8*(2*$D$10)
C23: (F1) +B23*$D$3
D23: (F1) +$D$5+(B23*$D$7)
B24: (F1) [W8] 0.9*(2*$D$10)
C24: (F1) +B24*$D$3
D24: (F1) +$D$5+(B24*$D$7)
B25: (F1) [W8] 2*$D$10
C25: (F1) +B25*$D$3
D25: (F1) +$D$5+(B25*$D$7)

Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.