E xp 0 0 02 h21 g3 007h204 032 h21 g3 g4 0192 t

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0 0.2 =H2*(1-G3) =0.07*H2*0.4 0.32 =H2*(1-G3-G4) 0.192 T o find P G i ve n F (P/ F ) P W (7 % ) =F3+I3 0.9346 =K3*J3 1.07 =M3*L3 =0.07*H3*0.4 =F4+I4 0.8734 =K4*J4 0.5531 =(L3+L4)*M4 =0.07*H4*0.4 =F5+I5 0.8163 =K5*J5 0.3811 =(L3+L4+L5)*M5 =0.07*H5*0.4 =F6+I6 0.7629 =K6*J6 0.2952 =0.07*H6*0.4 =F7+I7 0.713 =K7*J7 0.2439 0.0576 =H2*(1-G3-G4-G5) =H2*(1-G3-G4-G5G6) =H2*(1-G3-G4-G5G6-G7) =H2*(1-G3-G4-G5G6-G7-G8) =0.07*H7*0.4 =F8+I8 0.6663 =K8*J8 0.2098 0 0 =0.07*H8*0.4 =F9+I9 0.6227 0.1856 0 0 =0.07*H9*0.4 =F10+I10 0.582 =K9*J9 =K10*J1 0 0.1675 =(L3+L4+L5+L6)*M6 =(L3+L4+L5+L6+L7)* M7 =(L3+L4+L5+L6+L7+L 8)*M8 =(L3+L4+L5+L6+L7+L 8+L9)*M9 =(L3+L4+L5+L6+L7+L 8+L9+L10)*M10 G DS 8000 T o find A G i ve n P ( A /P) E U A C ( A f t e r T a x) 7750 =SUM(C3:E 3)*(1-0.4) =SUM(C4:E 4)*(1-0.4) =SUM(C5:E 5)*(1-0.4) =SUM(C6:E 6)*(1-0.4) =SUM(C7:E 7)*(1-0.4) =SUM(C8:E 8)*(1-0.4) =SUM(C9:E 9)*(1-0.4) =SUM(C10: E10)*(1-0.4) 8000 0 0 560 3000 4116 0 .2 6400 224 4340 0.9346 4056.16 1 .07 4340.09 1500 329 3000 2897.4 0 .32 3840 179.2 3076.6 0.8734 2687.1 0.5531 3729.71 2200 1000 224 3500 2834.4 0.192 2304 107.52 2941.92 0.8163 2401.49 0.3811 3485.07 4 1450 750 154 4000 2942.4 0.1152 1382.4 64.512 3006.91 0.7629 2293.97 0.2952 3376.71 5 950 500 101.5 4500 3060.9 0.1152 460.8 38.7072 3099.61 0.713 2210.02 0.2439 3328.93 6 600 350 66 . 5 5250 3399.9 0.0576 3.3307 E -13 12.9024 3412.8 0.6663 2273.95 0.2098 3340.58 7 300 300 42 6250 3955.2 0 0 9.3259 E -15 3955.2 0.6227 2462.9 0.1856 3412.37 21 775 0 4842.6 0 0 0 4842.6 0.582 2818.39 0.1675 3551.67 1 4700 2 3200 3 2200 4 1450 5 950 6 600 7 300 8 0 0 8000 1 4700 3300 2 3200 3 8 0 300 3000 3000 3500 4000 4500 5250 6250 0.1152 0.1152 T h e e con om i c l i f e of t h is e q u i p m e n t is 5 y e a r s, as E U A C (a f t e r t a x ) st a r ts i n c r e asi n g i n y e a r 6. ...
View Full Document

This note was uploaded on 01/20/2012 for the course INDUSTRIAL 343 taught by Professor Capponi during the Spring '11 term at Purdue University-West Lafayette.

Ask a homework question - tutors are online