Blank L., Tarquin A. Engineering Economy (McGraw-Hill Series in Industrial Engineering and Management)

/

Format for Commonly Used Spreadsheet Functfon,s on Excel©

Present worth:

PV(i%,n,A,F)

NPV(i%,second_cell:lasCcell)

+

firsCcell

Future worth:

FV

(i %

,n,A,P)

Annual worth:

PMT(i

%

,n,P,F)

Number

of

periods (years):

NPER(i

% ,A,P,F)

\

for constant A series

for varying

ca

sh flow series

for constant A series

for single amounts with no A series

for constant A series

(Note:

The

PV

, FV, and

PMT

functions change the sense

of

the sign. Place a minus in front

of

the

function to retain the same sign.

The

NPV

and

IRR

functions take the sign

from

the tabulated cash

flows.)

Rate

of

return:

RATE(n,A,P,F)

IRR(firsC

cell

:lasC

cell)

Depreciation:

SLN(P,S,n)

DDB(P,S,n,t,d)

DB(P,S,n,t)

SYD(P,S,n,t)

Logical

IF

function:

IF

(logicaCtest,value_iCtrue,value_iCfalse)

One

function

may

be

imbedded into another function.

All functions

must

be

preceded

by

an = sign.

for constant A series

for varying

ca

sh flow series

Straight line depreciation for each period

Double declining balance depreciation for

period t at rate d (optional)

Declining balance, rate determined

by

the

function

Sum-of-year-digits depreciation for period t

For

logical two-branch operations

.,

,

,..

%

per

t

C~

f

t

=t'

