This volume provides a comprehensive introduction to modern financial modelling using Excel, VBA, standards of financial modelling and model review. It offers guidance on essential modelling concepts ...around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives.
An ActiveX control, steam tables grid (
StmTblGrd) to speed up the calculation of the thermodynamic properties of pure water is developed. First, it creates a grid (matrix) for a specified range of ...temperature (e.g. 400–600
K with 40 segments) and pressure (e.g. 100,000–20,000,000
Pa with 40 segments). Using the ActiveX component
SteamTables, the values of selected properties of water for each element (nodal point) of the 41×41 matrix are calculated. The created grid can be saved in a file for its reuse. A linear interpolation within an individual phase, vapor or liquid is implemented to calculate the properties at a given value of temperature and pressure.
A demonstration program to illustrate the functionality of
StmTblGrd is written in Visual Basic 6.0. Similarly, a methodology is presented to explain the use of
StmTblGrd in MS-Excel 2007. In an Excel worksheet, the enthalpy of 1000 random datasets for temperature and pressure is calculated using
StmTblGrd and
SteamTables. The uncertainty in the enthalpy calculated with
StmTblGrd is within ±0.03%. The calculations were performed on a personal computer that has a “Pentium(R) 4 CPU 3.2
GHz, RAM 1.0
GB” processor and Windows XP. The total execution time for the calculation with
StmTblGrd was 0.3
s, while it was 60.0
s for
SteamTables. Thus, the ActiveX control approach is reliable, accurate and efficient for the numerical simulation of complex systems that demand the thermodynamic properties of water at several values of temperature and pressure like steam flow in a geothermal pipeline network.
This is an update of an earlier paper, and is written for Excel 2007. A series of Excel 2007 models is described. The more advanced versions allow solution of f(x)=0 by examining change of sign of ...function values. The function is graphed and change of sign easily detected by a change of colour. Relevant features of Excel 2007 used are Names, Scatter Chart and Conditional Formatting. Several sample Excel 2007 models are available for download, and the paper is intended to be used as a lesson plan for students having some familiarity with derivatives. For comparison and reference purposes, the paper also presents a brief outline of several common equation-solving strategies as an Appendix.
This step-by-step exercise-driven guide shows how to utilize the capabilities of Microsoft Excel for teaching educational and psychological statistics. Connects statistical formulas to Excel ...commands, includes chapter-end exercises and a full practice exam.
In a revised and updated edition, this popular book shows readers how to build models using logic and experience, offers shortcuts for producing statistics using Excel 2010, and provides many ...real-world examples focused on business in emerging global markets.
Excel 2007 Dixon, Helen
2007, 2007-05-30, c2007
eBook
Books on Microsoft Excel have higher sales than books on any other computer topic. They outsell all books on all Open Source technologies. Excel 2007: Beyond the Manual is written for the experienced ...Excel user who wants to learn version 2007 quickly and efficiently. Features new to Excel 2007 are emphasized, as are complex features that, though available in earlier versions of Excel, were not readily accessible. The narrative is fast-paced, concise, and respectful of the reader's familiarity with earlier versions of the program.
Pro Excel 2007 VBA DeMarco, Jim
2008, 2008-03-07T00:00:00, 2008-06-05, c2008
eBook
Pro Excel 2007 VBA is a professionals’ guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, ...streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the next level. This book teaches how to do just that, with Jim DeMarco using his own real-life experience to develop your understanding to this professional level. The text dives right into teaching the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 such an exciting edition to work with.
Excel’s PivotTables and PivotCharts features have long been admired by the historically small community that made use of them, but Microsoft has made great efforts in the 2007 release of Microsoft ...Office to expose them and make them more evident to users. PivotTables Recipes, this book, will enable users to take real-world scenarios from the author, customize the PivotTables and supporting code around them, and use them directly in their work. Ultimate convenience for the reader on a feature which is familiar by name and interesting to many but with which few users have experience.
This book reviews basics then develops modeling with numerous examples from decision making. Results of statistical analysis are translated into business English and analyses are illustrated with ...graphics.