Lease Builder
Lay out the cash flows of a lease, in date order. Give any line a code (like OEC) and reuse it elsewhere β a residual of 0.15 x OEC updates itself. Put X in one or more amounts, in the rate, or in a line's ΓN (to solve the number of payments) and Solve fills it in.
Set each line's own periodicity in the Per column. Drag the β Ώ handle to reorder, then Re-chain dates to space them by ΓN. Money out is red (οΌ), in is green (οΌ). Tick no interest for pass-through fees (e.g. service). Add a Rate change line (a date + a new rate) for a stepped/floating rate.
β» Inputs changed β click Solve / Analyze to refresh the results.