ppt课件-usingexcelfinancialfunctionstosolvetvmproblems.pptVIP

Using Financial Functions in Excel or a TI-83 to Solve TVM Problems This explains how to use the Excel Finite Functions to solve Time Value of Money Problems related to annuities and bonds (Press F5 to run Slide Show) Note: This PowerPoint presentation is under construction. Currently, this only shows how to do this in Excel and we intend to make improvements in that presentation. Then we will add slides to explain how to use the TI-83 to do the same. Problem: Consider an annuity where you are paid $100 at the end of each year for ten years. Assuming that we discount at a rate of 12%, compo