Financial Planning

# Integrated Corporate Financial Planning & Analysis Model

I developed an integrated **Corporate Financial Planning and Financial Analysis Model in Microsoft Excel** designed to support financial forecasting, budgeting, performance analysis, and decision-making.

The model includes:

* **Financial Planning & Forecasting** for multiple historical and forecast periods.

* **Income Statement** with sales, COGS, gross margin, operating expenses, EBIT, interest expense, taxes, net income, EPS, dividends, and changes in equity.

* **Balance Sheet** covering current assets, receivables, inventories, PPE, liabilities, debt, shareholders’ equity, and external funds needed.

* **Cash Flow Statement** analyzing operating, investing, and financing cash flows.

* **Common-Size Financial Statements** showing income statement and balance sheet items as percentages of sales.

* **Financial Ratios Analysis**, including profitability, liquidity, financial leverage, asset turnover, market value, and other key performance indicators.

* **DuPont Ratio Analysis** to evaluate the drivers of Return on Equity (ROE).

* **Financial Forecasting Assumptions** covering sales growth, tax rates, short-term and long-term interest rates, dividend payout, and P/E assumptions.

* **Sensitivity Analysis** to evaluate the impact of changes in sales growth on External Funds Needed (EFN).

* Extensive use of **Excel formulas and integrated financial relationships** to ensure that changes in assumptions automatically flow through the financial model.

The project demonstrates advanced skills in **Excel Financial Modeling, Financial Planning, Forecasting, Financial Statement Analysis, Ratio Analysis, Sensitivity Analysis, and Corporate Finance**.

This type of model can be customized for companies, startups, investment analysis, budgeting, forecasting, and management reporting.