Excel model for starting an incorporated small business in Canada:…
Excel model for building a laneway house, garden suite, coach…
Annual Excel model for a used lubricating oil re-refinery. Compare…
Excel model for an Airbnb rental arbitrage business: lease apartments…
Monthly Excel model of the BRRRR strategy in Canada: buy…
Annual Excel model for a mixed-plastic pyrolysis (chemical recycling) plant:…
Annual Excel model for a construction and demolition (C&D) waste…
Annual Excel model for an e-waste (WEEE) recycling plant with…
Monthly 5-year Excel model for a self-publishing imprint on Amazon…
22-tab lender-grade solar project finance model: DSCR-sculpted debt with a…
Value an operating manufacturing company from its real accounts. Enter…
Plan a restaurant, cafe, or quick-service chain of up to…
A full feasibility and valuation model for a new manufacturing…
A complete development and operating model for a hotel with…
Evaluate dual-revenue agrivoltaics economics with a 30-year Excel model integrating…
Evaluate industrial heat electrification with a 240-month Excel model linking…
Evaluate a distributed energy aggregator with a 240-month Excel financial…
Evaluate biochar pyrolysis and carbon removal economics with a 240-month…
Evaluate Bitcoin mining operations with a 120-month Excel financial model…
Plan a single film's production budget, financing, release windows and…
A 30-year availability-based PPP infrastructure Excel model connecting 15 construction…
An editable 10-year self-storage financial model integrating Development and Acquisition…
Analyze renewable-power-to-methanol project economics with a 360-month Excel financial model,…
An integrated 10-year Excel DCF valuation model with three years…
15-year AI data center project finance model with power-constrained IT…
30-year monthly Solar PV project finance model in Excel with…
An institutional-grade 10-year Excel financial model template for AI GPU-as-a-Service…
Excel model for a 1 to 4 unit rental property…
Annual Excel model for a tire recycling and crumb rubber…
A co-located solar PV + battery storage financial model built…
A solar PV project financial model built on real 2025…
Annual Excel model for a tire pyrolysis plant: tipping fees,…
Evaluate boutique hotel and resort economics with an editable 120-month…
Evaluate carbon capture and geological storage project economics with a…
A 180-month residential and mixed-use development financial model combining unit…
Standalone BESS Excel project finance model with 240 monthly forecasts,…
20-year Excel biotech valuation model for 15 drug candidates with…
30-year Solar PV + BESS Excel project finance model with…
10-year commercial property underwriting model with 500-row rent roll, lease…
A quarterly land subdivision and lot development model. Three phases,…
🚀 Evaluate a launch-services and satellite-constellation business with an integrated…
🧠 Evaluate a psychedelic-therapeutics company with an integrated 32-sheet, 12-year…
Evaluate a vertical farm from canopy design to enterprise value…
A battery energy storage (BESS) financial model built on real…
A complete, fully linked Excel financial model for dairy farms,…
A detailed 5-year Excel financial model for a calf fattening…
Turn a public company’s operating assumptions into a decision-ready equity…
15-year financial model for a tea farm providing forecasts, profitability…
10-year financial model for a Wave Energy plant providing forecasts,…
15-year financial model for a sustainable aviation fuel plant providing…
A clean, fully formula-driven acquisition model for an income-producing property.…
A practical Excel-based acquisition underwriting model designed for European SME…
Buy-side underwriting for a US utility-scale solar plant that is…
Value the equity of a business directly by discounting free…
Bankable Financial Model for Utility-Scale Solar PV Project Finance This…
AI Data Center Power Procurement & Behind-the-Meter Generation Model ⚡…
⚡ Model the grid-connection decision before delay, network upgrades, deposits,…
The Self-Storage Development & Acquisition Model Pro is an institutional-grade…
An institutional, lender grade Excel model for a temperature controlled…
An institutional, lender grade Excel model for a concrete block…
2. You will notice the highlighted cells of free cash flows for each year or duration in the first part. Hence, you might be wondering where all these cash flows came from?
The Free Cash Flows or FCFs in calculating the Net Present Value came from the EBITDA. Again, you can see on the side of the excel the particulars. EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) refers to the company's earnings before essential expenses such as interest payments, tax payments, depreciation, and certain capital expenses that are accounted for, or amortized, over time.
Take note of the values under each cash flow as well. Following EBITDA is the discount for taxes, capital expenditures, and changes in networking capital. You will notice that the values for those elements are all negative. It means that this is the amount of money that the company has set aside to upgrade, fund new projects, or pay taxes.
3. The following assumed data are the EV/EBITDA and discount rate.
If you are new to finance, you might be wondering what does EV/EBITDA means?
EV/EBITDA refers to the ratio which gives a picture of comparison between Enterprise value (EV) to the company's EBITDA. This is commonly used as a valuation measure to determine if the company is overvalued or undervalued.
On the other hand, the Discount rate represents the time worth of money, the risk of an investment, or it can be used as a barrier rate for investment decisions.
4. Now that we are done with the assumed values, we will calculate the terminal value.
As you can see in the example, to calculate the Terminal Value, we multiplied the value of the fifth year by the EV/EBITDA. Thus, the Terminal value will be the sum of all cash flows from an investment or project. We use the assumed value for year five because we expect it to be the value of future cash flows beyond the 5-year forecast period.
5. Next is, to sum up, all the components to calculate the Free Cash Flows for each year.
You can see from our excel file how Free cash flows are calculated using EBITDA and other components.
6. After that, we are going to calculate the discount factors for each year.
Notice that we will need the discount rate and the time duration in the formula to calculate the discount factors. Take note that the only changing value in the formula is the time duration. See the image below:
7. The next thing that we will do is to calculate the discounted free cash flows.
We just need to add the calculated Free cash flow to its discounting factor. You must remember that the discount factor and discount rate are closely connected; however, the discount factor pertains to the present value of cash flows while the discount rate considers the current value of future cash flows. Another purpose it serves is it may forecast an investment's predicted profits or losses, as well as its net future value.
8. Lastly, we calculate the value of Net Present Value (NPV)
To compute the Net Present value in excel, we add all of the discounted free cash flows, including the initial investment. You will notice that the value for Year 0 is negative. Why is the value negative?
Year 0 serves as the start-up year, which means that an initial investment or capital is required for a business to operate. Therefore, the formula states that we must subtract today's expected cash flows from today's invested cash value when calculating the NPV. In this case, we will include the initial investment in the sum of discounted cash flows. It will be automatically deducted from the net present value because it is a negative amount of money.
Since our calculated Net Present Value in excel is positive, it means that Loveflies Co.'s investment in new beauty machines and ingredients will be helpful to increase sales or profit.
We may simply compare the values of each cash flow from each year in this diagram. You already know that the value of Net Present Value may be calculated by adding all of the discounted cash flows. However, in this illustration, the free cash flows for each year are not yet discounted. As a result, you can see that the trend line for the calculated values is going up until year 5, indicating that the investment made by investors may provide strong cash flows in the future.
To determine whether an investment can generate and sustain consistent cash flows, the net present value should be discounted. Similarly, after discounting, the calculated net present value should still be positive. Even if we include the initial investment, which has a negative value in the discounted cash flow calculation, the result is still positive in this example. It suggests that Loveflies Co.'s project is viable and will generate substantial cash flows in the coming years.
We followed the identical methods as in the first example in this case. As you can see, we have already figured out all the numbers. The starting investment, free cash flows for each year, and the discount rate were all adjusted. The only difference between this case and the first is that the calculated net present value was negative.
When the net present value is negative, the project is likely to lose a lot of money. Essentially, you expect to lose money on this project. As a result, it makes no logical sense to continue with this project.
On the other hand, the growth of other discounted cash flows from different years appeared less than the amount of money invested. As a result, the calculated net present value is negative and not even half of the amount invested.
In contrast, the first example has a favorable net present value, indicating that the project will be profitable. Also, you can see that the initial investment for Loveflies Co. is lesser than Buds and Meadows. At the same time, Buds and Meadows received a large amount of funding as a primary investment. As a result, its computed net present value was negative, signaling a red flag to investors.
We changed the values of the highlighted cells in this example. From Year 0 to Year 5, the free cash flows vary. The values are not in a fixed range, as can be seen. This indicates that cash flows are not always at a constant rate.
In this case, the computed net present value is similarly positive, indicating that the SEL construction investment in new equipment is a good project that will provide many cash flows in the future. That's why the company can consider pursuing this venture.
The significant disparity between the Net Present Values of Loveflies Co. and SEL Construction may be seen in this comparison diagram.
Even though their initial investments are different, both of their calculated net present values are positive. This means that the calculated net present values outweighed the funds invested. Similarly, it indicates that both firms should continue with their investments because both can generate large amounts of cash flow.
Similarly, from an NPV point of view, Loveflies Co. generated a more valuable result than Buds and Meadows. However, this result might be different from an IRR analysis. See here for more information about