JP6612818B2 - Real estate investment simulation system, real estate investment simulation program, and real estate investment simulation method - Google Patents

Description

  The present invention relates to a real estate investment simulation system, a real estate investment simulation program, and a real estate investment simulation method for dynamically changing and displaying a graph image simulating a real estate investment effect as time passes.

  In recent years, an increasing number of companies strategically manage and operate real estate (CRE (Corporate Real Estate)) used (owned / rented) by companies. In the CRE strategy, it is common to perform a financial simulation in the medium to long term span of real estate investment. Specifically, in real estate investment brokerage services, for example, forecast financial data of companies in the future fiscal year after investment, and calculate medium- to long-term financial statements (balance sheet (B / S), profit / loss calculation). (P / L), cash flow statement (C / F)), and real estate investment is often brokered based on the results of the financial simulation.

  However, the management team, which is the main entity in the CRE strategy of companies (especially SMEs), often lacks knowledge of finance, etc., and was predicted as a result of financial simulation in the medium- to long-term span of real estate investment. Even if a financial statement composed of financial data is displayed, it is difficult to interpret the account items of each financial statement and the numerical values in each account item. There is a problem that it is difficult to understand real estate investment such as whether or not it is better to purchase a property.

  For such a problem, a system for generating a chart corresponding to the financial statements has been proposed. For example, Patent Document 1 discloses a track chart corresponding to a balance sheet and an income statement for a plurality of business years. In addition, a comparison chart of the STRACK charts, in which the STRATC charts of the created business years are arranged in the order of the relevant business year, makes it easier to understand the financial condition of the company. An accounting system that can do this is disclosed.

JP 2012-108840 A

  Here, when deciding whether or not to invest in real estate, how the financial position of a company will change over time in the medium- to long-term span due to real estate investment. There is a need to understand how each component indicating the state moves and how it changes.

  In the case described above, the accounting system described in Patent Document 1 uses the financial data (for example, current assets, fixed assets, current liabilities, fixed liabilities, and capital) of the displayed Strat chart for each business year. It is difficult to understand how the financial status of a company's capital, etc. will change over time due to real estate investment because the continuity is not displayed. There was a problem.

  In view of the above problems, the object of the present invention is to provide a real estate simulation system that dynamically changes and displays a graph image representing a financial state of a company for each future fiscal year in accordance with the passage of time in an intermediary service for real estate investment, It is to provide a real estate simulation program and a real estate simulation method.

  The real estate simulation system according to the present invention is a real estate investment simulation system that predicts and displays future financial data of a company with respect to real estate investment effects, and represents the property information representing the property to be purchased and the financial status of each company. A storage unit that stores financial information, a simulation unit that predicts future financial data when a property is purchased based on the property information and financial information, and a future fiscal year based on the predicted financial data A generation unit that generates a graph image representing the financial state of the company, and a fiscal year to be displayed is dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is changed over time. And a display unit that dynamically changes and displays according to the transition of the fiscal year.

  Furthermore, in the real estate simulation system according to the present invention, the display unit may dynamically change and display the dynamically changed fiscal year in accordance with the transition of the fiscal year over time.

  Further, in the real estate simulation system according to the present invention, the property information includes the rent income of the property to be purchased, the interest rate of the borrowing amount and the depreciation cost, and the financial information includes assets, liabilities and net assets for each company, Is based on the property information and financial information to calculate the account data that constitutes at least one of the balance sheet, income statement or cash flow statement for each fiscal year when the property is purchased. The financial data is predicted, and the generation unit generates a graph image representing at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year based on the calculated account item data. May be.

  Further, in the real estate simulation system according to the present invention, the simulation unit predicts financial data by calculating a current ratio for each fiscal year based on the account item data constituting the balance sheet, and the generation unit includes: According to the current ratio for each fiscal year, change at least one of the size of the graph image representing the balance sheet generated for each fiscal year, the coloring, or the format of the code letters assigned to the graph image, The display unit may dynamically change and display the graph image representing the changed balance sheet corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time.

  Further, in the real estate simulation system according to the present invention, the financial information includes revenues and expenses in a predetermined accounting period for each company, and the simulation unit is provided for each fiscal year based on the account item data constituting the income statement. By calculating EBITDA, the financial data is predicted, and the generation unit determines the size of the graph image representing the income statement, the coloring, or the format of the code character given to the graph image according to the EBITDA for each fiscal year. At least one of them is changed, and the display unit dynamically displays the graph image representing the changed income statement corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time. May be.

  Further, in the real estate simulation system according to the present invention, the simulation unit predicts financial data by calculating free cash flow for each fiscal year based on the account item data constituting the cash flow calculation statement, and generates the generation unit. In accordance with the free cash flow for each accounting period, change at least one of the size of the graph image representing the cash flow statement, the coloring, or the format of the code character added to the graph image, and the display unit The graph image representing the changed cash flow statement corresponding to the changed fiscal year may be dynamically changed and displayed in accordance with the transition of the fiscal year over time.

  Furthermore, the real estate simulation system according to the present invention further includes an operation input unit that receives designation input of one or more fiscal years or periods, and the simulation unit is accepted by the operation input unit based on the property information and financial information. Financial data for a fiscal year or period may be predicted.

  Furthermore, in the real estate simulation system according to the present invention, the display unit may display the graph image with a hierarchy for each fiscal year.

  The real estate simulation program according to the present invention is a real estate investment simulation program for simulating the effect of real estate investment on a company's finance, and the computer stores property information representing the property to be purchased and financial information representing the financial status of each company. Storage function, simulation function to predict future financial data when a property is purchased based on property information and financial information, and financial status for each future fiscal year based on the predicted financial data The generation function that generates a graph image that represents and the fiscal year to be displayed are dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is displayed for the fiscal year over time. And a display function for dynamically changing and displaying in accordance with the transition.

  A real estate simulation method according to the present invention is a real estate investment simulation method for simulating the influence of real estate investment on a company's finance, and stores property information representing a property to be purchased and financial information representing a financial state of each company. Based on the property information and financial information, forecast future financial data when the property is purchased, and generate and display a graph image representing the financial status for each future fiscal year based on the predicted financial data The target fiscal year is dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is dynamically changed and displayed in accordance with the transition of the fiscal year over time.

  It should be noted that any combination of the above-described constituent elements and the expression of the present invention converted between a method, an apparatus, a system, a computer program, a data structure, a recording medium, and the like are also effective as an aspect of the present invention.

  According to the real estate investment simulation system, real estate investment simulation program, and real estate investment simulation method of the present invention, a graph image representing the financial state of a company for each future fiscal year is generated based on the predicted financial data, and is displayed. The fiscal year is dynamically changed every predetermined time, and the generated graph image corresponding to the dynamically changed fiscal year is matched with the transition of the fiscal year of the display target changed over time. Can be displayed dynamically (animation display), you can understand the continuity of each financial data, you can understand how the financial status of the company will change over time .

