Back to Excel models and data analysis

Project Finance – DashboardProject Finance
Dashboard

Fictional architecture firm · Budget vs actual, invoicing and results

Work Example
Total Budget
kr 4 970 700
Non-completed projects
Total Actual
kr 5 321 952
Incurred costs
Variance
(kr 351 252)
Budget − Actual
Invoiced
kr 6 200 000
Excl. VAT
Result
kr 878 048
Invoiced − Actual
Outstanding
kr 1 860 000
Click for details
Overdue
kr 400 000
Overdue outstanding
Over Budget
4
Number of projects
Hours
Click for details
Budget (h)5 782
Actual (h)5 987
Variance (h)-205
Effective hourly rate (NOK/h)kr 1 122
Invoicing
Click for details
Agreed fee excl. VATkr 7 020 000
Invoiced excl. VATkr 6 720 000
Invoiced % of agreed95,7%
Outstanding invoices6
Costs by category
Click for details
Hourskr 5 088 950
Consultantskr 361 047
Travelkr 188 369
Otherkr 114 536
Spending over time (monthly)
Budget
Actual
Project Status
6
Projects
Active (4)
Completed (1)
On hold (1)
Project Overview
ID Project Client Status Budget Actual Variance Invoiced Result ●
Download Excel Model
Excel Example project finance model

Need help with Excel models or data analysis?

Contact us

Back to Excel models and data analysis
ytly.no
Work example – Project finance dashboard