How to do an operating budget for my company of topic The Boeing Company using the following template.

using the previous quarter's financial data, interpret the data and propose a budget for the next Quarter based on your current and previous analysis of company performance. Complete the budget template using thisOperating Budget Template

download

:

• List your current sales, discounts and allowances, net sales, margins, operating costs, and earning before and after taxes.
• Choose a minimum of two financial ratios (below) and include in your analysis.
• Prepare the next quarter's budget based on your interpretation of past data.

Company Name: Operating Budget Q1

Revenue

[Prior Quarter]

Budget

Projection Next Q

Var +/-

Var %

Sales Revenue

Interest Income

Investment Income

Other Income

TOTAL INCOME

Costs and Expenses

[Prior Quarter]

Budget

Projection Next Q

Var +/-

Var %

Advertising

Health Insurance

Installation/Repair of

Equipment

Inventory Purchases

Salaries

Supplies

Insurance

Rent/Lease Payments

Other Expenses

TOTAL EXPENSES

NET PROFIT/LOSS

Net Earnings Before Taxes

(

Gain or Loss

)

Income Tax Expense

Net Earnings After Taxes

Ratio Analysis

(

Choose a minimum of two

)

[Prior Q]

Proj. Q.

Change

Profitability Ratio

Liquidity Ratio

Solvency Ratio

Valuation Ratio

Leverage Ratio