Arthur Kiselnikov
Arthur Kiselnikov
  • 49
  • 1 068 144
Citi Bank Investment Banking Task 4: Key Findings | Virtual Internship | Forage
#investmentbanking #investing #virtualexperience #investing
🔗 Forage Link: www.theforage.com/virtual-experience/amBSJDTDDFcYiKq9Z/citi/investment-banking-9wcw/synthesize-key-findings
I think the most valuable part of task 4 is the opportunity to go through a Confidential Investment Memo or "CIM" on Best Buy; bankers spend a lot of time working on these! Familiarize yourself with the structure and try to tease out key "story" focused concepts. 1) what are the key growth initiatives for Best Buy and 2) how will they help them achieve growth over the next several years.
Music Credit:
Chillpeach - In Dreamland: czcams.com/video/DSWYAclv2I8/video.html
zhlédnutí: 463

Video

Citi Bank Investment Banking Task 3: Spreading Comps | Virtual Experience | Forage
zhlédnutí 1KPřed měsícem
#investmentbanking #investing #virtualexperience #investing 🔗 Forage Link: www.theforage.com/virtual-experience/amBSJDTDDFcYiKq9Z/citi/investment-banking-9wcw/spreading-comps Task 3 is all about finding financial metrics of comparable companies or comps that are used to get an idea of the multiples at which these companies are trading. These multiples will then be used to help approximate a mul...
Citi Bank Investment Banking Task 2: Financial Modeling | Virtual Experience | Forage
zhlédnutí 841Před 2 měsíci
#investing #investmentbanking #virtualexperience 🔗 Forage Link: www.theforage.com/virtual-experience/amBSJDTDDFcYiKq9Z/citi/investment-banking-9wcw/financial-modeling-basics Task 2 is all about forecasting some basic financials. The number we are really after is the EBITDA as generally speaking we can use that figure to come up with a multiple that will allow us to find the Enterprise Value (EV...
Citi Bank Investment Banking Task 1 | Virtual Experience Program | Forage
zhlédnutí 1,3KPřed 2 měsíci
#investing #investmentbanking #internship 🔗 Forage Link: www.theforage.com/virtual-experience/amBSJDTDDFcYiKq9Z/citi/investment-banking-9wcw/m-a-target-company-profile In this video we go over Task 1 of the Citi Investment Banking Virtual Internship. The key takeaways that I would highlight are: 1) overview of what investment bankers do; 2) how a typical deal might begin, identifying a target a...
Task 4: Bucket FICO Score | JP Morgan Quant Research Virtual Experience
zhlédnutí 525Před 3 měsíci
#jpmorgan #quantitativeresearch #virtualexperience #virtualinternship 🔗 Forage Link: www.theforage.com/virtual-experience/bWqaecPDbYAwSDqJy/jp-morgan-chase-co/quantitative-research-11oc/investigate-and-analyze-price-data Task 4 of the JP Morgan Quant Research is all about finding the correct boundaries to classify FICO scores into categorical data buckets. To do this we use a log-likelihood mod...
Task 3: Credit Risk Analysis | JP Morgan Quantitative Research Virtual Experience
zhlédnutí 583Před 4 měsíci
In this video, I go through my code for Task 3 of the JPM Virtual Experience Program. To predict credit defaults and ultimately an expected loss of a loan, we can utilize several methods. The two most rudimentary, yet very effective ones, are 1) Logistic Regression, and 2) Decision Tree. In both cases, we get quite solid accuracy scores with low false positive and false negative rates. What met...
Task 2 Price a Commodity Contract | JP Morgan Quantitative Research Virtual Experience
zhlédnutí 635Před 4 měsíci
In this video, I go through my suggested solutions for Task 2 of the JPM Virtual Experience Program. I made some tweaks to my answers from Task 1. 1) I changed the code such that the input can be a date in the form "MM/DD/YYYY" as opposed to an integer that is 'X' months after the initial month zero. 2) If the date exists in our historical database the model will output a historic gas price, ot...
MOST popular brainteaser questions | Hedge Fund, Consulting, Investment Banking Interview Questions
zhlédnutí 3,3KPřed rokem
#finance #investing #interview #interviewpreparation 💰Get FREE $50 When You Sign Up For Discover: refer.discover.com/s/6isf2r The three questions I go through in this video are from BlackRock, Goldman Sachs, and SIG. These types of brainteasers are commonly asked in finance and consulting interview questions to test problem solving skills. Let me know if you all got the same answers as me! 1. B...
BEST First Credit Card To Get | Discover Credit Card | What Is The Best Credit Card To Get
zhlédnutí 987Před rokem
#creditcard #creditscore #discover 💰Get FREE $50 When You Sign Up: refer.discover.com/s/6isf2r If you're looking to start building your credit score and searching for your first credit card, search no further! One of the best credit cards to start with is the Discover Student Cash Back Card or the Discover Secured Credit Card. Easy sign up process and no prior credit history required! 🧑‍🎓 Stude...
Task 1 Analyze Price Data | JP Morgan Quantitative Research Virtual Experience
zhlédnutí 6KPřed rokem
#finance #investing #quantitativeresearch #internship #virtualexperience #programming #python JP Morgan Quantitative Research Task 1: 🔗www.theforage.com/modules/bWqaecPDbYAwSDqJy/Ds9LzaAaf5LCF8EjG?ref=b8kKye5KSBQHGWCpa In this task we use python and the Jupyter notebook environment to create a model that predicts natural gas price based on some historical price data. To find a solution to this ...
Top 10 Best FREE Virtual Internships | Best Thing To Do If You Do Not Have An Internship | Forage
zhlédnutí 15KPřed rokem
#investing #investment #career #careeradvice #virtualinternship 🔗 Forage Link: www.theforage.com/signup?inv=b8kKye5KSBQHGWCpa If you're someone looking to improve some of your technical skills and get a head start on your career or explore a new one, go check out some FREE virtual experience programs from forage. 🏆 Ranking: 1. KPMG Data Analytics www.theforage.com/virtual-internships/theme/m7W4...
Task 5 Excel Outputs | Goldman Sachs Virtual Experience Excel Skills For Business
zhlédnutí 6KPřed rokem
#investing #finance #excel #virtualinternship #virtualexperience This is task 5, the final video of the Goldman Sachs Excel Skills For Business module. Here we're creating a couple simple visualisations of our prior forecasts. Pay specific attention to the different ways you can select data inputs into our graphics and the variety of graphs we use: bar chart, line graph, area graph, and combo c...
Task 4 Cash Flow | Goldman Sachs Virtual Experience Excel Skills For Business
zhlédnutí 7KPřed rokem
#finance #investment #investing #explore In this video I go over task 4, forecasting cash flow of the Goldman Sachs Virtual Experience program. The key calculation is that of net interest which was interest income minus interest expense. Music Credit: Where It's Always Warm by Vlad Gluschenko is licensed under a Creative Commons License. creativecommons.org/licenses/... soundcloud.com/vgl9 Supp...
Task 3 Profit and Loss | Goldman Sachs Excel Skills For Business Virtual Internship
zhlédnutí 7KPřed rokem
#finance #investment #internship In this video I go over task 3 of the Goldman Sachs Virtual Internship, Excel Skills For Business module. The task is focused on forecasting the P&L using the assumptions created in the prior task. Mac Shortcut I'm using: Highlight row, press enter, enter formula, press control return Music Credit: Where It's Always Warm by Vlad Gluschenko is licensed under a Cr...
Goldman Sachs Excel Skills | Task 2 Forecasting Assumptions
zhlédnutí 9KPřed rokem
#excel #virtualinternship #finance This video goes through my suggested solutions for the Goldman Sachs Excel Skills for Business Task 2. Key tips Grow at 10% first year, then growth rate decreases by 1% the following years: Assuming we begin in A1... (A1) * 1.1 = A2 A2/A1 - 1% = A3 We can drag the formula across in A3 to obtain a growth rate that decreases by 1% with each additional cell Short...
Goldman Sachs Excel Skills for Business Virtual Experience | Task 1 Basic Excel Part 2
zhlédnutí 8KPřed rokem
Goldman Sachs Excel Skills for Business Virtual Experience | Task 1 Basic Excel Part 2
Goldman Sachs Excel Skills for Business Virtual Experience | Task 1 Basic Excel Part 1
zhlédnutí 18KPřed rokem
Goldman Sachs Excel Skills for Business Virtual Experience | Task 1 Basic Excel Part 1
WHY IS INFLATION BAD FOR THE STOCK MARKET | IS INFLATION GOOD OR BAD
zhlédnutí 430Před 2 lety
WHY IS INFLATION BAD FOR THE STOCK MARKET | IS INFLATION GOOD OR BAD
BEST WAY TO BUY CRYPTO USING DIGITAL SURGE | CRYPTO EXCHANGE REVIEW
zhlédnutí 3,1KPřed 3 lety
BEST WAY TO BUY CRYPTO USING DIGITAL SURGE | CRYPTO EXCHANGE REVIEW
JP Morgan Investment Banking Task 4 Solutions | Virtual Internship
zhlédnutí 37KPřed 3 lety
JP Morgan Investment Banking Task 4 Solutions | Virtual Internship
JP Morgan DCF Model Part 2 & Sensitivity Analysis Solutions | Investment Banking Virtual Internship
zhlédnutí 31KPřed 3 lety
JP Morgan DCF Model Part 2 & Sensitivity Analysis Solutions | Investment Banking Virtual Internship
JP Morgan Investment Banking Task 3 Solutions | Building a DCF | Virtual Internship
zhlédnutí 72KPřed 3 lety
JP Morgan Investment Banking Task 3 Solutions | Building a DCF | Virtual Internship
JP Morgan Investment Banking Task 2 Solutions | Virtual Internship
zhlédnutí 50KPřed 3 lety
JP Morgan Investment Banking Task 2 Solutions | Virtual Internship
JP Morgan Investment Banking Task 1 & 2 Part 1 Solutions | Virtual Internship
zhlédnutí 95KPřed 3 lety
JP Morgan Investment Banking Task 1 & 2 Part 1 Solutions | Virtual Internship
PwC Assurance Academy Task 4, 5 & 6 Solutions | Virtual Internship
zhlédnutí 12KPřed 3 lety
PwC Assurance Academy Task 4, 5 & 6 Solutions | Virtual Internship
PWC TASK 3 CALCULATING MATERIALITY | VIRTUAL INTERNSHIP SOLUTIONS
zhlédnutí 19KPřed 3 lety
PWC TASK 3 CALCULATING MATERIALITY | VIRTUAL INTERNSHIP SOLUTIONS
PWC MODULES 1 & 2 SOLUTIONS | ASSURANCE ACADEMY VIRTUAL EXPERIENCE
zhlédnutí 19KPřed 3 lety
PWC MODULES 1 & 2 SOLUTIONS | ASSURANCE ACADEMY VIRTUAL EXPERIENCE
Goggins 4x4x48 Challenge | Ultra Run | No Training
zhlédnutí 1,6KPřed 3 lety
Goggins 4x4x48 Challenge | Ultra Run | No Training
HOW TO START INVESTING IN CRYPTO USING COINSPOT | PASSIVE INCOME IDEAS
zhlédnutí 48KPřed 3 lety
HOW TO START INVESTING IN CRYPTO USING COINSPOT | PASSIVE INCOME IDEAS
HOW MUCH MONEY CAN YOU MAKE ON REDBUBBLE | PASSIVE INCOME IDEAS
zhlédnutí 1,6KPřed 3 lety
HOW MUCH MONEY CAN YOU MAKE ON REDBUBBLE | PASSIVE INCOME IDEAS

