This is a calulator for valuing a new business line for a solar company using a DCF Model
The business line is customer acquisition for a 3rd party, where you are paid by the number of customers you acquire to subscribe to your client's solar farm. Customers are measured by their energy usage of the solar farm, which is counted in Megawatts (MWs).
Valuation Goal measures how much you want your business line to be worth, which, when compared to Valuation Output on the bottom - which is informed by the MW, Margin, and Valuation inputs - loads the progess bar. For instance, a Valuation Goal of $100 with a Valuation Output of $120 means the progress bar will show 120%.
MW Inputs allow you to determine the number of MWs that will be acquired by this business line from 2022-2024.
Revenue Rate is the number of dollars you generated per MW (no need for the $ sign in inputs).
Operating Margin is the revenue % that is converted to cashflow. For instance, a 65% margin implies 35% of revenue is lost due to expenses.
Discount Rate measures the cost of capital for the business line - how much it costs to get debt and equity financing for the project. It's treated as an interest rate on future cash inflows to conver them into current cash flows.
Growth Rate is how much your cash flows post 2024 - which constitute the terminal value of your business line - grow year over year.