How to Model a Personal Loan to Others in Projection Lab
Why You Can't Just Model It as Income If you've ever lent money to a family member or friend and tried to model it in Projection Lab, you've probably run into a wall. PL doesn't have a native way to handle it, and if you just enter the payments as income, you'll overstate your taxes every single year of the loan. When someone repays a personal loan, each payment has two parts: Return of principal: not taxable. You already paid tax on this money. Interest: taxable as ordinary income. If you lump the whole payment into a single income stream in PL, it taxes everything. You have to split them into two separate streams to get the tax treatment right. The Three-Piece Setup in Projection Lab 1. The outflow Model the initial loan as a one-time expense in the year you make it. This reduces your cash balance at origination. 2. Interest income Create a separate ordinary income stream for the interest only. This is the piece that changes every year and where the Adv...