Question

A company collects 50% of its sales during the month of the sale, 40% one month...

A company collects 50% of its sales during the month of the sale, 40% one month after the sale, and 10% two months after the sale. The company expects sales of PhP50,000 in August, PhP80,000 in September, PhP70,000 in October, and PhP60,000 in November. The following income statement items of the company are: sales of PhP502,500; operating expenses of PhP101,150; the cost of goods sold of PhP350,250; and interest expense of PhP7,500. Furthermore, the company has a debt ratio of 0.47, noncurrent liabilities of PhP20,000, and total assets of PhP70,000.

a) How much money is expected to be collected in October?

b) How much are the Accounts Receivable by the end of November?

b) If the firm’s income tax rate is 40%, what is the amount of the firm’s income tax liability?

c) What is the company's level of current liabilities? 12900

Homework Answers

Answer #1

Money expected to be collected in October:

Octobers Collection: 70000*50%=35000

Septembers Collection: 80000*40%=32000

Augusts Collection: 50000*10%=5000

Total October Collection=35000+32000+5000 = PhP72,000

Accounts Receivable by the end of November:

Novembers Outstanding: 60000*50%=30000

Octobers Outstanding: 70000*10%=7000

Total Accounts Receivable by the end of November:30000+7000 = PhP37,000

The amount of the firm’s income tax liability:

sales of PhP502,500 - the cost of goods sold of PhP350,250- operating expenses of PhP101,150- interest expense of PhP7,500

=43600*Tax rate

=43600*40%

=PhP17,440

The company's level of current liabilities = Total Assets*Debt ratio-Non Current Liabilities

=(70000*0.47)-20000

=PhP12,900

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month...
ABC Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Credit sales are for the last 6 months are as follows: July $60,000 August $70,000 September $80,000 October $90,000 November $100,000 December $85,000 the estimated total cash collections during october from accounts receivable would be
7. Baker Company started business in October and collects 60% of its accounts receivable in the...
7. Baker Company started business in October and collects 60% of its accounts receivable in the month of sale; 30% the following month; 5% the month after that; and 5% never collected. If all sales are on account and October sales were $60,000; November sales were $80,000; and December sales were $100,000. IF January sales were $120,000 how much total cash would Baker collect in January? a. $80,000 b. $94,000 c. $100,000 d. $106,000 e. None of the above
Assume that a company estimates $200,000 sales for the month of September and $240,000 sales for...
Assume that a company estimates $200,000 sales for the month of September and $240,000 sales for the month of October. The company predicts that 60% of the cash from these sales will be collected one month following the sale and the remaining part will be collected two months after the sale. The beginning cash balance for October is forecasted to be $20,000. Each month $80.000 of expense will be incurred. If the minimum cash requirement is $60.000, what would be...
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000...
1) Budgeted sales (in units) for the Rockwall Energy Drink Company are as follows: September 45,000 units October 60,000 units November 40,000 units December 75,000 units The company wishes to have 10% of the next month’s sales on hand at the end of each month. How much is budgeted production for November? A) 43,500 units B) 40,000 units C) 47,500 units D) 36,000 units 2) SalaRita’s sales are 32% cash and 68% credit. Of the credit sales, 40% of credit...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $296,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month...
Moore Inc. had the following historical pattern for its credit sales: 70% collected in the month of sale 20% collected in the firs month after sale 8% collected in the second month after sale 2% uncollectible The sales on open account (credit sales) have been budgeted for the last four months of the year as shown below: September $12,000 October $13,000 November $10,000 December $12,000 Required: a. The estimated total cash collections by the company during December from accounts receivable...
ABC Company was organized on August 1 of the current year. Projected sales for the next...
ABC Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August   $250,000 September     200,000 October     275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections for August, September, and October. ABC Company Schedule of Collections from Sales...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business—September, October, and November—are $234,000, $316,000, and $417,000, respectively. The company expects to sell 25% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month of the sale and 30% in the month following the sale. The cash collections in November are a.$218,925 b.$104,250 c.$394,275 d.$473,130
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the...
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business are $235,000, $320,000, and $426,000, respectively, for September, October, and November. The company expects to sell 25% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month of the sale and 30% in the month following the sale. The cash collections in November are a.$106,500 b.$223,650 c.$482,580 d.$402,150