Per%Sense - Financial Calculator

Fill in Price or Monthly Total (not both). Fill in exactly one of: % Down, Cash Required, or Amt Borrowed. Computed cells look like $1,234.56 — don't retype them. Double-click a computed cell to harden it as input. Click Clear Row to start over.
Shortcuts: C calculates the selected row; Enter moves to the next field; H hardens the selected computed cell.

#	Price ?Total purchase price of the property.	Points ?One-time bank charge. 1.0 = 1% of amount borrowed paid at settlement.	% Down ?Down payment as % of price. Fill in this OR Cash Required OR Amt Borrowed (not more than one).	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.	Mo Tax+Ins ?Monthly real estate taxes + homeowner's insurance.	Monthly Total ?Total monthly payment including principal, interest, tax, and insurance.	Balloon Yrs ?Years until balloon payment (optional). Leave blank for no balloon.	Balloon Amt ?Lump sum payment amount. If only Yrs is specified, this is computed.	APR ?Annual Percentage Rate per Truth In Lending Act. Full-term APR assuming loan held to maturity.

Enter loan parameters below. Leave Payment Amount blank to compute it, or enter it and leave another field blank. Points are used only for APR — they do not affect the schedule.
Shortcuts: C calculates; press T in any date field for today's date; Enter moves to the next field.

Amt Borrowed ?Principal amount of the loan. Leave blank to back-solve from Payment + Rate + Term.	Loan Date ?Settlement date when the loan originates. Used to compute the partial-period interest if it precedes the first payment.	Rate % ?Annual interest rate quoted by the lender. Leave blank to back-solve from Amount + Payment + Term.	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	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.	Basis ?360=standard (30-day months). 365=actual days. 365/360=hybrid (actual days / 360 denominator).

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.

Advanced Options

Additional Periodic Payments ?Extra payments beyond the regular amount, e.g. biannual extra payments.

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 beyond the regular amount.

Balloon Payments ?One-time lump sum payments applied to principal. The "balloon includes regular" setting controls whether the regular payment is also due.

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 includes regular pmt" setting.

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

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.	Target Amt ?Minimum principal reduction per payment. Payment adjusts upward if needed.	Skip Months ?Months with no payment, e.g. "6-8,12" skips Jun-Aug and Dec.

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).
Shortcuts: C calculates; press T in any date field for today's date; Enter moves to the next field.

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

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.

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).

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

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.	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).

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%.	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.	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.

Person 1

Table

Date of Birth

Person 2 (optional, for two-life contingencies)

Table

Date of Birth

Reference Date ("Now")

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.

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