Applied Engineering Economics Using Excel

Applied Engineering Economics Using Excel

Author: Merwan Mehta

Publisher: Industrial Press

Published: 2014-10

Total Pages: 0

ISBN-13: 9780831135010

DOWNLOAD EBOOK

This must-have textbook for students in mechanical, civil, and electrical engineering departments addresses issues not sufficiently covered by existing engineering economics texts. Clearly presenting fundamental concepts that engineering students need to master in one semester, the author effectively applies an incremental learning method, starting with resolving personal financial matters and gradually progressing to the complexities of engineering economic calculations. Ample practical examples and exercises with answers at the end of each chapter teach students to solve problems using Microsoft Excel without the need for calculus. Future engineers also will gain valuable skills such as the ability to effectively communicate the results of their analyses to financial professionals.


Fundamentals of Economics for Applied Engineering

Fundamentals of Economics for Applied Engineering

Author: S. Kant Vajpayee

Publisher: CRC Press

Published: 2019-08-02

Total Pages: 418

ISBN-13: 0429581173

DOWNLOAD EBOOK

An easy-to-follow contemporary engineering economics text that helps making sound economic decisions without advanced mathematics. This one-semester introduction to the fundamentals of engineering economics provides an overview of the basic theory and mathematics underlying operational business decisions that engineering technology, engineering, and industrial technology students will face in the workplace. A basic knowledge of economics empowers a manager to balance costs with production. This new edition of Fundamentals of Economics for Engineering Technologists and Engineers is written in plain language. Concepts have been simplified and kept straightforward with an emphasis on "how to apply" economic principles. Practical examples as a tool for managing business data and giving detailed analysis of business operations. throughout the text make good use of Microsoft Excel templates, provided on the book’s companion website, for students. Chapter-end exercises provide discussion and multiple-choice questions along with numerical problems, and a solutions manual and instructor resources is given for adopting instructors.


Fundamentals of Engineering Economic Analysis

Fundamentals of Engineering Economic Analysis

Author: John A. White

Publisher: John Wiley & Sons

Published: 2020-07-28

Total Pages: 546

ISBN-13: 1118881060

DOWNLOAD EBOOK

Fundamentals of Engineering Economic Analysis offers a powerful, visually-rich approach to the subject—delivering streamlined yet rigorous coverage of the use of economic analysis techniques in engineering design. This award-winning textbook provides an impressive array of pedagogical tools to maximize student engagement and comprehension, including learning objectives, key term definitions, comprehensive case studies, classroom discussion questions, and challenging practice problems. Clear, topically—organized chapters guide students from fundamental concepts of borrowing, lending, investing, and time value of money, to more complex topics such as capitalized and future worth, external rate of return, deprecation, and after-tax economic analysis. This fully-updated second edition features substantial new and revised content that has been thoroughly re-designed to support different learning and teaching styles. Numerous real-world vignettes demonstrate how students will use economics as practicing engineers, while plentiful illustrations, such as cash flow diagrams, reinforce student understanding of underlying concepts. Extensive digital resources now provide an immersive interactive learning environment, enabling students to use integrated tools such as Excel. The addition of the WileyPLUS platform provides tutorials, videos, animations, a complete library of Excel video lessons, and much more.


Professional Financial Computing Using Excel and VBA

Professional Financial Computing Using Excel and VBA

Author: Donny C. F. Lai

Publisher: John Wiley & Sons

Published: 2011-12-28

Total Pages: 372

ISBN-13: 1118179080

DOWNLOAD EBOOK

"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) "Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks." Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong "Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs


Intermediate Microeconomics with Microsoft Excel

Intermediate Microeconomics with Microsoft Excel

Author: Humberto Barreto

Publisher: Cambridge University Press

Published: 2009-06-15

Total Pages: 593

ISBN-13: 0521899028

DOWNLOAD EBOOK

This unique text uses Microsoft Excel® workbooks to instruct students. In addition to explaining fundamental concepts in microeconomic theory, readers acquire a great deal of sophisticated Excel skills and gain the practical mathematics needed to succeed in advanced courses. In addition to the innovative pedagogical approach, the book features explicitly repeated use of a single central methodology, the economic approach. Students learn how economists think and how to think like an economist. With concrete, numerical examples and novel, engaging applications, interest for readers remains high as live graphs and data respond to manipulation by the user. Finally, clear writing and active learning are features sure to appeal to modern practitioners and their students. The website accompanying the text is found at www.depauw.edu/learn/microexcel.


Quantitative Finance

Quantitative Finance

Author: Matt Davison

Publisher: CRC Press

Published: 2014-05-08

Total Pages: 523

ISBN-13: 1439871698

DOWNLOAD EBOOK

