Question

In: Accounting

How do you prepare pro-forma financial statements and describe their relationship to the master budget components?

How do you prepare pro-forma financial statements and describe their relationship to the master budget components?

Solutions

Expert Solution

Answer:

To start creating a pro forma statement, one must begin with an income statement from the current year.

Step 1:

Calculate revenue projections for the business. Make sure to use realistic market assumptions to write an accurate pro forma statement. Research and speak to experts to determine what a normal annual revenue stream is, as well as cash flow and asset accumulation.

Step 2:

Estimate the total liabilities and costs. The liabilities are loans and lines of credit. The costs will be the lease, employee pay, insurance, licenses, permits, materials, etc. To create the first part of the pro forma one will use the revenue projections from Step 1 and the total liabilities and costs found here.

During this time, one has to put a lot of thought into each expense. This is an opportunity to evaluate if every cost is necessary, and what can be cut.

Step 3:

Estimate cash flows. This portion of the pro forma statement will project the future net income, sale of assets, dividends, issuance of stocks, etc. This is the second section of the pro forma financial statement.

Step 4:

Create the chart of accounts. This chart of accounts will make up the pro forma statement for a 3 to 5 year period. Year one will be broken down into monthly increments, while the following years ( years 2 and 3) will be broken down by quarter, and years 4 and 5 are broken down annually.

Remember to continually update the projections in your pro forma to ensure ongoing accuracy.

Financial statements and it's relationship to the master budget components:

A master budget contains all of the other budgets within a business. A successful budget depends on accurate predictions of future activity within each department or division. While companies with multiple divisions have a more complex master budget, all businesses share the same major components. The two main parts are the operational budget and the financial budget. There is a specific order of completion when preparing a master budget.

Operational Budget Relationships:

Sales revenues fund the other operational budgets. The sales budget and all other department budgets are closely related. The cost of producing an item, including direct costs and indirect costs, is a major consideration when setting the selling price of a line of merchandise. Yet the selling price must be competitive in the marketplace to make enough sales to fund the other budgets. Streamlining the process and minimizing waste is essential to increasing profits.

Financial Budget:

The financial budget has five parts. The schedule of expected cash receipts is based on predicted future sales revenues during each period. The amount for each month or quarter will vary in small businesses that are cyclical in nature. The schedule of expected cash payments reflects the amount of money the business plans to spend on purchases during each financial period. The cash budget, income statement and balance sheet all reflect budgeted amounts. If we compare them with the actual numbers at the completion of each quarter, then we can make any necessary adjustments.

Master Budget Order of Completion:

Some component budgets require financial data from other budgets before we can complete them. The correct order for completing the operational budget components is: sales, production, direct material purchases, direct labor, overhead, administrative and cost of goods manufactured. When completing the financial budget, one should begin with the schedule of expected cash receipts and then continue with the schedule of expected cash payments to suppliers, the cash budget, the budgeted income statement and budgeted balance sheet. Following this order will ensure that we have the necessary information for the next component.


Related Solutions

Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in this case are budgeted statements for 2018 based on the new location scenario at the bottom of the page) Pro Forma Income Statement Pro Forma Balance Sheet PEYTON APPROVED PRO FORMA INFORMATION The company is planning to open another location in 2018 . Prepare pro forma financials for 2018 for the new location using the following information: 1. Cost of leasing commercial space: $1,500...
A. What do pro forma financial statements show? B. What are pro forma financial statements based...
A. What do pro forma financial statements show? B. What are pro forma financial statements based on? C. What are the strategic benefits of making financial projections on pro forma statements?
The Gold Bay Hotel is in the process of developing a master budget and Pro-forma financial...
The Gold Bay Hotel is in the process of developing a master budget and Pro-forma financial statements. The beginning balance sheet for the current fiscal year is estimated to be Gold bay Hotel Estimated Balance sheet current year Cash $ 20,000 Accounts payable $ 20,000 Accounts Recievable 30,000 Notes payable 500,000 Facilities 3,010,000 Capital stock 100,000 Accumulated Dep (1,100,000) Retained Earnings 1,340,000 Total assets $ 1,960,000 Total Equities $1,950,000 During the year the hotel expects to rent 30,000 rooms. Rooms...
Case Study 2 Master Budgeting and Pro-Forma Financial Statements You have just been assigned to a...
Case Study 2 Master Budgeting and Pro-Forma Financial Statements You have just been assigned to a new manager who believes you have exceptional budgeting skills. Since you began your job last summer, you have been showing management your latest spreadsheets and how you use your new-found knowledge of Managerial Accounting to make sound business decisions. Your new manager is responsible for the nationwide distribution of designer handkerchief sets (HCS) and, through multiple franchise agreements, sales have grown very rapidly, and...
Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements...
Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available: The firm has estimated that its sales for 2020 will be $900,000. The firm expects to pay $35,000 in cash dividends in 2020. The firm wishes to maintain a minimum cash balance of $30,000. Accounts receivable represent approximately 18% of annual sales. The firm’s ending inventory...
Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements...
Integrative: Pro forma statements Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. The following financial data are also available: The firm has estimated that its sales for 2020 will be $900,000. The firm expects to pay $35,000 in cash dividends in 2020. The firm wishes to maintain a minimum cash balance of $30,000. Accounts receivable represent approximately 18% of annual sales. The firm’s ending inventory...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
How do you prepare the cash budget and describe the relationships among its components?
How do you prepare the cash budget and describe the relationships among its components?
How do you prepare the operating budget and describe the relationships among its components?
How do you prepare the operating budget and describe the relationships among its components?
Discuss the differences between GAAP financial statements and pro forma statements?
Discuss the differences between GAAP financial statements and pro forma statements?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT