Wall Street Prep Financial Modeling Course

Wall Street Prep Financial Modeling Course

in on 01/23/2023
Purchase ($25)

has been added to your cart, get more courses to get BIG DISCOUNT!

have been added to your cart, get more courses to get BIG DISCOUNT!

Wall Street Prep Financial Modeling Course
  • ⭐ Learn online (no require download), easy download (Google Drive)
  • ⭐ Ensure to get all files in the file list
  • ⭐ Get free update course through your email
  • ⭐ Last Updated Date: 03-18-2024
  • ⭐ Course Size: 2.2 GB

Wall Street Prep Financial Modeling Course (2.2 GB)

Last Updated Date: 03-18-2024

Google Drive Proof

My Drive
Data
Wall Street Prep Financial Modeling Course
Name
Owner
Last modified
File size
KIT
me
Jan 23, 2023 me
LECTURES
me
Jan 23, 2023 me
My Drive
Data
Wall Street Prep Financial Modeling Course
KIT
Name
Owner
Last modified
File size
Excel Shortcuts
me
Jan 23, 2023 me
Excel Templates by Lesson
me
Jan 23, 2023 me
Filings and Other Supporting Documents
me
Jan 23, 2023 me
FSM-AAPL-Course-Manual_5c723312ebde9 (2).pdf
me
Jan 23, 2023 me
11.8 MB
FSM-Cheat-Sheet (1).pdf
me
Jan 23, 2023 me
1.1 MB
FSM_COMPLETE.xlsx
me
Jan 23, 2023 me
64.1 kB
FSM_w_Waterfall_COMPLETE.xlsx
me
Jan 23, 2023 me
69.5 kB
My Drive
Data
Wall Street Prep Financial Modeling Course
KIT
Excel Shortcuts
Name
Owner
Last modified
File size
Excel-2007-Shortcuts (1).pdf
me
Jan 23, 2023 me
43.2 kB
Excel-2010-shortcuts.pdf
me
Jan 23, 2023 me
43.2 kB
Excel-2013-Shortcuts.pdf
me
Jan 23, 2023 me
43.9 kB
Excel-shortcuts-2016-Windows-Mac.pdf
me
Jan 23, 2023 me
194.5 kB
FINAL RESEARCH REPORT.docx
me
Jan 23, 2023 me
685.3 kB
Wall-Street-Prep-Shortcuts.xlsx
me
Jan 23, 2023 me
73.5 kB
cfa mega key.txt
me
Jan 23, 2023 me
22 B
imagecompressor.zip
me
Jan 23, 2023 me
2.5 MB
My Drive
Data
Wall Street Prep Financial Modeling Course
KIT
Excel Templates by Lesson
Name
Owner
Last modified
File size
1_IS-Segment-Hist-Empty.xlsx
me
Jan 23, 2023 me
314.8 kB
2_IS-Segment-Hist-Done.xlsx
me
Jan 23, 2023 me
28.7 kB
3_IS-Segment-Fcasts-Empty.xlsx
me
Jan 23, 2023 me
31.9 kB
4_IS-Segment-Fcasts-Done.xlsx
me
Jan 23, 2023 me
34.3 kB
5_BS-Historicals-Empty.xlsx
me
Jan 23, 2023 me
36.2 kB
6_BS-Historicals-Done.xlsx
me
Jan 23, 2023 me
34 kB
7_Working-Capital-Empty.xlsx
me
Jan 23, 2023 me
35.7 kB
8_Working-Capital-Done.xlsx
me
Jan 23, 2023 me
37.9 kB
9_PPE-Intangibles-Empty.xlsx
me
Jan 23, 2023 me
39.3 kB
10_PPE-Intangibles-Done.xlsx
me
Jan 23, 2023 me
39.4 kB
11_Other-Assets-Empty.xlsx
me
Jan 23, 2023 me
332.6 kB
12_Other-Assets-Done.xlsx
me
Jan 23, 2023 me
333.1 kB
13_Debt-Empty.xlsx
me
Jan 23, 2023 me
333.9 kB
14_Debt-Done.xlsx
me
Jan 23, 2023 me
335 kB
15_Comm-Treas-Stock-Empty.xlsx
me
Jan 23, 2023 me
45.3 kB
16_Comm-Treas-Stock-Done.xlsx
me
Jan 23, 2023 me
46.1 kB
17_Ret-Earnings-OCI-Empty.xlsx
me
Jan 23, 2023 me
47.1 kB
18_Ret-Earnings-OCI-Done.xlsx
me
Jan 23, 2023 me
47.8 kB
18b_Linking-Schedules-BS.xlsx
me
Jan 23, 2023 me
49.6 kB
19_CFS-Empty.xlsx
me
Jan 23, 2023 me
50.9 kB
20_CFS-Done.xlsx
me
Jan 23, 2023 me
52.6 kB
21_Revolver-Empty.xlsx
me
Jan 23, 2023 me
53.8 kB
22_Revolver-Done.xlsx
me
Jan 23, 2023 me
345.7 kB
23_Cash-Interest-Income-Empty.xlsx
me
Jan 23, 2023 me
54.8 kB
24_Cash-Interest-Income-Done.xlsx
me
Jan 23, 2023 me
55.6 kB
25_Circularity-Done.xlsx
me
Jan 23, 2023 me
55.7 kB
26_EPS-Empty.xlsx
me
Jan 23, 2023 me
53.9 kB
27_EPS-Done.xlsx
me
Jan 23, 2023 me
58 kB
28_Sensitivity-Empty.xlsx
me
Jan 23, 2023 me
61.6 kB
29_Sensitivity-Done.xlsx
me
Jan 23, 2023 me
63.5 kB
30_Scenarios-Empty.xlsx
me
Jan 23, 2023 me
65.2 kB
31_Scenarios-Done.xlsx
me
Jan 23, 2023 me
65.7 kB
32_Dep-Waterfall-Empty.xlsx
me
Jan 23, 2023 me
69.7 kB
33_Dep-Waterfall-Done.xlsx
me
Jan 23, 2023 me
70.3 kB
Non trade receivables illustrative Example.xlsx
me
Jan 23, 2023 me
11.2 kB
My Drive
Data
Wall Street Prep Financial Modeling Course
KIT
Filings and Other Supporting Documents
Name
Owner
Last modified
File size
AAPL-2013-10K.pdf
me
Jan 23, 2023 me
0.9 MB
AAPL-Consensus-EPS.pdf
me
Jan 23, 2023 me
29.6 kB
AAPL-LT-Growth-Rate.xlsx
me
Jan 23, 2023 me
8.9 kB
AAPL-LTM-Historical-Prices.xlsx
me
Jan 23, 2023 me
16.8 kB
AAPL Concensus Revenue EBITDA Factset.pdf
me
Jan 23, 2023 me
37 kB
Depreciation-Waterfall-Logic.xlsx
me
Jan 23, 2023 me
16.6 kB
RJames-AAPL.pdf
me
Jan 23, 2023 me
364.9 kB
My Drive
Data
Wall Street Prep Financial Modeling Course
LECTURES
Name
Owner
Last modified
File size
1 Introduction.mp4
me
Jan 23, 2023 me
48.8 MB
2 Excel Settings for Modeling.mp4
me
Jan 23, 2023 me
8.3 MB
3 Excel For Mac Quick Setup.mp4
me
Jan 23, 2023 me
29.1 MB
4 Keyboard Shortcuts.mp4
me
Jan 23, 2023 me
42.8 MB
5 Excel Productivity Add-ins.mp4
me
Jan 23, 2023 me
52.1 MB
6 Formatting Conventions.mp4
me
Jan 23, 2023 me
22.6 MB
7 Modeling Best Practices.mp4
me
Jan 23, 2023 me
49.7 MB
8 Naming, Linking & Deleting Cells.mp4
me
Jan 23, 2023 me
27.7 MB
9 Model Structure.mp4
me
Jan 23, 2023 me
20.7 MB
10 Gathering Documents for Modeling (the -PIB-).mp4
me
Jan 23, 2023 me
15.9 MB
11 Apple Case Study Introduction.mp4
me
Jan 23, 2023 me
5.4 MB
12 Modeling the Historical Income Statement, Part 1.mp4
me
Jan 23, 2023 me
83 MB
13 Modeling the Historical Income Statement, Part 2.mp4
me
Jan 23, 2023 me
47.3 MB
14 Introduction to Forecasting.mp4
me
Jan 23, 2023 me
39.1 MB
15 Segment-Level Revenue Forecasting.mp4
me
Jan 23, 2023 me
69 MB
16 Operations Forecasting.mp4
me
Jan 23, 2023 me
54.6 MB
17 Inputting the Historical Balance Sheet.mp4
me
Jan 23, 2023 me
48.2 MB
18 Working Capital Forecasting & Roll-Forward Mechanics.mp4
me
Jan 23, 2023 me
21.9 MB
19 Accounts Receivable, Part 1.mp4
me
Jan 23, 2023 me
23 MB
20 Accounts Receivable, Part 2.mp4
me
Jan 23, 2023 me
42.8 MB
21 Inventory.mp4
me
Jan 23, 2023 me
42.4 MB
22 Accounts Payable.mp4
me
Jan 23, 2023 me
33.1 MB
23 Accrued Expenses & Deferred Revenue.mp4
me
Jan 23, 2023 me
50.6 MB
24 Intangible Assets.mp4
me
Jan 23, 2023 me
15.7 MB
25 Modeling Intangible Assets.mp4
me
Jan 23, 2023 me
51.4 MB
26 PP & E.mp4
me
Jan 23, 2023 me
18.7 MB
27 Modeling PPE.mp4
me
Jan 23, 2023 me
44.8 MB
28 Other Balance Sheet Assets.mp4
me
Jan 23, 2023 me
6.6 MB
29 Modeling Other Current Assets.mp4
me
Jan 23, 2023 me
41.3 MB
30 Deferred Tax Assets.mp4
me
Jan 23, 2023 me
8.6 MB
31 Deferred Tax Liabilities.mp4
me
Jan 23, 2023 me
9.9 MB
32 Other Liabilities.mp4
me
Jan 23, 2023 me
9.1 MB
33 Modeling Deferred Taxes.mp4
me
Jan 23, 2023 me
56.1 MB
34 Debt.mp4
me
Jan 23, 2023 me
15.1 MB
35 Modeling Debt.mp4
me
Jan 23, 2023 me
76.2 MB
36 Capital Stock.mp4
me
Jan 23, 2023 me
11.8 MB
37 Modeling Capital Stock.mp4
me
Jan 23, 2023 me
67.8 MB
38 Treasury Stock.mp4
me
Jan 23, 2023 me
11.6 MB
39 Modeling Treasury Stock (1).mp4
me
Jan 23, 2023 me
29.7 MB
40 Retained Earnings and OCI.mp4
me
Jan 23, 2023 me
7.1 MB
41 Modeling Retained Earnings.mp4
me
Jan 23, 2023 me
46.4 MB
42 Modeling Other Comprehensive Income.mp4
me
Jan 23, 2023 me
16.7 MB
43 Linking Schedules Back to the Balance Sheet.mp4
me
Jan 23, 2023 me
28.2 MB
44 Cash Flow Statement Introduction.mp4
me
Jan 23, 2023 me
3.6 MB
45 Review- The Cash Flow Statement.mp4
me
Jan 23, 2023 me
24.4 MB
46 Cash From Operations.mp4
me
Jan 23, 2023 me
25.2 MB
47 Modeling Cash from Operations.mp4
me
Jan 23, 2023 me
56 MB
48 Cash From Investing & Other Financing Activities.mp4
me
Jan 23, 2023 me
14.6 MB
49 Modeling Cash from Investing Activities.mp4
me
Jan 23, 2023 me
23.6 MB
50 Understanding the Role of the Revolver in Financial Models.mp4
me
Jan 23, 2023 me
17.3 MB
51 Modeling the Revolver.mp4
me
Jan 23, 2023 me
79.9 MB
52 Modeling Interest Income.mp4
me
Jan 23, 2023 me
31.6 MB
53 Dealing with Circularities in Financial Models.mp4
me
Jan 23, 2023 me
108.6 MB
54 EPS.mp4
me
Jan 23, 2023 me
18.5 MB
55 Modeling EPS.mp4
me
Jan 23, 2023 me
70.3 MB
56 Integrity Checking.mp4
me
Jan 23, 2023 me
96.2 MB
58 Scenario Analysis.mp4
me
Jan 23, 2023 me
69.9 MB
59 Depreciation Waterfall.mp4
me
Jan 23, 2023 me
118.2 MB
Sensitivity Analysis Using Data Tables.mp4
me
Jan 23, 2023 me
67.1 MB
Get Discount ?

