Here are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019:

April May June
Credit sales $403,000 $352,000 $440,000
Credit purchases 180,000 168,000 201,000
Cash disbursements
Wages, taxes
and expenses 79,800 75,300 104,000
Interest 9,500 9,500 9,500
Equipment purchases 33,500 6,000 148,000

The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $330,000.

Using this information, complete the following cash budget.

April May June
Beginning cash balance $110,000
Cash receipts
Cash collections from credit sales
Total cash available
Cash disbursements
Purchases $172,000
Wages, taxes, and expenses
Interest
Equipment purchases
Total cash disbursements
Ending cash balance

Answers

Answer 1

Answer:

Ending cash balances are as follows:

April = $150,600

May = $247,350

June = $178,650

Explanation:

Note: See the attached excel file for the cash budget.

In the attached excel file, Cash collections from credit sales are calculated as follows:

April = 65 percent of March sales + 30 percent of April sales = (65% * $330,000) + (30% * $403,000) = $335,400

May = 65 percent of April sales + 30 percent of May sales = (65% * $403,000) + (30% * $352,000) = $367,550

June = 65 percent of May sales + 30 percent of June sales = (65% * $352,000) + (30% * $440,000) = $360,800


Related Questions

If Chelsea decides to wait two years
before making the down payment,
instead of one, how much money
will she have after two years?

Answers

(646) 804-0642skskskskskskslksksks

What do you think is the most important skill a judge can possess

Answers

Answer:

The decision making skill because it's hard for a judge to make the right decision.

state three essential characteristics of a good leaders​

Answers

Answer:

The Characteristics & Qualities of a Good Leader

Integrity.

Ability to delegate.

Communication.

Self-awareness.

Gratitude.

Learning agility.

Influence.

Empathy.

Answer:

ghhh función de agosto The Rock Creek and have been for a long time now for the rest in the morning and I will be there and I and my son is in a la medicina y cirugía de las partes involucradas te mando la celula BBDD de las tareas que BBDD PAC gxg de las partes involucradas la

You are considering investing $1,000 in a T-bill that pays 0.05 and a risky portfolio, P, constructed with 2 risky securities, X and Y. The weights of X and Y in P are 0.60 and 0.40, respectively. X has an expected rate of return of 0.14 and variance of 0.01, and Y has an expected rate of return of 0.10 and a variance of 0.0081. If you want to form a portfolio with an expected rate of return of 0.10, what percentages of your money must you invest in the T-bill, X, and Y, respectively if you keep X and Y in the same proportions to each other as in portfolio P

Answers

Answer:

% in T bills = 18.92%, % in P = 81.08%

Explanation:

Portfolio return = Weighted average return

Return of portfolio P = 0.14*0.6 + 0.10*0.4

Return of portfolio P = 0.124

Let % money in T bills be x

0.11 = 0.05*x + 0.124*(1-x)

0.11 = 0.05x + 0.124 - 0.124x

0.014 = 0.074x

x = 18.92%

Hence, % in T bills = 18.92%, % in P = 81.08%

[The following information applies to the questions displayed below.]
The general ledger of Jackrabbit Rentals at January 1, 2021, includes the following account balances:
Accounts Debits Credits
Cash $ 41,500
Accounts Receivable 25,700
Land 110,800
Accounts Payable 15,300
Notes Payable (due in 2 years) 30,000
Common Stock 100,000
Retained Earnings 32,700
Totals $ 178,000 $178,000
The following is a summary of the transactions for the year:
1. January 12 Provide services to customers on account, $62,400.
2. February 25 Provide services to customers for cash, $75,300.
3. March 19 Collect on accounts receivable, $45,700.
4. April 30 Issue shares of common stock in exchange for $30,000 cash.
5. June 16 Purchase supplies on account, $12,100.
6. July 7 Pay on accounts payable, $11,300.
7. September30 Pay salaries for employee work in the current year, $64,200.
8. November 22 Pay advertising for the current year, $22,500.
9. December 30 Pay $2,900 cash dividends to stockholders.
The following information is available for the adjusting entries.
Accrued interest on the notes payable at year-end amounted to $2,500 and will be paid January 1, 2022. Accrued salaries at year-end amounted to $1,500 and will be paid on January 5, 2022. Supplies remaining on hand at the end of the year equal $2,300.
Record closing entries. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)

Answers

Answer:

3.2 Million

Explanation:

Three friends are trying to decide what to do on Saturday night. The options are to go to a party, go see a play, or hang out at their apartment. Abdul prefers to see a play over going to the party, which he prefers to hanging out. Gina prefers to hang out over seeing a play, which she prefers to going to the party. Shaquille would most like to go to the party, his second choice is to hang out, and the play is his least preferred option. In the spirit of democracy, they decide to vote on their options. In a three-way vote, they each vote for a different choice, leading to a tie and failing to solve their problem. They thus decide to consider the options in pairs.
(1 point) Shaquille suggests that they first vote on hanging out versus going to the play and then vote on the winner of that versus going to the party. Which option will be chosen?
Choose one:
A. Go to the play.
B. Go to the party.
C. Hang out.

