Wednesday, 1 August 2012

My Approach to Handling The Backgrounder

When you receive your backgrounder you will have 48 hours to do whatever you want with it. 48 hours seems like a lot but it is not so I think it is important to have a strategy for how to approach the backgrounder and what to do with it so that you do not get overwhelmed and forget to do something important in preparation for the case exam.

This was my approach to the backgrounder:

Day 1
  • Read the backgrounder
  • Re-read the backgrounder
  • Make note on the key individuals and get familiar with their names and roles
  • Re-read backgrounder again and make notes/highlight key information
  • Make sure I understand what the company does
  • Read and re-read the SWOT to get familiar with all the points
  • Tackle financials - crunch every single possible ratio that I can think of and make sure I know what each of the ratios mean as well as memorize the ratio formulas
  • Review the resulting ratios and note anything that stands out 
  • Do a situational analysis for the backgrounder (SWOT - try to find additional points, stakeholder preferences, constraints, etc.)
 
Day 2
  • Read the backgrounder and SWOT twice (the goal is to have all the backgrounder info so solidified and clear in your head so that you will reduce the number of times you may need to refer to the backgrounder copy during the case exam)
  • Review the situational analysis created on Day 1 and note if anything needs to be added or modified
  • Review financials I crunched on Day 1 to make sure you did not make any errors
  • Study the ratios and what they are indicating about the company - choose a handful of ratios that are the most relevant and/or are showing something that needs to be noted and perhaps addressed (ie. debt to equity ratio is trending up)
  • Review everything that I have done so far and study it as much as possible - by the end of this day the goal is for me to be VERY comfortable with everything in the backgrounder.


Share what your strategy on handling the backgrounder is so that other students can benefit and get good ideas.

Wednesday, 4 July 2012

Wednesday, 20 June 2012

Calculating Present Value, Future Value and Payment In Excel - Formulas

 
When writing the CMA Case Exam or the CMA Board Report you can (and should) use formulas to help you compute Present, Future and Payment values. After posting my NPV Template where I utilize these formulas, I have received some email questions about setting up these Time Value of Money formulas (present value, future value and payment) in excel. I put the above together so that you can see how I calculate these values in excel, using formulas. Let me know if you have any questions on the above.

Notes:
  • rate is the discount rate per period
  • nper is the number of periods
  • PMT is the payment per period
  • PV is the present value
  • type indicates whether it is a regular annuity or an annuity due (whether payment is due at the end of a period or at the beginning)
  • FV is future value

If you have other questions on excel (pivot tables, formulas, formating, etc. post them in the comments and I will do a post on these).

CM

Popular Posts