Teach Your Students How to Become Successful Working Quants Quantitative Finance: A Simulation-Based Introduction Using Excel provides an introduction to financial mathematics for students in applied mathematics, financial engineering, actuarial science, and business administration. The text not only enables students to practice with the basic techniques of financial mathematics, but it also helps them gain significant intuition about what the techniques mean, how they work, and what happens when they stop working. After introducing risk, return, decision making under uncertainty, and traditional discounted cash flow project analysis, the book covers mortgages, bonds, and annuities using a blend of Excel simulation and difference equation or algebraic formalism. It then looks at how interest rate markets work and how to model bond prices before addressing mean variance portfolio optimization, the capital asset pricing model, options, and value at risk (VaR). The author next focuses on binomial model tools for pricing options and the analysis of discrete random walks. He also introduces stochastic calculus in a nonrigorous way and explains how to simulate geometric Brownian motion. The text proceeds to thoroughly discuss options pricing, mostly in continuous time. It concludes with chapters on stochastic models of the yield curve and incomplete markets using simple discrete models. Accessible to students with a relatively modest level of mathematical background, this book will guide your students in becoming successful quants. It uses both hand calculations and Excel spreadsheets to analyze plenty of examples from simple bond portfolios. The spreadsheets are available on the book’s CRC Press web page.


Elements of Numerical Mathematical Economics with Excel

Elements of Numerical Mathematical Economics with Excel

Author: Giovanni Romeo

Publisher: Academic Press

Published: 2019-11-28

Total Pages: 818

ISBN-13: 0128176490

DOWNLOAD EBOOK

Elements of Numerical Mathematical Economics with Excel: Static and Dynamic Optimization shows readers how to apply static and dynamic optimization theory in an easy and practical manner, without requiring the mastery of specific programming languages that are often difficult and expensive to learn. Featuring user-friendly numerical discrete calculations developed within the Excel worksheets, the book includes key examples and economic applications solved step-by-step and then replicated in Excel. After introducing the fundamental tools of mathematical economics, the book explores the classical static optimization theory of linear and nonlinear programming, applying the core concepts of microeconomics and some portfolio theory. This provides a background for the more challenging worksheet applications of the dynamic optimization theory. The book also covers special complementary topics such as inventory modelling, data analysis for business and economics, and the essential elements of Monte Carlo analysis. Practical and accessible, Elements of Numerical Mathematical Economics with Excel: Static and Dynamic Optimization increases the computing power of economists worldwide. This book is accompanied by a companion website that includes Excel examples presented in the book, exercises, and other supplementary materials that will further assist in understanding this useful framework. - Explains how Excel provides a practical numerical approach to optimization theory and analytics - Increases access to the economic applications of this universally-available, relatively simple software program - Encourages readers to go to the core of theoretical continuous calculations and learn more about optimization processes


Schaums Outline of Engineering Economics

Schaums Outline of Engineering Economics

Author: Jose A. Sepulveda

Publisher: McGraw Hill Professional

Published: 1984-06-22

Total Pages: 196

ISBN-13: 9780070238343

DOWNLOAD EBOOK

Algebraic relationships and solution procedures. Discrete, periodic compounding. Continuous compounding.


Applied Economic Analysis for Technologists, Engineers, and Managers

Applied Economic Analysis for Technologists, Engineers, and Managers

Author: Michael S. Bowman

Publisher: Pearson

Published: 2003

Total Pages: 632

ISBN-13:

DOWNLOAD EBOOK

This book provides a practical approach to making integrated financial decisions in contemporary organizations. While mathematics is used throughout, it focuses on the application of the math techniques used in real-world settings. Examples, Questions, Problems, and Discussion Cases balance quantitative analysis, team based decisions, technical factors, and qualitative information. A four-part organization covers financial concepts, financial analysis and time value of money, financial decision making, and continuous financial improvement. For those working in design, process and manufacturing engineering, purchasing, and financial analysis in both manufacturing and service organizations; for members of financial improvement teams; and for technical and senior managers.


Engineering Economics for Aviation and Aerospace

Engineering Economics for Aviation and Aerospace

Author: Bijan Vasigh

Publisher: Routledge

Published: 2016-12-08

Total Pages: 712

ISBN-13: 1317288459

DOWNLOAD EBOOK

For all engineers and practitioners, it is essential to have a fundamental understanding of cost structure, estimating cash flows, and evaluating alternative projects and designs on an economic basis. Engineering Economics for Aviation and Aerospace provides the tools and techniques necessary for engineers to economically evaluate their projects and choices. The focus of this book is on a comprehensive understanding of the theory and practical applications of engineering economics. It explains and demonstrates the principles and techniques of engineering economics and financial analysis as applied to the aviation and aerospace industries. Time value of money, interest factors, and spreadsheet functions are used to evaluate the cash flows associated with a single project or multiple projects. The alternative engineering economics tools and techniques are utilized in separate chapters to evaluate the attractiveness of a single project or to select the best of multiple alternatives. Most of the engineering economics and financial mathematics books available in the market take either a pure theoretical approach or offer limited applications. This book incorporates both approaches, providing students of aviation and industrial economics, as well as practitioners, with the necessary mathematical knowledge to evaluate alternatives on an economic basis.