Answers

Answer:

go to party

Explanation:

Scale of preference can be described as a list of wants of individuals. They are usually arranged in order of importance or preference.

If the individuals vote  on hanging out versus going to the play :

Abdul would vote to see a play because it is his most preferred activity

Gina would vote to go hangout because it is her most preferred activity

Shaquille would vote to hangout. this is because going to the play is his second most preferred activity

so hangout would win with 2 votes to 1 in this round.

In the next round of voting, the two contenders would be hangout and going to the party.

Abdul would vote to go the party.  Going to the party is  his second most preferred activity and hangout is his least preferred activity

Gina would vote to go hangout because it is her most preferred activity

Shaquille would vote to go to the party. This is his most preferred activity.

Going to the party would win the second round of voting

The Pioneer Company has provided the following account balances: Cash $39,400; Short-term investments $5,400; Accounts receivable $7,400; Supplies $55,000; Long-term notes receivable $3,400; Equipment $103,000; Factory Building $194,000; Intangible assets $7,400; Accounts payable $28,600; Accrued liabilities payable $3,300; Short-term notes payable $16,800; Long-term notes payable $99,000; Common stock $194,000; Retained earnings $73,300. What is Pioneer's current ratio

Answers

Answer:

2.20

Explanation:

Calculation for What is Pioneer's current ratio

First step is to calculate current assets

Current assets = $39,400 + $5,400 + $7,400 + $55,000

Current assets = $107,200

Second step is to calculate Current liabilities

Current liabilities =

=$28,600 + $3,300 + $16,800.

Current liabilities =$48,700

Now let calculate Current ratio

Using this formula

Current ratio=Current assets/Current Liabilities

Let plug in the formula

Current ratio = $107,200 ÷ $48,700.

Current ratio=2.20

Therefore Pioneer's current ratio will be 2.20

Jasper Furnishings has $300 million in sales. The company expects that its sales will increase 12% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows:

Inventories=$25+0.125(Sales).

Given the estimated sales forecast and the estimated relationship between inventories and sales, what are your forecasts of the company’s year-end inventory level and its inventory turnover ratio?

Answers

Answer:

Sales = $300,000,000

Sales Increase = 12%

Inventories = $25 + 0.125 (Sales)

Forecast sales = $300,000,000 * 1.12 = $336,000,000

As per equation inventory level = $25 + 0.125 (Sales)

= $25 + 0.125 ($336,000,000/1,000,000)

= $25 + $42

= $67 million

Inventory turnover ratio = Sales / Inventory

Inventory turnover ratio = $336,000,000/$67,000,000

Inventory turnover ratio = 5.014925373134328

Inventory turnover ratio = 5.015

Other Questions
I need two equations find the surface area of cuboid whose Length breadth and height are 15 CM 12 cm and 10cm respectively someone please help meWhat materials do motor neurons need to survive and how do they get those materials? Which sentence contains a simile?A. He was the rock of the familyB. Her finger was a woodpecker tapping on her chin.c. That is a big problem," Seth said with a sigh.d. Mindi stood stiffly like a board in a lumber yarde. Dad, you are the best father in the world," Seth said.f. You do not have to buy me something as soon as possible. Which of the following activities would be best-suited for a thinking mind map?defining priorities for a projecttaking notes from a lecture delivering a speechrecording results from web searches Which lines from Ovids "Pyramus and Thisbe" contain an example of characterization?ringed by the tall brick walls Semramishad builtso we are told.If you searched allthe East, you'd find no girl with greater charmthan Thisbe;The wall their houses shared had one thin crack,which formed when they were built and then was left;when firstlighthad banished night's bright star-fires from the skyand sun had left the brine-soaked meadows dry, Just say anything pls HELP The Romans were more maintainers of culture than inventors of culture. Agree or disagree with this statement. Which word best describes pops and coach moses? A? Demanding b) discouraging c) sentimmental d) supportive The length and width of a rectangle are shown below.50 X2x+10Please hurry Plz help ASAP !!!!!!!!! this is due tomorrow morning its probably easy i just didnt pay attention please help 2x+5=? when x is 3 what is the answer Is this a balanced equation? 4NH3+ 5O2 4NO + 5H20 A rectangle on a coordinate plane is translated 5 units up and 3 units to the left. Which rule describes the translation?(x, y) (x + 5, y 3)(x, y) (x + 5, y + 3)(x, y) (x 3, y + 5)(x, y) (x + 3, y + 5) A turntable rotates at 68 revolutions per minute. What is its angular speed in radians per second? Help me please, I have a asked this question a lot of times. Please!! HEY CAN ANYONE PLS ANSWER DIS!!! IN YO OWN WORDS!! In a parallel circuit, there is only one path for current to take. Please select the best answer from the choices provided T F Peter's family traveled 5/8 of the distance to his grandmothers house on Saturday. They traveled 2/3 of the remaining distance on Sunday. What fraction of the total distance to his grandmothers house was traveled on Sunday?