Tabellab
Science & Engineering Intermediate

Engineering Economics in Excel

Compare machines, pumps and public projects the way engineers do: interest factors, present and annual worth, incremental ROR, B/C ratios, MACRS depreciation, replacement and break-even, every cell checked live.

8 lessons 8 labs 1.9 h Certificate

The first lesson is free — no account needed.

About this course

An engineering economics course in Excel that compares machines, pumps and public projects the way engineers, and the engineering economy part of the FE exam, do. You build cash-flow tables and the F/P, P/F, P/A and A/P interest factors, compare two alternatives by present worth, handle unequal lives with annual worth (EUAC), rank machines by rate of return and incremental ROR, test a public project with the benefit/cost ratio, build a MACRS depreciation table with after-tax cash flow, decide when a challenger should replace the defender and find break-even operating hours with a sensitivity chart. The first lab is free.

Lessons

  1. Cash-Flow Tables & Interest Factors: F/P, P/F, P/A, A/PLab14 minFree
  2. Present Worth Comparison: Two Alternatives with Equal LivesLab14 min Pro
  3. Annual Worth with Unequal Lives: EUACLab14 min Pro
  4. Rate of Return & Incremental ROR Between Two MachinesLab15 min Pro
  5. Benefit/Cost Ratio for a Public ProjectLab13 min Pro
  6. Depreciation Methods, a MACRS Table & After-Tax Cash FlowLab16 min Pro
  7. Replacement Analysis: Defender vs ChallengerLab14 min Pro
  8. Break-Even Hours & a Sensitivity ChartLab15 min Pro