- 49
- 1 068 144
Arthur Kiselnikov
Australia
Registrace 15. 09. 2012
Sharing resources on career development, my passion for entrepreneurship, investing, and cryptocurrency. University of Chicago alumnus with a B.A. in Economics and Minor in Data Science.
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
🔗 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
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?
Thank you so much dude👍
Hello Arthur. Can you please tell me that how 0% come in FY18A?
Thank you so much for these videos! They were really helpful!!!
First one you have 2 balls left and you already used 3 weighting
Can you please make a series video on Bank of America Investment banking virtual internship?
Thank you so much..!!
Thomas Joseph Williams Betty Robinson Matthew
Brown Steven Williams Carol Moore Edward
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?
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?
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
I dont understand how how u got cash to balance sheet and the net interest 😢
Awesome ❤
heyy, can you please make this series on PWC audit one as well
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.
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
I have ran the same code but the graphs don't match
What were the shortcuts for changing the style?
Wow that is cool. I hope there are some course related to Environmental Impact Analysis
what about the growth% 20%
how did he changed that in Millions and Billions? 4:57
help please :')
@@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
I try this like you 3.22 but it gives me value error what should ı do?
Niiice🎉
Bro i don't know where to start task 3 can you guide me
Bro i don't know where to start task 3 can you guide me
thank you so much
is this all free? i am from asia btw . Can i take the course? with no experience ?
They are all free on Forage
The PwC professional we do not deserve
Hey share audits and account skill programs
Thank you!!
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?
Thanks buddy... That was really helpful
you legend. thank you so much
Thanks so much Arthur as someone with zero prior excel knowledge and only in my first year at university this series was unbelievably helpful
отличное видео
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.
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
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.
Please, who is the advisor that assists you with your investments?
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.
I looked up her name online and found her page. I emailed and made an appointment to talk with her. Thanks for the tip
thank you so much for making these
8 min
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 😅)
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?
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.
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.
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.
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
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.
Very well understood
"the share price is the share price" ah now i understand
Please make a video on strategy consulting by accenture
I also need that one
this is so useful thank you
No problem! glad it was helpful
You do it fast so please teach us with basics so that could help everyone
Very helpful. Kindly make videos on task 3 and 4.
I will try upload tasks 3 and 4 in the next couple days!
please can you make vídeo on task 3 and 4?
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.
Sir It will be great help if you make Video on Task 3 and 4
Thanks