Aspiring finance professionals looking to enhance their financial modeling skills turn to Wall Street Prep’s Financial Modeling Course to gain expertise in modeling complex financial scenarios. Whether you are a beginner or an experienced analyst, this course offers valuable insights and practical guidance on building financial models using Excel.

One of the key components of financial modeling is setting up Excel to efficiently handle the data and calculations required for accurate modeling. The course covers Excel settings for modeling, including key functions, formulas, and shortcuts that simplify the modeling process. By learning how to customize Excel settings for financial modeling, students can streamline their workflow and improve their modeling accuracy.

For those using Excel on a Mac, the course offers a quick setup guide to optimize Excel for financial modeling. Excel for Mac can have slightly different settings and functionalities compared to Excel for Windows, so it’s important to adjust the settings accordingly. The course walks students through the process of setting up Excel for Mac, ensuring a smooth modeling experience on Apple devices.

In addition to Excel settings, the course emphasizes modeling best practices to ensure accuracy and reliability in financial models. By understanding the best practices for modeling, students can avoid common pitfalls and errors that may impact the integrity of their models. From model structure to formula auditing, the course covers the essential best practices for creating robust financial models.

When it comes to building financial models, gathering the necessary documents and data is crucial. The course provides guidance on gathering documents for modeling, including financial statements, market research reports, and industry data. By knowing how to effectively gather and analyze the required documents, students can develop models that accurately reflect the financial health of a company or project.

