XLCS Real Estate Project Full Cost Calculation Template V7 Download

XLCS Core Edition (XLCS Core V7) is officially launched! Utilizing AI tools, extensive VBA code has been used to rewrite the function formulas from previous versions. VBA has advantages in execution efficiency, handling complex logic, automation, and custom functionality, thereby achieving advanced features that were previously impossible with complex function formulas, meeting user needs.

Newly integrated XLCS Beginner Edition (XLCS Lite V1). The XLCS Lite version is suitable for beginners to perform one-click calculations and trial features. For more calculation conditions, please use the XLCS Core Edition. Faced with the dazzling array of features and settings in the Core Edition, many beginners may feel overwhelmed. In that case, try starting with the Lite version first. It only extracts conventional project economic and technical indicator tables and key calculation elements such as land price and three-fee rates to output reports identical to those of the Core Edition.

To meet the needs of WPS users, comprehensive adaptation and optimization have been performed based on WPS characteristics and JS code. The new XLCS Core V7 Full Cost Calculation Template_WPS Edition (also fully compatible with Excel) has been launched. Office users can choose to use the XLCS Core V7 Full Cost Calculation Template_Excel Edition.

V7 Download Link:

V7.6 Updates

① Added 4 more input fields for commercial property types, bringing the total to 10, facilitating data entry for projects with multiple commercial properties.
② Fixed bugs in land price sensitivity analysis.
③ Improved the cell settings for land transfer fees that can be included in output VAT calculations in the VAT calculation table.
④ Fixed price reference bugs in the land appreciation tax table and optimized the calculation logic of the price sensitivity analysis table.
⑤ Fixed the calculation logic for deed tax, adding other land fees as part of the calculation base.
⑥ Fixed the VAT and land appreciation tax calculation logic for free-matching construction product types.

V7.5 Updates

① Fixed errors in the calculation logic for construction agency fees and added multiple custom settings for these fees.
② Improved the early repayment logic for non-standard financing, adding a 6-month no-gap early repayment logic that triggers when no funding gap is detected in the next 6 months.

V7.4 Updates

① Added automatic checks for key names in the name manager when opening and closing files to ensure normal cloud service usage.
② Fixed management fee allocation errors in the VAT calculation table and storage room pre-construction cost allocation errors in the land appreciation tax calculation table.
③ Fixed the exemption logic for non-standard residential and non-residential properties in the land appreciation tax calculation table.
④ Fixed profit rate allocation and phased profit allocation errors in the full cost table.
⑤ Fixed the error of unaccounted storage room sales revenue in the supervision fund table.
⑥ Improved the logic for various projects entering costs in the cross-period allocation table.
⑦ Rewrote the price sensitivity analysis code to directly modify prices in the data source, ensuring accurate analysis results.
⑧ Added a standard construction period template—12-month pre-sale template.

V7.3 Updates

① Rewrote the VBA code for the monthly supervision fund plan table, fixing previous logic errors to ensure normal data entry into cash flow. Users can choose whether to include it in the cash flow table with one click in Table 02.
② For users experiencing network connection errors when opening files, which may cause errors in custom name references in the name manager, a “One-Click Fix for Cloud Link Exceptions” button has been added at the top of the basic indicator entry and data validation table.
③ Fixed land fee reference errors in the land appreciation tax calculation table and allocation errors in the summary table, among other minor bugs.
④ Improved the calculation of construction agency fees for non-saleable portions in the agency agreement.
⑤ Enhanced the logic for non-standard financing plans, adding forced zeroing of principal and interest for financing during liquidation months.

V7.2 Updates

① To meet the needs of WPS users, comprehensive adaptation and optimization have been performed based on WPS characteristics and JS code. The new XLCS Core V7.2 Full Cost Calculation Template_WPS Edition (also fully compatible with Excel) has been launched. Office users can choose to use the XLCS Core V7.2 Full Cost Calculation Template_Excel Edition.
② Fixed product reading errors in the summary table and land fee reading errors in the full cost table.

V7.1 Updates

