Finance Financial Analysis Using Excel.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

COUPDAYS

9 9

COUPDAYSNC

9 9

COUPNCD

9 9

COUPPCD

9 9

COUPNUM

9 9

DURATION

9 9

MDURATION

9 9

PRICE

9 9

PRICEDISC

9 9

PRICEMAT

9 9

Excel for Professionals  2002 VJ Books. All rights reside with the author.

RECEIVED

9 9

YIELD

9 9 9 9 9

YIELDDISC

9 9 9 9 9

YIELDMAT

9 9 9

ACCRINT

ACCRINTM

INTRATE

9 9

9 9 9

DISC

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

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

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

To Dr “Chini” at the Business School Georgetown Universitry

and SEC.

Thanks for the timely support and advice.

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.

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.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: