Great tutorial. I'm a long term CRE broker in SoCal. On a side note, I/O to some is dangerous, but when you examine your equity position, most folks over time have an overwhelming majority of their equity via appreciation. Even if you pay off your entire home over 20yrs...look at your equity from appreciation vs principle paydown, it's not even close. Especially in prime markets. If I'm at 80ltv on an I/O loan, I don't need some guy with an FHA at 97% LTV sticking his nose up at me, lol.
@wayneedmondson1065
2 жыл бұрын
Hi Doug I do these schedules often. Thanks for the examples :)) Thumbs up!!
@DougHExcel
2 жыл бұрын
Very welcome! I found the interest only / ARM portion quite interesting, but I don't think they will be often used now compared to the 2000s.
@wayneedmondson1065
2 жыл бұрын
@@DougHExcel Agreed.. although commercial real estate borrowers and lenders still use them. Thanks again!!
@21crad6
2 жыл бұрын
What about adding late fees for missed payments?
@bhavneshparikh8283
Жыл бұрын
How to auto update if client wise loan amotozation table with extra payment aditional payment If rate change how to auto update if only interest recive how can work in excel
@KevinDonnelly-jw8vm
Жыл бұрын
Great Tutorial!! When I double click G10 and H10 as shown at 11:18 I get a circular reference warning re D11 through H11. Any help would be appreciated.
@DougHExcel
Жыл бұрын
don't know about your specific use case, but maybe use the formula evaluator to see where it goes bad.. kzitem.info/news/bejne/rKmF3ZeoZmR0gYY
Пікірлер: 9