Pharaoh Financial Models
Pharaoh Financial is an online portal were Excel and PowerBi developers can share their creative solutions and collaborate to create models that help financial analysts develop their data analysis, financial modeling and data visualization skills. Register with us and start publishing your work for other professionals to benefit from.
Excel Models
Manpower Analysis Model
The Manpower Analysis Model was designed to equip HR managers and analysts with a tool to control the transition of a workforce from one year to another.
Group Payroll Analysis Model
This model produces a useful dashboard for CEOs to receive on a monthly basis to keep them reminded of the total group payroll.
Budget Analysis Model
This model performs analysis on actual spending of capex and opex items and conducts budget variance calculations and visualizations of spending monthly.
Monthly Sales Analysis Model
A dynamic analytics dashboard for e-commerce start-ups to monitor their monthly sales and generate useful analytics on their products, customers and segments.
IFRS-16 Transition Module
This model allows for a transition to use IFRS-16 for leased properties. The calculations allow projecting IFRS-16 balances to be incorporated in business plans with many leased properties.
Treasury Monitor Dashboard
This financial model attempts to give a CFO a daily monitor of the existing bank balances for all entities in a multi-currency and multi-entity environment.
5-yr Historical Analysis
This Dashboard is a 5-year Historical Financial Analysis Excel Template is useful for financial analysts to quickly have an overview of a company’s performance with basic ratios and charts.
CAPEX & Depreciation Module
This worksheet is a sub-module for Capex and depreciation calculations to be used by financial modelers to integrate into their business plan models.