Close
Posts Tagged ‘Excel’

Finance Basics 6 – Present Value Examples In Excel – How Much Something Is Worth Today.

Date : December 5th, 2009Category : CD Type AnnuitiesAuthor : EditorNo comments


Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial goes through 3 Present Value problems and shows you how to solve them using t…

Tags : , , , , , , , , ,

Calculate Value Of Savings/retirement Plan In Excel – Fv()

Date : October 19th, 2009Category : CD Type AnnuitiesAuthor : Editor3 Comments

http://www.TeachExcel.com

This teaches you how to use the FV() Future Value function in excel in order to calculate how much a savings or retirement plan will be worth in so many years. This is a …

Tags : , , , ,

Excel Busn Math 60: Future Value Annuities Fv & Pmt Function

Date : October 6th, 2009Category : CD Type AnnuitiesAuthor : EditorNo comments


See how to use the Excel functions FV and PMT to make a future value calculation for an annuity.

This is a Highline Community College Business Math Class, Busn 135, taught by Mike Gel excelisfun …

Tags : , , , , , ,

Excel Finance Trick 14: Npv Function Capital Invest Decision

Date : October 5th, 2009Category : CD Type AnnuitiesAuthor : EditorNo comments


You can use the NPV function when the cash flows are of different amounts but the time periods between cash flows is the same.

When an asset DOES NOT have an annuity cash flow pattern, you can use…

Tags : , , , , , ,

Excel Finance Trick 13: Pv Function Capital Invest Decision

Date : October 3rd, 2009Category : CD Type AnnuitiesAuthor : EditorNo comments


When an asset has an annuity cash flow pattern, you can use the PV function for Capital Investment Decision. An annuity has equal payments at equal time intervals.

Asset Valuation with Discounting…

Tags : , , , , , ,

Excel Busn Math 59: Annuities Math & Excel

Date : October 1st, 2009Category : CD Type AnnuitiesAuthor : Editor3 Comments


Learn what an annuity is and how to make calculations for annuities. Future Value and Present Value Annuities and the math formulas seen written out by hand.

See how to use the Excel function FV t…

Tags : , , ,

Excel Busn Math 59: Annuities Math & Excel

Date : September 30th, 2009Category : CD Type AnnuitiesAuthor : Editor3 Comments


Learn what an annuity is and how to make calculations for annuities. Future Value and Present Value Annuities and the math formulas seen written out by hand.

See how to use the Excel function FV t…

Tags : , , ,

Excel Busn Math 59: Annuities Math & Excel

Date : September 29th, 2009Category : CD Type AnnuitiesAuthor : Editor3 Comments


Learn what an annuity is and how to make calculations for annuities. Future Value and Present Value Annuities and the math formulas seen written out by hand.

See how to use the Excel function FV t…

Tags : , , ,