(.

::=.r

·

....

,

-=

~

i.

::;(

I r

::'

-)

""-

,

Relations for Discrete Cash Flows with End-of-Period Compounding

Factor Notation

Sample Cash Flow

Type Find/Given and Formula

Relation Diagram

F/ P

(F

/ P,i,n) =

(1

+ i)"

F =

P(F

/ P,i,n)

F

Compound

Single

amount

o

-In

Amount

P/ F

(P/ F,i,n) =

(1

~

i)"

P

=

F(P

/

F,i

,n)

r-+

"

Present

worth (Sec. 2.1)

P

PIA

(P/A

,i,n) =

(1

+ i)" - 1

P =

A(P/A,i,n)

A

A'

" A A

Present

i(1 + i)"

r4

...

~

worth

A/ P

(A/ P,i,n) =

i(1 + i)"

A = P(A/ P,i,n)

(1 + i)" - 1

Capital

P

Uniform

recovery (Sec. 2.2)

Series

(1

+ i)" - 1

F/A

(F

/A,i,n) =

F =

A(F

/A,i,n) F

Compound

i

amount

o 1

'"~"

A/F

(A/F,i

,n) =

i

A

=

F(A/

F,i,n)

11

'"

Sinking

(1

+

0"

- 1

fund (Sec. 2.3)

A A

"'A

A

P

cl

C

(P/

Cin)

j

(1

+ i)" - in -

1

~

P

G

=

C(P

/ C,i,n)

Pc

, , i

2

(

1 + on ;

~A

"

A

"

Present

Arithmetic

worth

Gradient

(A

/ C,i,n) = 1 -

n

o 1 ,.

,H"

A

ci

C

(1

+ on - 1

AG = C(A/ C,i,n)

G 2G -

--_

Uniform

I

4000

0

(

n-l

) G

series

(Sec. 2.5)

A{I-

(~r]

AI

(1+g

)

,,

-1

P/ A

I

and g

g*i

AIA~(l::~)(J

Geometric

i - g

Gradient

Present

P =

rR

"-1"

g

worth

A_n_

g = i

II

+ i

(Sec. 2.6)

~

J

,/0 V

e><-r~""

+

Col.

5u_

Y"'IO"';-~>

.fro"""

A-t

Surn~

1::-'

f.t!/,t!-:>f fl..o.fe..

I

t:Jf

C<

+~"...,

y~~.,..,

5

+ro

.........

...v h

(/.

f

v--V

v I J

be

f-",

~

v

c"

I v

e.

7

1"'1

ow

~

ell

Q_

o 1

2345""J117

S'C(t

Jr

{I

II>

Ic?b

Q,o

y

"'

> = 'oo(I-l-,OS),b

~

~,~

~----------------------------------~-------------

,'>

e5+

,

'

~.::.

f~J

p

r

~V

I

·

OV;'.

r~

5e+

00

110

r-

c:<~o

LJ

0"\

f-

(Jt-

1"1-,-<.

'1

ex

t /

by~c<"">,

1,0

........

5R-.J-

..

.

Sf

'

cJ

C-

+b

c-

()

ve..-

&1./1

P::;

z.

5'"

0 0 (

PIA.(

rL

)

/Q)

-t

'Sb

C L ? I

{,

/ I

(Z

I

b)

Z

')

00

C

4.

III

'i)

+

~o

tt..

fS

. 'l3 0

-z.)

:: I }

<..)

7

LI

"5

. b D

A-

=

l'i'"

""3 I

to

(hi

P, . I

Z-I

' )

---

-

l i!

),'1

'70

z)

,--.

....

----

S ix

6"

ENGINEERING

ECONOMY

$"'0

0;

000.:

F(

If

,

Oct3)

36

!Jii.

D;JSs

.

7?J

j)

yDu

blA-r""o,v

'6

,

000

f-PJ(

-.

y 'I-

4j/'e..e

f~

/1"

(..

,:>':,/

5 "'''''ple.-

//l

fe".

~.>""

'I

t..f>

h<J,:I><JI'1J

e

d (

/-10

LA.--'

,....,

v L

~

(,A.;

d (

~

w

o I

~

1

4J

-

I

~CO()

F

~

t5OC>o(

q

)~

0

'1

)

+-

$.£0

DO

[i!;-Zt[D]

---

McGraw-Hili

Series in

Industrial

Engineering

and

Management

Science

Consulting

Editors

Kenneth E. Case, Department

of

Industrial Engineering and Management,

Oklahoma State

University

Philip

M.

Wolfe, Department

of

Industrial and Management Systems Engineering,

Arizona State

University

Blank

and

Tarquin: Engineering Economy

Chapra:

Applied Numerical Methods with MATLAB for Engineers and Scientists

Grant

and

Leavenworth: Statistical Quality Control

Gryna:

Quality Planning and Analysis: From Product Development through Use

Harrell, Ghosh,

and

Bowden: Simulation Using PROMODEL

Hillier

and

Lieberman:

Introduction

to

Operations Research

Kelton, Sadowski,

and

Sturrock:

Simulation with Arena

Law

and

Kelton: Simulation Modeling and Analysis

Navidi:

Statistics for Engineers and Scientists

Niebel

and

Freivalds: Methods, Standards, and Work Design

ENGINEERING

ECONOMY

Leland Blank,

P.

E.

American University

of

Sharjah, United Arab Emirates and

Texas A

& M University

Anthony Tarquin,

P.

E.

University

of

Texas at El Paso

R

Higher

Education

Boston Burr Ridge,

IL

Dubuque,

IA

Madison,

WI

New

York

San

Francisco

St.

Louis

Bangkok Bogota Caracas

Kuala Lumpur Lisbon London Madrid Mexico City

Milan Montreal New Delhi Santiago Seoul Singapore Sydney Taipei Toronto

The

McGraw

'HiII

Compames

~

_

II

Higher

Education

ENGINEERING ECONOMY, SIXTH EDITION

Published

by McGraw-Hili, a business unit

of

The McGraw-Hili Companies, Inc., 1221 Avenue

of

the Americas, New York, NY

198

of

this

publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without

th

e

prior written conse

nt

of

The

McGraw-Hili Companies, lnc., including, but not limited to,

in

any network or other electronic storage

or transmission, or broadcast for distance learning.

Some ancillaries, including electronic and print components, may not be available

to

customers outside the United States.

This book is printed on acid-free paper.

2 3 4 5 6 7 8 9 0 QPF/QPF 0 9 8 7 6 5

ISBN

0-07-320382-3

Pub

li

sher: Elizabeth A.

Jon

es

Senior Sponsoring Ed

it

o

r:

Su

za

nne

Jeans

Developmental Editor:

Amanda

J. Green

Senior Market

in

g Mana

ge

r:

Mary

K.

Kitte

LL

Project Manage

r:

J

oyce

Watters

Senior Production Supervisor:

Sherry

L.

Kane

Media Technology Producer: Eric A. W

eber

Senior Coordinator

of

Freelance Design:

Mi

c

hell

e

D.

Whitaker

Cover Designer: True

Blu

e Desig

n/Chad

Kreel

(USE) Cover Images: (l

ef

er

Comstock

Images/Get

ty

ges

Compositor: Int

erac

tive

Compos

iti

on

Corporatio

ll

Typeface:

/0

/

/2

Times Ro

man

Printe

r:

Queb

eco

r Wo

rld

Fairfie

ld

,

PA

Library

of

Congress

Cataloging-in-Publication Data

Blank, Leland

T.

Engineering economy I Leland Blank. - 6th ed.

p.

em. - (McGraw-Hi

li

se

ri

es

in

industrial engineering and management science)

Includes bibliographical references and indexes.

ISBN 0-07

-3

20382

-3

(hard

copy:

alk. paper)

I.

Engineering economy.

I.

Title.

II.

Series.

TA

I 77.4.B58 2005

658.15'2-dc22

2004016408

CIP

www.mhhe.com

This

book

is

dedicated

to

our

mothers

for their ever-present

encouragement

to

succeed

in

all

aspects

of

life.

Blank L., Tarquin A. Engineering Economy (McGraw-Hill Series in Industrial Engineering and Management)

Подождите немного. Документ загружается.