I have considerable experience with energy modules in Excel and VBA. I prepare dynamic financial modules for renewable energy platforms, upon demand; the financial modules include a driver’s tab, debt/grand repayment schedule, P&L, BS, and CF valuation (including IRR, NPV, DSCR, and terminal value).
Also, I build modules in Excel that sets cost/sales prices for each level required. There is also a small VBA to manage the database and to keep on the historical prices. There is a report generator which enables to develop templates independently. The system is secured with usernames and passwords.
About us
Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.