Financial Modelling Tool for Buy-to-Let Property Developers

Project Setup

• Project name : Buy-to-Let Property Portfolio
• Time period : Monthly (ideal for tracking rental income and mortgage payments)

Income Components

Component: Rental Income

Sub-components:

• Residential Property 1 – Monthly Rent (£1,200/month)
• Residential Property 2 – Monthly Rent (£1,500/month)
• Short-term Rental Income (Variable, based on occupancy rates)
• Parking Space Rental (£100/month)

Component: Additional Income

Sub-components:

• Service Charges to Tenants (£50/month per unit)
• Late Payment Fees (Occasional, estimated yearly total)
• Utilities Recharges (if applicable)

Expenditure Components

Component: Operational Costs

Sub-components:

• Mortgage Payment – Property 1 (£800/month interest + principal)
• Mortgage Payment – Property 2 (£1,000/month interest + principal)
• Maintenance & Repairs (£200/month per property, with additional annual refurbishments)
• Property Management Fees (10% of rental income)
• Insurance (£500/year per property)
• Utilities & Council Tax (if covering tenants' costs)

Component: Administrative Costs

Sub-components:

• Legal & Accounting Fees (£1,000/year)
• Marketing for Vacant Properties (£300 per vacancy)
• Licensing Fees (£500/year for HMO licenses)
• Software & Tools (Subscription to property management software or Brixx itself!)

Component: Taxes

Sub-components:

• Income Tax on Rental Profits (Variable, depending on total income)
• Capital Gains Tax (modelled when a property sale is forecasted)
• Stamp Duty (modelled in the acquisition phase)

Asset Components

Component: Fixed Assets

Sub-components:

• Property 1 (Purchase price: £250,000, appreciation rate: 3% annually)
• Property 2 (Purchase price: £300,000, appreciation rate: 3% annually)
• Furniture & Fixtures (£5,000 per property, depreciated over 5 years)

Component: Current Assets

Sub-components:

• Cash Reserves (Starting balance + monthly surplus)
• Accounts Receivable (Outstanding rent)
• Tenant Deposits Held (Modelled as a liability if required)

Funding Components

Component: Mortgages

Sub-components:

• Buy-to-Let Mortgage – Property 1 (£200,000 at 4% interest, 25-year term)
• Buy-to-Let Mortgage – Property 2 (£240,000 at 3.8% interest, 25-year term)

Component: Personal Investment

Sub-components:

• Initial Equity Contribution (£50,000 for Property 1, £60,000 for Property 2)

Component: Future Funding (Optional)

Sub-components:

• Bridging Loan for New Property Acquisition (Short-term, higher interest rate)

Scenario Planning in Brixx

Vacancy Rate Scenarios :

• Model a 5%, 10%, or 20% vacancy rate to see the impact on cash flow.

Interest Rate Changes :

• Test scenarios with increasing mortgage rates (e.g., 1% rise) to evaluate financial resilience.

Property Appreciation :

• Forecast how property values grow over time and the effect of capital gains when selling.

Unexpected Repairs :

• Create an Unexpected Expenses component to simulate sudden major repairs.

Dashboard & Reporting

Cash Flow Report :

• Visualise monthly income versus expenses, highlighting net rental income.

Balance Sheet :

• Track growing property values as assets while seeing mortgage liabilities reduce over time.

Profit & Loss Statement :

• Display total revenue, operational costs, and net profit for each fiscal year.

Custom KPIs :

• Set up specific metrics like Rental Yield, Loan-to-Value Ratio, and Return on Investment (ROI).