Martin Corporation’s expected sales revenue for the 4th quarter of 2023 is as follows: Oct ............. $400,000Nov............. 450,000Dec ............ 500,000 All sales are on account (credit) with 50 percent collected in the month of sale, 30 percent collected in the month after sale, and 20 percent collected in the second month after sale. Assume there are no uncollectable accounts. Martin's cash collections in December are expected to be.

Martin Corporation’s expected sales revenue for the 4th quarter of 2023 is as follows: Oct ............. $400,000Nov............. 450,000Dec ............ 500,000 All sales are on account (credit) with 50 percent collected in the month of sale, 30 percent collected in the month after sale, and 20 percent collected in the second month after sale. Assume there are no uncollectable accounts. Martin's cash collections in December are expected to be.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 9PB: Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May,...

See similar textbooks

Similar questions

Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Suppose that the Sales in December 2019 were 64,566. The sales are expected to grow by 6% in January 2020, by 17% in February 2020, and by 10% in March 2020. After that, the sales are expected to grow by 14%. The purchases are 10% of sales. The purchases will be paid in the same month. The general administrative expenses are $13,032 and will be paid in the same month. The depreciation expense is $6,611 per month. The interest expenses are $8,778 per quarter and will be paid in March, June, September, and December. What is the cash outflow for June, 2020?
Anusha Berhad’s sales pattern for the first quarter 2021 and projected revenues are as follows: Additional information:i. Historically, Anusha Berhad’s sales were on cash basis.ii. Anusha purchase raw material two month before the sales month and paid in cash equal to 60 percent of its sales.iii. Fixed monthly rent of RM11,000.iv. A depreciation expense is RM400 per month.v. Dividend of RM3,000 will be received at the end of each quarter.vi. Wages and salaries are estimated RM15,000 per month.vii. Anusha decide to repay RM40,000 of their loan on April.viii. Interest on accumulated loan is at 9 percent annual interest and paid in the following month.ix. Ending cash balance for the budget period is RM20,000 and it would like to maintain minimum desired balance of RM20,000 per month. Prepare a monthly cash budget for the first quarter 2021 for Anusha Berhad.
Paladin Furnishings generated $2 million in sales during 2019, and its year-end total assets were $1.4 million. Also, at year-end 2019, current liabilities were $500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and $100,000 of accrued liabilities. Looking ahead to 2020, the company estimates that its assets must increase by $0.70 for every $1.00 increase in sales. Paladin's profit margin is 5%, and its retention ratio is 35%. How large of a sales increase can the company achieve without having to raise funds externally? Write out your answer completely. For example, 25 million should be entered as 25,000,000. Do not round intermediate calculations. Round your answer to the nearest cent.
Noah’s ark video games expects sales to grow by 25% next year. Assume that it pays out 95% of its net income. Using the following statements and the percent of sales method, forecast accounts receivable
Noah’s ark video games expects sales to grow by 25% next year. Assume that it pays out 95% of its net income. Using the following statements and the percent of sales method, forecast accounts payable
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 180 $ 200 $ 220 $ 250 Sales for the first quarter of the following year are projected at $195 million. Accounts receivable at the beginning of the year were $77 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 25 percent of sales. Interest and dividends are $10 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $81 million cash balance and wishes to maintain a $40 million minimum balance. b-1. Complete the following short-term financial plan assuming that Wildcat maintains a minimum cash balance of $20 million.…
Paladin Furnishings generated $4 million in sales during 2018, andits year-end total assets were $3.2 million. Also, at year-end 2018, current liabilities were$500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and$100,000 of accrued liabilities. Looking ahead to 2019, the company estimates that its assetsmust increase by $0.80 for every $1.00 increase in sales. Paladin’s profit margin is 3%, andits retention ratio is 50%. How large of a sales increase can the company achieve withouthaving to raise funds externally?
Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first quarter of 2022.