You can refer to the following information: XX Company's 20 13 budget preparation plan and 20 13 comprehensive management expense fund budget table, and prepare the 20 13 annual fund budget plan according to the actual situation of the enterprise.
1.XX company's 20 13 annual budget preparation plan: wenku.baidu/...9;
2.20 13 comprehensive management expense budget table: wenku.baidu/...4;
3.20 13 Annual Financial Budget Plan: wenku.baidu/...6.
Question 2: How to fill in the project fund budget table? You can refer to the following "XX Company's 20 13 Budget Preparation Plan" and "20 13 Comprehensive Management Expense Fund Budget Table" to prepare the "20 13 Enterprise Annual Fund Budget Plan" according to the actual situation of the enterprise.
1.XX company's 20 13 annual budget preparation plan: wenku.baidu/...9;
2.20 13 comprehensive management expense budget table: wenku.baidu/...4;
3.20 13 Annual Financial Budget Plan :wenku.baidu/. ... Gexun Palace.
Question 3: How to make the annual budget statement? First, make an accounting with reference to the expenses and cost expenditures of the previous year, and then all departments discuss and summarize what equipment needs to be purchased and submit it to the budget person. Make comprehensive summary and classification according to the submitted expenses.
For example, cost: how many employees will the company increase this year? What is the salary standard?
For example, charging; Will the rent be adjusted? The increase of utilities directly affects the increase of expenses.
For example, fixed assets: have office equipment and facilities increased, and by what amount?
Any increase or decrease in operating expenses last year should be taken into account.
Question 4: excel 20 13 Financial Monthly Capital Budget Table Design
Question 5: How to use app excel as a company budget fund? I need detailed steps on how to make that form. It's excel on the app, not that it won't.
Question 6: How to prepare the cash flow budget cash flow statement The cash flow budget is based on the cash inflow and outflow generated by operating activities, investment activities and financing activities, and reflects the direction, scale and structure of cash flow during the enterprise budget period. The net value of cash inflow and outflow reflects the enterprise's ability to pay and pay debts. Through the preparation of cash flow budget, reasonable arrangements and handling of cash receipts and payments, fund scheduling and other businesses, to ensure that enterprises now prepare cash flow budget. Based on the cash balance at the beginning of the enterprise, we can fully consider the cash income during the budget period, predict the ideal cash balance at the end of the period and determine the cash expenditure during the budget period.
The relationship can be expressed by the formula: cash balance at the beginning+cash income in budget period-ideal cash balance at the end of budget period = cash expenditure in budget period.
1. The opening cash balance data comes from the opening amount of monetary funds in the budget balance sheet.
2. Cash income includes the following three aspects: cash income from operating activities, investment activities and financing activities.
(1) Cash income from operating activities mainly comes from cash income from selling goods or providing services, rental income and other income related to operating activities. It is equal to sales revenue and other operating income plus or minus the difference between accounts receivable at the end of the period and accounts receivable at the beginning of the period.
(2) The cash income from investment activities mainly comes from the return received from foreign investment, the recovery of investment and the cash received from the disposal of fixed assets, intangible assets and other long-term assets. The cash received from foreign investment is equal to the investment income of the budget income statement, plus or minus: the difference between the ending and the beginning of accounts receivable and accounts received in advance. Cash received from investment recovery, according to the resolution of the board of directors to recover investment, the decrease of long-term investment and short-term investment is expected, plus or minus: the difference between accounts receivable and accounts received in advance at the end of the period and the beginning of the period. The cash received from the disposal of fixed assets or intangible assets is equal to the net income from the disposal of fixed assets or intangible assets plus or minus the difference between accounts receivable and advance receipts at the end of the period and the beginning of the period.
(3) The cash income from fund-raising activities is equal to the cash received from absorbing equity investment, issuing bonds and borrowing. The cash absorbed by equity investment income is equal to the amount of capital increase and allotment plus or minus the difference between accounts receivable and advance receipts at the end of the period and the beginning of the period. The cash received by borrowing is equal to the difference between cash expenditure and cash income (excluding the net increase in cash received by borrowing) and monetary funds at the end of the period and at the beginning of the period.
3. Cash expenditure includes cash expenditure from operating activities, investment activities and financing activities.
(1) Cash expenditure from operating activities includes cash paid for purchasing commodities or accepting labor services, wages paid to employees and cash paid for employees, cash paid for operating leases, taxes paid and other cash related to operating activities. When determining the cash paid for purchasing goods, based on the purchasing budget of materials and low-value consumables, cash purchase and credit purchase are distinguished, and the payment time and amount of credit purchase are analyzed. The cash paid for purchasing goods and accepting services is equal to the amount of purchasing goods and materials and accepting services, plus or MINUS the difference between accounts payable and prepayments at the end of the period and at the beginning of the period. Wages and cash paid to employees can be adjusted and calculated on the basis of analyzing the actual wages, bonuses and other subsidies paid to direct production personnel, sales personnel, management personnel and other indirect personnel in previous years, as well as the actual expenditures paid to employees in previous years such as housing provident fund, medical insurance, endowment insurance and welfare funds payable. It is equal to the salary payable to employees and the cash expenses such as housing provident fund, medical insurance and endowment insurance paid for employees during the budget period plus or minus the difference between the salary payable to employees, welfare funds payable and other payables at the end of the period and the beginning of the period. The cash paid for operating lease is equal to the rent payable determined in the contract or agreement plus or minus the difference between the end of the period and the beginning of the period. Taxable cash is equal to the difference between the end of the period and the beginning of the budget, including value-added tax, business tax, income tax and other taxes payable and surcharges, plus or minus taxes payable and surcharges.
(2) Cash expenditure of investment activities, including cash paid for the purchase and construction of fixed assets, intangible assets and other long-term assets, cash paid for equity investment and debt investment of enterprises, and other cash expenditures related to investment activities. It is equal to the investment amount of fixed assets, intangible assets and other long-term assets determined in the investment budget plus or minus the changes in accounts payable and prepayments related to investment activities. & gt
Question 7: How to prepare financial budget statements? Financial budget is a series of budgets that specifically reflect the expected financial position and operating results of an enterprise in a certain budget period in the future, as well as cash receipts and payments and other value indicators, including cash budget, expected income statement, expected balance sheet and expected cash flow statement.
1. Contents of financial budget
1. Financial budget
1) Contents: Three major accounting statements.
2) Practice: Based on business budget (sales, cost, expenses, fixed assets, funds, etc. ) and financial assumptions.
3) Step: Profit and loss first, then assets and liabilities, then cash flow.
4) Format: omitted
5) Method: Finance only makes assumptions and does not make predictions.
1, forecast sales volume, and push sales varieties and quantities;
2. Deduct related production costs according to the variety and quantity of sales;
3, according to the proportion of sales and previous years, sales expenses are reduced;
4. Calculate the amount of management fee according to the historical situation;
5. Prepare the forecast income statement according to the above data;
6. Calculate the corresponding items in the balance sheet according to the income statement and historical data (such as inventory turnover rate, accounts receivable turnover rate, current ratio, quick ratio, etc.). )
7. According to the business intention of the company or boss this year, modify the above statement reasonably.
2. Data collection.
Before preparing the financial budget, collect relevant information for preparing the financial budget. It is necessary to fully collect the historical data inside and outside the enterprise, grasp the current operating financial situation and future development trend, use time series analysis and ratio analysis to study and analyze the degree and efficiency of the operation of various assets of the enterprise, judge the increase and decrease trend and interdependence of relevant economic indicators and data, and calculate possible budget values.
3. Summarize the business budget of the enterprise.
Various business budgets prepared by various departments of the enterprise, such as sales budget, production budget, cost budget, procurement budget of materials and low-value consumables, direct labor budget, etc. , is an important basis for the preparation of financial budget. Before preparing the financial budget, the summary data and economic indicators of various business budgets should be collated and analyzed, and cross-checked as the relevant budget figures in each table of the financial budget.
4. Preparation procedure of financial budget.
The preparation of financial budget takes the sales revenue of sales budget as the starting point and the balance of cash flow as the condition, and finally comprehensively reflects the operating results and financial status of the enterprise through the budget income statement and balance sheet. A series of financial budget statements and data are closely linked, interrelated and complementary, forming a complete system.
Second, the preparation of the financial budget table
(1) The budget profit statement comprehensively reflects the income, cost and operating results of the enterprise during the budget period.
Since the whole financial budget is based on sales revenue, only when the sales revenue is determined in the budget income statement can the cost matching with the sales revenue be further planned and calculated. The part where the sales revenue exceeds the operating cost is called gross profit, and the level of sales gross profit is the key to the profit of an enterprise. The operating expenses, management expenses, financial expenses and profit realization of an enterprise all depend on gross profit. The structure, data sources and balance relationship of the budget income statement are as follows:
Project data source
Sales revenue, sales budget and forecast
Operating cost cost budget and forecast
C gross profit equals A -B b b.
Sales expenses sales expenses budget and forecast
Management expenses management expenses budget and forecast
F "Cash for financing expenses and interest" in the cash flow statement of financial expenses budget.
G investment income the financial budget of the invested enterprise or the data analysis of the economic benefits and investment returns of the invested enterprise over the years.
H profit is equal to C -D -E -F +G g g.
I income tax equals H× tax rate.
net profit
Run equals H -I i.
(2) Budget cash flow statement
Cash flow budget is based on cash inflow and outflow from operating activities, investment activities and financing activities, and reflects the direction, scale and structure of cash flow during the enterprise budget period. The net value of cash inflow and outflow reflects the enterprise's ability to pay and pay debts. Through the preparation of cash flow budget, we can reasonably arrange and handle cash receipts and payments and fund scheduling business, and ensure the normal and relatively smooth cash flow of enterprises ... >>
Question 8: What's the difference between a detailed budget table and a budget table? Budget table refers to the main indicators that can correctly reflect the budget level when preparing the budget. Budget schedule refers to the factors that make up each index of the budget table.
Question 9: How to fill in the balance sheet? For example, the final debit balance of accounts receivable is 6,543,800 yuan, the credit balance is 200,000 yuan, the bad debt reserve balance is 6,543,800 yuan, the debit balance of accounts received in advance is 300,000 yuan, and the credit balance is 900,000 yuan. In the report, the net accounts receivable are 654.38+000-654.38+00+30 =
Question 10: How to write the planned capital budget? What should the format be? List the projects first, and then explain the required funds. And there must be space. The amount of funds can be capitalized.