Komentáře

  • @smitbhave1908
    @smitbhave1908 Před 6 hodinami

    Hello Sir Thanks for sharing the video. in 1:39 how did you arrange 2.0% from 2025E to 2030E. But still I didn't get it. Can you please teach me a basics?

  • @maheshkumar-118
    @maheshkumar-118 Před dnem

    Thank you so much dude👍

  • @smitbhave1908
    @smitbhave1908 Před 2 dny

    Hello Arthur. Can you please tell me that how 0% come in FY18A?

  • @Carol.26
    @Carol.26 Před 2 dny

    Thank you so much for these videos! They were really helpful!!!

  • @caanosadax9561
    @caanosadax9561 Před 5 dny

    First one you have 2 balls left and you already used 3 weighting

  • @theakashsharmachannel3252

    Can you please make a series video on Bank of America Investment banking virtual internship?

  • @leelamadhuri9430
    @leelamadhuri9430 Před 10 dny

    Thank you so much..!!

  • @SgGdkkfk
    @SgGdkkfk Před 11 dny

    Thomas Joseph Williams Betty Robinson Matthew

  • @SgGdkkfk
    @SgGdkkfk Před 11 dny

    Brown Steven Williams Carol Moore Edward

  • @leon_1894
    @leon_1894 Před 13 dny

    Hi Arthur, one question. Are the tutorial videos made for certifications when there was still Sherpa valid for doing the same certifications on Forage, or are the tasks different now?

  • @leon_1894
    @leon_1894 Před 13 dny

    Hi Arthur, one question. Are the tutorial videos made for certifications when there was still Sherpa valid for doing the same certifications on Forage, or are the tasks different now?

    • @arthurkiselnikov
      @arthurkiselnikov Před 11 dny

      I believe InsideSherpa was bought or changed names to Forage at one point, I would assume that they continue to release new "programs" and potentially discontinue older ones. I believe you still get a certificate at the end. Hope that helps answer your question

  • @odehglory6726
    @odehglory6726 Před 13 dny

    I dont understand how how u got cash to balance sheet and the net interest 😢

  • @garimamishra3784
    @garimamishra3784 Před 13 dny

    Awesome ❤

  • @harshithsaikosuru2603

    heyy, can you please make this series on PWC audit one as well

  • @mohammedansar651
    @mohammedansar651 Před 21 dnem

    Great video Arthur. One thing I understood is that a little bit of accounting knowledge is required to work on this. But pretty much got it to the point.

  • @anmol7603
    @anmol7603 Před 21 dnem

    While copying the values of net interest why your values changes .....it should be same like the p&l and cash flow .....but after copying both p&l and cash flow changes

  • @maxscharp
    @maxscharp Před 21 dnem

    I have ran the same code but the graphs don't match

  • @binessed2682
    @binessed2682 Před 21 dnem

    What were the shortcuts for changing the style?

  • @duaneowens7777
    @duaneowens7777 Před 22 dny

    Wow that is cool. I hope there are some course related to Environmental Impact Analysis

  • @nayanikachoudhury5023

    what about the growth% 20%

  • @zoroarx
    @zoroarx Před 27 dny

    how did he changed that in Millions and Billions? 4:57

    • @zoroarx
      @zoroarx Před 27 dny

      help please :')

    • @arthurkiselnikov
      @arthurkiselnikov Před 27 dny

      @@zoroarxit’s just the formatting. If you click alt + H + FM and then use custom format. I had already done that for the billion cell so I just copy that cells format into the million cell

  • @pharbx
    @pharbx Před 28 dny

    I try this like you 3.22 but it gives me value error what should ı do?

  • @Leo-nj3ep
    @Leo-nj3ep Před 29 dny

    Niiice🎉

  • @dhonidhoni1345
    @dhonidhoni1345 Před měsícem

    Bro i don't know where to start task 3 can you guide me

  • @dhonidhoni1345
    @dhonidhoni1345 Před měsícem

    Bro i don't know where to start task 3 can you guide me

  • @AsthaSingh-nc1lj
    @AsthaSingh-nc1lj Před měsícem

    thank you so much

  • @calvinyip364
    @calvinyip364 Před měsícem

    is this all free? i am from asia btw . Can i take the course? with no experience ?

    • @ayodus
      @ayodus Před měsícem

      They are all free on Forage

  • @michael_083
    @michael_083 Před měsícem

    The PwC professional we do not deserve

  • @siddhantsharma9700
    @siddhantsharma9700 Před měsícem

    Hey share audits and account skill programs

  • @andrewkabugo2836
    @andrewkabugo2836 Před měsícem

    Thank you!!

  • @rockygamey
    @rockygamey Před měsícem

    Hi Arthur, thank you uploading this video. As I was going through the video, I have noticed that the cash and cash equivalents that you recorded is $932M while I can see in the same video where you discuss that part its shows $1.447B. Even in case of Short term Debt you mention it as $16M but in the video where you discuss the data from Yahoo Finance it says $631M. While the number recoreded under Long term debt is the matching. Can you please help me why the numbers are different from Yahoo Finance that you have showed in this video and what you have recorded on your excel sheet?

  • @CMcgregor809
    @CMcgregor809 Před měsícem

    Thanks buddy... That was really helpful

  • @shloktodi3728
    @shloktodi3728 Před měsícem

    you legend. thank you so much

  • @aliknowsplato
    @aliknowsplato Před měsícem

    Thanks so much Arthur as someone with zero prior excel knowledge and only in my first year at university this series was unbelievably helpful

  • @liammcleod159
    @liammcleod159 Před měsícem

    отличное видео

  • @aihan-gl1ft
    @aihan-gl1ft Před měsícem

    I recently sold some of my long-term position and currently sitting on about 250k, do you think Nvidia is a good buy right now or I have I missed out on a crucial buy period, any good stock recommendation on great performing stocks will be appreciated.

    • @RobertFarley532
      @RobertFarley532 Před měsícem

      Safest approach i feel to tackle it is to diversify investments. By spreading investments across different asset classes, like bonds, and international stocks, they can reduce the impact of a market meltdown. its important to seek the guidance of an expert

    • @HermanBekkink
      @HermanBekkink Před měsícem

      I have greatly grown more than 45% this year already, though my FA has advised we diversify going forward. But safe to say a growing market does not always mean that the economy is smooth-sailing, but yeah, we can as well enjoy while it lasts.

    • @user-yu7yf5rx4w
      @user-yu7yf5rx4w Před měsícem

      Please, who is the advisor that assists you with your investments?

    • @HermanBekkink
      @HermanBekkink Před měsícem

      I'm cautious about giving specific recommendations as everyone's situation varies. Consider independent financial advisors like “ Deborah Lynn Dilling ” I've worked with her for 9 years and highly recommend her. Check if she meets your criteria.

    • @user-yc1cf5uf2z
      @user-yc1cf5uf2z Před měsícem

      I looked up her name online and found her page. I emailed and made an appointment to talk with her. Thanks for the tip

  • @Benjiming2
    @Benjiming2 Před měsícem

    thank you so much for making these

  • @rahulkumar1248
    @rahulkumar1248 Před měsícem

    8 min

  • @theodorelapointe3624
    @theodorelapointe3624 Před měsícem

    We could use the min function too right? Like it directly addresses the issue of paying down debt with all the net cash flow without exceeding the avail cash or remaining debt. (They've used the same 😅)

  • @user-yc1cf5uf2z
    @user-yc1cf5uf2z Před měsícem

    My husband and I were fortunate enough to be able to pay off our mortgage early. We were both still working, and took the payment amount that we had been using to pay off our mortgage faster and we put it straight into investments. We were able to retire early because of almost 7 years of putting away what would have been our mortgage payment as well as maxing out our 401K/403B plans. Thankfully we were taught by both of our parents the value of living within our means. Thank you for your advice. I know it will help people. we are interested in investments that could set me up for retirement , I mean I've heard of people that netted hundreds of thousands during these crash, I listened to someone on a podcast who earned over $650K in less than a year, what's the strategy behind such returns?

    • @RobertFarley532
      @RobertFarley532 Před měsícem

      Investing without proper guidance can lead to mistakes and losses. I've learned this from my own experience.If you're new to investing or don't have much time, it's best to get advice from an expert.

    • @HermanBekkink
      @HermanBekkink Před měsícem

      Even with the right strategies and appropriate assets, investment returns can differ among investors. Recognizing the vital role of experience in investment success is crucial. Personally, I understood this significance and sought guidance from a market analyst, significantly growing my account to nearly a million. Strategically withdrawing profits just before the market correction, I'm now seizing buying opportunities once again.

    • @user-yu7yf5rx4w
      @user-yu7yf5rx4w Před měsícem

      How can one find a verifiable financial planner? I would not mind looking up the professional that helped you. I will be retiring in two years and I might need some management on my much larger portfolio. Don't want to take any chances.

    • @HermanBekkink
      @HermanBekkink Před měsícem

      Deborah Lynn Dilling is the licensed advisor I use.Just research the name. You'd find necessary details to work with to set up an appointment

    • @aihan-gl1ft
      @aihan-gl1ft Před měsícem

      She appears to be well-educated and well-read. I ran an online search on her name and came across her website; thank you for sharing.

  • @William-ob9ik
    @William-ob9ik Před 2 měsíci

    Very well understood

  • @liammcleod159
    @liammcleod159 Před 2 měsíci

    "the share price is the share price" ah now i understand

  • @sakshisharma4558
    @sakshisharma4558 Před 2 měsíci

    Please make a video on strategy consulting by accenture

  • @soudity5731
    @soudity5731 Před 2 měsíci

    this is so useful thank you

  • @ROCKSTAR-ub3nd
    @ROCKSTAR-ub3nd Před 2 měsíci

    You do it fast so please teach us with basics so that could help everyone

  • @swarnas9045
    @swarnas9045 Před 2 měsíci

    Very helpful. Kindly make videos on task 3 and 4.

    • @arthurkiselnikov
      @arthurkiselnikov Před 2 měsíci

      I will try upload tasks 3 and 4 in the next couple days!

  • @soudity5731
    @soudity5731 Před 2 měsíci

    please can you make vídeo on task 3 and 4?

  • @andresportelabesteiro4310
    @andresportelabesteiro4310 Před 2 měsíci

    Amazing video this actually was pretty helpful I hope you will continue doing this sort of videos as I believe that people can learn a lot from this.

  • @ashutoshsharma978
    @ashutoshsharma978 Před 2 měsíci

    Sir It will be great help if you make Video on Task 3 and 4

  • @yoshicrafto2242
    @yoshicrafto2242 Před 2 měsíci

    Thanks