Per%Sense - Financial Calculator

Fill in Price or Monthly Total (not both). Fill in exactly one of: % Down, Cash Required, or Amt Borrowed — whichever you leave blank is what Per%Sense solves for (the fill-in-the-blank concept). Computed cells look like $1,234.56 — these are outputs, recalculated on every Calculate, so they aren't used as inputs. To reuse a computed value as a fixed input (and solve for a different blank), harden it: double-click the cell or press H. If you just want a different number, type over it instead. Click Clear Row to start over.
Shortcuts: C or F10 calculates the selected row; Enter moves to the next field (and recalculates if Auto-calculate is on); H hardens the selected computed cell; Shift+Delete clears the focused cell; Ctrl/⌘+Z undoes the last change.
More: Mortgage screen guide · the grid & balloons · APR & loan comparisons · What-If tables.

#	Price ?Total purchase price of the property.	Points ?One-time bank charge. 1.0 = 1% of amount borrowed paid at settlement. Learn more →	% Down ?Down payment as % of price. Fill in this OR Cash Required OR Amt Borrowed (not more than one). Learn more →	Cash Required ?Down payment + points. The bulk of money needed at closing.	Amt Borrowed ?Loan amount = Price minus down payment.	Years ?Duration of the mortgage in years (e.g. 15, 20, or 30).	Loan Rate ?Quoted annual interest rate. Equals APR only when Points=0. Learn more →	Mo Tax+Ins ?Monthly real estate taxes + homeowner's insurance.	Monthly Total ?Total monthly payment including principal, interest, tax, and insurance.	Balloon Yrs ?When an optional lump (the balloon) is paid. It does not shorten the loan — payments still run the full Years term; the balloon just lets you carry a lower Monthly Total. Leave Balloon Amt blank to compute it. To instead pay off the balance owed and end the loan early, set Years to that payoff year too (after hardening the long-term Monthly Total) — see Help, Example 4. Learn more →	Balloon Amt ?An extra lump paid in the Balloon Yrs year, on top of the regular payments, that reduces the Monthly Total. Enter Monthly Total and leave this blank to solve it. Note: a full amortizing Monthly Total needs no balloon, so it solves to about 0 — lower the Monthly Total to size a real balloon. For the remaining balance owed (a true early payoff), set Years to the payoff year with the long-term Monthly Total hardened — see Help, Example 4. Learn more →	APR ?Annual Percentage Rate per Truth In Lending Act. Full-term APR assuming loan held to maturity. Always computed on a 360-day basis — the Settings “Basis” option affects only the Amortization and Present Value screens, not Mortgage. Learn more →

Enter loan parameters below. Leave Payment Amount blank to compute it, or leave Amount Borrowed or Rate blank to back-solve it. Points are used only for APR — they do not affect the schedule.
Note: any Advanced Options in effect stay in effect until cleared (a red badge on the panel shows how many) — use Clear All before starting an unrelated loan so a leftover target, moratorium, or skip-month doesn't quietly change the schedule.
Shortcuts: C or F10 calculates; press T in any date field for today's date; Enter moves to the next field (and recalculates if Auto-calculate is on); Shift+Delete clears the focused cell; Ctrl/⌘+Z undoes the last change.
More: Amortization guide · Advanced Options · payoff / balance lookup · settings that affect the schedule.

