Use The Resources Linked Below To Help Complete This Assessment. Collapse All Time Value Of

Use the resources linked below to help complete this assessment.

Collapse All

Time Value of Money and Calculations

The following resources may be useful in learning about time value of money (TVM) and how to calculate TVM in Excel:

• Alexander, M., & Kusleika, D. (2016). Excel 2016 formulas. John Wiley & Sons, Inc.
  • You will find explanations on using Excel to calculate financials in these chapters:
    • Chapter 11, "Borrowing and Investing Formulas."
    • Chapter 12, "Discounting and Depreciation Formulas."
    • Chapter 13, "Financial Schedules."
• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 4, "Discounted Cash Flow Valuation," pages 82-128.
• Schmidt, C. E. (2016). A journey through time: From the present value to the future value and back or: Retirement planning: A comprehensible application of the time value of money concept. American Journal of Business Education, 9(3), 137-143.
• Time Value of Money | Transcript.
  • This presentation discusses the components that make up time value of money. The presenter also provides examples to compute and read the computations.
• Mayes, T. R. (n.d.). Microsoft Excel as a financial calculator part I. http://www.tvmcalcs.com/index.php/calculators/excel_tvm_functions/excel_tvm_functions_page1/
• Skillsoft. (n.d.). Financial statement analysis for non-financial professionals.
  • Go to the Analyzing the Financial Statement section in the Table of Contents menu, and select The Time Value of Money.

Discounted Cash Flow Valuation

• Seeking Alpha. (2016, March 28). Does Warren Buffett use discounted cash flow? https://seekingalpha.com/instablog/5969741-the-value-pendulum/4868716-warren-buffett-use-discounted-cash-flow
• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 4, "Discounted Cash Flow Valuation," pages 82-128.

Impacts to Common Stock Prices

• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 6, "Stock Valuation," pages 164-193. Find out how the valuation of these securities determines the ultimate value of the entire enterprise.
• Edspira. (n.d.). Capital stock (common stock and preferred stock) [Video] | Transcript https://www.youtube.com/watch?v=TZ2uWgtQXBo
• TheFinCoach. (2012). Session 08: Objective 1 – common stock valuation [Video] | Transcript https://www.youtube.com/watch?v=uajW4BWh_zY
• Harper, D. (2018, February 18). Forces that move stock prices. https://www.investopedia.com/articles/basics/04/100804.asp

Bond Valuation

• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 5, "Interest Rates and Bond Valuation," pages 129-163. This chapter illustrates the employment of time value of money concepts to determine the value of corporate debt/bonds and common/preferred stock.
• McCracken, M. (n.d.). Bond valuation [Video] | Transcript http://www.teachmefinance.com/bondvaluation.html

Capital Budgeting Tools

• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 7, "Net Present Value and Other Investment Rules," pages 194-228. This chapter introduces the process of capital budgeting, which determines the value of a potential investment/project to a firm. That is, it weeds out good investments from the bad. Evaluating capital budget projects is a critical function for any business professional involved with finance decisions.
  • Chapter 8, "Making Capital Investment Decisions," pages 229-261. The key to valuation of investments and projects is the cash they generate. This chapter illustrates the way to figure the all-important cash flows from investment projects.
• Van Dalsem, S. (2017). Capital budgeting cash flows tutorial [Video] | Transcript https://www.youtube.com/watch?v=X6HvKl__rLY&t=19s
  • View the segment, 12:36-27:36.

Capital Budgeting and Risk

• Nockolas, S. (2015). How do you calculate payback period using Excel? https://www.investopedia.com/ask/answers/051315/how-do-you-calculate-payback-period-using-excel.asp
• Ross, S. A., Westerfield, R. W., Jaffe, J. F., & Jordan, B. D. (2021). Corporate finance: Core principles and applications (6th ed.). McGraw-Hill. Available in the courseroom via the VitalSource Bookshelf link.
  • Chapter 9, "Risk Analysis, Real Options, and Capital Budgeting," pages 262-286. The concept of risk is introduced in this chapter. Risk is an important aspect of business and investment, and the impact of risk needs to be measured on all capital projects.
• Sham, G. (n.d.). Capital budgeting: Wrapping it all up. https://www.investopedia.com/university/capital-budgeting/conclusion.asp

Additional Resources for Further Exploration

• Finance and Accounting Videos by Prof Coram. (n.d.). Profitability index calculation using Excel [Video] | Transcript https://www.youtube.com/watch?v=1CcRIdUU3sw
• Financecanbefun. (2014). Capital budgeting in Excel example [Video] | Transcript https://www.youtube.com/watch?v=Twpfr2VCIWE
  • View the segment 1:53-16:53.