Jacek Polewski, Author at ChallengeJP

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial shows how to create a merger and acquisition financial model including synergies, debt, and valuation calculations. It starts with analysing the cash flows of the target and the…

How to Create a Capital Investment Plan in Excel

December 29, 2022

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial shows how to create a Capital Investment Plan in Excel. First, I will set up a financial model in Excel, calculate revenue and cost, and forecast cash flow.…

How to Create a Marketing Investment Plan in Excel

November 14, 2022

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial will show you how to create a Marketing Investment Plan in Excel. First, I will show you how to analyse and process data from an existing advertising campaign.…

How to Create a Telecom Financial Model in Excel

August 21, 2022

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial will show you how to create a Telecom Financial Model in Excel. It will start with instructions on projecting users’ growth and estimating revenues and operating expenses related…

business documents on office table with laptop

How to Create a Real Estate Investment Model in Excel

June 30, 2022

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial will show you how to create a Real Estate Cash Flow Model in Excel. It will first present examples of calculating monthly revenues and costs from property rental…

How to Create a Project Finance Model in Excel

March 22, 2022

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This tutorial will show you how to create a Project Finance Model and forecast Cash Flow in Excel with step-by-step instructions, practical examples to download and the calculation of Equity…

How to Create a Subscription Model with Churn Calculation

May 26, 2021

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This step-by-step tutorial will take you through an example of using Excel to create a Subscription Model with Churn Calculation. First, it will show you how to forecast customer acquisition…

tableau data visualisation how to tutorial

How to Visualise Data in Tableau

April 21, 2021

Data Analytics, Tableau Tutorial

This tutorial will introduce you to Tableau and data visualisation. It will use an example of data downloaded from Destasis, Germany’s Federal Statistical Office, to visualise Germany’s 2020 International Trading…

How to Create an Excel Financial Model with Debt Financing

March 22, 2021

Cash Flow Forecasting, Excel Tutorial, Financial Modelling

This step-by-step tutorial will take you through an example of using Excel to create a financial model with debt financing. First, it will show you how to calculate and forecast…

How to Analyse Data in Excel with Power Query and a Pivot Table

February 26, 2021

Data Analytics, Excel Tutorial