NEPSE Portfolio Calculator: What Your Shares Are Really Worth After Fees and Tax (2026)

By Wilson Shrestha · Updated 18 November 2026 · Rates checked against the Nepal Gazette of 22 September 2026 and the current SEBON commission schedule

NEPSE portfolio calculator showing portfolio growth after broker commission, SEBON fee and capital gains tax

MeroShare tells you what your shares are worth at the last traded price. It does not tell you what would land in your bank account if you sold today. The gap is broker commission, the SEBON fee, the Rs 25 DP charge and capital gains tax, and on a mixed portfolio it can eat a quarter or more of your paper profit.

Use the free NEPSE portfolio calculator below to see your real portfolio value, or download the spreadsheet template. The guide underneath explains the formula for every holding, works through a five-stock example, checks your sector allocation and annualised returns, and covers the one tax rule that surprises almost every investor.

NEPSE Portfolio Calculator

Add each holding. Results update as you type and stay saved in this browser only.




Equity shares, resident individual rates from 22 Sep 2026: commission 0.36% to 0.24% (flat Rs 10 up to Rs 2,500), SEBON fee 0.015%, DP Rs 25 per scrip, CGT 5% if held 365 days or less, 3.75% if longer. Estimate only; your broker contract note is final. Not investment or tax advice.


Free NEPSE portfolio spreadsheet template

Excel file with 50 holding rows, every formula from this guide, a summary tab, sector weights and a Rates tab you can update when fees or tax change. Opens in Google Sheets too: upload it to Google Drive and choose Open with Google Sheets.

Quick answer: how to calculate your NEPSE portfolio value

  1. For each share: Cost = quantity × WACC, and Market value = quantity × current price.
  2. Subtract the selling charges: broker commission (0.24% to 0.36%), SEBON fee (0.015%) and Rs 25 DP charge.
  3. If what is left is above your cost, take off capital gains tax: 5% if held 365 days or less, 3.75% if held longer.
  4. Add the results for all holdings. That total is your real (liquidation) portfolio value. Subtract total cost and add cash dividends to get your true profit.

0.24–0.36%

Broker commission on each sell, by trade size

0.015%

SEBON fee on the trade value

Rs 25

DP charge per company per day

5% / 3.75%

CGT for individuals: short / long term

The five numbers a NEPSE portfolio calculator should give you

Most free trackers stop at “invested” and “current value”. That is the same thing MeroShare already shows. A useful portfolio calculator answers five questions:

NumberWhat it answersDoes MeroShare show it?
Total costHow much money really went in, fees includedYes, if every WACC is correct
Market valueWhat the shares are worth at today’s priceYes, at last closing price
Liquidation valueWhat you would receive if you sold everything todayNo
Total returnNet profit plus cash dividends, in rupees and percentNo
AllocationHow much of your money sits in one stock or sectorNo

If you only want to check a single trade, the NEPSE share calculator on this site does that in one step. This page is for the whole portfolio.

The NEPSE portfolio formula, step by step

Work out each holding on its own line, because every scrip is sold as a separate order and pays its own commission, DP charge and tax. Then add the lines up.

For each holding

  1. Cost = Quantity × WACC
  2. Market value (MV) = Quantity × current price (LTP)
  3. Selling charges = Commission on MV + (MV × 0.015%) + Rs 25
  4. Taxable gain = MV − Selling charges − Cost (if this is zero or negative, there is no tax)
  5. CGT = Taxable gain × 5% (held 365 days or less) or 3.75% (held more than 365 days)
  6. Net value = MV − Selling charges − CGT
  7. Net profit = Net value − Cost

For the whole portfolio

Real portfolio value = sum of all Net values. Total return = (sum of Net profits + cash dividends) ÷ total Cost × 100.

Broker commission rates used in the formula

The rate depends on the size of the whole order, not on slices of it. A Rs 1,09,000 sale pays 0.33% on the full Rs 1,09,000.

Trade value (equity shares)Commission
Up to Rs 2,500Flat Rs 10
Rs 2,501 to Rs 50,0000.36%
Rs 50,001 to Rs 5,00,0000.33%
Rs 5,00,001 to Rs 20,00,0000.31%
Rs 20,00,001 to Rs 1,00,00,0000.27%
Above Rs 1,00,00,0000.24%

The CGT rates above apply to resident individuals selling listed shares on or after 22 September 2026, when the cut was published in the Nepal Gazette. Earlier in fiscal year 2083/84 the rates were briefly 7.5% and 10%, so a sale made between mid-July and 21 September 2026 was taxed at the higher rate.

Seen 3.5% somewhere? The gazetted rate is 3.75%

News of the Cabinet decision on 16 September 2026 reported a 3.5% long-term rate, and some sites still repeat it. The Finance Ministry notice published in the Nepal Gazette on 22 September 2026 set 3.75% for holdings over 365 days and 5% for 365 days or less. Use 3.75%.

Who these rates are for. The September cut applies to resident individuals. Institutional investors have paid a flat 10% on listed share gains and were not part of the cut, so this calculator is not set up for company or fund accounts.

Mutual fund units and debentures. They trade on lower commission tiers (about 0.10% to 0.15% for mutual funds and 0.02% to 0.10% for debentures) with a 0.010% SEBON fee. The portfolio calculator above is built for equity shares; switch the security type in the NEPSE share calculator to check a fund or debenture sale.

Worked example: a Rs 3.1 lakh, five-stock portfolio

Here is a typical retail portfolio: a bank, two hydropower holdings (one from secondary market, one from an IPO), a life insurer and a telecom share. The prices are example figures, not today’s market prices, so you can follow every rupee. To keep the arithmetic easy, the WACC figures are round numbers; in your own portfolio they should already include the buy-side fees (see getting WACC right).

HoldingQtyWACCLTPDays heldCostMarket value
Commercial bank2005205455001,04,0001,09,000
Hydropower (secondary)30031026242093,00078,600
Life insurer10064072815064,00072,800
Telecom5088090520044,00045,250
Hydropower (IPO)501002457005,00012,250
Total3,10,0003,17,900

MeroShare would show this portfolio as Rs 7,900 in profit. Now run the selling charges and tax on each line:

HoldingSelling chargesTaxable gainCGTNet valueNet profit
Commercial bank401.054,598.95172.46 (3.75%)1,08,426.49+4,426.49
Hydropower (secondary)296.17−14,696.170.0078,303.83−14,696.17
Life insurer276.168,523.84426.19 (5%)72,097.65+8,097.65
Telecom194.691,055.3152.77 (5%)45,002.54+1,002.54
Hydropower (IPO)70.947,179.06269.21 (3.75%)11,909.85+6,909.85
Total1,239.01920.633,15,740.36+5,740.36

How one line works, using the bank: market value Rs 1,09,000 falls in the 0.33% tier, so commission is Rs 359.70. SEBON fee is Rs 16.35 and DP is Rs 25, a total of Rs 401.05. Taxable gain is 1,09,000 − 401.05 − 1,04,000 = Rs 4,598.95. It was held 500 days, so tax is 3.75%, or Rs 172.46.

Where the Rs 7,900 paper profit goes

You keep 72.7%
Fees
Tax

Rs 5,740 kept · Rs 1,239 selling charges · Rs 921 capital gains tax

Add the Rs 3,400 in cash dividends the bank and telecom paid during the holding period and the true total return is Rs 9,140, or 2.95% on Rs 3,10,000. That is the number to compare with a fixed deposit, not the Rs 7,900 on screen.

Why you pay Rs 921 tax on a portfolio that is barely up

Look at the hydropower line again. It lost Rs 14,696, yet the portfolio still pays Rs 921 in tax. That is because capital gains tax on NEPSE is deducted per sale, at source, by the clearing system. A loss on one scrip does not reduce the tax on another.

How it works now

Tax is charged on every profitable sale. Losses are simply losses. In the example: Rs 920.63 tax.

If loss netting is ever introduced

Gains and losses would be combined first. The net taxable gain here is only about Rs 6,661, so tax would fall to roughly Rs 300.

Loss netting was listed in the government’s 21-point capital market revival plan announced in September 2026, but as of mid-November 2026 it is still a proposal, not a rule. Until it is live, plan each sale on its own. If you must cut a loser and book a winner, remember the winner’s tax will not be reduced by the loss.

Allocation check: how concentrated is your portfolio?

