Financial Dashboard

Comprehensive financial analysis and budget tracking for Frankland River

Last updated: 7/22/2024

Updated by: Sarah Chen

$3,500,000

Total Budget

52.9% utilized

$1,055,000

Total CAPEX

Capital expenditure

$83,000

OPEX YTD

Operating expenses

$875,000

Revenue Generated

+12.3% vs forecast

On Track

Category	Type	Budgeted	Actual	Variance	% Variance
Site Preparation	CAPEX	$450,000	$425,000	$25,000	-5.6%
Seedlings & Planting	CAPEX	$500,000	$487,000	$13,000	-2.6%
Infrastructure	CAPEX	$280,000	$295,000	+$15,000	+5.4%
Monitoring & Compliance	OPEX	$120,000	$108,000	$12,000	-10.0%
Management & Admin	OPEX	$200,000	$180,000	$20,000	-10.0%

Description	Category	Supplier	Status	Budgeted	Actual	Variance	Date
Initial site preparation - weed control and clearing Invoice: GL-2022-0456	SITE PREP	GreenLand Contractors	PAID	$180,000	$165,000	$15,000	6/15/2022
Native seedlings - 50,000 units mixed species Invoice: MVN-2022-1234	SEEDLINGS	Murray Valley Nursery	PAID	$250,000	$245,000	$5,000	8/20/2022
Mechanical planting services Invoice: PPS-2022-0789	PLANTING	Precision Planting Services	PAID	$320,000	$335,000	+$15,000	9/10/2022
Livestock exclusion fencing - 15km Invoice: RFC-2022-0234	FENCING	Rural Fencing Co	PAID	$180,000	$190,000	+$10,000	7/30/2022
Access roads and firebreaks	INFRASTRUCTURE	—	PLANNED	$120,000	—	—	—

Month	Budgeted	Actual	Variance	% Variance
Jan 24	$200,000	$185,000	$15,000	-7.5%
Feb 24	$250,000	$267,000	+$17,000	+6.8%
Mar 24	$180,000	$172,000	$8,000	-4.4%
Apr 24	$300,000	$295,000	$5,000	-1.7%
May 24	$220,000	$238,000	+$18,000	+8.2%
Jun 24	$180,000	$165,000	$15,000	-8.3%

Document	Type	Version	Created By	Date	Actions
Murray River Financial Model v3.2 Comprehensive financial model including sensitivity analysis	excel	v3.2LATEST	Sarah Chen	7/15/2024
Carbon Price Sensitivity Analysis Analysis of project returns under different carbon price scenarios	excel	v1.1LATEST	Michael Thompson	7/10/2024