Excel Financial Analysis and Model of Pfizer Inc.
Budget: €8 – €20 EUR
I need a complete financial analysis model built in Excel based on my MBA assignment requirements (Financial Statements Analysis & Company Valuation – FSACV) for the company Pfizer Inc.
The freelancer must create a fully automated Excel model including:
Historical Financial Statements (3 years): Balance Sheet, Income Statement, Cash Flow Statement (data will come from a listed company on Yahoo Finance / Nasdaq / Reuters).
Inputs Page: Growth assumptions, cost assumptions, amortization, CAPEX, interest rate, dividends, etc. All inputs must be linked through formulas.
Financial Ratios Analysis (last 3 years): Profitability, liquidity, leverage, efficiency ratios.
Interpretation of company performance : 7-Year Financial Projections
P&L, Balance Sheet, and Cash Flow projections driven by assumptions.
Risk Analysis
Standard deviation & variance for 5 companies + my chosen company.
CAPM cost of equity using market index (S&P 500) + treasury bills.
Net Working Capital (NWC) Analysis
Company Valuation
Dividend Discount Model (DDM) with terminal value.
Intrinsic share price vs. market share price comparison.
Conclusion Summary
Interpretation of liquidity, profitability, risk, valuation, and recommendations.
The final Excel must be:
professional and clean
fully formula-driven (no hardcoding except assumptions)
organized exactly according to the assignment pages (2–10)
The freelancer must create a fully automated Excel model including:
Historical Financial Statements (3 years): Balance Sheet, Income Statement, Cash Flow Statement (data will come from a listed company on Yahoo Finance / Nasdaq / Reuters).
Inputs Page: Growth assumptions, cost assumptions, amortization, CAPEX, interest rate, dividends, etc. All inputs must be linked through formulas.
Financial Ratios Analysis (last 3 years): Profitability, liquidity, leverage, efficiency ratios.
Interpretation of company performance : 7-Year Financial Projections
P&L, Balance Sheet, and Cash Flow projections driven by assumptions.
Risk Analysis
Standard deviation & variance for 5 companies + my chosen company.
CAPM cost of equity using market index (S&P 500) + treasury bills.
Net Working Capital (NWC) Analysis
Company Valuation
Dividend Discount Model (DDM) with terminal value.
Intrinsic share price vs. market share price comparison.
Conclusion Summary
Interpretation of liquidity, profitability, risk, valuation, and recommendations.
The final Excel must be:
professional and clean
fully formula-driven (no hardcoding except assumptions)
organized exactly according to the assignment pages (2–10)