Weight = holding market value ÷ total market value × 100. Do it by stock and by sector. Here is the example portfolio by sector:

Banking
34.3%
Hydropower
28.6%
Life insurance
22.9%
Telecom / others
14.2%

What to look for:

  • One stock above about 25% means a single bad AGM, dividend cut or NRB directive moves your whole result. Here the bank is 34.3% of the portfolio.
  • One sector above about 40% leaves you exposed to sector-wide news, such as a monsoon hit to hydropower or a policy change for banks.
  • Tiny positions under 2–3% barely move your return but still cost Rs 25 DP and a minimum commission to sell. The IPO hydro line here is 3.9%.

These are rules of thumb, not limits. Before adding to a big position, size the trade with the NEPSE risk manager so one stop-loss cannot do serious damage.

Returns that count: dividends, CAGR and XIRR

A 12% gain in five months and a 12% gain in five years are not the same result. Use three return measures, from simplest to most accurate:

MeasureFormulaUse it for
Total return(Net profit + dividends) ÷ CostA quick “am I up?” check
CAGR (per holding)((Cost + total profit) ÷ Cost)365 ÷ days − 1Comparing holdings held for different lengths of time
XIRR (whole portfolio)Spreadsheet XIRR on dated cash flowsPortfolios built with many buys, sells and dividends over time

Example: total return vs annualised return

HoldingDaysTotal returnAnnualised (CAGR)
Commercial bank (with Rs 1,900 dividend)5006.08%4.41%
Hydropower (secondary)420−15.80%−13.88%
Life insurer15012.65%33.63%
Telecom (with Rs 1,500 dividend)2005.69%10.62%
Hydropower (IPO)700138.20%57.23%

Notice two things. The bank looks fine at 6.08% but only earned 4.41% a year after fees and tax, which is below what many fixed deposits paid. And the life insurer’s 33.63% is a short holding stretched to a full year; it only stays that high if the stock keeps rising at the same pace. Treat annualised figures for holdings under a year with care.

How dividends and bonus shares are taxed

  • Cash dividends are paid after 5% tax is withheld at source. Enter the amount that actually reached your bank, not the gross dividend, or you will overstate your return. The TDS calculator explains how withholding works.
  • Bonus shares carry 5% tax on their face value. Under SEBON’s amended directive, listed companies now deduct and pay this tax themselves when they issue bonus shares, so you receive the full bonus quantity without a separate payment. In the past many companies asked shareholders to pay it in cash or paid a small cash dividend to cover it.
  • When you later sell bonus shares, capital gains tax applies on the gain over the Rs 100 cost, like any other lot.

XIRR in Google Sheets or Excel

List every cash flow with its date: purchases as negative numbers, sales and cash dividends as positive numbers, and today’s liquidation value (Net value total) as the last positive number dated today. Then:

=XIRR(B2:B20, A2:A20)

Column A holds dates, column B holds amounts. The result is your money-weighted annual return, the fairest single figure for a portfolio you have added to over several years. If you also invest through mutual funds, the same method works for a SIP in Nepal.

How to see your portfolio and WACC in MeroShare

MeroShare (meroshare.cdsc.com.np, or the MeroShare app) holds the three numbers this calculator needs: quantity, WACC and buy date.

  1. Log in with your DP, username and password.
  2. Open My Portfolio. It lists every holding valued at the last transaction price (LTP) and the total. You can download it as CSV or PDF and paste the scrips and quantities straight into the template.
  3. Open My Purchase Source, choose the Purchase Source tab, select a scrip and click Search. Check or enter the real purchase price for each lot, accept the terms and update to see the WACC MeroShare uses for tax.
  4. In the same menu, the My Holdings tab shows each lot’s holding period, which tells you whether it qualifies for the 3.75% rate.
  5. Enter quantity, WACC and buy date for each scrip in the calculator, and today’s price from your broker’s TMS.

If a menu or WACC looks wrong, our guide to Mero Share problems and fixes covers the common errors. MeroShare must be renewed every year to keep working; see how to renew Mero Share and demat.

Getting WACC, dates and prices right

The calculator is only as good as its inputs. Three of them cause most wrong answers.

