3-Statement Financial Model with debt schedule
Originally published: 20/11/2023 11:01
Publication number: ELQ-48444-1
View all versions & Certificate
certified

3-Statement Financial Model with debt schedule

3-Statement financial model with debt and fixed asset schedules

Description
This 3-Statement Financial model will be a perfect base for most financial forecasting exercises for corporate finance, budgeting, and valuation purposes.

The model includes:
1- Readme tab with all explanations

INPUTS
2- P&L Inputs:
  a- 4 Revenue Streams
  b- COGS
  c- Opex as a % of revenue and YoY growth

3- Balance Sheet Inputs:
  a- Receivable Days
  b- Inventory Days
  c- Other Current Assets
  d- Payable Days
  e- Tax Liability
  f- Other Current Liabilities
  g- Equity issuance
  h- Dividends

4- Cash Flow Inputs

5- Checking tab to avoid mistakes during modeling

SCHEDULES
1- Fixed Asset
2- Long Term debt

OUTPUT
1- Monthly and annual tabs with integrated P&L, Balance Sheet, and Cash Flow statement. All the information you need at a glance.

If you want to learn more about Castellum Capital, we help start-ups get funded by shortening the fundraising time and maximizing the valuation and investment terms. Please visit us at www.castellum.capital.

I am reachable at a.morente@castellum.capital.

This Best Practice includes
1 Excel file

Alberto Morente, CFA offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Financial forecasting, valuation, budgeting.
It can be modified to have a very detailed financial model

Financial forecasting, valuation, budgeting.

SaaS
Short-term debt


5.0 / 5 (1 votes)

please wait...