Franklin Street Properties Corp. (FSP) DCF Valuation

Franklin Street Properties Corp. (FSP) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Franklin Street Properties Corp. (FSP) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Simplify Franklin Street Properties Corp. (FSP) valuation with this customizable DCF Calculator! Featuring real Franklin Street Properties Corp. (FSP) financials and adjustable forecast inputs, you can test scenarios and uncover Franklin Street Properties Corp. (FSP) fair value in minutes.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 269.1 245.8 209.4 165.6 145.7 125.2 107.5 92.4 79.3 68.2
Revenue Growth, % 0 -8.63 -14.84 -20.89 -12.02 -14.1 -14.1 -14.1 -14.1 -14.1
EBITDA 127.0 118.2 94.0 66.1 57.9 55.0 47.3 40.6 34.9 30.0
EBITDA, % 47.2 48.09 44.89 39.89 39.76 43.97 43.97 43.97 43.97 43.97
Depreciation 266.6 247.2 196.4 165.1 54.7 107.7 92.5 79.5 68.3 58.6
Depreciation, % 99.1 100.53 93.8 99.71 37.57 86.04 86.04 86.04 86.04 86.04
EBIT -139.7 -128.9 -102.4 -99.1 3.2 -52.8 -45.4 -39.0 -33.5 -28.7
EBIT, % -51.91 -52.44 -48.91 -59.82 2.19 -42.18 -42.18 -42.18 -42.18 -42.18
Total Cash 9.8 2.7 40.8 6.6 125.5 28.6 24.6 21.1 18.1 15.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 91.7 75.4 75.0 74.7 42.6
Account Receivables, % 34.09 30.69 35.81 45.11 29.23
Inventories -3.0 .0 .0 -4.4 .0 -.9 -.8 -.7 -.6 -.5
Inventories, % -1.12 0.000000407 0.000000478 -2.63 0 -0.75091 -0.75091 -0.75091 -0.75091 -0.75091
Accounts Payable 66.7 72.1 89.5 50.4 41.9 39.0 33.5 28.8 24.8 21.3
Accounts Payable, % 24.77 29.31 42.75 30.41 28.74 31.2 31.2 31.2 31.2 31.2
Capital Expenditure -70.7 -77.9 -64.8 -54.9 -31.6 -36.0 -30.9 -26.6 -22.8 -19.6
Capital Expenditure, % -26.29 -31.69 -30.97 -33.16 -21.71 -28.76 -28.76 -28.76 -28.76 -28.76
Tax Rate, % -0.5833 -0.5833 -0.5833 -0.5833 -0.5833 -0.5833 -0.5833 -0.5833 -0.5833 -0.5833
EBITAT -134.1 -127.9 -102.2 -83.5 3.2 -50.6 -43.5 -37.3 -32.1 -27.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 39.8 60.0 47.3 -7.8 45.6 18.0 18.6 16.0 13.8 11.8
WACC, % 6.55 6.68 6.7 6.08 6.71 6.55 6.55 6.55 6.55 6.55
PV UFCF
SUM PV UFCF 65.8
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 12
Terminal Value 402
Present Terminal Value 292
Enterprise Value 358
Net Debt 277
Equity Value 81
Diluted Shares Outstanding, MM 103
Equity Value Per Share 0.79

What You Will Receive

  • Adjustable Forecast Inputs: Modify key assumptions (growth %, margins, WACC) effortlessly to explore various scenarios.
  • Real-World Data: Franklin Street Properties Corp. (FSP) financial data pre-loaded to kickstart your analysis.
  • Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
  • Customizable and Professional: A sleek Excel model designed to meet your valuation requirements.
  • Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Investment Metrics: Adjust essential parameters such as occupancy rates, rental income growth, and operating expenses.
  • Instant Property Valuation: Automatically computes market value, cap rates, and other key financial indicators.
  • High-Precision Analytics: Leverages Franklin Street Properties' real estate data for accurate investment assessments.
  • Comprehensive Scenario Planning: Easily evaluate various market conditions and their potential impacts on performance.
  • Efficiency Booster: Streamlines the valuation process, removing the need for intricate financial models.

How It Works

  • Download: Get the pre-prepared Excel file containing Franklin Street Properties Corp.'s (FSP) financial data.
  • Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various forecasts and analyze results immediately.
  • Make Decisions: Leverage the valuation findings to inform your investment approach.

Why Choose This Calculator for Franklin Street Properties Corp. (FSP)?

  • Designed for Real Estate Experts: A specialized tool tailored for analysts, investors, and property managers.
  • Comprehensive Data: Franklin Street Properties’ historical and projected financials included for precision.
  • Flexible Scenario Analysis: Easily test various investment scenarios and assumptions.
  • Insightful Outputs: Automatically calculates intrinsic value, NPV, and essential real estate metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.

Who Should Use This Product?

  • Investors: Evaluate Franklin Street Properties Corp. (FSP)'s performance before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
  • Real Estate Developers: Understand how publicly traded real estate companies like Franklin Street Properties Corp. (FSP) are valued.
  • Consultants: Provide expert valuation analyses for clients in the real estate sector.
  • Students and Educators: Utilize current market data to practice and teach real estate valuation principles.

What the Template Contains

  • Preloaded FSP Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.