Financial Modeling/US/Equity/Waterfall/DCF/Expert Level

Posted last week

Worldwide

Summary

Requirements: Qualified CPA, CFA and finance experts who have 10+ year’s work experience with reputable finance/accounting/private equity/investment banking firms specializing in mergers and acquisitions, financial modeling and valuations of private businesses across various industries, preferably Construction. Investment bank Analysts Advance English Language skill Best quality undisrupted internet connection, ability to use Zoom/Teams/Google Meet Individuals must be expert in reading, analyzing GAAP/IFRS/cash and accrual accounting reports of US based businesses, including IRS tax summaries, debt schedules, depreciation schedules, book values vs fair market values of assets as per accounting standards. Selected candidates must be able to work across US time zones. Responsibility: Read, review, analyze financial statements and prepare financial model within 7 days of being assigned a deal. Update the model as required from time to time until the deal is approved by credit committee/investors Deliverables: Leverage buyout (LBO) model with 5 years historical income statement, balance sheet, cash flow statement, debt schedule, net working capital; proforma 7-years forecast of financial statements; assumptions, sensitivity analysis, stress test (separate tab), discounted cash flow (if applicable), equity waterfall (if applicable), debt repayment schedule; dashboard with IRR, MOIC, Debt to Equity ratio, DSCR, Equity Value, TEV, and all other covenants as normal for LBO models Time/hours: This is not an hourly role. It is project based. When assigned a deal, a delivery timeline of 1 week for base model draft, thereafter ongoing revisions that maybe required as per Quality of earnings, due diligence reports, investor/lender requirements Multiple deals will get assigned to you subject to your performance and availability on an ongoing basis Compensation structure: $50 as a sign-up advance fee for each deal assigned. $50 upon deal’s model approval by credit committee and funding completion, which usually is approximately within 6 months. Total of $100 base fee for each successfully closed deal. Additionally, subject to the deal's successful funding, a performance based bonus of $100

  • $100.00

    Fixed-price
  • Expert
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Microsoft Excel
Valuation
Activity on this job
  • Proposals:5 to 10
  • Last viewed by client:last week
  • Hires:
    1
  • Interviewing:
    0
  • Invites sent:
    1
  • Unanswered invites:
    0
About the client
Member since Aug 9, 2019
  • Canada
    Toronto10:11 AM
  • $38K total spent
    25 hires, 5 active
  • 1,935 hours
  • Government & Public Sector
    Mid-sized company (10-99 people)

Explore similar jobs on Upwork

Microsoft Excel
Financial Modeling
Visual Basic for Applications
Financial Analysis
Data Entry
Spreadsheet Software
Data Visualization
Founding Revenue AssociateHourly‐ Posted 4 weeks ago
Business Development
Sales Development
Lead Generation

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo