Business Planning via spreadsheet 999

BUSINESS PLANNING via spreadsheet

(A systematic approach to business)

COURSE CONTENTS

1.       The right business model – the matching of revenue against costs

a.       Price and quantities

b.      Fixed and variable costs

2.       Adequate working capital

a.       Adequate current assets matched with the right current liabilities

3.       Minimizing fixed assets investments

a.       Internal rate of return

b.      Net Present value

4.       Cheaply financed by a combination of equity and loans.

a.       Costs of shares

b.      Cost of other sources of funds

                                                               i.      Debentures

                                                             ii.      Bank overdrafts

                                                            iii.      Bank term loans

5.       Ensuring liquidity at all time through proper cash flow projections

a.       Sources of inflows

b.      Outflow commitments

c.       Borrowings

d.      Loan repayments

6.       Ensure the right return on equity objective through ROE chart

a.       Return on Sales

b.      Sales turnover

c.       Asset equity multiplier

7.       Construct the financial statement

a.       Income statement

b.      Balance sheet

c.       Cash flow statements

8.       Ratio Analysis

© arriffin@gmail.com     Tel :  012-2786282