Create a Probability Impact Table & Matrix

https://youtu.be/cbiuV-UWvPc

The video covers how to create a probability impact table or Risk Assessment table. If you're doing project management or risk management, you'd be creating this table or matrix chart for your program or projects. You'd need to list out the different risk criteria and then figure out the likelihood of the risk happening (the probability part) and then the impact it would have (high, medium or low). This combination of probability and impact then helps determine the risk (again high, medium or low) that specific risk has to the project. There's bonuses to this; in addition to how to create the table and risk matrix I show how to create a drop down list, use conditional formatting for the color coding and show how to count up the different combinations of probability-impact in the matrix.

Format Excel Sheet to Print a More Readable Table

Printing out excel ranges should be a simple process. It's just text or values in little boxes, but if there's little or no formatting your audience might find it hard to read. Unlike text in a book there may not be enough space to help make it easier to read. With some simple steps you can help make a table easier for your audience to read when you actually give them a hard copy printout to read. I'll give you two example of how this can be done.

Interest Only Loan Amortization Schedule in Excel

https://youtu.be/Gbv-urHtW5o

Interest only loans may have been one of the contributing factors to the mortgage crisis in the late 2000s, but that was because lenders were not doing their job in vetted out people that were applying for the loans. As a tool to help people afford their dream house an interest only loan is a reasonable option to use. The key is to have the right expectations and that comes with knowing what you are getting into. That's why building out the year by year or amortization schedule will help you model your payments.