Financial Analysis Using Excel

Only available on StudyMode
  • Topic: Spreadsheet, Formula, Volume Two
  • Pages : 142 (26790 words )
  • Download(s) : 319
  • Published : November 9, 2012
Open Document
Text Preview
Financial Analysis using Excel
Function

Information requirements for function
Dates

Prices and par values

Frequency, and related

Yields and interest/ discount rates Discount

Any amount paid at maturity ?

Frequency of payme nts pa

First coupon

Redemption amount

Investment amount

# of periods

Settlement

Par/coupon

Maturity

COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT ACCRINTM INTRATE DISC

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

Interest

Basis

Issue

Yield

Price

Financial Analysis using Excel

Financial Analysis using Excel Financial Analysis using Excel Volume 6 in the series Excel for Professionals 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

ABOUT THE AUTHOR
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

VISION
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...
tracking img