Amt Borrowed ?Principal amount of the loan. Leave blank to back-solve from Payment + Rate + Term. Learn more →	Loan Date ?Settlement date when the loan originates. Used to compute the partial-period interest if it precedes the first payment. Learn more →	Rate % ?Annual interest rate quoted by the lender. Leave blank to back-solve from Amount + Payment + Term. Learn more →	1st Pmt Date ?Date of the first regular payment. Optional — if left blank, defaults to Loan Date + 1 period.	# Periods ?Total number of regular payments. Leave blank if Last Pmt Date is supplied; the system derives one from the other.	Last Pmt Date ?Date of the final regular payment. Computed from 1st Pmt Date + # Periods, or supply it directly and leave # Periods blank.	Pmts/Yr ?1=annual, 2=semi, 4=quarterly, 12=monthly, 24=semi-monthly, 26=biweekly, 52=weekly Learn more →	Pmt Amount ?Leave blank to compute. Or enter a specific payment and leave # Periods blank.	Points ?One-time charge at settlement, in points (1 point = 1% of Amt Borrowed). Used only to compute the APR — it does not change the payment schedule. Leave 0 for no points.	APR % ?Annual Percentage Rate including the cost of points. Computed when Points is non-zero (DOS EstimateAndRefineAPRwithPoints) and reported as an effective annual yield.

Payoff as of

Balance

?Enter a date to find the remaining balance at that point — or enter a target balance to find the date it is reached. Generate the schedule first. This is a payoff quote: principal still owed plus interest accrued since the last payment, and it does not credit that date's scheduled payment — so early in a high-rate loan it can exceed the amount borrowed. Learn more →

Advanced Options

Additional Periodic Payments ?Recurring extra payments, e.g. biannual extras. By default each is paid in addition to the regular payment; the "Balloon / prepayment includes regular pmt" setting can switch them to replace the regular payment instead. Learn more →

Start Date ?Date of the first extra payment in this series.	# Pmts ?Number of extra payments (alternative to Stop Date). Note: the engine currently honors Stop Date only; if you supply both, # Pmts is ignored.	Stop Date ?Date after which no more extra payments are made.	Per/Yr ?Frequency of the extra payments (e.g. 12 = monthly, 2 = semi-annual).	Amount ?Dollar amount of each extra payment. By default it is added to the regular payment; set "Balloon / prepayment includes regular pmt" to YES to have it replace the regular payment instead.

Balloon Payments ?One-time lump sum payments applied to principal. The "Balloon / prepayment includes regular pmt" setting controls whether the regular payment is also due that period. Learn more →

Date ?Date the balloon is paid. Must be on or after the 1st Pmt Date.	Amount ?Dollar amount of the balloon. Whether this replaces or is added to the regular payment is controlled by the "Balloon / prepayment includes regular pmt" setting.

Rate/Payment Adjustments ?For adjustable-rate mortgages: change rate and/or payment on specific dates. Learn more →

Date ?Date the rate or payment change takes effect. Must be after Loan Date and before Last Pmt Date.	New Rate % ?New annual interest rate effective from this date forward. Leave blank if only the payment amount is changing.	New Amount ?New regular payment amount effective from this date forward. Leave blank if only the rate is changing — Per%Sense then re-amortizes the remaining balance at the new rate (DOS AO5). Leave the rate blank and supply only an amount to have the engine solve the implied rate (AO6). Leaving both blank is the AO7 "re-amortize at current rate" signal.

Other Options

Moratorium ?Interest-only period. Enter the date when principal repayment resumes. Learn more →	Principal minimum ?Minimum amount by which the principal must decrease each payment. Early payments are raised to meet this minimum; later payments settle to the regular amount. Learn more →	Skip Months ?Months with no payment, e.g. "6-8,12" skips Jun-Aug and Dec. Learn more →

View:

#	Date	Payment	Interest	Principal	Balance	Int to Date

Enter payments above, rate and as-of date below. Leave Rate blank to compute an IRR (internal rate of return). The as-of date can be past (present value) or future (future value).
Note: the help-doc worked examples are quoted using the True Rate convention — pick it in Rate Type to reproduce their figures. Every row and modifier listed below is summed into the total, so use Clear All before starting an unrelated example.
Shortcuts: C or F10 calculates; press T in any date field for today's date; Enter moves to the next field (and recalculates if Auto-calculate is on); Shift+Delete clears the focused cell; Ctrl/⌘+Z undoes the last change.
More: Present Value guide · payment grids · rate types · COLAs · variable-rate mode.

