Banner Image

All Services

Business & Finance

Financial Statement Analysis & Modelling

$25/hr Starting at $1K

• Financial Analyst Skills: o Financial Statement Analysis and Business Consulting: ? Building 1/3/5 years or so of Financial Projections ? Gather Financial Data using online and other data sources (10-q, 10-k, 8-k reports etc.) ? Analyzing and Spreading historical information in Excel (P&L, Balance Sheet and Cash Flow statement), ? Analysis of Financial Statement using Ratio Analysis. ? Normalizing the financial statements for Exceptional and non-recurring items to arrive at true profitability. ? Financial Analysis, Bank/Account Reconciliation ? KPI Analysis & Implementation ? Bookkeeping / GL Accounting (US GAAP), Financial Reporting, Expert on creating streamlined and autonomous excel reports (nested ifs, sumifs, index, arrays, V-look ups, H-look ups, other logical reasonings, VBA Macros etc), simplifying large data down into insightful summaries, comparisons, visuals and graphics. ? Creating different types of C-level/staff-level/analytical reports, charts, tables and graphs, o Equity Research and Company Valuation: ? Comparable Company Valuation: Trading and Transaction Comps, Using Valuation Multiples, Calculation of Enterprise value. ? Financial valuation with DCF and Multiples, WACC calculation, NPV and IRR for Capital Budgeting, financial analyses and reports for management, Pivot Tables, VBA, and advanced formulas (VLOOKUP, nested if statements, etc.) in Excel ? Building Models for future projections, Using Revenue and Cost Drivers, DCF Modelling. Going through the supplementary schedules, Notes and MD&A for detailed breakups and adjustments. o MBA Finance and Entrepreneurship with four years of experience in Financial Analysis, Financial Forecasting, Budgeting, o Experienced with R Statistical Program, SAP, Excel, and, Tableau

About

$25/hr Ongoing

Download Resume

• Financial Analyst Skills: o Financial Statement Analysis and Business Consulting: ? Building 1/3/5 years or so of Financial Projections ? Gather Financial Data using online and other data sources (10-q, 10-k, 8-k reports etc.) ? Analyzing and Spreading historical information in Excel (P&L, Balance Sheet and Cash Flow statement), ? Analysis of Financial Statement using Ratio Analysis. ? Normalizing the financial statements for Exceptional and non-recurring items to arrive at true profitability. ? Financial Analysis, Bank/Account Reconciliation ? KPI Analysis & Implementation ? Bookkeeping / GL Accounting (US GAAP), Financial Reporting, Expert on creating streamlined and autonomous excel reports (nested ifs, sumifs, index, arrays, V-look ups, H-look ups, other logical reasonings, VBA Macros etc), simplifying large data down into insightful summaries, comparisons, visuals and graphics. ? Creating different types of C-level/staff-level/analytical reports, charts, tables and graphs, o Equity Research and Company Valuation: ? Comparable Company Valuation: Trading and Transaction Comps, Using Valuation Multiples, Calculation of Enterprise value. ? Financial valuation with DCF and Multiples, WACC calculation, NPV and IRR for Capital Budgeting, financial analyses and reports for management, Pivot Tables, VBA, and advanced formulas (VLOOKUP, nested if statements, etc.) in Excel ? Building Models for future projections, Using Revenue and Cost Drivers, DCF Modelling. Going through the supplementary schedules, Notes and MD&A for detailed breakups and adjustments. o MBA Finance and Entrepreneurship with four years of experience in Financial Analysis, Financial Forecasting, Budgeting, o Experienced with R Statistical Program, SAP, Excel, and, Tableau

Skills & Expertise

Account ReconciliationAccountingAnalyticsBusiness ValuationCreativeData ManagementEntrepreneurshipFinancial AnalysisFinancial ReportingFormulaMacroMicrosoft ExcelMicrosoft Excel Pivot TablesModelingR ProgrammingReportsResearchTable DesignTableauVBA

Related Work Collections

0 Reviews

This Freelancer has not received any feedback.