Question

In: Finance

Suppose that you constructed a pro forma balance sheet and a cash budget for a company...

Suppose that you constructed a pro forma balance sheet and a cash budget for a company for the same time period and the external fi-nancing required from the pro forma forecast exceeded the cash deficit estimated on the cash budget. How would you interpret this result?

Solutions

Expert Solution

External financing required is the amount that should be raised by a company from external sources to finance any increase in assets that may be required by the company.

A Cash Deficit estimated on the cash budget indicates an excess of estimated disbursements of cash over cash receipts or cash revenue.

This cash deficit will also indicate the extent to which External Financing will be required to fund this deficit in the cash budget for a given time period.

This means that the External Financing required should be equal to the cash deficit estimated on the cash budget.

If the external financing required from the pro forma forecast exceeded the cash deficit estimated on the cash budget, then this can be interpreted to mean that an error has been committed in making the forecasts in the Pro Forma Balance Sheet and/or the estimated Cash Budget. The error(s) have been made in either or both of these forecasts.

The forecasts should be checked for accounting errors and arithmetical errors.


Related Solutions

Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In...
Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In putting together the cash budget for the fourth quarter of the year, he has assembled the following data. Sales July (actual) $100,000    August (actual) 120,000    September (estimated) 90,000    October (estimated) 100,000    November (estimated) 135,000    December (estimated) 150,000    Each month, 20 percent of sales are for cash, and 80 percent are on credit. The collection pattern for credit sales...
Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In...
Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In putting together the cash budget for the fourth quarter of the year, he has assembled the following data. Sales July (actual) $100,000    August (actual) 120,000    September (estimated) 90,000    October (estimated) 100,000    November (estimated) 135,000    December (estimated) 150,000    Each month, 20 percent of sales are for cash, and 80 percent are on credit. The collection pattern for credit sales...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Phoebe's Cat Foods​ Inc.: Total asset turnover   1.6 times Average collection period (assume 365-day year)   16 days Fixed asset turnover   6 times Inventory turnover (based on cost of goods sold)   2 times Current ratio   2.0 times Sales (all on credit)   $3,000,000 Cost of goods sold   75% of sales Debt ratio   60% Fill in the assets section of the pro forma balance sheet....
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 16 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 2 times Current ratio 1.9 times Sales​ (all on​ credit) ​$5,000,000 Cost of goods sold 70​% of sales Debt ratio 40​% . Fill in the assets section of the pro forma balance...
Understanding Relationships, Cash Budget, Pro Forma Balance Sheet Ryan Richards, controller for Grange Retailers, has assembled...
Understanding Relationships, Cash Budget, Pro Forma Balance Sheet Ryan Richards, controller for Grange Retailers, has assembled the following data to assist in the preparation of a cash budget for the third quarter of the year: Sales: May (actual) $100,000 June (actual) 120,000 July (estimated) 90,000 August (estimated) 100,000 September (estimated) 135,000 October (estimated) 110,000 Each month, 30% of sales are for cash and 70% are on credit. The collection pattern for credit sales is 20% in the month of sale,...
The CFO of Biologic Company has created the firmâ s pro forma balance sheet for the...
The CFO of Biologic Company has created the firmâ s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 20 percent to $42 million. Current assets, fixed assets, and short-term debt are 28 percent, 62 percent, and 12 percent of sales, respectively. Biologic Company pays out 40 percent of its net income in dividends. The company currently has $8 million of long-term debt and $17 million in common stock par value. The profit margin...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
Develop a pro forma income statement and balance sheet for the company given below. Use the...
Develop a pro forma income statement and balance sheet for the company given below. Use the following assumptions in making your pro forma: Currently, fixed assets are at full capacity Each asset grows proportionally with sales Payables and accruals grow proportionally with sales 2017’s profit margin (2.52%) and dividend payout (30%) will be maintained in 2018 Sales are projected to increase by $500 million (25%) Interest payments will not change (this is not realistic, but will save you some steps)...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s Oil Service Company: Actual Sales 3rd QTR                    Estimated Sales 4th QTR July        $1,200,000                               Oct.                $3,000,000 Aug.       $1,400,000                              Nov. $5,000,000 Sept.     $1,600,000                              Dec.                $7,000,000 ****************************************************************** Actual Purchases 3rd QTR             Estimated Purchases 4th QTR July       $1,000,000                              Oct.                  $3,000,000 Aug.      $1,500,000                               Nov.    $4,000,000 Sept.     $2,000,000                               Dec.               $1,000,000 __________________________________________________________________ One-half (50 percent) of the sales each month are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT