Question

In: Finance

​(Pro forma accounts receivable balance calculation​) The accounts receivable for Pastors Brewing Company on March ​...

​(Pro forma accounts receivable balance calculation​)

The accounts receivable for Pastors Brewing Company on March ​ 31, 2016 was ​$23,000. Firm sales are roughly evenly split between credit and cash​ sales, with 40 percent of the credit sales collected in the month after the sale and the remainder 2 months after the sale. Historical and projected sales for the brewing company are given​ here:

MONTH

SALES

MONTH

SALES        

January

​$19,000

March

​$31,000

     

February

​$25,000

April​ (projected)

​$35,000

     

.

a. Under these​ circumstances, what should the balance in accounts receivable be at the end of​ April?

b. How much cash did​ Pastors' realize during April from sales and​ collections?

a. Under these​ circumstances, what should the balance in accounts receivable be at the end of​ April?

​$ ​ (Round to the nearest​ dollar.)

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


Related Solutions

​(Pro forma accounts receivable balance calculation​) ​Jimmie's micro brewery is located in downtown​ Ruston, Louisiana in...
​(Pro forma accounts receivable balance calculation​) ​Jimmie's micro brewery is located in downtown​ Ruston, Louisiana in a restored section of the old Ford dealership. Jimmie sells his beer both to retail customers that visit his brewery and also distributes his line of craft beers through M. L. Keith Food Distributors.​ Jimmie's wholesale distributor purchases his beer on credit which amounts to about​ 50% of the​ brewery's total sales. Firm sales were roughly evenly split between credit and cash​ sales, with...
​(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...
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?
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
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. 1.Create the pro forma statements. 2. What’s the plug variable here? 3. If Fire Corp pays half of income as dividend,...
• Describe pro forma income and the importance of pro forma income in the evaluation of...
• Describe pro forma income and the importance of pro forma income in the evaluation of the income statement. Choose at least two items that are excluded from pro forma income. Suggest to management why including the items would be misleading to investors and creditors.
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)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT