MIRR in WPS on Windows: Introduction

MIRR in WPS Spreadsheet on Windows is a financial function for calculating the modified internal rate of return for periodic cash flows; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

MIRR is a built-in financial function in WPS Spreadsheet on Windows for calculating the modified internal rate of return for a series of periodic cash flows when finance and reinvestment rates differ.

Core capabilities include:

Type MIRR( to view syntax guidance and start formula entry quickly.
Enter cash flow values, the finance rate, and the reinvestment rate in the required order.
Use cross-sheet references and combine MIRR with other formulas.
Recalculate results automatically when referenced data changes.

Common use cases include investment return analysis, project cash flow review, and financial modeling.

It helps reduce manual trial calculations and keeps return analysis inside the same worksheet.

Distinct: the function fits directly into the regular spreadsheet formula workflow for ongoing review and comparison.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need permission to open WPS Spreadsheet files and edit cells and formulas

Download & Installation

Before using the MIRR function, install WPS Office for Windows and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office → open WPS Spreadsheet → select a cell and enter `=MIRR(` in the formula bar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, entering `MIRR(` shows syntax guidance and supports parameter entry, cross-sheet references, nested calculations, and automatic result updates.	Excel provides the MIRR function with the syntax `MIRR(values, finance_rate, reinvest_rate)` to return the modified internal rate of return for periodic cash flows.	Google Sheets official pages describe spreadsheet formulas, calculations, analysis, and collaboration, but the cited page does not provide a dedicated MIRR reference.	Notion formulas support properties, built-ins, and functions for database calculations, but they are not presented as traditional spreadsheet financial functions.	Acrobat supports calculated form fields in PDF forms, which is useful for form totals and field relationships rather than spreadsheet financial functions.
WPS Advantages	Advantage: MIRR can be entered directly in spreadsheet cells for financial analysis; Distinct: it fits naturally with cross-sheet references and existing worksheet models.	Compared with WPS: Excel also offers a dedicated MIRR function and provides a detailed syntax reference on its official support page.	Compared with WPS: Google emphasizes collaborative spreadsheet analysis and formulas, but the cited official page does not show a dedicated MIRR function reference.	Compared with WPS: Notion is more suitable for database property formulas than cell-based financial return analysis.	Compared with WPS: Acrobat focuses on PDF form calculations instead of worksheet-based MIRR analysis for investment scenarios.
Official Source	—	MIRR function	Google Sheets training and help	Formula syntax and functions	Configure form field calculations in Acrobat

Overall Conclusion

WPS keeps MIRR work inside a familiar spreadsheet workflow, which is practical for entering, referencing, and reviewing cash flow data in one workbook. Microsoft Excel also provides an official MIRR reference, while the cited Google, Notion, and Adobe pages focus more on general formulas, database formulas, or PDF form calculations.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Investment return analysis	Finance staff	Finance cost and reinvestment rate need to be evaluated separately	Use MIRR with cash flows and both rates to return a result directly
2	Business plan comparison	Business analysts	Different repayment schedules are hard to compare quickly	Build MIRR formulas in separate columns for side-by-side comparison
3	Training and practice	Students and trainees	Function parameters need to be understood clearly	Practice formula entry with syntax guidance and sample data
4	Dynamic report review	Worksheet maintainers	Results need to update after data changes	Use automatic recalculation to keep results current

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
MIRR formula entry and calculation	✅	✅
Basic spreadsheet editing	✅	✅
More advanced office and PDF features	Available within the free offering	More advanced features are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday formula learning and basic financial calculation	Free	The MIRR function itself is available without membership
More cloud storage or broader advanced office features	WPS Premium	Suitable when you also need more document storage and extended office capabilities

WPS membership center: Subscribe now