Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel®. In this sense, this is a finance "cookbook," providing recipes with lists of ingredients and instructions. Areas covered include computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The second edition contains six new chapters covering financial calculations, cost of capital, value at risk (VaR), real options, early exercise boundaries, and term structure modeling. A new technical chapter contains a potpourri of tips for using Excel®. Although the reader should know enough about Excel™ to set up a simple spreadsheet, the author explains advanced Excel® techniques used in the book. The book includes chapters dealing with random number generation, data tables, matrix manipulation, and VBA programming. It also comes with a CD-ROM containing Excel® worksheets and solutions to end-of-chapter exercises.
Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: * Use Excel and VBA in general
* Import data from a variety of sources
* Analyze data
* Perform calculations
* Visualize the results for interpretation and presentation
* Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.
(1)
* Shows people how to organize and manage their personal finances, create a budget, reduce debt, pay bills, balance a checkbook, and build a financial plan for the future using Microsoft Money, the #2 personal finance software, with approximately four million users
* Walks people through Money basics and helps them take charge of their finances, including setting up online banking accounts, recording transactions, writing and printing checks, and reconciling accounts
* Covers organizing finances by category, researching investments online, preparing for tax time, and planning for the future
* Revised throughout to cover the latest enhancements in the software
* From a veteran For Dummies author who has written more than two dozen computer books
New Lower Price! Besides offering powerful new features, Microsoft Excel 2000 is as Web-ready a spreadsheet program as PC users will find. New features enable users to access, analyze, and take advantage of the wealth of data on intranets and the Internet. QUICK COURSE(r) IN MICROSOFT EXCEL 2000 offers fast-paced, to-the-point tutorials and learning exercises for quickly grasping spreadsheet basics and building proficiency. Designed for the beginning to intermediate student, Quick Course(r) books can be used for self training and instructor-led classes, focusing on using the computer to get specific tasks done in a work environment. The core of each book is a logical sequence of straightforward, easy-to-follow instructions for creating useful worksheets, forms, and more-the same kind that people build and use on the job.