1 is a system diagram showing a configuration of a real estate investment simulation system according to an embodiment of the present invention. It is a block diagram which shows the function structure of the real estate investment simulation system which concerns on embodiment of this invention. It is a table | surface which shows an example of the property information of the real estate investment simulation system which concerns on embodiment of this invention. It is a table | surface which shows the simulation of the investment effect of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the example of the balance sheet of the real estate investment simulation result of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the example of the profit and loss statement of the real estate investment simulation result of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the example of the cash flow calculation document of the real estate investment simulation result of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the graph image of the real estate investment simulation result of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the example of the display screen of the real estate investment simulation system which concerns on embodiment of this invention. It is a figure which shows the example of the display of the real estate investment simulation system which concerns on embodiment of this invention, and an input screen. It is a flowchart figure which shows the operation example of the real estate investment simulation system which concerns on embodiment of this invention.

(System configuration)
FIG. 1 is a system diagram showing a system configuration of a real estate investment simulation system in one embodiment of the present invention.

  As shown in FIG. 1, the real estate investment simulation system 500 includes a server 100 and a terminal 200 (terminal 200A, terminal 200B). Server 100 is connected to terminal 200A and terminal 200B via network 400. In FIG. 1, for simplicity of explanation, one server 100 and two terminals 200, 200A and 200B, are shown, but it goes without saying that more servers may exist. In addition, when there is no particular need to distinguish, terminal 200A and terminal 200B are collectively referred to as terminal 200.

  The server 100 may be any electronic device as long as it is a computer device having an information processing capability for financial data calculation (prediction) processing, drawing processing of still image moving images such as graph images, for example, a personal computer. , Servers, mainframes, and other electronic devices.

  Specifically, the server 100 may be a processing device whose entire device is controlled by a processor. The processor is configured by connecting a storage device (storage unit 130) such as a RAM and a hard disk drive, an input / output interface (I / O unit 140), a communication interface (communication unit 110), and the like via a bus. Yes. The storage device has a function of storing various processing data and programs necessary for various processes in the control unit 120. Input / output devices such as a display, a keyboard, a mouse, and an external storage medium are connected to the input / output interface. A network 400 is connected to the communication interface.

  In addition, the server 100 does not have software, hardware, OS, etc. dedicated to the real estate investment simulation system 500, but is provided with cloud server SaaS (Software as a Service), Paas (Platform as a Service), IaaS (Infrastructure as a Service). ) May be used as appropriate.

  The terminal 200 is a terminal used in a real estate investment brokerage service or the like by a real estate investment simulation system 500 such as a customer or an employee, and a specific device is not limited to a desktop personal computer or a smartphone as illustrated, for example, , A portable terminal, a tablet terminal, a notebook computer, and other electronic devices.

  The network 400 may be wireless or wired as long as it is an IP network, and is a network including a LAN and a WAN. For example, in the case of wireless communication, the terminal 200 may access a wireless LAN access point (not shown) and communicate with the server 100 via the network 400.

(Functional configuration)
FIG. 2 is a diagram illustrating a functional configuration example of a real estate investment simulation system 500 according to an embodiment of the present invention. As shown in FIG. 2, the real estate investment simulation system may include the server 100 and the terminal 200, but is not limited to this. For example, the information processing capability of the terminal 200 does not include the server 100. When there is no problem in the storage capacity and the like, and there is a problem of communication congestion, the terminal 200 includes each necessary function unit of the server 100 and is configured to be realized by only one or more terminals 200. (In other words, the server 100 may not be provided, and all processes may be performed by a distributed processing technique using a plurality of terminals 200). In order to describe the functional configuration of the real estate investment simulation system 500 according to an embodiment of the present invention, an explanation will be given using an example in which the server 100 and the terminal 200 are configured.

  As shown in FIG. 2, a real estate investment simulation system 500 is a real estate investment simulation system that predicts and displays future financial data of a company for real estate investment effects. Based on the predicted financial data, a storage unit 130 that stores financial information representing the financial status of the product, a simulation unit 121 that predicts future financial data when a property is purchased based on the property information and financial information, and A generation unit 122 that generates a graph image representing the financial state of the company for each future fiscal year, and a fiscal year that is to be displayed is dynamically changed every predetermined time, and is generated corresponding to the changed fiscal year. A display unit 240 that dynamically changes and displays the graph image in accordance with the transition of the fiscal year over time. By adopting such a configuration, it is possible to display a state in which the financial state of a company when a property is purchased continuously changes, and thus it is possible to improve the ease of understanding the effect of real estate investment.

  As illustrated in FIG. 2, the server 100 includes a control unit 120, a communication unit 110, a storage unit 130, and an I / O unit 140.

  The communication unit 110 has a function of executing communication with the terminal 200 via the network 400 under the control of the control unit 120. The communication unit 110 includes a reception unit 111 that receives various types of information from an external device such as the terminal 200 via the network 400, and a transmission unit 112 that transmits various types of information to the external device such as the terminal 200 via the network 400. Composed. The communication may be either wired or wireless, and any communication protocol may be used as long as mutual communication can be performed. Specifically, for example, the communication unit 110 transmits graph image information to be output to the display output unit 241 of the terminal 200 or receives display input information input from the operation input unit 242 of the terminal 200. May be.

  Here, the “graph image information” is information for displaying a graph image representing the financial state of the company for each fiscal year on the display output unit 241 of the terminal 200. Specifically, the graph image information is generated based on the account item data calculated by the generation unit 122 of the server 100, and is at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year. It may be a graph image (a still image or a moving image) representing one. The generated graph image information is transmitted from the server 100 to the terminal 200 via the communication unit 110 and the network 400. Here, the “graph image” may be any graph as long as it represents each financial statement, such as a bar graph, pie graph, line graph, band graph, hiss and gram, radar chart, and scatter chart. For example, a stacked vertical bar graph may be used for the balance sheet, a collective bar graph for the income statement, and a waterfall graph for the cash flow statement.

  The control unit 120 is a processor that includes a simulation unit 121 and a generation unit 122 and has a function of controlling each functional unit of the server 100. As an example, the control unit 120 performs arithmetic processing based on processing requests from the function units of the terminal 200 or the server 100, and refers to various information such as property information and financial information stored in the storage unit 130. Performs computation, update, or deletion processing.

  The simulation unit 121 has a function of analyzing a company's financial state in a predetermined fiscal year and accounting period based on various information stored in the storage unit 130 and predicting a simulation or the like. Specifically, the simulation unit 121 predicts future financial data when a property is purchased based on the property information and financial information. The simulation unit 121 transmits the predicted financial data to the generation unit 122.

  Here, the “property information” is information indicating the target property to be purchased. Specifically, the property information includes items related to the sale of each property in the real estate investment. For example, as shown in FIG. 3, the sale price, the own funds (used for sale), the (for sale) ) It may be configured to include the borrowing amount, interest rate, annual income, depreciation, etc.

  Here, “financial information” is information representing the financial state of each company. Specifically, the financial information may be information including account items constituting financial statements for each fiscal year and accounting period. Here, “financial data” is data indicating the financial information predicted by the simulation unit 121.

  More specifically, the financial information is, for example, when the financial statement is “balance sheet (hereinafter abbreviated as“ B / S ”as necessary)”, as shown in FIG. Assets and liabilities at a certain point in the company (fiscal year), such as current assets, fixed assets, current liabilities as liabilities, fixed liabilities, shareholders' equity as net assets And may include net assets. FIG. 5 is composed of future financial data (account item data) predicted (calculated) based on the property information and financial information as a result of the property investment simulation of the property investment simulation system 500 when the property is purchased. It is a figure which shows the example of the balance sheet made.

  In addition, when the financial statements are “Profit and Loss Statement (hereinafter abbreviated as“ P / L ”as necessary)”, the financial information is as the account items that make up the Profit and Loss Statement as shown in FIG. , Net sales, cost of sales, selling, general and administrative expenses, non-operating income, non-operating expenses, (1) gross profit, (2) operating profit, (3) ordinary profit, (4) income before income taxes, (5) You may comprise the profit and expense in the fixed accounting period for every company, such as five profits of the net profit. FIG. 6 is composed of future financial data (account item data) that is predicted (calculated) based on the property information and financial information as a result of the property investment simulation of the property investment simulation system 500 and that is calculated when the property is purchased. It is a figure which shows the example of the profit-and-loss statement made.

  In addition, when the financial statement is a “cash flow statement (hereinafter abbreviated as“ C / F ”as necessary)”, the financial information includes the accounts constituting the cash flow statement as shown in FIG. Courses include: (1) Cash flows from operating activities (cash-in such as net income after tax, cashouts such as transfer to cash flows from investing activities) (hereinafter abbreviated as “Operating CF” as necessary) (2) Cash flows from investing activities (cash-in from proceeds from sales of tangible fixed assets, cash-out from expenditures from purchases of tangible fixed assets) (hereinafter abbreviated as “investment CF” as necessary), (3) Cash flow from financing activities (cash-in such as proceeds from borrowing of long-term borrowings, cash-out such as expenditures due to repayment of long-term borrowings) (hereinafter required) Correspondingly abbreviated as "financial CF") may comprise configure. FIG. 7 is composed of future financial data (account item data) predicted (calculated) based on the property information and financial information as a result of the property investment simulation of the property investment simulation system 500, when the property is purchased. It is a figure which shows the example of the cash flow statement made.

  The financial information may include a current ratio, EBITDA, and free cash flow calculated based on the account item data constituting the financial statements for each fiscal year.

  The simulation unit 121 configures at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year when a property is purchased based on the property information and financial information stored in the storage unit 130 By calculating the account item data to be used, the future financial data when the property is purchased may be predicted. The simulation unit 121 transmits the calculated account item data to the generation unit 122.

  An example of the simulation of the simulation unit 121 will be described with reference to FIGS. FIG. 3 is a table showing an example of a data configuration example of property information stored in the real estate investment simulation system 500 according to an embodiment of the present invention. FIG. 4 is a table showing an example of the real estate investment simulation of the simulation unit 121 of the real estate investment simulation system 500 according to the embodiment of the present invention. In this example, the simulation is performed on the assumption that the property is sold at 190 million yen on the last day of the tenth year in the property example shown in FIG.

  Specifically, for example, as shown in FIG. 4, the simulation unit 121 is based on the property information, based on the property information, the company's income, cost, cash flow for each property purchase year (the property purchase first year to the tenth year), Calculate financial data such as expected returns, assets and liabilities.

  Specifically, for example, as shown in FIG. 4, the simulation unit 121 sets No. 1 “Revenue” (specifically, No. 1-1 “Rent” in No. 3-1 “Profit”). Revenue ”) and No.2“ Cost ”(specifically, No.2-8“ Cost Subtotal ”is calculated as the subtotal of items No.2-1 to No.7, and the calculated No.2-8 The difference between "Subtotal" and No.2-10 "Tax (30%)" (No.2-11 "Cost Total") is No.3-1 "Profit" and the profit By calculating No. 3-9 “Cash Flow Status” from the total of each item (No. 3-1 to 8) that calculates cash flow, including financial data, forecast financial data for each fiscal year, The effect of fixed investment may be simulated.

  Further, for example, as shown in FIG. 4, the simulation unit 121 subtracts No. 5-2 “repayment amount” from No. 5-1 “borrowing amount” of the previous year, for example, Calculate No. 5-1 “Borrowing Amount” or subtract No. 2-2 “Depreciation Expenses” from No. 5-4 “Building” of the previous fiscal year (as an asset) For example, by calculating the asset amount of “building”, the financial data for each fiscal year may be predicted to simulate the effect of real investment.

  Specifically, for example, as shown in FIG. 5, the simulation unit 121 calculates a balance sheet such as an asset, a liability, and a net asset of a company that forms a balance sheet for each fiscal year based on property information and financial information. You may simulate by calculating each account item which comprises. FIG. 5 shows the property shown in FIG. 3 in the real estate investment simulation system 500 in one embodiment according to the present invention in (1) property purchase period, (2) property purchase fourth year, and (3) property purchase eighth year. It is a schematic diagram showing an example of the result of having predicted the state (financial state) of the asset, the liability, and the net asset by purchase.

Further, the simulation unit 121 may predict future financial data by calculating the current ratio for each fiscal year based on the account item data constituting the balance sheet. The current ratio is calculated by the following formula.
Current ratio = (current assets / current liabilities) x 100
Quick ratio = (cash, deposits, accounts receivable) / (borrows scheduled to be repaid within one year) x 100

Further, the simulation unit 121 may predict future financial data by calculating EBITDA for each fiscal year based on the account item data constituting the income statement. “EBITDA (Earnings Before Interest, Tax, Depreciation and Amortization)” refers to profits before interest payments, taxes and amortization. EBITDA is calculated by the following equation.
EBITDA = Profit before tax + Interest expense + Depreciation

In addition, the simulation unit 121 calculates free cash flow for each fiscal year (hereinafter abbreviated as “FCF (Free Cash Flow)” as necessary) based on the account item data constituting the cash flow calculation sheet. In the future, future financial data may be predicted. FCF is calculated by the following formula.
FCF = Sales CF + Investment CF

  As an example, the simulation unit 121 specifically simulates the investment effect of property purchases in the fiscal year or accounting period received by the operation input unit 242 of the terminal 200 based on property information and financial information, for example. Also good. Specifically, the simulation unit 121, for example, on the basis of display input information including designation input of one or more fiscal years or accounting periods transmitted from the terminal 200, the property in the designated fiscal year or accounting period You may simulate the investment effect of the purchase. With such a configuration, only a simulation of real estate investment effects such as property purchases in a necessary fiscal year or period can be performed and a graph image can be displayed. The effect of real estate investment can be confirmed efficiently.

  The generation unit 122 displays display information and display for display on a display terminal (not shown) connected via the terminal 200 or the I / O unit 140 of the server 100 based on various information stored in the storage unit 130. It has a function of generating input information and the like. The generation unit 122 generates a graph image representing the financial state of the company for each future fiscal year based on the predicted financial data.

  Specifically, the generation unit 122 represents at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year based on the account item data calculated by the simulation unit 121, for example. A graph image may be generated.

  More specifically, the generation unit 122 is given to the size, coloring, or graph image of the generated balance image for each fiscal year, for example, according to the current ratio for each fiscal year. At least one of the code character formats may be changed. With such a configuration, the financial status indicated by the current ratio can be graphically displayed, and the mid- to long-term financial status after real estate investment can be grasped more intuitively as the effect of real estate investment. Quick ratio is one of the indicators of safety analysis. It can grasp the short-term payment ability of a company and know the actual increase / decrease in cash and deposits by grasping the numerical value of the ratio. Can do. For this reason, for example, it can be determined that the larger the graph image is, the higher the short-term payment ability is due to the real estate investment effect.

  Here, “the size of the graph image, the coloring, or the format of the code character added to the graph image” refers to the size (width and height) of the graph image, the graph image, as shown in FIGS. Fill color and background color setting (RGB designation, shading, transparency, etc.), code characters added to the graph image (for example, “Flowing assets (100)” “ Debt (200) "font size, bold, typeface, etc.

  As an example here, the current ratio was used, but any index may be used as long as it is a financial index related to the balance sheet and an index that shows a certain effect of real estate investment. Capital adequacy ratio may be used. As a general point of view, the higher the ratio (the higher the ratio of equity capital to total assets), the more the capital adequacy ratio is. Therefore, management can be considered stable.

  In addition, the generation unit 122 more specifically, for example, according to EBITDA for each fiscal year, at least one of the size of the graph image representing the income statement, the coloring, and the format of the code character added to the graph image You may change one of them. With such a configuration, the financial status indicated by EBITDA can be displayed graphically, and the mid- and long-term financial status after real estate investment can be grasped more intuitively as the effect of real estate investment. EBITDA is an index that measures the profitability of a company, and is an index that can know a company's ability to acquire cash. For this reason, for example, it can be determined that the stronger the color of the graph image, the higher the cash acquisition ability of the company due to the real estate investment effect.

  The generation unit 122 more specifically, for example, according to the FCF for each accounting period, at least the size of the graph image representing the cash flow calculation sheet, the coloring, or the format of the code character added to the graph image Any one of them may be changed. With such a configuration, the financial status indicated by the FCF can be graphically displayed, and the mid- to long-term financial status after real estate investment can be grasped more intuitively as the effect of real estate investment. The FCF indicates the funds that the company can use freely from the business activities (the cash flows that the company can distribute freely to the provider of the funds that the company generates by the business activities) It is an index that shows the quality of real estate investment. For this reason, for example, for example, as the font size of the code character increases as the format change of the code character given to the graph image, the certain value of the company increases as a result of real estate investment. Can be determined.

  Here, with reference to FIG. 5 and FIG. 8, an example of a graph image representing the balance sheet for each fiscal year generated by the generation unit 122 and the size of the graph image as a financial index (current ratio) in the fiscal year An example changed according to the above will be described. FIG. 8 shows the state of assets, liabilities, and net assets obtained by the property purchase shown in FIG. 3 in the property purchase period, the property purchase fourth year, and the property purchase eighth year. As a result of the simulation, the account item data constituting the balance sheet shown in FIG. 5 is calculated, and the balance sheet graph image for each fiscal year generated based on the calculated account item data is combined with It is a schematic diagram showing an example which changed the magnitude | size of the graph image by the financial index for every calculated fiscal year.

  FIGS. 8A, 8B and 8C show balance sheets generated by the generation unit 122 in (1) property purchase period, (2) property purchase 4th year, and (3) property purchase 8th year, respectively. It is an example of the graph image showing. 8 (d), (e), and (f) are (1) the property purchase period, (2) the fourth year of property purchase, and (3) the eighth year of property purchase generated by the generation unit 122. FIGS. 8A, 8B, and 8C, which are graph images representing a balance sheet, are examples of graph images in which the size is changed according to the current ratio in each fiscal year.

  The generation unit 122 uses, for example, the size and the current ratio (about 279%) of the graph image representing the balance sheet of the property purchase period in FIGS. 8A and 8D as a reference. (2) Using the graph image of the fourth year of property purchase as the basis for the current ratio (about 428%) for the current fiscal year, the ratio (about 1.5 times) of the current ratio of (1) The graph image in FIG. 8E can be obtained by changing the height and width of each size. Similarly, the generation unit 122 uses the graph image of the third year of property purchase in (3) in FIG. 8C as the basis for the current ratio (about 625%) for the current fiscal year. The graph image of FIG. 8F can be obtained by changing the height and width of the graph image with a magnification (about 2.2 times). By adopting such a configuration, the graph image is displayed in accordance with the numerical values of the indicators that should be considered with priority in real estate investment (for example, the current ratio and capital ratio in the balance sheet). Since the size and the like can be changed, the financial state indicated by the index can be graphically displayed. From FIG. 8A, FIG. 8B, and FIG. 8C before the change, FIG. In d), (e), and (f), it is possible to intuitively grasp the effect of real estate investment such as medium- to long-term property purchase (for example, increase the stability of management).

  In this example, the current ratio was used as an example, but any financial index should be used as long as it is a priority index for real estate investment. You may decide according to. For example, as another example of a financial index related to the balance sheet, an equity ratio (a ratio of equity (net assets) to total assets (total of liabilities and net assets)) may be used. As a general point of view, the higher the capital ratio (the higher the ratio of capital to total assets), the more likely the company is to operate with capital that does not require repayment. Therefore, it can be considered that the management is stable, so the capital adequacy ratio can be used for such a judgment.

  In this example, the balance sheet is used as the financial statement and the current ratio is used as the financial index using FIGS. 5 and 8. In addition, the profit and loss statements shown in FIGS. Similarly to this example for the cash flow statement, the size of the graph image representing each financial statement, the coloring, or the format of the code characters attached to the graph image, depending on the value of the index (financial index) indicating the financial status What is necessary is just to change at least any one of these. By adopting such a structure, the real estate investment effect is based on the quantitative value evaluation shown by these financial indicators without knowing the financial indicators that are the key to judging the real estate investment effect of each financial statement. It is possible to intuitively grasp whether the value of a company will increase.

  The storage unit 130 has a function of storing various programs, data, parameters, and the like necessary when the server 100 operates under the control of the control unit 120. Specifically, the storage unit 130 stores property information, financial information, simulation information, and the like. Specifically, the storage unit 130 includes, for example, a main storage device including a ROM and a RAM, an auxiliary storage device including a nonvolatile memory, an HDD (Hard Disc Drive), an SSD (Solid State Drive), a flash It is composed of various recording media such as a memory.

  The I / O unit 140 has a function of connecting to another device, another device, or a medium by wireless or wired communication under the control of the control unit 120. Specifically, the I / O unit 140 includes WiFi (Wireless Fidelity), HDMI (registered trademark) (High-Definition Multimedia Interface) (registered trademark), USB (Universal Serial Bus), power connector, I2C (Inter-Integrated) Circuit).

  As illustrated in FIG. 2, the terminal 200 includes a communication unit 210, a control unit 220, a storage unit 230, a display unit 240, and an I / O unit 250.

  The communication unit 210 has a function of executing communication with an external device such as the server 100 via the network 400 under the control of the control unit 220. The communication may be either wired or wireless, and any communication protocol may be used as long as mutual communication can be performed. Specifically, the communication unit 210 may receive display output information including a graph image transmitted from the server 100 for display on the display output unit 241 according to the control of the control unit 220, for example. Display input information transmitted to each function unit of the server 100 generated based on the input result of the operation input unit 242 may be transmitted.

  The control unit 220 is a processor having a function of controlling each functional unit of the terminal 200. Specifically, for example, the control unit 220 stores the display output information transmitted from the server 100 in the storage unit 230 or causes the display output unit 241 to display and output the display output information. Specifically, for example, the control unit 220 generates display input information based on the result input from the operation input unit 242 and stores the display input information in the storage unit 230 or the display input in the server 100. The communication unit 210 may be controlled to transmit information.

  The storage unit 230 has a function of storing various programs, data, parameters, and the like necessary when the terminal 200 operates under the control of the control unit 220. Specifically, the storage unit 230 stores, for example, display input information, display output information, and the like. Specifically, the storage unit 230 is configured by various recording media such as a main storage device configured by a ROM and a RAM, an auxiliary storage device configured by a nonvolatile memory, an HDD, an SSD, a flash memory, and the like. .

  The display unit 240 includes a display output unit 241 and an operation input unit 242, and has a function of displaying various types of information on the terminal 200 and receiving a designation input under the control of the control unit 220.

  Specifically, for example, an LCD (Liquid Crystal Display) display, an LED (Light Emitting Diode) display, an OLED (Organic Light Emitting Diode) display, a plasma display, or the like provided in the terminal 200 may be used as the display unit 240.

  The display output unit 241 has a function of displaying display output information and the like transmitted from the server 100 under the control of the control unit 220. The display screen of the display output unit 241 has a general data format that can be displayed on the terminal 200, such as a markup language such as HTML (Hyper Text Markup Language), bitmap data, or compressed image data. It only has to be generated. Specifically, the display output unit 241 may display a graph image transmitted (transmitted) from the server 100 via the network 400 and the communication unit 210 under the control of the control unit 220.

  The display output unit 241 dynamically changes the fiscal year to be displayed every predetermined time, and moves the generated graph image corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time. May be changed and displayed. By adopting such a configuration, it is possible to display an animation showing a state in which the financial state of a company changes continuously when a property is purchased, so that it is possible to improve the ease of understanding the effect of real estate investment.

  Further, the display output unit 241 may dynamically change and display the graph image representing the changed balance sheet corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time. With this configuration, it is possible to animate the graph image of the balance sheet showing the financial status of the company when the property is purchased, making it easier to understand the effects of real estate investment Can be improved. Here, an example of dynamic change display by the display output unit 241 in the real estate investment simulation system 500 will be described with reference to FIG. FIG. 10 is a diagram illustrating an example of a display and input screen of the real estate investment simulation system 500.

  As shown in FIG. 10 (a), the display output unit 241 sends a current asset (designated 1 million yen in this example) or a fixed asset (designated 2 million yen in this example) to the operation input unit 242. A graph image of the balance sheet may be displayed based on the input specification in the text box for inputting various conditions such as the financial state of the company at the current stage shown in the upper part of FIG. When an execution button with a down arrow is pressed on the contents specified in each text box, the operation input unit 242 accepts these inputs and passes through the simulation unit 121, the generation unit 122, and the like of the server 100, and FIG. You may display the graph image showing the balance sheet of the present stage shown to the lower part of (a).

  Subsequently, as shown in FIG. 10B, the display output unit 241 displays a button for inputting and specifying a property to be purchased such as “apartment B 1 million”, “apartment C 2 million”, and “apartment D 3 million”. May be. In this example, as an example of displaying a real estate investment simulation in the case of purchasing “Mansion B 1 million”, the display output unit 241 presses the button displayed as “Mansion B 1 million” on the operation input unit 242. In addition to the terms and conditions already entered and specified in the text box shown at the top, a graph image representing the balance sheet when the specified property (condominium B million) is purchased (property purchase period) is displayed in FIG. May be.

  Subsequently, the display output unit 241 may dynamically change the fiscal year to be displayed every predetermined time, as shown in the display screen examples of FIGS. When the display output unit 241 presses a dynamic change display (animation display) execution button (horizontal triangle button) as shown in FIGS. 10B to 10D, the display fiscal year is displayed every predetermined time. The graph image representing the financial statements (balance sheet in this example) may be displayed so as to be dynamically changed in accordance with the changed fiscal year of the display target. The fiscal year to be displayed is, for example, “Property purchase period” in FIG. 10B, “Property purchase 4th year” in FIG. 10C, and “Property purchase 8th year” in FIG. , It may be dynamically changed at a predetermined time (for example, every 0.8 seconds, every second). The “predetermined time” here is the interval time for dynamically changing the fiscal year or graph image to be displayed, and it is a time when the animation display is unnatural or does not cause stress as the standby time until the next screen display. As long as there is, it can be any time.

  Here, as shown in the middle part of FIGS. 10C to 10D, the display output unit 241 moves the dynamically changed fiscal year to a bar graph in accordance with the transition of the fiscal year over time. May be changed and displayed. For example, as shown in FIGS. 10A to 10D, the display output unit 241 has a scale of the year (for example, 0 (property purchase period), 1, 2,... 20 years (property purchase 20 years). )) Is displayed in advance, and as time passes, the fiscal year is dynamically changed to the property purchase period, the property purchase 4th year, and the property purchase 8th year, and the bar graph May be changed and displayed (animated) so as to extend along the scale of the current year. With such a configuration, the fiscal year to be displayed can be intuitively grasped at a glance in conjunction with a continuously changing graph image, and an easy-to-understand real estate investment simulation display can be provided.

  Further, the display output unit 241 may dynamically change and display the graph image representing the changed profit and loss statement corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time. With this structure, it is possible to animate the graph image of the income statement showing the financial status of the company when the property is purchased, so it is easy to understand the effect of real estate investment Can be improved.

  Further, the display output unit 241 may dynamically change and display the graph image representing the changed cash flow calculation sheet corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time. With this structure, you can animate the graph image of the cash flow statement that shows the financial state of the company when you purchase the property, making it easy to understand the effects of real estate investment. Can be improved.

  Specifically, the display output unit 241 may display a graph image in a fiscal year or a fiscal period accepted by the operation input unit 242 according to the control of the control unit 220, for example.

  For example, the display output unit 241 may display a graph image with a hierarchy for each fiscal year. Specifically, for example, as shown in FIGS. 9A and 9B, the display output unit 241 displays a graph image of a plurality of fiscal years in a superimposed manner by layering each fiscal year. May be. FIG. 9 is a diagram illustrating an example of a display screen of the display output unit 241 of the real estate investment simulation system 500. By adopting such a configuration, it is possible to compare the financial states in a plurality of fiscal years at a time and grasp the real estate investment effect at a glance and intuitively.

  The operation input unit 242 has a function of receiving an operation input including a designation input from a customer or an employee who provides a real estate investment brokerage service or the like under the control of the control unit 220. Specifically, the operation input unit 242 is realized by a soft key or a hard key such as a touch panel.

  Specifically, the operation input unit 242 may accept designation input of one or more fiscal years or accounting periods, for example, under the control of the control unit 220. The operation input unit 242 generates display input information based on the received designation input result under the control of the control unit 220 and transmits (transmits) the information to the server 100 via the communication unit 210 and the network 400. When the server 100 receives the display input information, the server 100 transmits the display input information to the simulation unit 121 under the control of the control unit 120. When the display input information is transmitted to the simulation unit 121, the server 100 purchases a property based on the display input information. In order to simulate the effect of real estate investment, the company's financial data for the designated fiscal year or period is predicted.

  The I / O unit 250 has a function of connecting to another device, another device, or a medium by wireless or wired communication under the control of the control unit 220. Specifically, the I / O unit 250 includes WiFi (Wireless Fidelity), HDMI (registered trademark) (High-Definition Multimedia Interface) (registered trademark), USB (Universal Serial Bus), a power connector, and I2C (Inter-Integrated). Circuit).

