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.

Split Text between Upper and Lower Case in Excel

https://youtu.be/POIV3wCyHLE

Separating text that should have been in two columns instead of one is easy to do if there is some kind of delimiter (i.e., comma or colon). But if it was two words like first name and last name that was combined; and the only way to make out the beginning vs. end is the case (Upper case vs. Lower case; like Bob Smith). There's actually a really easy way to do this and then there's the super nerdy formula combination way. I'll show both ways but show the formula way first.

Rent Split Calculator in Excel

Splitting the rent between roommates is not an easy task, especially if you all have got different preferences about what's important. In this video, we'll take a hard facts approach to apartment rent splitting by using square footage. One model will use the square footage of the whole unit but give specific consideration to the bedrooms and other model will pay attention only to the bedroom. There's not right approach, just the approach you all agree on. The beauty of this model is that it's done in Excel and when you look at different room sizes or the number of room mates sharing, you can adjust the numbers and the cost per person will recalculate.