Excel 2019 Bible

Chapter 14: Using Formulas for Matching and Lookups 14 Change the Name box to Married. Click OK. Select the range B15:E22. Choo ...

Part II: Working with Formulas and Functions references. For named ranges, a1 can be either TRUE or FALSE, and INDIRECT will ret ...

Chapter 14: Using Formulas for Matching and Lookups 14 becomes the row argument for INDEX. The year 2012 is matched across the h ...

Part II: Working with Formulas and Functions Figure 14.12 shows the same sales table, but the user has left the Year input blank ...

Chapter 14: Using Formulas for Matching and Lookups 14 In the example shown in Figure 14.13, when SUMPRODUCT gets to row 12, it ...

Part II: Working with Formulas and Functions The INDEX function when used on a single column needs only a row argument. The thir ...

333 C H A P T E R 15 Using Formulas for Financial Analysis IN THIS CHAPTER Performing common business calculations Leveraging Ex ...

Part II: Working with Formulas and Functions FIGURE 15.1 Financial statement for a manufacturing company The gross margin formul ...

Chapter 15: Using Formulas for Financial Analysis 15 By marking up the cost of the product 32%, you achieve a 24% gross margin. ...

Part II: Working with Formulas and Functions The EBIT formula starts with net loss in C18 and uses two VLOOKUP functions to find ...

Chapter 15: Using Formulas for Financial Analysis 15 Calculating return on assets Return on assets (ROA) is a measure of how eff ...

Part II: Working with Formulas and Functions however, uses average total equity rather than average total assets. The formula to ...

Chapter 15: Using Formulas for Financial Analysis 15 Gross Margin =SUM(D7:D8) Revenue =ROUND(D8/(1-SUM(C4:C7)),0) The two variab ...

Part II: Working with Formulas and Functions If this company makes a 60% gross margin, pays 8% in commissions, and has estimated ...

Chapter 15: Using Formulas for Financial Analysis 15 Calculating annual churn rate If a business has monthly recurring revenue, ...

Part II: Working with Formulas and Functions Average Customer Margin =F4/AVERAGE(C4,C10) Customer Lifetime Value =F6/C7 FIGURE 1 ...

Chapter 15: Using Formulas for Financial Analysis 15 FIGURE 15.10 Monthly employment changes over one year Employee turnover is ...

Part II: Working with Formulas and Functions Effective Rate This is the actual rate paid. If the nominal rate period is the same ...

Chapter 15: Using Formulas for Financial Analysis 15 Both EFFECT and NOMINAL take two arguments: the rate to be converted and th ...

Part II: Working with Formulas and Functions nper (required) The nper argument is the number of payments that will be made over ...