- Get live stock quotes and fundamental data in Excel
- Value more than 250 stocks worldwide using Benjamin Graham's formula
- Screen, filter and sort stocks to capture investing opportunities
- All in Excel, no add-ins!
- Forecasts demand using Product Life Cycle, linear and exponential techniques
- Calculates NPV, IRR and Payback
- Performs Monte Carlo simulations
- Evaluates Dependency Ranking
- Builds Financial Statements
- Translates strategy into action
- Suggest up to 65 indicators
- Presents results in dynamic charts
- Creates a database with KPI!
- Prepares cash flow statements from BS and P&L
- 24 financial ratios
- Performs company valuation & sensitivity analysis
- Performance charts!
- Builds a 2 month cash forecast
- Operational, financing and investing cash flows
- Creats a Waterfall chart
- Line chart with daily cash position
Are you still wasting your time with bank reconciliations? If you are like most financial professionals, I'm sure you'd rather run an automated routine in Excel and get the work done for you, so you can devote your knowledge and energy to more value-added functions.
Of course, bank reconciliations are necessary to avoid errors and follow the cash. But, they are also time-consuming and boring. With this in mind, I created a VBA macro in Excel that checks every line item of your bank statement and cash book to do the job for you.
