Business Math Using Excel Book

Chapter 1. Basic Math Functions 1.1 Numbers 1.2 Addition 1.3 Subtraction 1.4 Multiplication 1.5 Division 1.6 Basic Math Operations and Excel Chapter 2. Fractions 2.1 Fractions and Mixed Numbers 2.2 Add and Subtract Fractions and Mixed Numbers 2.3 Multiply and Divide Fractions and Mixed Numbers Chapter 3. Percent 3.1 Introduction to Percents 3.2 Part, Rate, and Base 3.3 Percent of Increase and Decrease Chapter 4. Bank Services 4.1 The Checking Account 4.2 Bank Statement Reconciliation Chapter 5. Payroll 5.1 Gross Earnings 5.2 Gross Pay for Various Compensation Methods 5.3 Payroll Deductions 5.4 Employee's Earnings Record and Payroll Register Chapter 6. Taxes & Insurance 6.1 Property Tax and Property Tax Rate 6.2 State Unemplyment Tax, Federal Unemployment Tax, and Federal Income Tax 6.3 Health, Auto, Life, and Property Insurance Chapter 7. Purchasing Merchandise 7.1 The Purchasing Cycle 7.2 Cash Discounts 7.3 Trade Discounts 7.4 Series Discounts 7.5 Sales Tax Chapter 8. Markup and Markdown 8.1 Concepts Used in Pricing Merchandise 8.2 Selling Price 8.3 Markup Rate 8.4 Markdown Rate Chapter 9. Interest 9.1 Simple Interest 9.2 Notes and Interest Variables 9.3 Compound Interest Chapter 10. Consumer Credit and Mortgages 10.1 Open-End Credit 10.2 Closed-End Credit 10.3 Mortgage Loans Chapter 11. Annuities, Stocks, & Bonds 11.1 Annuities 11.2 Stocks 11.3 Bonds Chapter 12. Depreciation 12.1 Straight-Line Depreciation Method 12.2 Declining-Balance Method 12.3 Sum-of-the-Year's-Digits Method 12.4 Modified Accelerated Cost Recovery System (MACRS) Chapter 13. Financial Statements 13.1 Income Statement 13.2 Balance Sheet 13.3 Financial Ratios Chapter 14. Business Statistics 14.1 Measures of Central Tendency: Mean, Median, and Mode 14.2 Frequency Distributions and Graphs 14.3 Measures of Dispersion Student Progress Record Index