Build the MBA Math and Spreadsheet Skills You Need

Now that you got in, get ready

Home

Admitted Student

Introduction

Course Summary

Course Demo

Sample Exercises

PURCHASE

"MBA Math was the cornerstone of my MBA preparation because it:

- Was extremely comprehensive. Having all of my information housed in a central location and having my progress tracked in a central hub allowed me to travel to other countries during my summer without interrupting my studies.

- Offered me a variety of dynamic learning tools. The online lectures were very clear and direct and the reference guides served as a quick reference during the problem solving exercises."

- Tumi A., Tuck (Dartmouth) '07

More Testimonials

Are You Curious to Know How MBA Math Gets You MBA-Ready? Here are the secret incredients of the MBA Math approach. Strike a Balance Between "Too Little" and "Too Much" The biggest challenge in designing and delivering the MBA Math course is to include the right topics at the appropriate level of detail. Too little and you get a false sense of security. Too much and you get bogged down, faced with the online equivalent of a bulging 1000-page textbook. The MBA Math "Just Enough" Active Problem-Solving Approach The MBA Math course, refined over eight years of teaching a 35-hour "math camp" to incoming first-year MBA students the week before Orientation, strikes that balance. Exercise Driven: You encounter a range of exercises drawn from first-year MBA quantitative courses. Minimal Theory: You review problem-solving approaches and techniques with a minimum of theory. Solve Problems: You spend most of your time solving problems. Not reading. Not listening passively. Wrestling with problems. Building spreadsheets. Computing answers. Actively. Focus on Getting it Right Eventually Rather than Getting it Right the First Time The MBA Math course covers 22 modular topics, each with its own quizzes and learning materials. Pre-Quiz: You start with a pre-quiz on a particular topic to establish your starting point. For some topics, your pre-quiz score may well be a big fat zero! There is no reason that you would know about regression, for example, until you have studied it. Study: Guided by your pre-quiz score, you then work through the teaching material and exercises until you understand how to solve problems accurately. Post-Quiz: You take a post-quiz when you are ready. If you are not satisfied with your post-quiz score, you can continue your studying and then take another post-quiz. As many times as you need to attain the proficiency you desire. You can browse the MBA Math topics below. For a clearer understanding of the MBA Math learning experience, click below to view the MBA Math demo in a separate window. When you are ready, click the Purchase Subscription button to get started.

	View Course Demo	Purchase Subscription
Course Summary (PDF format) Contract All \| Expand All Excel Spreadsheets Basic Excel worksheet techniques are covered in one topic. Additional topic-specific techniques are used in lessons covering the MBA topics below. Solutions illustrate basic functions implementing algebraic formulas and also the built-in functions (e.g., FV, NPV, VAR, STDEV, CORREL, RSQ, NORMDIST) that you will use most often in your MBA experience. Financial Math Familiarity with time value of money concepts, formulas, and spreadsheet solution techniques should be considered a prerequisite for your MBA experience. Because everything else in financial math is built on this foundation of shifting one cash payment at one time to its equivalent at another time, you should be clear about this before you start. Annuities and perpetuities are the simplest smooth patterns of cash flows over time. Bonds are a mixture of annuities and future values. Net present value allows you to convert an irregular set of cash flows back to the present to compare one course of action with another. Such problems appear throughout the MBA curriculum. Time Value of Money Annual Compounding Present Value Rate Number of Periods Future Value Sub-Annual Compounding same as Annual plus: Periods per Year Annuities and Perpetuities Constant Growing Bond Basics Zero Coupon Coupon Net Present Value Accounting Making sense of accounting requires a clear understanding of the three main financial statements and how these statements represent standard business transactions. The math is simple. The challenge lies in the logic, definitions, and conventions. Using Intel's financial statements as an example, you learn the basics about the balance sheet, income statement, and statement of cash flows. After studying each financial statement separately, you then work on the connections among the three statements with a set of examples. You use the balance sheet equation and t-accounts to characterize standard business transactions in terms of offsetting debits and credits . Finally, you apply what you learned with t-accounts to make appropriate journal entries. Balance Sheet Assets Liabilities Equity Balance Sheet Equation Transactions Income Statement Revenues Expenses Cash vs. Depreciation Statement of Cash Flows Operating Activities Investing Activities Financing Activities Cash vs. Depreciation T Accounts and Balance Sheet Equation Balances Debits Credits Transactions Journals Journal Entry Template Debits Credits Transactions Microeconomics Marginal analysis addresses the question of how much to produce to maximize profit, given specified costs and revenues. Problem statements and solutions involve either tables or formulas. You learn to distinguish among marginal, total, and average costs and revenues. Supply and demand are the classic economics concept. You learn to create and interpret the classic linear "curves", compute the equilibrium point that maximizes profit and the corresponding consumer surplus. You examine market segmentation, and use demand curves as part of marginal analysis. Marginal Analysis Tables Formulas and Calculus Supply and Demand Statistics and Probability You start with basic summary statistics, which form the foundation. You then tackle statistics of linear combinations, which is a fancy way of saying stock portfolios. Tables and graphs summarize raw data. You need to know how to make them and work with them. Regression allows you to draw a best-fit line through a set of data points. You can do it visually or computationally. Both approaches are a snap using Excel. The standard normal "bell curve" is the king of continuous distributions. You learn to work with continuous distributions in terms of intervals rather than points. Excel makes solutions a breeze but you may, depending on your MBA program, need to learn the z-table approach and its corresponding pictographs and conversions. Basic Summary Statistics Mean, Median, and Mode Variance and Standard Deviation Linear Combinations (e.g., Stock Portfolios) Covariance and Correlation Portfolio Statistics from Individual Stock Returns Portfolio Statistics from Individual Stock Statistics Discrete Probability Distributions Linear Regression Regression Line Equation Prediction Measure of Linearity Continuous Distributions Uniform Standard Normal Normal

Are You Curious to Know How MBA Math Gets You MBA-Ready?

Strike a Balance Between "Too Little" and "Too Much"

The MBA Math "Just Enough" Active Problem-Solving Approach

Focus on Getting it Right Eventually Rather than Getting it Right the First Time

Excel Spreadsheets

Financial Math

Accounting

Microeconomics

Statistics and Probability