EXPLORING THE CORRELATION BETWEEN WAGES AND HOUSING PRICES - APPLYING EXCEL SOLVER TO CONSTRUCT A HOUSING LOAN DYNAMIC ANALYSIS CALCULATOR
DOI:
https://doi.org/10.29121/ijetmr.v12.i8.2025.1656Keywords:
Taiwan, Salary, Housing Prices, Housing Loans, Interest Rates, Excel SolverAbstract
Starting a family has long been a key life goal for many, yet in recent years, the number of people remaining unmarried and childless has steadily increased. This shift is influenced not only by evolving social structures and personal values, but also by growing economic pressures, persistent inflation, and broader environmental uncertainties. Although Taiwan’s minimum wage has risen for eight consecutive years, these gains have been largely eroded by rising living costs, diminishing real purchasing power. Consequently, for many young people, buying a home has become an increasingly distant dream.
This study investigates the rationality of housing prices in Taiwan by comparing global housing trends, evaluating current domestic housing prices, and analyzing the salary levels of Taiwanese workers. It also examines the affordability of home loans and the correlation between wage growth and property prices to assess the financial burden on prospective homeowners. To provide more practical insights, the study integrates Excel Solver to create a dynamic mortgage analysis calculator that links income levels with housing costs.
Through this comprehensive approach, the research highlights the critical challenges facing today’s young adults in achieving homeownership. Finally, it offers actionable strategies and policy suggestions aimed at improving housing affordability and helping the younger generation move closer to realizing their dream of owning a home.
Downloads
References
Directorate-General of Budget, Accounting, and Statistics. (2023, November 30). Statistics on the Median and Distribution of Annual Salaries of Employees in Industry and Services in 2022.
Liu, G.-T. (2023, December 8). Hou You-yi's Policy on Youth Homeownership: First-Time Buyers Under 40 Can Borrow Up to 15 Million with No Down Payment. Central News Agency. 2024 Presidential and Legislative Election – Housing Policy.
Ministry of Labor Global Information Network. (2023). The Process of Establishing and Adjusting the Minimum Wage.
Ministry of the Interior Real Estate Information Platform. (2019). Price Indicators. [Unavailable – Request Rejected]
Ministry of the Interior, Republic of China. (2022). Second Quarter of 2022, National Housing Loan Burden Rate Increased by 1.27%.
Numbeo Global Database. (2009). Apartment Prices: Price Per Square Meter to Buy an Apartment in the City Center.
Weng, B. Y. (2012). An Empirical Study on the Fluctuation of Housing Prices and Income Inequality in Taiwan (Master’s thesis). Graduate Institute of Economics, National Taiwan University.
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Yu-Fen Chen
This work is licensed under a Creative Commons Attribution 4.0 International License.
License and Copyright Agreement
In submitting the manuscript to the journal, the authors certify that:
- They are authorized by their co-authors to enter into these arrangements.
- The work described has not been formally published before, except in the form of an abstract or as part of a published lecture, review, thesis, or overlay journal.
- That it is not under consideration for publication elsewhere.
- That its release has been approved by all the author(s) and by the responsible authorities – tacitly or explicitly – of the institutes where the work has been carried out.
- They secure the right to reproduce any material that has already been published or copyrighted elsewhere.
- They agree to the following license and copyright agreement.
Copyright
Authors who publish with International Journal of Engineering Technologies and Management Research agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors can enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or edit it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) before and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
For More info, please visit CopyRight Section