As-of Date ?Reference date for all value calculations. Set in the past for present value; in the future for future value. Learn more →

Rate Type

Rate % ?True Rate: continuous compounding (savings, PV). Loan Rate: discrete compounding (loans). Yield: actual annual return after compounding. These are equivalent representations. Leave blank to solve for IRR. Learn more →

Present Value ?Computed total when Rate and As-of Date are both filled. To solve backward, type a target value here and leave Rate blank (solves the rate / IRR) or As-of Date blank (solves the date). Learn more →

Single Payments (Lump Sums) ?One-time payments at specific dates. Each is valued independently at the as-of date. Learn more →

Date ?Date of the one-time payment. Leave blank to back-solve when Amount is supplied along with a target Sum Value.	Amount ?Dollar amount of the payment. Leave blank to back-solve from Date + target Sum Value.	Life ?Life contingency: None, Living, Dead, Only 1, Only 2, Either, Both. Requires actuarial tables below. The four two-life options (Only 1, Only 2, Either, Both) stay disabled until Person 2 is configured. Learn more →	Value ?Computed present/future value of this payment at the as-of date. Each lump sum is valued independently.

Periodic Payments ?Series of regular payments between two dates. COLA = annual cost-of-living adjustment (optional, interpreted as yield). Learn more →

From Date ?Date of the first payment in the series. Leave blank to back-solve when Through + Amount + target Sum Value are supplied.	Through ?Date of the last payment in the series. Leave blank to back-solve when From Date + Amount + target Sum Value are supplied.	Per/Yr ?Payment frequency: 1=annual, 2=semi-annual, 4=quarterly, 12=monthly, 24=semi-monthly, 26=biweekly, 52=weekly.	Amount ?Dollar amount of each payment. Leave blank when both dates are supplied along with a target Sum Value.	COLA % ?Annual cost-of-living adjustment (optional). Payments grow by this percentage each year. Interpreted as a yield, not a continuous rate. Blank = 0%. Learn more →	Life ?Life contingency: None, Living, Dead, Only 1, Only 2, Either, Both. Requires actuarial tables below. The four two-life options (Only 1, Only 2, Either, Both) stay disabled until Person 2 is configured. Learn more →	Value ?Computed present/future value of the entire series at the as-of date.

Life Contingency (Actuarial) ?Weight present values by survival probability from an actuarial life table. Set a contingency type (Living, Dead, etc.) on each payment row above, then configure the life table(s) here. Learn more →

Person 1

Table

Date of Birth

Person 2 (optional, for two-life contingencies)

Table

Date of Birth

Reference Date ("Now") ?The date the person is known to be alive — survival probabilities are conditioned from here. Leave blank to use the As-of Date (filled in green on Calculate); type a date to override.

Payment on Death (POD) ?Optional lump sum payable at the moment of death. Its expected present value is computed by integrating over the mortality distribution.

Variable Rate Schedule ?Use different interest rates for different time periods (e.g. IRS tax interest, statutory rates). When any rate is populated, the As-of Rate field above is ignored. IRR cannot be computed in variable rate mode. Learn more →

Enter rates that change over time. Row 1's rate is the starting rate (its date is fixed at "—"); subsequent rows specify when the rate changes. Fill in any one of True Rate, Loan Rate, or Yield per row — they're equivalent and the engine uses the True Rate form internally (LoanRate assumes monthly compounding).

Effective Date ?Date this rate takes effect. Row 1 is read-only (the starting rate); subsequent rows change the rate from that date forward.	True Rate % ?Continuously compounded rate — the mathematically "pure" rate. Passed directly to the engine.	Loan Rate % ?Nominal annual rate compounded monthly. Converted to True Rate via TrueRate = 12 × ln(1 + LoanRate/12).	Yield % ?Effective annual yield. Converted to True Rate via TrueRate = ln(1 + Yield).

"What-If" Table Generator

Computational Settings