Investing in land, commonly referred to as "dirt" in real estate parlance, can be a lucrative venture, but like all investments, it carries both advantages and risks. Below is an analysis of the pros and cons, along with common strategies employed to profit from land investments.
SmartHelping / Renewable Energy / Excel
Build a 10-year forecast for a Solar-as-a-Service business that installs panels without charging an upfront installation fee, then earns recurring revenue from customer electricity usage and excess power sold to the grid. Model deployment timing, energy production, financing, direct costs, valuation, and returns across a scalable portfolio.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Watch the walkthrough, then open the screenshots to review the tranche assumptions, production and pricing drivers, debt schedules, pro forma statements, executive summary, valuation, sensitivities, and visual outputs.
What the model includes
Build the portfolio one deployment tranche at a time, then roll the activity into operating results, debt coverage, valuation, and equity-return outputs.
Enter up to 200 separate installation tranches, each with its own timing, cost, financing, production, pricing, and direct-cost assumptions.
Forecast up to ten years with the monthly detail needed for rollout timing and annual views for planning and presentation.
Forecast recurring revenue from energy consumed by each customer instead of relying on a one-time panel installation fee.
Separate energy used by the customer from excess production sold to the grid using its own kWh price assumptions.
Allocate expected annual power production by month to reflect the seasonal pattern of solar generation.
Define financing percentage, interest rate, and term by tranche, then monitor debt-service coverage as deployments grow.
Measure investment returns, apply an EBITDA exit multiple, and review the value created for equity investors.
Review 18 visualizations plus IRR and NPV sensitivities across changing exit years, EBITDA multiples, and discount rates.
The business behind the model
The operating concept differs from a traditional installer that earns a one-time project fee. The model follows the economics of retaining the installed system and monetizing its production.
The customer receives the solar installation without paying a conventional installation fee at deployment.
The business earns recurring revenue as the customer pays for electricity consumed, measured in kWh.
Power produced but not used by the customer can be sold to the grid under a separate pricing assumption.
Every tranche carries its own installation timing, cost, financing, production, pricing, and ongoing direct costs.
A row can represent one installation or a group of 10, 20, 100, or more installations by scaling the cost, production, and direct-cost assumptions.
Define how customer kWh pricing, grid pricing, and direct costs change over time across the operating forecast.
Inputs for every deployment tranche
Each tranche can reflect a different launch schedule, financing package, energy profile, selling price, and cost structure.
Define the installation month, the lead time from installation to kWh production, and the month recurring revenue begins.
Enter the total installation cost, percentage financed, interest rate, and loan term for each deployment tranche.
Forecast annual MWh consumed by the customer, the contracted kWh price, and any cap applied to that pricing.
Model the energy sold to the grid, grid price per kWh, maintenance, insurance, and other recurring direct costs per installation.
Decision-ready outputs
The deployment assumptions flow into a detailed operating forecast and a focused set of executive and investor outputs.
Review detailed revenue, direct costs, EBITDA, cash flow, and operating performance at both monthly and annual levels.
Use a higher-level annual view to communicate the scale, financial trajectory, and key results of the business.
Evaluate investor returns and present value using the forecast cash flows, discounting assumptions, and exit economics.
Apply an EBITDA exit multiple and monitor debt-service coverage, an important constraint when debt is used to accelerate deployment.
Test IRR across exit year and EBITDA multiple, then test NPV across discount rate and EBITDA multiple.
How to use it
Enter the installation month, cost, production lead time, and revenue start for every planned tranche.
Set annual customer usage, customer and grid kWh pricing, price caps, seasonality, and long-term pricing drivers.
Enter the financed percentage, rate, term, maintenance, insurance, and other direct costs associated with each tranche.
Use the pro forma, summary, DSCR, DCF, IRR, equity multiple, charts, and sensitivity tables to test the plan.
Who gets value from it
Plan installations, customer energy revenue, grid sales, financing, direct costs, and portfolio expansion.
Test the economics of launching and scaling a business that retains ownership of installed solar assets.
Evaluate deployment needs, debt-service coverage, cash generation, valuation, and equity returns.
Use a detailed bottom-up structure for client planning, fundraising, scenario analysis, and investment review.
Also available in these bundles
The Solar Panel Installation Model is also included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Use a broader library of bottom-up operating and financial models built around specific business types.
View Industry-Specific ModelsExplore solar, wind, hydro, storage, charging, recycling, and other energy-business forecasts.
View Renewable Energy ModelsGet the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.
View Super Smart BundleRelated renewable-energy and investor models
Use these complementary SmartHelping models for other renewable-energy businesses, manufacturing operations, and investor distribution structures.
Forecast feedstock, processing capacity, recovered materials, pricing, costs, financing, and returns.
Explore the battery recycling modelModel utility-scale solar production, revenue, operating costs, financing, valuation, and investor returns.
Explore the solar farm modelForecast generation, pricing, operating costs, capital needs, debt, and returns for a hydropower project.
Explore the hydropower modelBuild a deployment-based forecast for charging stations, utilization, energy sales, costs, and returns.
Explore the EV charging modelEvaluate biomethane production, revenue streams, operating costs, financing, and project economics.
Explore the biogas modelForecast turbine deployment, power production, energy pricing, operating costs, debt, and returns.
Explore the wind farm modelModel custom production volume, capacity, labor, materials, inventory, pricing, and operating performance.
Explore the MTO modelUse the solar model's DCF outputs to evaluate preferred equity, preferred returns, IRR hurdles, and investor distributions.
Explore the JV templatesQuestions before you buy
The modeled business installs panels without charging an upfront installation fee, then earns recurring revenue from customer kWh usage and excess power sold to the grid.
The template supports up to 200 deployment tranches. Each row can also represent a group of installations, allowing the model to scale to potentially thousands of systems.
Inputs include installation timing and cost, production lead time, revenue start, financing percentage, interest rate, term, customer and grid pricing, energy usage, grid sales, and ongoing direct costs.
Financing inputs are set by tranche, and the model calculates debt-service coverage because debt capacity is an important driver of deployment scale.
One table sensitizes IRR across exit year and EBITDA multiple. The second sensitizes NPV across discount rate and EBITDA multiple.
Yes. It is included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Model the full Solar-as-a-Service lifecycle
Forecast up to 200 tranches across ten years, including energy revenue, grid sales, seasonality, financing, DSCR, valuation, sensitivities, and 18 visualizations. One-time purchase for $65.
Fundraising rounds for a startup typically follow a sequence, each catering to different stages of the company's development. Here are the primary fundraising rounds:
I have had quite a bit of interest in the made-to-order financial model over the last year and with that has come a few modifications that have made sense to use on the master version of this template. Let's dive in!
Template: Made-to-Order Manufacturing Financial Model
Updates:
IRR sensitivity tables are invaluable in real estate models because they provide a clear, quantitative assessment of how changes in key assumptions, such as rental growth rates, cap rates, and construction costs, impact the internal rate of return (IRR). By systematically varying these inputs and observing the resulting IRR, investors and analysts can gauge the potential risks and rewards associated with different scenarios, enhancing their decision-making process. This helps in identifying the most critical variables that affect project viability, thus enabling more informed investment strategies and risk management. Ultimately, these tables support a thorough understanding of the sensitivity of returns to various market conditions and operational changes, ensuring that investors can make well-informed decisions based on a range of possible outcomes.
Real estate syndication fees are charges incurred during the process of pooling capital from multiple investors to invest in a real estate project. These fees compensate the syndicator (the party managing the investment i.e. the GP) for their work and can significantly impact the returns to investors. Here's a breakdown of common syndication fees and how they typically flow into a preferred return waterfall:
Owning businesses can be a highly effective long-term strategy for several reasons, including its potential to combat the effects of inflation:
I recently built the hydropower construction financial model and in it the construction loan needed an option to have the interest paid during the interest-only (i/o) period or accrue and compound. For the past week I've been debating on adding that functionality update to the wind farm and biogas models as they both have interest-only loan options, but if that is chosen, the interest automatically accrued and compounded until the REFI / conversion month. Now, they also have the additional feature to pay interest during i/o period or accrue and compound.
Excel has long been a cornerstone tool for financial planning and analysis (FP&A) due to several key attributes that make it a powerful and versatile solution:
SmartHelping / Renewable Energy / Excel
Build a 20-year, monthly and annual financial forecast for a hydropower dam using bottom-up generation assumptions, construction financing, operating costs, fixed assets, valuation, and investor returns. Connect flow rate, net head, uptime, efficiency, and kWh pricing directly to a fully integrated 3-statement model.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Watch the walkthrough, then open the screenshots to review the project timing, bottom-up energy assumptions, construction loan, operating forecast, financial statements, DCF, return analysis, fixed assets, and KPI visuals.
What the model includes
Translate physical dam and water assumptions into electricity revenue, operating cash flow, financing requirements, financial statements, valuation, and investor returns.
Run the detailed project forecast for up to 20 years and use terminal value to represent economics beyond the explicit forecast.
Integrate the income statement, balance sheet, and cash flow statement across both monthly and annual views.
Calculate energy and revenue from flow rate, net head, uptime hours, efficiency, and expected kWh pricing.
Test reduced flow, declining efficiency, expansion, changing uptime, and other year-specific operating scenarios.
Link monthly loan draws to construction costs, choose how interest is handled, and convert the balance to amortizing debt.
Calculate depreciation and net book value, then estimate the net tax effect when the project is sold at exit.
Measure project value and returns and support joint-venture cash-flow waterfalls using IRR hurdles.
Use fixed and variable expense slots, staffing assumptions, three transmission-cost inputs, additional CAPEX, and detailed visualizations.
Bottom-up hydropower assumptions
The model denominates its physical calculations in meters and lets the core generation variables change by year across the 20-year forecast.
Define the volume of water moving through the generation system and adjust it over time for changing operating conditions.
Use the effective vertical drop created by the dam's size and height to drive the energy available from gravity.
Apply conversion efficiency to the available hydraulic energy and test degradation, improvement, or equipment changes by year.
Define the operating time available for generation and use it to translate capacity into annual MWh production.
Apply expected revenue per kWh and change pricing assumptions throughout the life of the project.
Adjust physical and commercial assumptions annually to evaluate capacity expansion or other operating changes.
Construction financing
The construction loan follows the monthly build schedule, offers flexible treatment of interest, and transitions into regular principal-and-interest repayment.
Define the number of interest-only months while the project is being built and before regular amortization begins.
Use the defined financing percentage and construction costs to calculate the loan amount drawn in each month.
Select whether construction-period interest compounds into the loan balance or is paid in cash each month.
Define the terms for principal-and-interest repayment after the interest-only construction period ends.
When terminal value is displayed, repay the remaining loan balance in the selected project exit month.
Use the additional CAPEX schedule for one-time depreciable spending that does not belong in the construction schedule or loan draws.
Decision-ready outputs
Physical and financial assumptions flow into connected statements, valuation, return analysis, fixed-asset schedules, and operating KPIs.
Review the integrated income statement, balance sheet, and cash flow statement at both monthly and annual levels.
Value the explicit forecast cash flows and include an optional terminal value to represent the project's longer economic life.
Measure investor returns and use the modeled cash flows in an IRR-hurdle joint-venture waterfall structure.
Calculate cost basis, accumulated depreciation, net book value, and the net tax effect based on terminal value less net book value.
Review high-level financial charts plus KPIs such as uptime, efficiency over time, and MWh generated.
How to use it
Use month numbers for all timing assumptions, then layer the desired dates onto the selected model start month.
Enter flow rate, net head, uptime, efficiency, and kWh pricing for each year of the operating period.
Configure the construction loan, operating cost categories, three transmission-cost inputs, staffing, and additional depreciable assets.
Use the financial statements, DCF, IRR, terminal value, fixed-asset analysis, and KPI visuals to test downside, degradation, and expansion cases.
Who gets value from it
Plan construction, generation, energy revenue, operating costs, staffing, CAPEX, and long-term performance.
Evaluate project cash flow, terminal value, IRR, downside cases, and the economics available to equity.
Review construction draws, interest treatment, conversion to amortization, and repayment at exit.
Use a detailed bottom-up framework for feasibility analysis, fundraising, client work, and scenario planning.
Also available in these bundles
The Hydropower Financial Model is also included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Use a broader library of bottom-up operating and financial models built around specific business types.
View Industry-Specific ModelsExplore solar, wind, hydro, storage, charging, recycling, and other energy-business forecasts.
View Renewable Energy ModelsGet the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.
View Super Smart BundleMore renewable-energy business case models
Use these complementary SmartHelping models for other renewable-energy, charging, recycling, and distributed-generation opportunities.
Forecast feedstock, processing capacity, recovered materials, pricing, costs, financing, and returns.
Explore the battery recycling modelModel utility-scale solar production, revenue, operating costs, financing, valuation, and investor returns.
Explore the solar farm modelForecast turbine deployment, power production, energy pricing, operating costs, debt, and returns.
Explore the wind farm modelBuild a deployment-based forecast for charging stations, utilization, energy sales, costs, and returns.
Explore the EV charging modelEvaluate biomethane production, revenue streams, operating costs, financing, and project economics.
Explore the biogas modelModel material intake, processing, recovered outputs, pricing, direct costs, operating performance, and valuation.
Explore the recycling modelForecast a Solar-as-a-Service business with deployment tranches, kWh revenue, grid sales, financing, and returns.
Explore the solar installer modelRequest modifications to this hydropower model or a custom infrastructure forecast built for a specific project.
Contact SmartHelpingQuestions before you buy
The explicit forecast runs for up to 20 years, with an optional terminal value to account for the project's remaining economic life in the DCF analysis.
The bottom-up calculation uses water flow rate, net head, uptime hours, efficiency, and kWh pricing. Physical calculations are denominated in meters.
A selected percentage of monthly construction costs drives loan draws during an interest-only period. Interest can be accrued or paid, and the loan can convert to regular principal-and-interest amortization.
The model calculates depreciation, accumulated depreciation, and net book value. At exit, the estimated net tax effect can be based on terminal value less net book value, and the remaining loan can be repaid.
Yes. An additional CAPEX schedule handles depreciable one-time costs that are outside the main construction schedule and not subject to construction financing.
Yes. It is included in the Industry-Specific, Renewable Energy, and Super Smart bundles.
Model the full hydropower project lifecycle
Build a 20-year, monthly and annual 3-statement forecast with bottom-up generation, construction debt, fixed assets, DCF, terminal value, IRR, and operating KPIs. One-time purchase for $75.
Below are some things that have shaped a big part of the industry I work in.
If you want to support me and my continuous building of new bottom-up dynamic 3-statement models, check out these financial model templates that help anyone create robust projections across 100s of different industries.
Maintaining the profitability and operational efficiency of an auto repair chain during slow times and managing location scaling requires strategic planning and implementation. Here are some strategies for both scenarios: