Current location - Loan Platform Complete Network - Loan intermediary - How to calculate the liquidity demand in the loan preparation form?
How to calculate the liquidity demand in the loan preparation form?
1. How to calculate the liquidity demand in the loan preparation form?

Professional answer:

Working capital = last year's sales revenue ×( 1- last year's sales profit rate )× (estimated annual sales revenue growth rate 1)/ number of operations.

In which: number of operations = 360/ (average collection period of inventory turnover days-turnover days of accounts payable-turnover days of prepayments-turnover days of prepayments).

Turnover days =360/ turnover times

Accounts receivable turnover times = sales revenue/average accounts receivable balance

Turnover times of accounts received in advance = sales revenue/average balance of accounts received in advance

Inventory turnover times = cost of sales/average inventory balance

Prepayment turnover times = cost of sales/average prepayment balance

Accounts payable turnover times = cost of sales/average accounts payable balance

New working capital loan amount = working capital-borrower's own funds-existing working capital loans-working capital provided by other channels.

Second, how to calculate the liquidity demand in the loan preparation form?

Professional answer: liquidity = sales profit rate of last year) ×( 1 estimated annual sales revenue growth rate)/number of operations, in which: number of operations = 360/ (inventory turnover days, average collection period-accounts payable turnover days, prepayment turnover days-advance receipt turnover days) number of weeks, turnover times of accounts receivable = sales revenue/average turnover times = sales revenue/average advance receipt balance, inventory turnover times. Average inventory balance prepayments turnover times = cost of sales/average prepayments balance accounts payable turnover times = cost of sales/average accounts payable balance New working capital loan amount = working capital amount-borrower's own funds-existing working capital loans-other channels

3. What is the latest formula for calculating the annual capital demand?

Capital demand = (average capital occupation in base period-unreasonable capital occupation) × (1 sales increase or decrease rate in forecast period )× (1speed change rate in forecast period). Capital demand forecast refers to the estimation and speculation of the future capital needed by enterprises according to the needs of production and operation.

Calculation formula for forecasting capital demand

First, the factor analysis method:

Capital demand = (average capital occupation in base period-unreasonable capital occupation) × (1 sales increase or decrease rate in forecast period )× (1speed change rate in forecast period).

Second, the sales percentage method:

External financing demand = (increased sensitive assets-increased sensitive liabilities and increased non-sensitive assets)-increased retained earnings.

What is the forecast of capital demand?

Capital demand forecast refers to the estimation and speculation of the future capital needed by enterprises according to the needs of production and operation. In order to raise funds, enterprises must first predict the capital demand, that is, estimate, analyze and judge the capital demand for organizing production and business activities in the future, which is the basis for enterprises to formulate financing plans.

The significance of capital demand forecast

The continuous production and operation activities of enterprises constantly generate the demand for funds. At the same time, enterprises need to raise funds for foreign investment and capital structure adjustment. Some of these funds needed by enterprises come from within the enterprise, and the other part is obtained through external financing. When enterprises raise funds abroad, they not only need to find a fund provider, but also need to make a commitment to repay the principal and interest or provide a profit prospect for the enterprise, so that the fund provider can be sure that their investment is safe and profitable, and this process often takes a long time. Therefore, enterprises need to know their own capital needs in advance, determine the amount of funds needed, and arrange financing plans in advance so as not to affect them.

Steps of capital demand forecast

The capital demand forecast is generally carried out according to the following steps:

(1) sales forecast

Sales forecast is the starting point of enterprise financial forecast. Sales forecast itself is not the function of financial management, but it is the basis of financial forecast, and financial forecast can only be started after sales forecast is completed. Therefore, the forecast of enterprise capital demand should also be based on sales forecast.

(2) Estimated assets needed

Assets are usually a function of sales volume and can be analyzed according to historical data. According to the expected sales volume and asset sales function, the total amount of required assets can be predicted. Some current liabilities are also functions of sales, which can also predict the spontaneous growth rate of liabilities and reduce the external financing amount of enterprises.

(3) Estimated income, expenses and retained earnings

There is also a certain functional relationship between income and expenses and sales, so we can estimate income and expenses according to sales and determine net profit. Net profit and dividend payout ratio, * * * both determine the amount of funds that retained earnings can provide.

(4) Estimate the amount of additional funds needed and determine the amount of external financing.

According to the estimated total assets, minus the existing sources of funds, the spontaneous growth of liabilities and the retained earnings provided internally, additional capital requirements are obtained, and on this basis, the required external financing amount is further determined.

Four, the CBRC "working capital loan demand calculation reference" calculation formula.

The reference formula for the CBRC to calculate the demand for working capital loans is: amount of working capital-sales revenue of the previous year ×( 1- sales profit rate of the previous year) ×( 1 expected times).

Among them, the number of operations =360/ (average collection period of inventory turnover days-payment turnover days and prepayment turnover days). Turnover days =360/ turnover times. Accounts receivable turnover times = sales revenue/average accounts receivable balance = locked sales revenue/average accounts receivable balance = inventory turnover times = sales cost/average inventory balance.

Prepaid turnover times = cost of sales/average prepaid balance = turnover times of accounts payable = cost of sales! Average balance of accounts payable. According to the traditional financial management theory, we can use factor analysis, sales percentage method and capital habit prediction method to estimate and predict the liquidity needed by enterprises.

On this basis, according to the relationship between working capital and sales revenue, CBRC provided a set of reference formulas in 20 10 Interim Measures for the Management of Working Capital Loans. By reasonably calculating the demand for working capital loans, it not only helps banks and other financial institutions to strengthen the management and control of working capital loans needed by enterprises.

It is also convenient for large enterprise group settlement centers or financial companies to manage loans to group members. This paper summarizes the practical experience of more than 50 member units of a large domestic coal enterprise group in applying the calculation formula in the process of internal credit granting, finds that there are still some shortcomings in the application of the calculation formula, and puts forward some concrete suggestions for improvement.