Current location - Education and Training Encyclopedia - Graduation thesis - How to write a standardized real estate financial analysis report
How to write a standardized real estate financial analysis report
I. Basic financial data of xxx project:

By the end of xx, the total sales funds of the project have been collected 660 million yuan, the loan ratio of bank mortgage signing has reached 100%, and the maximum cash flow during the construction investment period is 3170,000 yuan. It is estimated that the net sales profit of the project will eventually reach 654.38+25 million yuan, and the return on investment of the project will reach 20.7%, and all the work assessment indicators issued by XX Group and industrial companies have been successfully completed.

Second, financial control management and financial indicators analysis

(1) Under the supervision of industrial companies, several breakthroughs have been made in financial work.

1) supervision and service

At the beginning of XX, the industrial company conducted supervision and assessment on the target cost management of the project company, and the company required the internal financial management supervision level to be continuously improved. Externally, the key supervision of real estate enterprises by tax authorities and banks, the adjustment of tax policies and the macro-control of national financial policies have also increased the difficulty of our work. In these extraordinary three years, the finance department of real estate company has overcome many difficulties such as heavy workload, centralized affairs, long distance and long time caused by serious shortage of financial professionals and payment approval process. With the full support and care of leaders at all levels in the company, the Finance Department has accumulated some experience in functional management, made a big step forward, and resolutely carried out financial audit, supervision and service.

2) the choice of cooperative banks

In the process of negotiating mortgage cooperation conditions with banks, the Finance Department analyzed some experiences and lessons of previous development projects, and carefully studied the safe and timely withdrawal of funds after the project was sold, the joint and several guarantee responsibilities undertaken by developers, and a series of value-added services closely linked to sales. After many specific and exploratory investigations and discussions, the Finance Department held many talks with the leaders of many domestic and foreign banks. According to the specific requirements of the industrial company for the use of funds for the Xiangmihu project, we will find a partner suitable for our project, and finally reach a consensus with the cooperative banks (Bank of China, China Merchants Bank and Shenzhen Development Bank) on a number of most favorable policies for the Xiangmihu project within the scheduled time.

From the initial mortgage receipt to the copy of the pre-sale contract after the signing of the final mortgage contract, the huge cash withdrawal time of our project was at least two months ahead of schedule, and nearly 654.38 billion yuan was withdrawn within one week of the opening sale, which controlled the lending rhythm of the bank to the maximum extent and enabled the company to use sufficient free funds. This operation mode also ensures the safe and timely withdrawal of funds, and also ensures the timely and smooth follow-up contract filing and mortgage work.

Three. Existing problems and solutions:

Xx project has entered the stage of construction and sales. Looking back, we found that there were many shortcomings in the work, some of which were corrected by the superior leaders in time before the incident, some of which were exposed during the exploration process, and even affected the work. These shortcomings will make our work detour and even produce financial risks.

(A) the importance of establishing a marketing account

The marketing account is as important as the engineering account, because the marketing department has no similar budget position, and the consciousness of cost control and reasonable expenditure planning is relatively weak, unlike the financial department and the engineering department, which can realize the dual control of cost expenditure, so the daily expenditure, management and control functions of sales expenses are actually only completed unilaterally by the financial department. In particular, publicity, exhibition, advertising and other expenses are frequently paid in the initial stage of real estate marketing promotion, and the forms are also diverse and complicated. Often, we have signed many cooperation agreements with the same company, and the work intensity and pressure suddenly increase, which tests our seriousness and carefulness. At this time, if you can record the marketing account on time, you won't feel confused and have a clear account in your heart.

(b) Early warning of sales expenses and development expenses.

The project company will adjust the cost target according to the actual situation every year, resulting in cost overruns. Opinions vary. In addition to the fluctuation of market prices and policies, the real reason is that the early warning of cost overruns is not sensitive enough. What are reasonable and necessary expenses, what are unnecessary expenses, what must be paid on time, what needs to be deferred, and so on. These contents require our financial personnel to have an understanding of the image and progress of the market and the project, and have good control ability. Cost control can not be separated from three steps: pre-prediction, in-process control and early warning, and post-event analysis. Financial personnel should not stay in the traditional office to make accounting statements, but should strive for more opportunities and time to go out, promote communication with internal functional departments, information sharing, and contact with external related markets, enhance the basic judgment ability of the rationality of the use of various expenses in advance, and make the planned objectives based on various estimated costs more reliable and true. According to the above-mentioned plan objectives, the daily work is guided, and the dynamic changes of itemized expenses are obviously abnormal. By comparing with the objectives, early warning information is obtained.