Ivan Klykov
Corporate Finance | M&A | Private Equity | Venture Capital | Project Finance | Restructuring Follow 16

• views 3.2k
• users 464
• reviews 30
• Downloadable Best Practice 1

Ivan Klykov

Corporate Finance | M&A | Private Equity | Venture Capital | Project Finance | Restructuring

Discuss with Ivan Klykov!

mailPrivate message

Follow 16

Bio

I am an investment professional with 8 years experience in investment analysis, valuation of public and private companies, raising equity/project finance and M&A advisory.I am currently working at SP Capital - top tier Russian M&A-advisory firm - as a Director (M&A Advisory) The main goal of my work is to provide independent support to projects during all stages: from the initial analysis and capital raising to operational stage exit that results in value increase for shareholders.

Education

• Burgundy School of Business - BSB Lead For Change

Tags

annual modelscredit calculatordebt paymentdebt scheduledebt structurefinancefinancial modeling

Website

http://sp.capital/

Social

Categories

• 

  Corporate Finance

• 

  Investment Banking

• 

  Debt Schedule

• 

  Financial Modeling

• views 3.2k
• users 464
• reviews 30
• Downloadable Best Practice 1

• 

  Excel Revolving Credit Calculator for annual models

  An automatic excel algebraic approach for revolving loan facility in annual financial models (no macro & circular links)

  financedebt schedulefinancial modelingcredit calculatordebt structure

  3,228Discussadd_shopping_cart

  free

Publish your own Best Practice

People using this Best Practice also downloaded

Best Practices Downloaded & Rated by Ivan Klykov

• 

  Retail business model in Excel

  In this file I will show you how to model a retail chain in Excel in order to create a business / financial model.

  business planbusiness modelfinancial modelstartupmodel in excel

  4,763Discussadd_shopping_cart

  $5.00

  by Asen Gyczew
• 

  Financial Model audit check list - spreadsheet

  This is an audit or productivity tool that you can use while reviewing someone else’s models.

  financial modelingtoolsproductivityfinancial modelersfinancial model audit

  2,1976add_shopping_cart

  free

  by FinExMod
• 

  Blockchain/ICO Forecasting and Analysis Financial Excel Model Template

  This ICO model allows you to analyse and create financial projections for cryptocurrencies and blockchains.

  investmentsforecastfinancial modelinvestorsexcel

  1,0633add_shopping_cart

  $49.00

  by Alex Martyanov
• 

  FMCG (Fast Moving Customer Goods) Business Model in Excel - Management Consulting

  Financial model for a FMCG business in Excel that can be used during consulting projects - eg: due diligence

  valuationfinancial modelstartupsfinancial modelingmanagement consulting

  2,673Discussadd_shopping_cart

  free

  by Asen Gyczew
• 

  Form Controls and Other Interactive Tools in Excel

  An overview of form controls, ActiveX controls and hyperlinks used in financial models.

  scenariosinputsfinancialmodelssensitivitesformcontrols

  1,9192add_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Dates and Timelines in Excel Financial Models

  Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions

  datestipsfinancial modelingexcelmethod

  1,624Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Unlocking Full Potential of Excel Data Tables (Part 1)

  This publication explains an advanced method of using data tables for sensitivity analysis in financial models

  scenariosexcelfinancialmodelssensitivitiesdatatables

  5,589Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Guiding principles of Financial Modelling

  The publication explains the general principles of building financial models with practical examples

  financeplanningforecastingexcelfinancialmodeling

  3,708Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Monte Carlo Analysis (without macros) Excel Model

  This post explains how to run full Monte Carlo analysis in Excel without macros

  excelcorrelationfinancialmodelingstatisticssimulation

  3,1354add_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Descriptive statistics for grouped (weighted) data

  Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data

  standard deviationexcelcorrelationstatisticsmedian

  1,038Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Sensitivity analysis Excel Model with indifference curves

  An Excel utility to draw indifference curves for two inputs in a financial model

  excelfinancialmodelingvbamacrossensitivities

  1,6091add_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Sensitivity Analysis Template Using Data Table

  This workbook and this manual are designed to help you build a sensitivity analysis into your models.

  sensitivity analysistemplateexceldata table

  7794add_shopping_cart

  free

  by FinExMod
• 

  Building Integrity Checks in Project Finance Models (Manual & Template)

  This is a spreadsheet that can be integrated in any project finance model. It contains most common integrity checks.

  financial modelproject financeauditchecks

  4812add_shopping_cart

  free

  by FinExMod
• 

  Charts and Dashboards in Excel (short version)

  Explains the basics of building professional quality charts in Excel

  chartsexcel

  650Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Timing Flags and Master sheet in a Project Finance Model

  Contains necessary flags, counters and switches to build in flexibility in your project finance models

  project finance modelingtiming flagsmaster sheet

  350Discussadd_shopping_cart

  free

  by FinExMod
• 

  Financial Model Version Tracker

  Financial model tracker is a tool enables you to keep a track of the changes through multiple versions

  toolfinancial modelscenario analysisproductivityversion tracker

  304Discussadd_shopping_cart

  free

  by FinExMod
• 

  Typical Cash Flow Waterfall (Excel Template and PDF manual)

  Contains a typical cash flow waterfall and covers the concept of cash flow waterfall

  cash flowfinancial modelingproject financewaterfall modelcash flow waterfall

  352Discussadd_shopping_cart

  free

  by FinExMod
• 

  Project Finance Debt Metrics (Manual and Template)

  This manual and workbook are designed to help you build metrics required by lenders for project finance transactions.

  project financedscrllcrdebt metricsaverage loan life

  290Discussadd_shopping_cart

  free

  by FinExMod
• 

  VBA Interface Collection (demo version)

  A set of Excel VBA macros aimed at enhancing user interface

  excelvbamacroscalendarcontrolroundbuttons

  575Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Visualize Financial Statement with Dynamic Charts

  This spreadsheet and manual demonstrate how to include dynamic charts for the visualizations of the financial statements

  chartsdashboardfinancial modelingfinancial modelling

  180Discussadd_shopping_cart

  free

  by FinExMod
• 

  Debt Service Reserve Account (Manual & Excel Template)

  Free Excel template and detailed manual covering the concept and structure of Debt Service Reserve Account.

  debtfinancial modelingtemplateproject financedebt service reserve account

  201Discussadd_shopping_cart

  free

  by FinExMod
• 

  Modeling different principal debt repayment methods

  This Excel file runs through five methods for modelling debt principal repayment

  financial modelingproject financedebt repaymentprincipal debt repaymentdebt service

  354Discussadd_shopping_cart

  free

  by FinExMod
• 

  Financial Model Assumption Book

  Financial model assumption and reference sheet template to be linked to the model

  financial modelproject financeauditassumption bookdata book

  582Discussadd_shopping_cart

  free

  by FinExMod
• 

  Delay sensitivity, Overrun and Liquidated Damages (Manual and Excel Template)

  This manual and Excel template provide a clear way to model a delay in construction, cost overrun and Liquidated damages

  risksensitivitydelayfinancial modelproject finance

  211Discussadd_shopping_cart

  free

  by FinExMod
• 

  Development Indicators for a typical renewable project (Excel Template)

  This template is designed to capture the development impacts of developing energy infrastructure projects.

  powereconomic analysisrenewabledevelopment indicators

  149Discussadd_shopping_cart

  free

  by FinExMod

+ More Best Practices

Discuss with Ivan Klykov

Ask Ivan Klykov questions about their Best Practices. Go ahead!

Post Comment