Real estate, loans and other financial calculations & solutions

A full payment-by-payment schedule for a loan that pays off completely over its term. Shows how much of each payment goes to interest and how much to principal, plus the balance after every payment.

The same schedule, but the loan is paid off early with a lump sum. Enter when the balloon comes due to see the payoff amount and the interest paid up to that point.

Payment schedule for a fixed installment note, the kind used for a vehicle, equipment, or a short-term seller carryback.

Interest accrues but nothing is paid until maturity. Shows the total amount owed on the payoff date.

Schedule for an adjustable rate loan where the rate changes on a set schedule. Shows how the payment moves at each adjustment.

A second adjustable rate schedule, for loans with a different adjustment pattern or a different starting rate.

Enter the loan amount, rate, and term to get the payment. Just the number, without the full schedule.

Puts the two terms side by side: the difference in payment, the total interest each one costs, and what the shorter term saves over the life of the loan.

Compares two loans on annual percentage rate rather than the note rate, so points and fees are counted. The lower rate is not always the cheaper loan.

Works backward from income and existing debt to the largest loan a buyer can qualify for.

Shows the monthly income a buyer needs to qualify for a given loan, based on gross income and qualifying ratios.

Shows how changing the down payment changes both the loan amount and the income a buyer needs to qualify.

Income property analysis: gross income, vacancy, operating expenses, net operating income, debt service, and the cash flow and return that come out the other side.

The same analysis with capital improvements included, so money spent on the building during the hold period is reflected in the return.

Return analysis for raw land, which carries costs but produces no income until it sells.

Land analysis with capital improvements added, such as grading, utilities, or entitlement costs.

The annual yield on a series of cash flows, including the proceeds from the sale. The single most common way to compare one investment against another.

A refinement of IRR. Negative cash flows are covered at a safe rate and positive ones are reinvested at a realistic rate, which avoids the unrealistic reinvestment assumption built into IRR.

Net operating income divided by annual debt service. Lenders use this ratio to decide how large a commercial loan they will make.