Oct 05, 2007
Contains 10 annuities Excel templates: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule. Our bonus: 1. investment evaluation 5 Excel templates.
2. effective annual interest rate, annual nominal interest rate.
3. 2 secutities Excel templates: Price and Yield.
Easy function navigation in 4 workbooks. Use of some complex financial functions are simplified by VBA procedures. Full instructions.
Read the related entries:
Create flow charts and graphs, technical illustrations, graphics designs and any other rich artwork for print and the Web. Edit your photos and other pictures, make clips and paste them together as a new design. In the new art, fine-tune the saturat
Create rich collage artwork, technical illustrations, and graphics designs for print and the Web.
Edit your photos and other pictures, make clips and paste them together as a new design. In the new art, fine-tune the saturation, contrast and lightne
Calculates straigh-light depreciation of an asset for a single period, sum-of-years' digits depreciation of an asset for a specified period, depreciation of an asset for a specified period using the fixed-declining balance method, depreciation of an
Excel templates. Allows to calculate correlation matrix and partial correlation matrix, linear, exponential, polynomial regression analysis. Additionally, contains 26 securities Excel templates: templates for coupons (6 templates), templates for pric
Product title: FinTemplates
Contains 56 Excel financial templates:
1. npv.xls - NPV & IRR for periodic cash flows templates
2. npvirrdate.xls - NPV & IRR for any cash flows templates
3. mirr.xls - MIRR template
4. sec.xls - 26 securities templat
Ready to use two Excel templates for NPV & IRR calculation. 1. NPV & IRR Excel template for periodic cash flows 2. NPV & IRR Excel Template for a schedule that is not necessarily periodic. Requires Excel 97 or later. Requires the Annalysis ToolPak -
Contains 26 securities Excel templates: templates for coupons (6 templates), templates for price calculation (6 templates), templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modifie
You will be able to download the product immediately after ordering!
Order a full version!
