Sign in with Google to save your projects.

← Valtrics Real Estate · Budget & Capital Stack

Budget & Capital Stack Engine

Upload the original budget, track revised budget and cost overages, and log invoices each period.

Setup Project Details

Project Name
Location
Update Cadence Determines how invoice periods are grouped and labelled.

Step 1 Capital Stack

Add each source of capital and choose whether it is Debt or Equity. For debt, set the interest rate, interest-only period, amortisation period and repayment (maturity) date — interest is calculated automatically on the outstanding drawn balance each period. Expand a source to enter how much is drawn in each Monthly period.

Interest-only / amortisation / repayment are measured in periods of the chosen cadence.
Source Type Committed Rate (%) IO Periods Amort. Periods Repayment / Exit Date Drawn to Date Interest to Date
TOTAL CAPITAL $0 $0 $0

Debt is shown senior (bottom of stack) to equity. Interest during the interest-only period is interest-only; after it, the drawn balance amortises over the amortisation period until the repayment date (any remaining balance is due at maturity).

Draw Schedule — period by period

Every source across every period on a single screen. For debt, each cell shows the draw with the interest accrued that period beneath it. Edit draws in a source's expandable row above.

Saved Projects

Sign in with Google (top right) to save this project and reload it later. Your work autosaves to your account while signed in.

Step 2 Budget & Cost Overages

Upload your budget as a CSV or Excel file — the engine automatically finds the header row and pulls only the original budget and actual cost line items, skipping titles, section headings, subtotals and total rows. Column labels like "Original / Budget / Approved" and "Actual / Spent / Cost to Date" are detected in any order. You can also add line items manually. Revised budget is editable; Cost Overage defaults to Revised − Original and can be overridden at any point.

Line Item / Cost Code Original Budget Revised Budget Cost Overage Actual to Date
TOTAL $0 $0 $0 $0

Step 3 Periods & Invoices

Invoices are grouped by Monthly period. Add a period, then upload invoices (CSV / Excel) or add them one at a time. Each invoice can be mapped to a budget line item so actuals roll up automatically.

No periods yet. Add a period to start logging invoices.

Dashboard Funding & Cost Position

Original Budget
$0
Revised Budget
$0
Cost Overage
$0
0% vs original
Actual Spend
$0
0% of revised
Interest Paid
$0
debt interest to date
Invoices Logged
0
0 periods

Budget Position

Original Budget$0
Revised Budget$0
Actual Spend to Date$0
Original Revised Actual

Top Cost Overages

No overages. Enter a cost overage, or set a revised budget above the original.

Spend by Period

No invoices logged yet.

Spend vs Budget by Line Item

Add budget line items and invoices to see spend against each line.
Total Committed Capital
$0
Equity
$0
0% of stack
Debt
$0
0% of stack
Capital Drawn to Date
$0
Interest to Date
$0
Funding vs Cost
$0
vs revised budget

Capital Stack Composition

Add capital sources
Equity Debt Funding gap

Interest by Debt Source

Add a debt source with a rate and draws to see interest accrue.