The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $48,000. Required Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent and 4 percent. The results at a growth rate of 1 percent are shown as an example. Cash sales Sales on account Total budgeted sales 2 percent 4 Percent Sales Budget January $ 210,000 50,000 $ 60,000 Cash sales Sales on account Total budgeted sales Current cash sales. Plus collections from accounts receivable Total budgeted collections. Use the following forms, assuming a growth rate of 2 percent and 4 percent: Schedule of Cash Receipts Complete this question by entering your answers in the tabs below. Current cash sales Plus collections from accounts receivable Total budgeted collections January $ Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent. Sales Budget $ Schedule of Cash Receipts $ February $ 10,100 50,500 $ 60,600 10,000 50,000 60,000 January $ < 2 percent January $ 10,000 48,000 $ 58,000 10,000 48,000 58,000 March $ 10,201 51,005 $ 61,206 Growth rate of 2% February March Growth rate of 2% March February 50,000 February $ 10,100 50,000 $ 60,100 4 Percent > March $ 10,201 50,500 $ 60,701

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please do not give solution in image format thanku 

The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different
growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales
for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of
sale. Assume a beginning balance in accounts receivable of $48,000.
Required
Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2
percent and 4 percent. The results at a growth rate of 1 percent are shown as an example.
Cash sales
Sales on account
Total budgeted sales
Current cash sales
Plus collections from accounts receivable
Total budgeted collections
2 percent
Sales Budget
4 Percent
January
$ 210,000
50,000
$ 60,000
Cash sales
Sales on account
Total budgeted sales
Use the following forms, assuming a growth rate of 2 percent and 4 percent:
Schedule of Cash Receipts
Complete this question by entering your answers in the tabs below.
Current cash sales
Plus collections from accounts receivable
Total budgeted collections
$
Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent.
Sales Budget
January
$
Schedule of Cash Receipts
$
January
February
$ 10,100
50, 500
$ 60,600
10,000
50,000
60,000
$
< 2 percent
January
$ 10,000
48,000
$ 58,000
10,000
48,000
58,000
March
$ 10, 201
51,005
$ 61,206
Growth rate of 2%
February March
Growth rate of 2%
March
February
50,000
February
$ 10,100
50,000
$ 60,100
4 Percent >
March
$ 10,201
50,500
$ 60,701
Transcribed Image Text:The management team of Magnificent Modems, Incorporated (MMI) wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected to be $10,000. Credit sales for January are expected to be $50,000. MMI collects 100 percent of credit sales in the month following the month of sale. Assume a beginning balance in accounts receivable of $48,000. Required Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent and 4 percent. The results at a growth rate of 1 percent are shown as an example. Cash sales Sales on account Total budgeted sales Current cash sales Plus collections from accounts receivable Total budgeted collections 2 percent Sales Budget 4 Percent January $ 210,000 50,000 $ 60,000 Cash sales Sales on account Total budgeted sales Use the following forms, assuming a growth rate of 2 percent and 4 percent: Schedule of Cash Receipts Complete this question by entering your answers in the tabs below. Current cash sales Plus collections from accounts receivable Total budgeted collections $ Calculate the amount of sales and cash receipts for the months of February and March assuming a growth rate of 2 percent. Sales Budget January $ Schedule of Cash Receipts $ January February $ 10,100 50, 500 $ 60,600 10,000 50,000 60,000 $ < 2 percent January $ 10,000 48,000 $ 58,000 10,000 48,000 58,000 March $ 10, 201 51,005 $ 61,206 Growth rate of 2% February March Growth rate of 2% March February 50,000 February $ 10,100 50,000 $ 60,100 4 Percent > March $ 10,201 50,500 $ 60,701
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Receivables Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education