Portfolio Project 01

Financial
Modeling

An interactive financial modeling tool covering 3-statement modeling, 5-year forecasting, capital budgeting, loan amortization, and WACC analysis.

Assumptions — edit any value to update all statements

Revenue ($)

COGS % of Revenue

SG&A % of Revenue

Depreciation ($)

Interest Expense ($)

Tax Rate (%)

Cash ($)

Accounts Receivable ($)

Inventory ($)

PP&E ($)

Accounts Payable ($)

Long-Term Debt ($)

Key Metrics

Forecast Assumptions

Base Year Revenue ($)

Revenue Growth Rate (%)

COGS % of Revenue

SG&A % of Revenue

Depreciation ($)

Tax Rate (%)

Interest Expense ($)

CAPEX ($)

Revenue & Net Income Projection

5-Year Pro Forma

Project Inputs

Initial Investment ($)

Discount Rate / WACC (%)

Year 1 Cash Flow ($)

Year 2 Cash Flow ($)

Year 3 Cash Flow ($)

Year 4 Cash Flow ($)

Year 5 Cash Flow ($)

Terminal Growth Rate (%)

Cash Flow Analysis

Loan Parameters

Loan Amount ($)

Annual Interest Rate (%)

Loan Term (Years)

Payments Per Year

Principal vs Interest Over Time

Amortization Schedule (first 24 periods)

Capital Structure

Total Equity ($)

Total Debt ($)

Cost of Equity — Ke (%)

Cost of Debt — Kd (%)

Tax Rate (%)

CAPM — Cost of Equity

Risk-Free Rate (%)

Beta

Market Risk Premium (%)

Capital Structure Breakdown

FinancialModeling

Financial
Modeling