(Operation example)
An operation example of the real estate investment simulation system 500 in one embodiment of the present invention will be described with reference to FIG. FIG. 11 is a flowchart showing an operation example of the real estate investment simulation system 500 in one embodiment of the present invention.

  The storage unit 130 stores property information representing the property to be purchased and financial information representing the financial status of each company (step S10).

  The simulation unit 121 predicts future financial data when the property is purchased based on the property information and financial information stored in the storage unit 130 (step S11). The simulation unit 121 transmits the predicted financial data to the generation unit 122.

  The generation unit 122 generates a graph image representing the financial state of the company for each future fiscal year based on the financial data transmitted from the simulation unit 121 (step S12). The generation unit 122 transmits the generated graph image to the display unit 240 of the terminal 200 via the communication unit 110 and the network 400.

  The display unit 240 dynamically changes the fiscal year to be displayed at predetermined time intervals according to the user's input designation and trigger (step S13). The display unit 240 dynamically changes and displays the graph image transmitted from the server 100 corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time (step S14).

  Each functional unit of the server 100 and the terminal 200 may be realized by a logic circuit (hardware) or a dedicated circuit formed in an integrated circuit (IC (Integrated Circuit) chip, LSI (Large Scale Integration)), You may implement | achieve by software using CPU (Central Processing Unit) and memory. Each functional unit may be realized by one or a plurality of integrated circuits, and the functions of the plurality of functional units may be realized by a single integrated circuit. An LSI may be called a VLSI, a super LSI, an ultra LSI, or the like depending on the degree of integration. Here, the “circuit” may include the meaning of digital processing by a computer, that is, functional processing by software. The circuit may be realized by a reconfigurable circuit (for example, FPGA: Field Programmable Gate Array).

  When the functional units of the server 100 and the terminal 200 are realized by software, the server 100 and the terminal 200 are configured to execute a command of a real estate investment simulation program that is software that realizes each function, the real estate investment simulation program, and various data. Includes a ROM (Read Only Memory) or storage device (referred to as “recording medium”) recorded so as to be readable by a computer (or CPU), a RAM (Random Access Memory) for developing the real estate investment simulation program, and the like. ing. And the objective of this invention is achieved when a computer (or CPU) reads the said real estate investment simulation program from the said recording medium, and runs it. As the recording medium, a “non-temporary tangible medium” such as a tape, a disk, a card, a semiconductor memory, a programmable logic circuit, or the like can be used. The real estate investment simulation program may be supplied to the computer via an arbitrary transmission medium (such as a communication network or a broadcast wave) that can transmit the real estate investment simulation program. The present invention can also be realized in the form of a data signal embedded in a carrier wave, in which the real estate investment simulation program is embodied by electronic transmission.

  The real estate investment simulation program is implemented using, for example, a script language such as ActionScript or JavaScript (registered trademark), an object-oriented programming language such as Objective-C or Java (registered trademark), or a markup language such as HTML5. it can.

