Financial Analysis Using Excel

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