How to use Loan Fee and Effective Rate Calculator
- Enter Stated loan amount before fees, then Upfront fees withheld from proceeds. The difference is Net proceeds, the amount advanced in this model, and must remain positive.
- Enter one Fixed monthly payment and Number of monthly payments. The first payment is exactly one month after the advance; later payments are equal and one month apart.
- Select Calculate result. Read Monthly implied yield separately from nominal annualized yield, 12r, and Effective annual yield, (1 + r)^12 − 1. Those annualizations use different conventions.
- Check Present-value residual, the modeled present value of repayments minus net proceeds at the solved rate. Copy the table or text if useful; no schedule download is generated.
Example: Loan Fee and Effective Rate Calculator
With a $200,000 stated loan and $3,000 withheld fees, net proceeds are $197,000. The 240 payments of $1,350 total $324,000. Solving that monthly cash-flow equation gives the displayed 5.59218738886% effective annual yield.
Options
- Net proceeds
- The model starts from the stated loan amount minus the fees withheld upfront. Those proceeds must remain positive.
- Payment sequence
- Enter equal positive payments at the end of each month. Irregular dates, extra advances and balloon payments need a different model.
- Currency label
- The currency label applies to net proceeds and payment totals. Monthly and annual yields are percentages; the residual is an amount difference in the entered currency. No exchange rate is used.
Supported inputs and limits
- Principal and payment must be positive whole-cent amounts; fees may be zero but must be below principal.
- Each monetary input is limited to 1,000,000,000,000.
- Use 1 to 1,200 whole monthly payments.
- Grouping commas and a leading $ are accepted in amount fields.
- The model has one net advance followed by equal positive end-of-month payments.
More details
It excludes financed fees, irregular dates, extra advances, balloons and unentered charges.
The bounded numerical solver can return a negative monthly yield when the total repayments are below net proceeds; an inaccurate or unsupported solution is refused.
Displayed rates use up to 12 significant digits.
Nominal annualization is 12 × monthly rate; effective annualization compounds that rate for 12 months.
Neither determines statutory APR, legally includable fees or required lender disclosures.
The residual measures the equation fit, not completeness of the supplied costs.
Processing is local without automatic saving.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Modeled borrowing yield is not a statutory APR
The solver finds a monthly rate that discounts the entered repayments to the net proceeds. Nominal and effective annualizations describe that same mathematical rate using different conventions. Fee classification and required legal disclosures vary; this page does not determine them. Review the reported residual as part of the numerical result.
Questions about Loan Fee and Effective Rate Calculator
Is this the APR a lender must disclose?
No. Statutory APR depends on applicable rules, included charges and timing. This page solves the stated cash-flow model only.
Why can the yield be negative?
If the modeled repayments are worth less than the net advance at zero interest, the corresponding cash-flow yield is negative.
What does the residual show?
It shows the difference between the modeled present value of repayments and net proceeds at the solved rate.