Q1 Q2 Q3 Q4
Sales $315 $390 $475 $435
Total cash disbursement $265 $340 $560 $375
Cash Collections $385 $363 $445 $449
Complete the following cash budget for the company.
Q1 Q2 Q3 Q4
Beginning receivables
Sales
Cash collections
Ending receivables
Total cash collections
Total cash disbursements
Net cash inflow
Beginning cash balance
Net cash inflow
Ending cash balance
Minimum cash balance
Cumulative surplus (deficit)
Compute the accounts receivables turnover (ART) ratio, using the equation as shown below:
ART ratio = Net credit sales/ Average receivables
= $375,000/ $68,000
= 5.51470588
Hence, the ART ratio is 5.51470588.
Compute the annual percentage rate (APR), using the equation as shown below:
APR = (ART ratio*Discounting factor)/
= (5.51470588*3%)/ (1 – 0.03)
= 0.17055791388
Hence, the APR is 0.17055791388.
Compute the effective cost of factoring, using the equation as shown below:
Effective cost = [1 + {Discounting factor/(1 – Discounting factor)}]ATR – 1
= [1 + {3%/(1 – 0.03)}]5.51470588 – 1
= (1.03092783505)5.51470588 – 1
= 1.182905346 – 1
= 0.182905346 or 18.2905346%
Hence, the effective factoring cost is 18.2905346%
The average credit sales for Jiffy Co. is $375,000. Accounts receivables average balance is $68,000. Jiffy...
Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash balance of $30 million, which is what the company currently has on hand. The company currently has a receivables balance of $194 million and has developed the following sales and cash disbursement budgets in millions: Q1 02 3 Q4 $423 S495 $576 $540 322 440 686 445 Sales Total cash disbursement Complete the following cash budget for the company. (A negative answer should be...
Hurzdan, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $40 million, which is what the company currently has on hand. The company currently has a receivables balance of $195 million and has developed the following sales and cash disbursement budgets (in millions): Q1Q2Q3Q4 Sales$432$504$585$549 Total cash disbursement290441686455 Complete the following cash budget for the company. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions rounded to...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 790 $ 820 $ 900 $ 980 a. Accounts receivable at the beginning of the year are $380. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
The Litzenberger Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 690 $ 720 $ 800 $ 870 a. Accounts receivable at the beginning of the year are $270. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by...
The Bass Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $540 $630 $590 $840 Required: (a) Accounts receivable at the beginning of the year are $295. Bass has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following (Do not round intermediate calculations. Round your answers to the nearest dollar amount (e.g., 32)): Q1 Q2 Q3 Q4 Beginning receivables $ $ $ $ Sales...
King Fisher Aviation has projected the following quarterly sales amounts for the coming year: Quarter 1 $750 Quarter 2 $820 Quarter 3 $790 Quarter 4 $950 Accounts Receivable at the beginning of the year are $350. King Fisher has a 30-day collection period. Calculate the cash collections in each of the four quarters by completing the following for each quarter Beginning receivables Sales Cash Collections Ending Receivables Rework the Ending Receivables calculation using 45 and 60 days What do you...
You have recently beenhired by Piepkorn Manufacturing to work in its newly established treasury department. Piepkorn Manufacturing is a small company that produces cardboard oxes in a variety of sizes. Gary Piepkom, the owner of the company, works primarily in the sales and production areas. Currently, the company puts all receivables in one shoe box and all payables in another. Because of the disorganized system, the finance area needs work, and that's what you've been brought in to do. The...
Use the following information to complete the quarterly cash budget. Please be sure to read all instructions very carefully. • Jazzy Pet Treats, Inc. specializes in gourmet pet treats and receives all income from sales • Sales estimates (in millions, round all line items to the nearest million, except, in Stage 2 when you get to the $162.5 value, round one up and one down of course) – Q1 = 500 – Q2 = 600 – Q3 = 650 –...
please answer b1 and b2 Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 155 $ 175 $ 195 $ 225 Sales for the first quarter of the year after this one are projected at $170 million. Accounts receivable at the beginning of the year were $67 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales for the first quarter of the following year are projected at $145 million. Accounts receivable at the beginning of the year were $57 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 20 percent...