CHAPTER 15
Using Formulas for Financial Analysis
Spreadsheets got their start in the accounting and finance departments back when it was all done with paper and pencil. And even though Excel has grown far beyond a simple electronic ledger sheet, it's still a required tool in business.
In this chapter, you'll look at some formulas commonly used in accounting, finance, and other areas of businesses.
Performing Common Business Calculations
This section provides a reference for some of the more common business- and financial-oriented formulas that you may be asked to create when working as a business analyst using Excel.
This book's website, |
Calculating gross profit margin and gross profit margin percent
Gross margin is the money...