Excel 2019 Bible

Chapter 15: Using Formulas for Financial Analysis 15 Principal The amount of each payment applied to the loan balance. The formu ...

Part II: Working with Formulas and Functions FIGURE 15.14 Conditional formatting to hide rows This formula compares the payment ...

Chapter 15: Using Formulas for Financial Analysis 15 FIGURE 15.15 A variable rate amortization schedule The Rate column contains ...

Part II: Working with Formulas and Functions Using dates instead of payment numbers The two amortization schedules for this sect ...

Chapter 15: Using Formulas for Financial Analysis 15 Calculating depreciation Excel provides a number of depreciation-related wo ...

Part II: Working with Formulas and Functions The main part of this formula is SLN($C3,0,$E3). The SLN worksheet function compute ...

Chapter 15: Using Formulas for Financial Analysis 15 function that has that logic built in. Figure 15.18 shows a depreciation sc ...

Part II: Working with Formulas and Functions For an asset with a five-year useful life, the period for the first year goes from ...

Chapter 15: Using Formulas for Financial Analysis 15 The PV function accepts five arguments: Rate Also known as the discount rat ...

Part II: Working with Formulas and Functions FIGURE 15.20 The present value of a series of future payments Calculating net prese ...

Chapter 15: Using Formulas for Financial Analysis 15 the rate period must be consistent with the payment period. In this example ...

Part II: Working with Formulas and Functions FIGURE 15.22 The net present value of both positive and negative cash flows In the ...

Chapter 15: Using Formulas for Financial Analysis 15 Note that we have to include the initial investment for IRR to work. The fi ...

Part II: Working with Formulas and Functions Figure 15.24 shows a schedule of nonperiodic cash flows. On some days, the investme ...

Chapter 15: Using Formulas for Financial Analysis 15 This workbook is available on this book’s website at http://www.wiley.com/g ...

Part II: Working with Formulas and Functions FIGURE 15.26 The Create Forecast Worksheet dialog box The confidence interval (depi ...

Chapter 15: Using Formulas for Financial Analysis 15 Click Create and Excel inserts a new worksheet that contains a table and a ...

365 C H A P T E R 16 Using Formulas for Statistical Analysis IN THIS CHAPTER Working with weighted averages Smoothing data with ...

Part II: Working with Formulas and Functions weight is 17%, and it is computed by dividing 72,021.35 by 423,655.02. The second a ...

Chapter 16: Using Formulas for Statistical Analysis 16 FIGURE 16.2 Expanding a weighted average calculation into adjacent cells ...