Monday, September 27, 2010

Spreadsheet Finance - 7 key steps

1) Cost analysis for decision making
  • Cost concepts
  • Break even analysis
  • Activity based costings
2) Working capital management
  • Current Assets minus current liabilities
  • Trading Strategies
3) Fixed Asset Investment and depreciations
  • Evaluate fixed asset investment
  • Leverage /  loans
4) Equity and Leverage
  • Shares
  • Preference shares
  • debentures / bonds
  • Bank Loans
5) ROE objective and structure format.
  • Financial strategies to achieve objective
6) Cash flow projections
  • Templates
  • Liquidity Planning
7) Constructing the financial statements
  • Income statement
  • Balance Sheet
8) Evaluation of financial performance

  • ROE Chart