Question

In: Finance

Use the following information to answer questions 27 - 32 Silly Sally, Inc. Silly Sally, Inc....

Use the following information to answer questions 27 - 32

Silly Sally, Inc.

Silly Sally, Inc. forecasts the following sales levels: January, $420; February, $435; March, $450; and April, $470. Historically, 40% of its sales are for cash. Of the remaining sales, 80% are collected in one month, 15% are collected in the second month, while the rest remain uncollected. November sales were $380 and December sales were $500. (all values $000)

Purchases are made at 60% of the next month’s sales forecast, and are paid for in the month of purchase. Other cash outlays are: rent, $10 monthly; wages and salaries, $50 monthly; a tax payment of $30 in March; an interest payment of $15 in March; and a planned purchase of $20 of new fixed assets in January.

27. Refer to Silly Sally, Inc. What is the forecasted amount to be collected from cash sales in March?

  1. $450

  2. $360

  3. $261

  4. $180

28. Refer to Silly Sally, Inc. What are forecasted total cash collection for January?

  1. $420

  2. $442

  3. $168

  4. $240

29. Suppose Silly Sally, Inc. forecasts an ending cash balance of $20, its minimum desired balance, in January. If February’s forecasted cash expenditures are $400, which of the following describes the changes to Silly Sally’s cash balance and level of borrowing, if any, related to its minimum cash balance, at the end of February?

  1. net cash flows of $21; borrowing will increase $21

  2. net cash flows of $21; borrowing will decrease $21

  3. net cash flows of $11; borrowing will increase $9

  4. net cash flows of $11; borrowing will decrease $9

30. What are Silly Sally’s forecasted cash outflows for February?

a. $270 b. $330 c. $395 d. $450

31. What is Silly Sally’s change in cash for March?

  1. $40 increase in cash

  2. $40 decrease in cash

  3. $85 increase in cash

  4. $20 increase in cash

32. Suppose Silly Sally experiences a change in customer payment patterns in accounts receivable, so that payments are now 30% in cash, and of the credit sales, 60% are collected in one month, 35% are collected in the second month, with the rest uncollected. What is the new forecasted collection for January, and how much is this different from the original forecast?

  1. $408; $72 higher

  2. $336; $93 lower

  3. $442; $13 higher

  4. $429; $13 lower

Solutions

Expert Solution

Month November December January February March April
sales 380 500 420 435 450 470
purchase-60% of next month sales 300 252 261 270 282
cash collection
cash sales -40% of the month sale 168 174 180 188
collection of credit sales-60% of month sales
80% of credit sales in the first month of sales 240 202 209 216
15% of credit sales in the second month of sales 34.2 45 38 39
total credit sales collection 274.2 247 247 255
total cash collection = cash sales collection+total credit sales collection 442.2 421 427 443
disbursement:
payment towards purchase 168 270 282 188
rent 10 10 10 10
wages and salaries 50 50 50 50
tax payment 30
interest payment 15
purchase of fixed asset 20
total disbursement of expense 248 330 387 248
net cash available = total cash collection-total disbursement of expenses 194.2 91 40 195
27- What is the forecasted amount to be collected from cash sales in March 180
28- What are forecasted total cash collection for January 442
29- total cash collection+minimum cash balance-payment in february-minimum cash balance 421+20-400-20 21 net cash flows of $21; borrowing will decrease $21
30- What are Silly Sally’s forecasted cash outflows for February 330
31- What is Silly Sally’s change in cash for March 40 increase in cash
32- What is the new forecasted collection for January, and how much is this different from the original forecast 442-429 13 429,13 lower
33-
November December January
380 500 420
300 252 0
cash collection January
cash sales -30% of the month sale 420*30% 126
collection of credit sales-70% of month sales
60% of credit sales in the first month of sales 500*70%*60% 210
35% of credit sales in the second month of sales 380*70%*35% 93.1
total credit sales collection 303.1
total cash collection = cash sales collection+total credit sales collection 429.1 0

jeff jeffy answered 6 months ago
Next > < Previous

Related Solutions

27.) Use the following information to answer questions 27 & 28: A statistics teacher wants to...
27.) Use the following information to answer questions 27 & 28: A statistics teacher wants to see if there is any difference in the performance of students on the final exam if she gives them orange jelly beans before the exam. She has a theory that orange jelly beans will change the results, but she isn't sure in which direction. She knows that the population mean score on the exam when students do not have orange jelly beans is 82...
Use the following information about Valerie Sporty to answer Questions 28 – 32. Valerie Sporty has...
Use the following information about Valerie Sporty to answer Questions 28 – 32. Valerie Sporty has just acquire a brand-spanking new, shiny red sports car (for her business, of course) at a cash price of $70,000. She put a certain amount down and financed the balance with a note requiring that Valerie make five equal year-end payments to retire the debt. A partial amortization table is as follows: Period Payment Interest Principal Carrying Value 0 $60,000 1 $15,426 $5,400 $10,026...
Required information Use the following information to answer questions [The following information applies to the questions...
Required information Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 31,000 $ 30,000 Work in process 9,500 18,200 Finished goods 54,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 197,000 Factory payroll (paid with cash) 200,000 Factory overhead Indirect materials...
Use the following information for ABC Inc. the answer the following questions (the applicable tax rate...
Use the following information for ABC Inc. the answer the following questions (the applicable tax rate is 34%): 2017 2018 Sales 23,146,000 25,872,000 Depreciation 3,322,000 3,472,000 Cost of Goods Sold 7,958,000 9,414,000 Other Expenses 1,892,000 1,648,000 Interest 1,552,000 1,852,000 Cash 12,134,000 12,932,000 Accounts Receivable 16,068,000 18,854,000 Short-term Notes Payable 3,422,000 2,294,000 Long-term Debt 40,640,000 49,392,000 Net Fixed Assets 101,776,000 108,546,000 Accounts Payable 8,768,000 9,288,000 Inventory 28,566,000 30,576,000 Dividends 2,822,000 3,236,000 Draw up a statement of comprehensive income and statement of...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 48,000 $ 48,000 Work in process 9,900 19,700 Finished goods 67,000 33,700 Activities and information for May Raw materials purchases (paid with cash) 194,000 Factory payroll (paid with cash) 150,000 Factory overhead Indirect materials 14,000 Indirect...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 44,000 $ 54,000 Work in process 9,500 18,800 Finished goods 59,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 185,000 Factory payroll (paid with cash) 250,000 Factory overhead Indirect materials 10,000 Indirect...
Use the following information to answer questions 12-13 [The following information applies to the questions displayed...
Use the following information to answer questions 12-13 [The following information applies to the questions displayed below.] On May 1, Donovan Company reported the following account balances: Current assets $ 130,000 Buildings & equipment (net) 260,000 Total assets $ 390,000 Liabilities $ 98,500 Common stock 150,000 Retained earnings 141,500 Total liabilities and equities $ 390,000 On May 1, Beasley paid $465,200 in stock (fair value) for all of the assets and liabilities of Donovan, which will cease to exist as...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT