Financial Statement Analysis & Valuation
Techniques employed: Financial Modeling, Ratio Analysis, Excel Projections, Data Verification, Financial Reporting.
• Applied Financial Analysis & Reporting techniques to evaluate a publicly traded company’s 3 year performance using SEC filings and Yahoo Finance data.
• Built a financial model in Microsoft Excel with Income Statement, Balance Sheet, and Cash Flow projections.
• Conducted ratio analysis (profitability, liquidity, leverage) to assess performance and deliver an equity valuation recommendation.
• Ensured data accuracy and reconciliation while preparing a professional analyst style report.
Budget Forecasting & Scenario Analysis
Techniques Employed: Budget Forecasting, Scenario Modeling, Excel Automation, Data Accuracy, Cost Analysis.
• Created a 12-month budget and forecast for store operations, incorporating revenue, expenses, and cash flow.
• Designed dynamic scenario analysis (Base, Best, Worst Case) using Excel tools (PivotTables, VLOOKUP, IF statements).
• Automated data entry and applied accuracy verification to maintain integrity of financial outputs. •Generated actionable insights on expense tracking, cost management, and resource allocation for decision-making.