1. WACC (your cost per share)

  • Secondary market buys: WACC should include the buy-side commission, SEBON fee and DP charge, not just the price you paid. A Rs 520 purchase ends up at about Rs 521.9 per share once fees are added.
  • IPO shares: cost is the issue price, usually Rs 100. See how to apply for an IPO in MeroShare.
  • Bonus shares: costed at the Rs 100 par value for tax purposes, which pulls your average WACC down.
  • Right shares: costed at the price you paid, usually Rs 100.
  • When you hold several lots of the same scrip, use the weighted average of all lots, not the price of the last one.

Use the WACC check tab in the NEPSE share calculator to confirm what MeroShare should show. If MeroShare shows a lower WACC than your real cost, you will pay tax on profit you never made. Fix it under My Purchase Source before you sell; our guide to Mero Share problems and fixes covers the common WACC errors.

2. Holding days

Count from the purchase or allotment date to the sell date. The lower 3.75% rate needs more than 365 days; exactly 365 days is still short-term. For a portfolio, record the buy date of each lot, because a bonus lot credited last month is short-term even if you have held the original shares for years.

3. Current price

MeroShare values your holdings at the previous closing price during trading hours. For a live check, take the LTP from your broker’s TMS. For month-end reviews, use the closing price on the same day each month so the numbers are comparable.

Build the NEPSE portfolio calculator in Google Sheets or Excel

The downloadable template is already built this way. To make your own, put one holding per row in rows 2 to 51, fill columns A to F and Q yourself, and copy the formulas down. Keep totals on a separate tab or below row 51, never inside the range the formulas sum.

ColHeadingEnter or formula (row 2)
AScripType it
BSectorType it
CQuantityType it
DWACCFrom MeroShare (checked)
ELTPToday’s price
FBuy dateDate credited to demat
GCost=C2*D2
HMarket value=C2*E2
ICommission=IF(H2<=2500,10,H2*IF(H2<=50000,0.0036,IF(H2<=500000,0.0033,IF(H2<=2000000,0.0031,IF(H2<=10000000,0.0027,0.0024)))))
JSEBON fee=H2*0.00015
KDP charge25
LDays held=TODAY()-F2
MTaxable gain=MAX(0,H2-I2-J2-K2-G2)
NCGT=M2*IF(L2>365,0.0375,0.05)
ONet value=H2-I2-J2-K2-N2
PNet profit=O2-G2
QCash dividendsAmount credited to your bank
RTotal return %=(P2+Q2)/G2
SCAGR=((G2+P2+Q2)/G2)^(365/L2)-1
TWeight=H2/SUM($H$2:$H$51)

For totals, use fixed ranges on another tab, for example =SUM(Sheet1!O2:O51) for the real portfolio value. A whole-column total such as SUM(H:H) placed in column H would count itself and halve every weight. For sector weights use =SUMIF(B2:B51,"Hydropower",H2:H51)/SUM(H2:H51). In the template all rates sit on a Rates tab, so a fee or tax change is a one-cell edit.

NEPSE portfolio tracker apps: what to check before you trust them

Free trackers such as ShareHub, Mero Share Khata, Hamro Share and Nepal Share, and paid tools like ShareSansar’s SS Pro, can import your holdings and track several family members’ BOIDs. They save time. Before relying on one, test it against the formula above with one of your own holdings:

Must have

  • Profit shown after selling charges and CGT, not just price difference
  • Correct 5% / 3.75% split by holding period
  • IPO, bonus and right lots costed correctly
  • Export to CSV or Excel

Nice to have

  • Dividend history per scrip
  • Sector allocation chart
  • Multiple portfolios for family accounts
  • Annualised or XIRR returns

A spreadsheet you control remains the best audit copy: an app can change its rules or shut down, but your own records stay with you. Apps also need your MeroShare details to import holdings, so only use well-known ones and keep your MeroShare and demat account renewed and secure.

