Forensic cremation. Recovery and analysis, INNE
Formulas and Functions With Microsoft Office Excel 2007, Dokumenty(eboki programy i inne), @Excel
Fiancial Analysis with Excel 2002, Dokumenty(eboki programy i inne), @Excel
Financial Lexicon - A Compendium of Financial Definitions,
Fizyka budowli dla architektów, ARCHITEKTURA (czytelnia)
Final Fantasy 5 Readme, Pegasus
Family traits, Vocabulary
Full Metal Alchemist - 12, anime, Odcinkowe, Full Metal Alchemist, napisy
Fuerteventura mapa 1100 000 DOWNLOAD, Turystyka, mapy, atlasy
Finance Financial Analysis Using Excel, IT(1)
[ Pobierz całość w formacie PDF ]Financial
Analysis using
Excel
Function
Information requirements for function
Dates
Prices and par values
Frequency,
and related
Yields and
interest/ discount
rates
COUPDAYBS
9
9
9
9
COUPDAYS
9
9
9
9
COUPDAYSNC
9
9
9
9
COUPNCD
9
9
9
9
COUPPCD
9
9
9
9
COUPNUM
9
9
9
9
DURATION
9
9
9
9
9
MDURATION
9
9
9
9
9
PRICE
9
9
9
9
9
9
PRICEDISC
9
9
9
9
9
9
PRICEMAT
9
9
9
9
9
Excel for Professionals 2002 VJ Books. All rights reside with the author.
RECEIVED
9
9
9
9
9
YIELD
9
9
9
9
9
9
9
9
YIELDDISC
9
9
9
9
9
9
YIELDMAT
9
9
9
9
9
ACCRINT
9
9
9
9
9
ACCRINTM
9
9
9
9
INTRATE
9
9
9
9
9
9
DISC
9
9
9
9
9
9
Financial Analysis using Excel
Financial Analysis usin
g Excel
Volume 6 in the series
Excel for Professionals
Volume 1: Excel For Beginners
Volume 2: Charting in Excel
Volume 3: Excel-- Beyond The Basics
Volume 4: Managing & Tabulating Data in Excel
Volume 5: Statistical Analysis with Excel
Volume 6: Financial Analysis using Excel
Published by VJ
Books Inc
All rights reserved. No part of this book may be used or reproduced in any form or by
any means, or stored in a database or retrieval system, without prior written
permission of the publisher except in the case of brief quotations embodied in
reviews, articles, and research papers. Making copies of any part of this book for any
purpose other than personal use is a violation of United States and international
copyright laws.
First year of printing: 2002
Date of this copy: Saturday, December 14, 2002
This book is sold as is, without warranty of any kind, either express or implied,
respecting the contents of this book, including but not limited to implied warranties
for the book's quality, performance, merchantability, or fitness for any particular
purpose. Neither the author, the publisher and its dealers, nor distributors shall be
liable to the purchaser or any other person or entity with respect to any liability, loss,
or damage caused or alleged to be caused directly or indirectly by the book.
This book is based on Excel versions 97 to XP. Excel, Microsoft Office, Microsoft
Word, and Microsoft Access are registered trademarks of Microsoft Corporation.
Publisher
: VJ
Books Inc, Canada
Author
: Vijay Gupta
2
To Dr “Chini” at the Business School Georgetown Universitry
and SEC.
Thanks for the timely support and advice.
3
Financial Analysis using Excel
A B O U T T H E A U T H O R
Vijay Gupta has taught statistic, econometrics, and finance to institutions in
the US and abroad, specializing in teaching technical material to
professionals.
He has organized and held training workshops in the Middle East, Africa,
India, and the US. The clients include government agencies, financial
regulatory bodies, non-profit and private sector companies.
A Georgetown University graduate with a Masters degree in economics, he
has a vision of making the tools of econometrics and statistics easily
accessible to professionals and graduate students. His books on SPSS and
Regression Analysis have received rave reviews for making statistics and
SPSS so easy and “non-mathematical.” The books are in use by over 150,000
users in more than 140 nations.
He is a member of the American Statistics Association and the Society for
Risk Analysis.
In addition, he has assisted the World Bank and other organizations with
econometric analysis, survey design, design of international investments,
cost-benefit, and sensitivity analysis, development of risk management
strategies, database development, information system design and
implementation, and training and troubleshooting in several areas.
Vijay has worked on capital markets, labor policy design, oil research, trade,
currency markets, and other topics.
4
V I S I O N
Vijay has a vision for software tools for Office Productivity and
Statistics. The current book is one of the first tools in stage one of his
vision. We now list the stages in his vision.
Stage one:
Books to
Teach
Existing Software
He is currently working on books on word-processing, and report
production using Microsoft Word, and a booklet on Professional
Presentations.
The writing of the books is the first stage envisaged by Vijay for
improving efficiency and productivity across the world. This directly
leads to the second stage of his vision for productivity improvement
in offices worldwide.
Stage two:
Improving
on Existing Software
The next stage is the construction of software that will radically
improve the usability of current Office software.
Vijay’s first software is undergoing testing prior to its release in Jan
2003. The software — titled “Word Usability Enhancer” — will
revolutionize the way users interact with Microsoft Word, providing
users with a more intuitive interface, readily accessible tutorials, and
numerous timesaving and annoyance-removing macros and utilities.
He plans to create a similar tool for Microsoft Excel, and, depending
on resource constraints and demand, for PowerPoint, Star Office, etc.
5
[ Pobierz całość w formacie PDF ]
