{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

02 Chapter model - 02 Chapter model 7:08 AM Chapter 2 The...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
02 Chapter model 3/22/10 7:08 AM 2/13/2006 Chapter 2. The Time Value of Money First, note that this model is STRICTLY OPTIONAL. Neither students nor instructors need to go through it. However, if someone wants to practice with Excel, then the model can be useful. Also, it shows actual solutions for the within-chapter self-test questions. The "Main Model" performs the calculations required for Chapter 2, and was used to create many of the chapter exhibits (Tables and Figures). We pasted in a few dialog boxes for specific Excel functions and features and show then off to the right of where they apply, but in general we encourage students who want to know more about Excel to use the Excel Tutorial and refer to it as necessary. We also like to let students know that Excel models can be used to create tables and graphs that can then be copied into Word documents, which is the way we prepared the text manuscript for submission to the publisher. That procedure is used often in business to prepare reports. Although answers to the Self-Test questions within the chapter are generally quite easy and were found with a calculator, we also solved them with Excel as a check and also to provide some information on the solutions in case students have questions. The tabs at the lower part of this screen take you to these solutions. Even if students are not familiar with Excel, they should still be able to see the solution setup and then work out the answer with a calculator. Although we did not create the model specifically for use in lectures, it could be used as such in a classroom where a projector is attached to a computer. The instructor could scroll through the model and lecture on points as they come up. This would be more useful if the students have some familiarity with Excel, but that is not really necessary because everything the model does can also be done with a financial calculator. FUTURE VALUES (Section 2.2) A dollar in hand today is worth more than a dollar to be received in the future because, if you had it now, you could invest it, earn interest, and end up with more than a dollar in the future. The process of going to future values (FVs) from present values (PVs) is called compounding. To illustrate, refer to our 3-year time line and assume that you plan to deposit $100 in a bank that pays a guaranteed 5% interest each year. How much would you have at the end of Year 3?
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Table 2-1. Summary of Future Value Calculations -$100.00 5.00% 3 Periods: 0 1 2 3 | | | | Cash Flow Time Line: -$100 FV = ? Step-by-Step Approach: $100 $105.00 $110.25 $115.76 = $115.76 3 5 -$100.00 $0 Calculator Approach: N I/YR PV PMT FV $115.76 Excel Approach: Fixed inputs: $115.76 Cell references: $115.76 The Compounding Process: A Graphic View Investment = CF 0 = PV = Interest rate = I = No. of periods = N = Formula Approach: FV N = PV(1+I) N FV N = $100(1.05) 3 FV N = = FV ( 0.05 ,3, 0 , -100 ) = FV N = = FV ( C15 ,C16, 0 , C14 ) = In the Excel formula, the terms are entered in this sequence: interest, periods, 0 to indicate no intermediate cash flows, and then the PV. The data can be entered as fixed numbers or as cell references.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern