Question
In: Finance
P4-15 (similar to) Multiple cash budgetslong dash—Scenario analysis Brownstein, Inc., expects sales of $101,000 during each...
|
P4-15 (similar to) |
Multiple cash
budgetslong dash—Scenario
analysis Brownstein, Inc., expects sales of $101,000 during each of the next 3 months. It will make monthly purchases of $56,000 during this time. Wages and salaries are $ 10,000 per month plus 6 %of sales. Brownstein expects to make a tax payment of $25,000 in the next month and a $19,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance are assumed to be zero.
a. Construct a cash budget for the next 3 months.
b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $81,000
per month and the most optimistic is $121,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periods?
c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for financing needs.
Solutions
Expert Solution
(a):
| Month 1 | Month 2 | Month 3 | |
| Opening cash balance | - | 3,940.00 | 13,880.00 |
| Sales | 101,000.00 | 101,000.00 | 101,000.00 |
| Cash from sale of asset | 8,000.00 | ||
| Total inflow | 101,000.00 | 101,000.00 | 109,000.00 |
| Cash payments/disbursements: | |||
| Purchases | 56,000.00 | 56,000.00 | 56,000.00 |
| Wages and Salaries: Fixed | 10,000.00 | 10,000.00 | 10,000.00 |
| Wages and Salaries: Variable (6% of sales) | 6,060.00 | 6,060.00 | 6,060.00 |
| Tax payment | 25,000.00 | ||
| Purchase of fixed assets | 19,000.00 | ||
| Total outflow | 97,060.00 | 91,060.00 | 72,060.00 |
| Closing cash balance | 3,940.00 | 13,880.00 | 50,820.00 |
(b): Pessimistic scenario:
| Month 1 | Month 2 | Month 3 | |
| Opening cash balance | - | - 14,860.00 | - 23,720.00 |
| Sales | 81,000.00 | 81,000.00 | 81,000.00 |
| Cash from sale of asset | 8,000.00 | ||
| Total inflow | 81,000.00 | 81,000.00 | 89,000.00 |
| Cash payments/disbursements: | |||
| Purchases | 56,000.00 | 56,000.00 | 56,000.00 |
| Wages and Salaries: Fixed | 10,000.00 | 10,000.00 | 10,000.00 |
| Wages and Salaries: Variable (6% of sales) | 4,860.00 | 4,860.00 | 4,860.00 |
| Tax payment | 25,000.00 | ||
| Purchase of fixed assets | 19,000.00 | ||
| Total outflow | 95,860.00 | 89,860.00 | 70,860.00 |
| Closing cash balance | - 14,860.00 | - 23,720.00 | - 5,580.00 |
Optimistic scenario:
| Month 1 | Month 2 | Month 3 | |
| Opening cash balance | - | 22,740.00 | 51,480.00 |
| Sales | 121,000.00 | 121,000.00 | 121,000.00 |
| Cash from sale of asset | 8,000.00 | ||
| Total inflow | 121,000.00 | 121,000.00 | 129,000.00 |
| Cash payments/disbursements: | |||
| Purchases | 56,000.00 | 56,000.00 | 56,000.00 |
| Wages and Salaries: Fixed | 10,000.00 | 10,000.00 | 10,000.00 |
| Wages and Salaries: Variable (6% of sales) | 7,260.00 | 7,260.00 | 7,260.00 |
| Tax payment | 25,000.00 | ||
| Purchase of fixed assets | 19,000.00 | ||
| Total outflow | 98,260.00 | 92,260.00 | 73,260.00 |
| Closing cash balance | 22,740.00 | 51,480.00 | 107,220.00 |
| Month 1 | Month 2 | Month 3 | |
| Monthly mimimum ending cash balance | - 14,860.00 | - 23,720.00 | - 5,580.00 |
| Monthly maximum ending cash balance | 22,740.00 | 51,480.00 | 107,220.00 |
(c): The financial manager can plan for financing needs by considering an average estimate of the optimistic and pessimistic sales scenarios. This will give the financial manager the most likely sales position and the most likely ending cash balance for each period. Using this number the manager can also determine the desired the minimum cash balance required at the end of each month and borrow any deficiency for meeting the same.
jeff jeffy answered 1 month agoRelated Solutions
P4-9 (similar to) Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the...
P4-9 (similar to)
Cash disbursements schedule Maris Brothers, Inc., needs a
cash disbursement schedule for the months of April, May, and June.
Use the format given here
LOADING...
and the following information in its preparation.Sales:
February
$ 520 comma 000
;
March
$ 508 comma 000
;
April
$ 555 comma 000
;
May
$ 586 comma 000
;
June
$ 651 comma 000
;
July $ 648 comma 000Purchases: Purchases are calculated as
61 %
of the next month's...
Singal Inc. is preparing its cash budget. It expects to have sales of $30,000 in January,...
Singal Inc. is preparing its cash budget. It expects to have
sales of $30,000 in January, $35,000 in February, and $20,000 in
March. If 20% of sales are for cash, 40% are credit sales paid in
the month after the sale, and another 40% are credit sales paid 2
months after the sale, what are the expected cash receipts for
March?
a. $34,200
b. $28,200
c. $24,600
d. $30,000
e. $27,600
Reese Brothers Publishers Inc (RBP) expects to have sales this year of $15 million under its...
Reese Brothers Publishers Inc (RBP) expects to have sales this
year of $15 million under its current credit policy. The present
terms are net 30; the days sales outstanding (DSO) is 60 days; and
the bad debt loss percentage is 5 percent. Since RBP wants to
improve its profitability, the treasurer has proposed that the
credit period be shortened to 15 days. This change would reduce
expected sales by $500,000, but it would also shorten the DSO on
the remaining...
15) Paradise Retailers, Inc. (PRI) determined that $1,500,000 is needed for cash transactions made during the...
15) Paradise Retailers, Inc. (PRI) determined that $1,500,000 is
needed for cash transactions made during the next year. Each time
PRI deposits money in its checking account, a charge of $12.95 is
assessed to cover clerical costs. If PRI can hold marketable
securities that yield 4.5%, and then convert these securities to
cash at a cost of only the $12.95 deposit charge, what is the
optimal cash amount C* to transfer from marketable securities to
the checking account according to...
15.Paradise Retailers, Inc. (PRI) determined that $1,500,000 is needed for cash transactions made during the next...
15.Paradise Retailers, Inc. (PRI) determined that $1,500,000 is
needed for cash transactions made during the next year. Each time
PRI deposits money in its checking account, a charge of $12.95 is
assessed to cover clerical costs. If PRI can hold marketable
securities that yield 4.5%, and then convert these securities to
cash at a cost of only the $12.95 deposit charge, what is the
optimal cash amount C* to transfer from marketable securities to
the checking account according to the...
The Bookbinder Company has made $300,000 before taxes during each of the last 15 years, and it expects to make $300,000 a year before taxes in the future.
Problem 2-13Loss Carryback and CarryforwardThe Bookbinder Company has made $300,000 before taxes during
each of the last 15 years, and it expects to make $300,000 a year
before taxes in the future. However, in 2016 the firm incurred a
loss of $725,000. The firm will claim a tax credit at the time it
files its 2016 income tax return, and it will receive a check from
the U.S. Treasury. Show how it calculates this credit, and then
indicate the firm's...
The Bookbinder Company has made $250,000 before taxes during each of the last 15 years, and it expects to make $250,000 a year before taxes in the future.
Loss Carryback and CarryforwardThe Bookbinder Company has made $250,000 before taxes during
each of the last 15 years, and it expects to make $250,000 a year
before taxes in the future. However, in 2016 the firm incurred a
loss of $550,000. The firm will claim a tax credit at the time it
files its 2016 income tax return, and it will receive a check from
the U.S. Treasury. Show how it calculates this credit, and then
indicate the firm's tax...
6. During 2017, Miami Inc. had sales revenue $1,328,000, gross profit $728,000, operating expenses $398,000, cash...
6. During 2017, Miami Inc. had sales revenue $1,328,000, gross
profit $728,000, operating expenses $398,000, cash dividends
$90,000, other expenses and losses $40,000. Its corporate tax rate
is 30%. What was Miami's income tax expense for the year?
Select one:
a. $ 60,000
b. $ 87,000
c. $ 99,000
d. $267,000
e. $218,400
8.On January 1, 2018, equity account balances are as
follows:
Preferred
Stock
$ 500,000
Common
Stock
1,000,000
Paid-In Capital in Excess of Par...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 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...
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
ADVERTISEMENT