Every financial calculation you can imagine
Per%Sense is a fill-in-the-blank calculator. Enter the values you know and leave unknowns blank — the system fills in the answers automatically. Your input appears on a white background; computed answers appear on a green background.
| # | 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. |
|---|
| 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). |
|---|---|---|---|---|---|---|---|---|---|---|
| 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. |
|---|---|---|---|---|
| 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. |
|---|---|
| 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. |
|---|---|---|
| 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. |
|---|---|---|
| # | Date | Payment | Interest | Principal | Balance | Int to 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. |
|---|
| 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. |
|---|
| 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). |
|---|---|---|---|