Power BI - How to Do Financial Modelling of an AirBNB

Описание

In this tutorial, you'll learn how to create a Microsoft PowerBI financial model that can be used to rapidly evaluate real estate investments while on the go. The model is cloud based and housed on one single app-like page that beats any boring old Microsoft Excel financial model. All of our data will be dynamic including key investment metrics like cash flow, net present value, internal rate of return, and more.
------------------------------
Free downloads of templates and data used: https://www.ptarmy.com/joinus ✌️

If you want to pay for the calculator instead: https://dakotaptarmy.gumroad.com/l/kjoqc
------------------------------
As always please subscribe, like or comment with any more ideas or feedback. It helps keeps me going.
------------------------------
Timestamps:
0:00 Introduction
0:41 Model Inputs Create Parameters in PowerBI
4:11 Organize and Structure Create a DAX Date Table
8:19 Build a Cashflow Statement Create the Measures!
20:29 The Boring Stuff! Add in Inflation and Formatting
24:41 Finally a Visual Cash Flows Column / Line Chart
26:30 Economic Indicators DAX Financial Functions
33:11 Finally Done! Housekeeping on Formatting