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
jeff jeffy answered 1 year agoRelated 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
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT