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