# Financial Analyst Training Program

Canonical URL: <https://training-nyc.com/courses/financial-analyst-training-program>

## Overview

In this 5-day financial analyst program, you'll master Excel, review corporate finance and financial accounting concepts, and build a comprehensive valuation model on a public company. This bootcamp is the most effective and affordable course to gain the skills you need to succeed at a top financial firm. 

- **Core Excel Skills:** Build a strong foundation in Excel with formulas, functions, Pivot Tables, shortcuts, and more.
- **Advanced Excel for Financial Modeling: ** Learn advanced techniques including Goal Seek, financial functions, shortcuts, and cash flow projection tools. 
- **Accounting, Corporate Finance & Valuation:**  Review corporate finance and accounting concepts, including enterprise value, the financial statement analysis, DCF modeling techniques, and corporate valuation principles.
- **Financial Modeling:** Build an integrated 3-statement financial model. Create a DCF model on a public restaurant company using current financial data. Review company presentations, earnings releases, and financial reports to determine the model drivers and assumptions. Using valuation principles, you will derive a value per share and evaluate the equity as a potential investment.

Want to discuss this class further? [Email the program director](mailto:contact@nyimtraining.com?subject=Financial%20Modeling%20Bootcamp%20Question) directly and find out if this is the right course for you.

### Related Courses

Looking for a comprehensive Summer Program to prepare for an internship, full-time position, or interviews? Check out our [Summer Financial Modeling Bootcamp](/courses/summer-financial-modeling-program).

Those with a strong background in Excel can attend our 3-day [Financial Modeling Bootcamp](/courses/financial-modeling-courses-nyc) or our 1-day [Advanced Excel for Financial Modeling](/courses/excel-for-finance) course. 

### Prerequisites

Since this program covers core Excel the first two days, there are no prerequisites. Prior knowledge of finance and accounting is helpful but not required as these topics are covered throughout the program. Attendees will receive a short pre-learning guide one week prior to the start of the course.

## What you'll learn

### Learn Excel, Finance, & Accounting in Hands-on Training

- **Functions:** VLOOKUP, INDEX-MATCH, SUMIF
- **Excel Techniques** including Pivot Tables, What-if Analysis
- **Shortcuts and tricks** financial analysts need
- **Financial Accounting:** Core statements, working capital, financial ratios
- **Financial Concepts:** enterprise value, stocks, bonds, options
- **Financial Modeling:** Projecting revenues, expenses, CapEx, and working capital
- **DCF Valuation:** Deriving a share value from the financial model

## Curriculum
1. **Excel for Business Fundamentals**
2. **Intermediate Excel for Business**
3. **Financial Modeling Bootcamp**

## Schedule
- Jun 22, 2026 – Jun 26, 2026 — NYC
- Aug 24, 2026 – Aug 28, 2026 — NYC
- Oct 19, 2026 – Oct 23, 2026 — NYC

## Pricing

**Tuition:** $1295