500 real estate investment simulation system 100 server 110 communication unit 111 reception unit 120 control unit 121 simulation unit 122 generation unit 130 storage unit 140 I / O unit 200 terminal 210 communication unit 220 control unit 230 storage unit 240 display unit 241 display output unit 242 operation Input unit 250 I / O unit 400 Network

Claims (10)

A real estate investment simulation system that predicts and displays a company's future financial data about the effect of real estate investment,
A storage unit that stores property information representing properties to be purchased and financial information representing the financial status of each company;
Based on the property information and the financial information, a simulation unit that predicts future financial data when the property is purchased;
Based on the predicted financial data, a generation unit that generates a graph image representing the financial state of the company for each future fiscal year;
The fiscal year to be displayed is dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is dynamically changed and displayed in accordance with the transition of the fiscal year over time. A display unit to
Real estate investment simulation system with The display unit dynamically changes and displays the dynamically changed fiscal year in accordance with the transition of the fiscal year over time;
The real estate investment simulation system according to claim 1. The property information includes rent revenue of the property to be purchased, interest rate of borrowing and depreciation expenses, and the financial information includes assets, liabilities and net assets for each company,
The simulation unit includes at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year when the property is purchased based on the property information and the financial information. By calculating the data, the financial data is predicted,
The generating unit generates a graph image representing at least one of a balance sheet, a profit and loss statement, or a cash flow statement for each fiscal year based on the calculated account item data;
The real estate investment simulation system according to claim 1 or 2. The simulation unit predicts the financial data by calculating a current ratio for each fiscal year based on the account data constituting the balance sheet,
The generation unit has at least a size of a graph image representing a balance sheet for each generated fiscal year, coloring, or a format of a code character assigned to the graph image, according to the current ratio for each fiscal year Change any one,
The display unit dynamically displays the graph image representing the changed balance sheet corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time;
The real estate investment simulation system according to claim 3. The financial information includes revenues and expenses in a predetermined accounting period for each company,
The simulation unit predicts the financial data by calculating EBITDA for each fiscal year based on account item data constituting the profit and loss statement,
According to EBITDA for each fiscal year, the generation unit changes at least one of the size of the graph image representing the profit and loss statement, the coloring, or the format of the code character assigned to the graph image,
The display unit dynamically displays the graph image representing the changed income statement corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time;
The real estate investment simulation system according to claim 3. The simulation unit predicts the financial data by calculating a free cash flow for each fiscal year based on the account item data constituting the cash flow statement,
In accordance with the free cash flow for each fiscal year , the generator generates at least one of the size of the graph image representing the cash flow statement, the coloring, and the format of the code character added to the graph image. change,
The display unit dynamically displays the graph image representing the changed cash flow statement corresponding to the changed fiscal year in accordance with the transition of the fiscal year over time;
The real estate investment simulation system according to claim 3. The real estate investment simulation system further includes an operation input unit that receives designation input of one or more of the fiscal year or accounting period,
The simulation unit predicts the financial data in the fiscal year or accounting period accepted by the operation input unit based on the property information and the financial information;
The real estate investment simulation system according to any one of claims 1 to 6. The display unit displays the graph image with a hierarchy for each fiscal year;
The real estate investment simulation system according to any one of claims 1 to 6. A real estate investment simulation program that simulates the impact of real estate investment on a company's finances.
On the computer,
A storage function for storing property information representing properties to be purchased and financial information representing the financial status of each company;
Based on the property information and the financial information, a simulation function for predicting future financial data when the property is purchased;
A generating function for generating a graph image representing a financial state for each future fiscal year based on the predicted financial data;
The fiscal year to be displayed is dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is dynamically changed and displayed in accordance with the transition of the fiscal year over time. Display function to
Real estate investment simulation program to realize. A real estate investment simulation method in which a computer simulates the financial impact of a real estate investment on a company,
Stores property information representing the property to be purchased and financial information representing the financial status of each company,
Based on the property information and the financial information, predicting future financial data when the property is purchased,
Based on the predicted financial data, a graph image representing a financial state for each future fiscal year is generated,
The fiscal year to be displayed is dynamically changed every predetermined time, and the generated graph image corresponding to the changed fiscal year is dynamically changed and displayed in accordance with the transition of the fiscal year over time. To
Real estate investment simulation method.

Images