Common NEPSE portfolio calculation mistakes

  • Treating MeroShare value as cash. It ignores every selling cost. In the example the real figure was Rs 2,160 lower.
  • Assuming losses cancel gains for tax. They do not, at least not yet.
  • Using the old 7.5% / 10% or 5% / 7.5% tax rates. Many older calculators online still do. Sales from 22 September 2026 use 5% and 3.75%.
  • Leaving bonus shares at zero cost. They are costed at Rs 100 par for tax, not zero.
  • Forgetting dividends, or counting them gross. Steady dividend payers look weak on price alone, but use the after-tax amount that reached your bank.
  • Comparing raw percentages across different holding periods. Annualise first.
  • Selling one day too early. On day 365 you still pay 5%. On a Rs 1 lakh gain, waiting one more day saves Rs 1,250.
  • Ignoring the fixed Rs 25 DP charge on small holdings. On a Rs 3,000 position it is almost 1% of the value.

FAQ

What is a NEPSE portfolio calculator?

It is a tool or spreadsheet that totals all your Nepal Stock Exchange holdings and shows cost, market value, value after selling charges and capital gains tax, total return including dividends, and how your money is split across stocks and sectors.

Why is my MeroShare portfolio value higher than what I get when I sell?

MeroShare multiplies your quantity by the last closing price. When you actually sell, broker commission (0.24% to 0.36%), the 0.015% SEBON fee, a Rs 25 DP charge and capital gains tax on any profit are deducted before the money reaches you.

Can I offset a loss in one share against a gain in another?

Not at present. Capital gains tax is deducted on each profitable sale separately. Loss netting was proposed in the government’s September 2026 capital market action plan but had not taken effect as of November 2026.

What cost price should I use for IPO and bonus shares?

Use the issue price you paid for IPO and right shares, usually Rs 100, and Rs 100 par value for bonus shares. Then calculate a weighted average with any shares bought from the secondary market.

How do I include dividends in my portfolio return?

Add the cash dividends actually credited to your bank account to your net profit before dividing by total cost. Bonus shares are not added as cash; they show up as extra quantity at Rs 100 cost.

How many days must I hold shares for the 3.75% tax rate?

More than 365 days. Shares held 365 days or less are taxed at 5% of the gain for resident individuals.

What is the best way to measure my NEPSE portfolio return?

For one holding, use annualised return (CAGR) so different holding periods are comparable. For a portfolio built over time, use XIRR in Google Sheets or Excel on every dated purchase, sale and dividend, with today’s value after fees and tax as the final entry.

Is a portfolio calculator the same as a portfolio tracker?

Not quite. A NEPSE portfolio tracker, such as an app linked to MeroShare, follows your holdings and prices over time. A portfolio calculator works out what those holdings are worth after selling charges and tax and what you actually earned. Many investors use a tracker for daily prices and a calculator like this one before deciding to sell.

सेयर पोर्टफोलियो क्याल्कुलेटर के हो र पूँजीगत लाभ कर कति लाग्छ?

सेयर पोर्टफोलियो क्याल्कुलेटरले तपाईंका सबै सेयरको लागत, हालको मूल्य, र बिक्री गर्दा लाग्ने ब्रोकर कमिसन, सेबोन शुल्क, रु २५ डीपी शुल्क तथा पूँजीगत लाभ कर घटाएपछि हातमा आउने वास्तविक रकम देखाउँछ। व्यक्तिगत लगानीकर्ताले ३६५ दिनसम्म राखेको सेयरको नाफामा ५% र ३६५ दिनभन्दा बढी राखेको सेयरको नाफामा ३.७५% पूँजीगत लाभ कर तिर्नुपर्छ।

How often should I update my portfolio calculation?

Monthly is enough for long-term investors: update prices on the same day each month, add any dividends and bonus lots, and check whether one stock or sector has grown too large. Active traders can check the liquidation value before each sell decision.

Bottom line

Your NEPSE portfolio is worth what you can walk away with, not what MeroShare shows. Calculate each holding after commission, SEBON fee, DP charge and the 5% or 3.75% tax; add dividends; annualise; and check that no single stock or sector dominates. Do this once a month and you will make better decisions about what to hold, what to trim and when to wait past the 365-day line.

New to the market? Start with how to start investing in the Nepal share market, open a demat account, learn the difference between Mero Share and demat, and check ASBA charges by bank before applying for IPOs. For your other income, the income tax calculator covers salary tax. All our tools are collected on the Finance and NEPSE guides page.

Disclaimer: The figures in this article are examples for learning. Fees and tax rates can change; your broker’s contract note and the CDSC settlement are final. This is not investment or tax advice.

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments