Economic Engineering Evaluating Alternatives (Excel)
You are to compare the presented equipment investments across a range of MARR values. Using MicroSoft Word and Excel you will include (1) an information block, (2) data block, (2) analysis block, (4) graphics block, (5) discussion block, and Conclusions (6).
Data:
Data
Krax Seamer
Split-Co Seamer
Life (years)
9
9
Purchase Price
$ 202,000
$ 285,000
Annual Benefits
$ 73,000
$ 88,000
Benefits Gradient
$ 1,200
$ 1,300
Annual O&M Costs
$ 18,000
$ 34,000
O&M Gradient
$ 600
$ 1,100
Salvage Value
$42,000
$48,000
Loan
Krax Seamer
Split-Co Seamer
Down Payment (% of Purchase Price)
30%
30%
Loan Period (years)
6
9
Loan Payment
$34,392.11
$37,441.93