Compound Interest and Time Value of Money Study Notes

Spreadsheet Work and Agenda Overview

  • Emphasis on practical spreadsheet application during class.
  • Encouragement to follow along on personal spreadsheets to reinforce understanding of formulas.
  • Acknowledgement that understanding nuances in formulas is critical for midterm and final exam preparation.
  • Today’s class focuses on:
    • Compound Interest
    • Homework problems (Homeworks 1-4)
    • Schedule overview, particularly concerning cash flows and cash flow equivalents.

Understanding Compound Interest

  • Definition of Compound Interest: Interest calculated on the initial principal and also on the accumulated interest of previous periods.
  • Time Value of Money Introduction: The earlier class introduced the concept of time value of money and related risks in lending and borrowing.
  • Factors Affecting Time Value of Money:
    • Purpose of the loan
    • Duration of the loan
    • Creditworthiness of the borrower
    • Inflation impacts
    • Mortality
    • Ability to repay (determining means)
    • Geopolitical climate
    • Payment structure

Conceptual Discussion on Risks

  • Risk refers to uncertainty in outcomes and is associated with various factors in lending.
  • Example Factors Recap:
    • Purpose, Duration, Credit History, Inflation, Mortality, Geopolitical Concerns, Ability to Repay, and Payment Structure.
  • Higher perceived risk usually leads to higher interest rates.

Worksheet Overview: Simple Interest Calculation

  • Example Formula for Simple Interest: $I = P imes r imes t$
    • Where:
    • $I$ = interest
    • $P$ = principal amount
    • $r$ = annual interest rate
    • $t$ = time in years
  • Simple Interest results in a uniform interest amount across periods.

Transitioning to Compound Interest Calculations

  • The difference in formulations between simple interest and compound interest becomes significant over time.
  • Thus, compound interest will yield a larger total as periods increase due to interest accruing on previously accumulated interest.

Spreadsheet Activity for Homework Problems

  • Excel Spreadsheet Tasks:
    • Calculate compound interest using future value and present value formulas in Excel.
    • Emphasis on utilizing Excel's functions for accurate computation.
  • Example formulas shared include:
    • Future Value Formula: =FV(rate, nper, pmt, pv, type); where each parameter must be appropriately configured based on data provided.
  • Importance of formatting Excel cells to reflect calculations correctly.

Detailed Explanation of Future Value and Present Value Formulas

  • Future Value (FV): Used to calculate the value of an investment at a future date, based on an assumed rate of growth.
    • Example Usage:
    • Formula: =FV(rate, nper, pmt, [pv], [type])
  • Present Value (PV): The current worth of a future sum, calculated by discounting the future amount back to the present using a specified interest rate.
    • Formula Example: =PV(rate, nper, pmt, [fv], [type])

Practical Applications and Examples

  • Real-life scenarios where these financial principles apply:
    • Certificates of Deposit (CDs) exemplifying simple and compound interest applications.
    • Loan agreements and negotiations highlighting the consequences of various risk factors on interest rates.

Special Consideration for Mathematical Operations

  • Emphasis on the order of operations; critical when transitioning from simple to compound interest calculations.
  • Misinterpretations can affect financial decision-making, producing erroneous outputs if operations are misapplied.

Homework Problems

  • Worked through various problems related to compound interest, present value, and future value calculations, reinforcing the importance of these formulas:
    • Calculated examples:
    • Interest earning over multiple periods and different scenarios was highlighted to emphasize how even minor variations in rate and period can greatly affect the result.
    • Anticipate remaining problems will tackle both understanding and applying formulas in practice.

Future Class Considerations

  • Upcoming class will review analysis periods and delve into more complex cash flow diagrams.
  • Continual reminder to stay engaged with materials and practices learned in class for practical mastery.

Conclusion and Next Steps

  • Confirmed a comprehensive grasp of both theoretical and practical financial management tools for future application.
  • Students encouraged to reach out with questions and to demonstrate their work on upcoming assessments for clarity.
  • Ended class with a reminder to practice independently and prepare for the complexity of future topics.