A comprehensive editable, MS Excel spreadsheet for tracking renovation project finances throughout your construction project, including summary tab, HR contract costs, SOW, supplier forecasts, tool hire costs, actuals, variance, expenses, suppliers and overall suppliers costings.

Track specialised funding that is frequently used for large-scale renovation projects and infrastructure. 

This entails the detailed planning, organising, and administration of financial resources for complicated projects such as real estate re-developments. 

Calculate project construction schedule cash flows over stages from the initial start to the operating phase.

It allows users to monitor and control the timing and how the cash flows over that time.

The primary worksheet, gives an overview of financing any project, expenses incurred, SOW, Forecast vs Actuals, forecast days, actual days worked, hours, variance, actual total cost vs forecast revenue, realistic revenue, and variance in revenue. Total days of variance and total cost, colour coded so easy to track.

Individual tabs for the following: Dining Room, Kitchen, Master Bedroom, Bedroom 2, Bathroom, Garage, and Exterior

(All tabs are editable and you can easily rename, add, and copy tabs)

Schedule of work is broken down into hours, so if you have 2 employees on installing electricals simply add your hourly rate and how many hours projected for the work, all calculations are done for you.

Total supplier costs tab: deliverables, purchase orders, invoice numbers on a single page.

Variables are colour coded, so if a job is one schedule job is highlighted in blue, green for under forecast and red for over.

Adjust inputs such as construction, landscaping and (Land Related Costs, Administration Fees, Building Permits, and Other, Hard Costs, General  Operations, and Closing Costs), along with debt and equity financing, monthly equipment rental revenue for each individual unit if required, escalation rates, management expenses, refurbishments, utilities, insurance, and taxes.

All of my templates are made with the user's needs and comfort in mind, according to best practice project modelling standards and demonstrating our commitment to excellence and client satisfaction.

My financial models are the ideal tools to improve your project operations, regardless of your level of knowledge in finance, accounting, or using Microsoft Excel!

However, if you run into any problems utilising this template and can't find the right help in the instructions, please don't hesitate to get in touch with us.

Provides thorough oversight, tracking, and reporting of construction project finances for engineers, including updates on budget utilisation and projections.

Eliminates the need to create project finance trackers from scratch and includes all common construction project actual and projection components.

Offers a number of charts for the project cost status that can be used in senior management reports and status reports.