Prepare a cash budget for Atlas Products, Inc. for the first year of 20X2, based on the following information. The budgeting section of the corporate finance department of Atlas Products has received the following sales estimates from the marketing department: Total Sales Credit Sales December 20X1 $825,000 $770,000 January 20X2 730,000 690,000 February 20X2 840,000 780,000 March 20X2 920,000 855,000 The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payment for those purchases are budgeted to lag the purchases by 1 month. Various disbursements have been estimated as follows: 139 January February March Wages and salaries $250,000 $290,000 $290,000 Rent 27,000 27,000 27,000 Other expenses 10,000 12,000 14,000 In addition, a tax payment of $105,000 is due on January 15, and $40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a $75,000 piece of equipment. Delivery is scheduled for early January; and payment will be due in February. The company's projected cash balance at the beginning of January is $100,000, and the company desires to maintain a balance of $100,000 at the end of each month. 2.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
2.
Prepare a cash budget for Atlas Products, Inc. for the first year of 20X2, based on
the following information.
The budgeting section of the corporate finance department of Atlas Products
has received the following sales estimates from the marketing department:
Total Sales
Credit Sales
December 20X1
$825,000
$770,000
January 20X2
730,000
690,000
February 20X2
840,000
780,000
March 20X2
920,000
855,000
The company has found that, on average, about 25 percent of its credit sales are
collected during the month when the sale is made, and the remaining 75 percent of credit
sales are collected during the month following the sale. As a result, the company uses these
figures for budgeting.
The company estimates its purchases at 60 percent of next month's sales, and payment
for those purchases are budgeted to lag the purchases by 1 month.
Various disbursements have been estimated as follows:
139
January
February
March
Wages and salaries
$250,000
$290,000
$290,000
Rent
27,000
27,000
27,000
Other expenses
10,000
12,000
14,000
In addition, a tax payment of $105,000 is due on January 15, and $40,000 in dividends will
be declared in January and paid in March. Also, the company has ordered a $75,000 piece
of equipment. Delivery is scheduled for early January; and payment will be due in February.
The company's projected cash balance at the beginning of January is $100,000, and the
company desires to maintain a balance of $100,000 at the end of each month.
Transcribed Image Text:2. Prepare a cash budget for Atlas Products, Inc. for the first year of 20X2, based on the following information. The budgeting section of the corporate finance department of Atlas Products has received the following sales estimates from the marketing department: Total Sales Credit Sales December 20X1 $825,000 $770,000 January 20X2 730,000 690,000 February 20X2 840,000 780,000 March 20X2 920,000 855,000 The company has found that, on average, about 25 percent of its credit sales are collected during the month when the sale is made, and the remaining 75 percent of credit sales are collected during the month following the sale. As a result, the company uses these figures for budgeting. The company estimates its purchases at 60 percent of next month's sales, and payment for those purchases are budgeted to lag the purchases by 1 month. Various disbursements have been estimated as follows: 139 January February March Wages and salaries $250,000 $290,000 $290,000 Rent 27,000 27,000 27,000 Other expenses 10,000 12,000 14,000 In addition, a tax payment of $105,000 is due on January 15, and $40,000 in dividends will be declared in January and paid in March. Also, the company has ordered a $75,000 piece of equipment. Delivery is scheduled for early January; and payment will be due in February. The company's projected cash balance at the beginning of January is $100,000, and the company desires to maintain a balance of $100,000 at the end of each month.
Self-Test Problems:
1.
Use the percentage of sales forecasting method to compute the additional financing
needed by Lambrechts Specialty Shops, Inc. (LSS), if sales are expected to
increase from a current level of $20 million to a new level of $25 million over the
coming year. LSS expects earnings after taxes to equal $1 million over the next
year. LSS intends to pay a $300,000 dividend next year. The current year balance
sheet for LSS is as follows:
Lambrechts Specialty Shops, Inc.
138
Balance Sheet as of December 31, 20X3
cash
$1,000,000 Accounts payable
$3,000,000
Accounts receivable
1,500,000 Notes payable
3,000,000
inventories
6,000,000 Long-term debt
2,000,000
Net fixed assets
3,000,000 Stockholders' equity
3,500,00
Total Assets
$11,500,000 Total liabilities and equity
$11,500,000
All assets, except "cash", are expected to vary proportionately with sales. Of total liabilities
and equity, only “accounts payable" is expected to vary proportionately with sales.
Transcribed Image Text:Self-Test Problems: 1. Use the percentage of sales forecasting method to compute the additional financing needed by Lambrechts Specialty Shops, Inc. (LSS), if sales are expected to increase from a current level of $20 million to a new level of $25 million over the coming year. LSS expects earnings after taxes to equal $1 million over the next year. LSS intends to pay a $300,000 dividend next year. The current year balance sheet for LSS is as follows: Lambrechts Specialty Shops, Inc. 138 Balance Sheet as of December 31, 20X3 cash $1,000,000 Accounts payable $3,000,000 Accounts receivable 1,500,000 Notes payable 3,000,000 inventories 6,000,000 Long-term debt 2,000,000 Net fixed assets 3,000,000 Stockholders' equity 3,500,00 Total Assets $11,500,000 Total liabilities and equity $11,500,000 All assets, except "cash", are expected to vary proportionately with sales. Of total liabilities and equity, only “accounts payable" is expected to vary proportionately with sales.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Budgeting
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