To apply these concepts in a real-world scenario, the course includes a case study on Apple Inc., one of the most successful companies in the world. The Apple case study introduces students to the complexities of modeling a multinational corporation, from historical financial data to forecasting future performance. By studying Apple’s financials and business operations, students gain valuable insights into the intricacies of financial modeling for a large, diverse company.

The course guides students through modeling the historical income statement of Apple, using actual financial data to create a comprehensive model of the company’s past performance. By analyzing historical financials, students learn how to identify trends, patterns, and key performance indicators that can inform future forecasts and projections.

Moving beyond historical modeling, the course introduces students to the fundamentals of forecasting, from revenue projections to operations forecasting. Segment-level revenue forecasting allows students to break down revenue streams by product line, geography, or customer segment, providing a detailed analysis of revenue drivers and growth opportunities.

Operations forecasting covers key operational metrics, such as cost of goods sold, operating expenses, and capital expenditures, to project the company’s future operational performance. By incorporating operational forecasts into their models, students gain a comprehensive understanding of how a company’s financials are impacted by its operational activities.

Overall, Wall Street Prep’s Financial Modeling Course equips students with the skills and knowledge needed to excel in financial modeling. From Excel settings to modeling best practices, the course offers a comprehensive overview of the essential elements of financial modeling. By studying real-world case studies and applying financial modeling techniques to complex scenarios, students can elevate their modeling skills and advance their careers in finance.


Information

Our courses are uploaded to Google Drive, you can view or download them.
Our system is automatic, you will receive the course immediately after payment.
If you enter a wrong gmail account during checkout, we will assist you as soon as possible (within 8 hours).
All your information will be completely confidential.
Thank you
Purchase ($25)

has been added to your cart, get more courses to get BIG DISCOUNT!

have been added to your cart, get more courses to get BIG DISCOUNT!

0 Sale

Share Now!