How to Calculate IRR in Excel: IRR, XIRR, and MIRR Functions (2026)
IRR in Excel uses three functions depending on cash flow timing. When to use =IRR, =XIRR, and =MIRR, with syntax, worked examples, and #NUM! fixes.
In-depth guides on personal finance, federal retirement, health, and more. Written to help you understand the math behind our calculators and make smarter decisions.
FinanceIRR in Excel uses three functions depending on cash flow timing. When to use =IRR, =XIRR, and =MIRR, with syntax, worked examples, and #NUM! fixes.
FinanceIRR, ROI, and equity multiple measure different things. Which to use for real estate and private equity, and when the three metrics conflict.
FinancePE funds report gross IRR; LPs receive net. How the gap is calculated, why funds show negative IRR early, and the three metrics that tell the full story.
FinanceIRR and NPV often agree, but four scenarios cause them to conflict. Which to trust for scale comparisons, mutually exclusive projects, and capital allocation.
FinanceA good IRR means different things for real estate, private equity, and stocks. Hurdle rates, benchmarks by strategy, and when a high IRR misleads.
EducationLaw school scholarship negotiation works when you hold a competing offer. Timing, what to say, and where schools have the most flexibility to move.
EducationLaw school scholarships for women and minorities come from two sources: school merit aid and external programs. How to find both and what qualifies.
EducationThe law schools that give the most scholarships are not the top-ranked ones. Which rank tiers offer the most merit aid and how to find your targets.
EducationFull ride law school scholarships: which school tiers offer full tuition, LSAT scores that qualify, and when a full ride beats a higher-ranked school.
EducationLaw school scholarships come down to LSAT and GPA vs school medians. How thresholds work, the renewal trap, and where full scholarships actually come from.
PayrollCalifornia hourly paycheck calculator: how daily overtime after 8 hours works, double time after 12, SDI on hourly wages, and take-home at $18, $25, and $35/hr.
PayrollCalifornia paycheck laws: how often employers must pay, what every pay stub requires, legal vs illegal deductions, and penalties for late regular paychecks under Labor Code 210.
PayrollCalifornia final paycheck law: termination means same-day pay, resignation with notice means last day, without notice means 72 hours. Labor Code 203 penalties explained.
PayrollCalifornia paycheck tax breakdown: CA income tax 1%–13.3%, SDI 1.1% no cap, federal withholding, and take-home at $50K, $75K, and $100K for single filers.
FinanceConstitutional silver value calculator by face value. What a $1,000 bag contains, current value, and how pre-1965 coin silver compares to silver bars.
FinanceCalculate scrap value of sterling silver jewelry and flatware. Covers pennyweight, weighing rings and chains, flatware patterns, and what dealers offer.
FinanceGold to silver ratio calculator: the formula, historical range from 1900 to today, how investors use it to time metal swaps, and why it expanded after 1971.
FinanceSilver-plated items have near-zero scrap value. How to identify plate vs solid sterling, what EPNS hallmarks mean, and when antique premiums apply.
FinanceSilver coin melt value calculator for US dimes, quarters, halves, and dollars. Silver content by coin type, date, formula, and dealer payout rates.
Health & Fitness99th percentile baby weighs more than 99% of same-age infants. What high and low percentile actually means clinically, when it matters, and when it doesn't.
Health & FitnessBaby percentile during pregnancy shows fetal size vs. same-age fetuses on ultrasound. How it's calculated, what SGA means, and what helps improve fetal growth.
Health & FitnessBaby weight percentile chart with WHO reference values birth to 24 months. Complete tables for boys and girls, 3rd to 97th percentile, by month.
PayrollOhio hourly paycheck: 0% on first $26,050, then 2.75%. How overtime, SDIT, and city tax affect hourly workers' take-home pay at $15 to $30/hr.
Health & FitnessBaby percentile compares your baby's weight or length to WHO reference babies the same age and sex. What the number means, how it's calculated, and what to watch.
PayrollIllinois income tax: constitutionally fixed 4.95% flat rate, full pension and Social Security exemption. Take-home pay at $50K, $75K, $100K for 2025.
PayrollNebraska income tax: 4-bracket system with a top rate dropping to 3.99% by 2027. Social Security now fully exempt. Take-home at $50K, $75K, $100K.
PayrollMinnesota income tax: 4 brackets from 5.35% to 9.85%, no local tax anywhere in the state. Take-home pay at $50K, $75K, and $100K for 2025.
PayrollUtah income tax: flat 4.55% rate with a personal exemption credit that reduces your bill directly. Take-home pay at $50K, $75K, and $100K for 2025.
PayrollOhio city income tax guide: rates for Columbus, Cleveland, Cincinnati, Toledo. How the resident credit works when you live in one city and work in another.
PayrollOhio SDIT explained: 210+ districts levy 0.5% to 2.5% based on where you live. Traditional vs. Earned Income types, top district rates, and what to do if not withheld.
FinanceFERS supplement calculator guide: who qualifies, how to calculate the amount, earned income test, sick leave credit, and when the supplement stops at 62.
PayrollNY paycheck calculator guide: NJ graduated rates, Indiana county taxes, Michigan city taxes, and NYC city tax. Take-home pay at $55K and $85K.
PayrollSouth Carolina 2026: simplified 1.99% and 5.21% rates replace the old six-bracket system. Military exemption, SS exemption, and take-home pay at $50K to $100K.
PayrollWisconsin paycheck tax: 3.5% to 7.65% brackets with a sliding standard deduction that phases out by $106K income. Take-home pay at $50K to $100K.
PayrollWisconsin paycheck calculator guide: SC flat tax path, Mississippi's $10K zero-rate band, and Connecticut's bracket structure. Take-home pay 2025-26.
PayrollMaryland paycheck tax: 4.75% to 6.5% state rates plus county income tax up to 3.30%. All 23 county rates and take-home pay at $60K to $120K.
FinanceSilver bar calculator for 1 oz, 10 oz, and 100 oz bullion. Covers silver bullion value, bar premiums, rounds vs bars, and live spot price calculation.
PayrollIllinois paycheck calculator guide: PA 3.07% flat tax, Maryland county taxes, and Washington state's no-income-tax rules. Take-home pay 2025-26.
FinanceSilver price per gram calculator for 999, 925, 900, 835, and 800 grade silver. Covers silver calculation formula and how to calculate silver price.
PayrollAlaska has no state income tax. Hawaii's top rate reaches 11%. Idaho went flat at 5.8% in 2023. Kentucky cut to 4.0%. Take-home pay at $50K, $75K, and $100K compared.
FinanceOld silver rate is today's spot price adjusted for purity and dealer margin. How to calculate old silver value per gram, why old rates differ from new silver, and what affects the price in your city.
PayrollMassachusetts paycheck tax guide: 5% flat state income tax, PFML withholding explained. Take-home pay at $60K, $80K, and $120K for 2025-26.
PayrollOhio paycheck tax guide: 0% on first $26,050, 2.75% to 3.125% for 2025 taxes. SDIT and city tax explained. Take-home pay at $50K-$100K.
FinanceHow to calculate IRR on the HP 12C, BA II Plus, and Excel. Key sequences, cash flow entry, and when you get no solution. Free IRR calculator included.
MathAcceleration calculator: find acceleration from velocity change and time, or use any of the 3 kinematic equations. All units supported. Free, no signup.
Health & FitnessA1C calculator: convert average blood glucose or GMI to estimated A1C using the ADA ADAG formula. mg/dL and mmol/L both supported. Free, no signup.
MathPower rule, polynomial, exponential, and log antiderivatives with worked examples. How to find any antiderivative and verify the result.
FinanceProrated rent formula, move-in and move-out examples, daily rate method. Calculate exact partial-month rent for any move date. No signup.
Finance2026 Roth IRA limits: $7,000 ($8,000 if 50+). Phase-out begins at $150k single, $236k married. Calculate your exact allowed contribution. No signup.
FinanceCap rate = NOI divided by property value. Learn the formula, see examples by property type, and find out what cap rate benchmarks apply to your investment.
FinancePre-1965 US coins hold 90% silver. Calculate junk silver value by weight, coin type, and grade. Covers dimes, quarters, and 800-grade European silver.
PayrollNebraska, Minnesota, Utah, and Montana tax wages differently. Take-home pay at $50K, $75K, $100K plus Montana's 2024 reform. No signup.
MathPartial derivatives measure how a function changes in one direction while others are fixed. Rules, worked examples, gradient, and applications.
MathA determinant shows if a matrix has an inverse and if a linear system has a unique solution. Step-by-step 2x2 and 3x3 methods with examples.
FinanceCommercial mortgage payments depend on rate, amortization, and balloon term. DSCR determines approval. Worked examples with real numbers.
Health & FitnessTotal calcium is unreliable with low albumin. The Payne correction formula adjusts for protein binding. When to use it and when ionized calcium is better.
FinanceIRR is the discount rate that makes an investment's NPV equal zero. Formula, worked examples, MIRR correction, and when IRR misleads.
ConstructionSquare footage is length times width for simple rooms. L-shapes and bay windows change the math. Exact method for rooms, floors, and whole houses.
FinanceCap rate measures income yield today. IRR captures total return with timing. How to calculate both and when each applies to a real estate deal.
FinanceCoast FIRE needs a larger portfolio but no part-time income. Barista FIRE gets you there sooner with less saved. Compare numbers and timelines.
Health & FitnessIn the US, proof is ABV doubled. A 40% spirit is 80 proof. Conversion table, formulas, and how the old UK proof system set 100 proof at 57% ABV.
Health & FitnessBrix from a refractometer converts to SG and potential ABV. Includes a Brix-to-SG table, the ABV formula, and correction for post-fermentation readings.
Health & FitnessCalculate ABV from original and final gravity using the standard homebrewing formula. Worked examples for beer, wine, and cider. No signup.
Health & FitnessHow to use a hydrometer to take gravity readings, apply temperature corrections, and calculate ABV from homebrew measurements. No signup.
FinanceScrap silver value depends on weight, purity, and spot price. Learn the formula, read purity hallmarks, and see what dealers pay for 925 and coin silver.
FinanceSilver is priced in troy ounces, not standard ounces. Convert to grams, calculate value by purity and weight, and understand live spot price.
Finance925 silver is 92.5% pure sterling. Value per gram and troy ounce, how a 925 silver calculator works, and comparison to fine silver spot price.
MathComplete trig antiderivatives reference: sin, cos, tan, cot, sec, csc, plus 1/x, ln x, and e^x. Derivations, worked examples, and quick reference table.
Health & FitnessLearn how to calculate your menstrual cycle length, when a period is late vs missed, and what affects period calculator accuracy. Includes manual formula.
Health & FitnessHow to calculate chronological age by hand, in years and months, for Pearson assessments, speech therapy, and prematurity adjustment. Free guide.
Health & FitnessStarbucks nutrition guide covering latte calories, Frappuccino calories, low calorie options, syrup nutrition, and custom order calorie calculation.
FinanceHow to calculate your FERS retirement annuity, High-3 salary, sick leave credit, FERS supplement, and early retirement reduction rules. Step-by-step.
FinanceHow to calculate your Coast FIRE number with worked examples, a reference table by age, and adjustments for Social Security and pension income.
FinanceNo law sets an equity floor for reverse mortgages, but the math creates one. How requirements work by age, home value, and rate, with real examples.
FinanceHow to calculate a reverse mortgage: principal limit factor, upfront costs, payout options, and worked examples for different ages and home values.