① Rewrote the VBA code for the monthly project payment plan, completely eliminating the issue of imperfect monthly project allocation by node time/ratio that was previously unresolved by complex function formulas. Settings include automatic refreshes when opening the file and every 3 minutes, with manual update buttons available in the pre-construction payment table.
② Optimized the detection of the official website URL when opening files, implementing a three-level detection system: domestic core nodes, domestic edge nodes, and international nodes. Only when core nodes are unavailable does it proceed to the next level, ensuring server accessibility and significantly speeding up file opening.
③ Added a non-standard financing module. Non-standard financing refers to non-standardized financing beyond front-end financing and development loans, used to cover project funding gaps. The template calculates monthly cash flow gaps and triggers non-standard financing based on user-defined annual interest rates and thresholds (when the cumulative monthly net cash flow gap exceeds this threshold). Each financing term is 12 months, with early repayment when cash flow turns positive, following the “first in, first out” principle. VBA code automatically calculates and arranges the optimal timing and amounts for non-standard financing, generating monthly interest. Users can choose whether to include it in the financing plan and cash flow table, with one-click trial calculations and adjustments to interest rates and thresholds.
④ Changed the front-end financing sensitivity analysis table to a financing method sensitivity analysis table. New VBA code enables sensitivity analysis for custom changes in financing amounts, interest rates, and terms under both development loans and front-end financing, providing investment analysis and forecasts.
① Added automatic inclusion of non-standard financing details (disbursement dates, repayment dates, amounts, etc.) in the financing plan table (L35:P44) based on calculation results.

V7.0 Updates

① Automatically connects to the fastest cloud server. If the default cloud database URL fails, check the network connection. When opening the file, it automatically detects and connects to the fastest server from the official website, updating cloud data. The network status and current server URL can be viewed above Table 2.
② Optimized the VBA code for worksheet checks and repairs when opening files, improving speed and robustness.
③ Optimized the VBA code for the price sensitivity analysis table, adding custom price functionality for quick sensitivity analysis directly on this page.
④ Added PPT sensitivity analysis table output for easy inclusion in presentation materials.
⑤ Replaced the GET.WORKBOOK macro function with VBA code for automatic table of contents generation, offering more flexibility, stability, and automation. A button on the homepage allows one-click regeneration of the table of contents.
⑥ Added quick sales template settings, including three presets: average sales over the default sales period, custom monthly residential unit sales, and custom sales cycle months. Users can switch templates with one click in Table 2, and VBA code automatically regenerates monthly sales rates based on selections, with options to apply different templates to individual products.
⑦ Fixed the issue of above-ground non-GFA areas not being included in current public allocation cost sharing.
⑧ Fixed formula issues in the pre-construction payment table for regular monthly pre-construction fees.
⑨ Newly integrated XLCS Beginner Edition (XLCS Lite V1). The XLCS Lite version is suitable for beginners to perform one-click calculations and trial features. For more calculation conditions, please use the XLCS Core Edition. Faced with the dazzling array of features and settings in the Core Edition, many beginners may feel overwhelmed. In that case, try starting with the Lite version first. It only extracts conventional project economic and technical indicator tables and key calculation elements such as land price and three-fee rates to output reports identical to those of the Core Edition.
⑩ Optimized the cloud database search logic after user city input. Previously, if a user entered a county/district name not in the database, it would directly show “Not Found.” Now, it automatically matches the superior city and outputs corresponding data, improving cloud data usability.

V7 Template File Update Time:

“XLCS Real Estate Project Full Cost Calculation Template” V7 Package Contents:

XLCS Core V7 Full Cost Calculation Template_Excel Edition.xlsm (For Excel users)
XLCS Core V7 Full Cost Calculation Template_WPS Edition.xlsm (For WPS users)
XLCS PRO V1.0 Full Cost Calculation Template_Multi-Parcel Edition.xlsm (For multi-parcel projects)
Single-Page Simple Calculation Template simple-template.xlsm
XLCS Real Estate Project Full Cost Calculation Template User Manual.docx
XLCS Core WPS Edition Quick Start Guide.docx
deepseek Analysis of XLCS Full Cost Calculation Template.docx
Version Update Notes.txt
City Database User Manual.txt
Edition Selection Guide.txt
XLCS Real Estate Project Full Cost Calculation Template Quick Start.txt
wps.vba.rar (Essential free VBA plugin for WPS personal edition)
Beginner Edition (XLCS Lite V1 Full Cost Calculation Beginner Edition.xlsm, XLCS Lite Beginner Edition Quick Start Guide.docx)