Green Caterpillar Garden Supplies Inc. has the following end-of-year balance sheet: Green Caterpillar Garden Supplies Inc. Balance Sheet For the Year Ended on December 31 Assets Liabilities Current Assets: Current Liabilities: Cash and equivalents Accounts payable Accounts receivable Accrued liabilities Inventories: Total Current Assets Net Fixed Assets: Net plant and equipment (cost minus depreciation) Total Assets, $150,000 400,000 350,000 $900,000 $2,100,000 $3,000,000 Notes payable D Total Current Liabilities Long-Term Bonds Total Debt Common Equity Common stock Retained earnings Total Common Equity Total Liabilities and Equity $250,000 150,000 100,000 $500,000 1,000,000 $1,500,000 800,000 700,000 $1,500,000 $3,000,000
Green Caterpillar Garden Supplies Inc. has the following end-of-year balance sheet: Green Caterpillar Garden Supplies Inc. Balance Sheet For the Year Ended on December 31 Assets Liabilities Current Assets: Current Liabilities: Cash and equivalents Accounts payable Accounts receivable Accrued liabilities Inventories: Total Current Assets Net Fixed Assets: Net plant and equipment (cost minus depreciation) Total Assets, $150,000 400,000 350,000 $900,000 $2,100,000 $3,000,000 Notes payable D Total Current Liabilities Long-Term Bonds Total Debt Common Equity Common stock Retained earnings Total Common Equity Total Liabilities and Equity $250,000 150,000 100,000 $500,000 1,000,000 $1,500,000 800,000 700,000 $1,500,000 $3,000,000
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 14M
Related questions
Question
![Green Caterpillar Garden Supplies Inc. has the following end-of-year balance sheet:
Green Caterpillar Garden Supplies Inc. Balance Sheet For the Year Ended on December 31
Assets
Liabilities
Current Assets:
Current Liabilities:
Cash and equivalents
Accounts payable
Accounts receivable
Accrued liabilities
Inventories
Total Current Assets
Net Fixed Assets:
Net plant and equipment
(cost minus depreciation)
Total Assets
$150,000
400,000
350,000
$900,000
$2,100,000
$3,000,000
Notes payable
Total Current Liabilities
Long-Term Bonds
Total Debt
Common Equity
Common stock
Retained earnings
Total Common Equity
Total Liabilities and Equity
$250,000
150,000
100,000
$500,000
1,000,000
$1,500,000
800,000
700,000
$1,500,000
$3,000,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F12eb5733-79a5-4c98-a8f1-6dfd47796cde%2F68b45c37-875d-4faf-86f9-cd03f902d4a3%2Fn5fzz3q_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Green Caterpillar Garden Supplies Inc. has the following end-of-year balance sheet:
Green Caterpillar Garden Supplies Inc. Balance Sheet For the Year Ended on December 31
Assets
Liabilities
Current Assets:
Current Liabilities:
Cash and equivalents
Accounts payable
Accounts receivable
Accrued liabilities
Inventories
Total Current Assets
Net Fixed Assets:
Net plant and equipment
(cost minus depreciation)
Total Assets
$150,000
400,000
350,000
$900,000
$2,100,000
$3,000,000
Notes payable
Total Current Liabilities
Long-Term Bonds
Total Debt
Common Equity
Common stock
Retained earnings
Total Common Equity
Total Liabilities and Equity
$250,000
150,000
100,000
$500,000
1,000,000
$1,500,000
800,000
700,000
$1,500,000
$3,000,000
![The firm is currently in the process of forecasting sales, asset requirements, and required funding for the coming year. In the year that just ended,
Green Caterpillar Garden Supplies Inc. generated $500,000 net income on sales of $14,000,000. The firm expects sales to increase by 18% this
coming year and also expects to maintain its long-run dividend payout ratio of 45%.
Suppose Green Caterpillar Garden Supplies Inc.'s assets are fully utilized. Use the additional funds needed (AFN) equation to determine the increase in
total assets that is necessary to support Green Caterpillar Garden Supplies Inc.'s expected sales. (Note: Do not round intermediate calculations.)
O $621,000
O $432,000
O $540,000
O $459,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F12eb5733-79a5-4c98-a8f1-6dfd47796cde%2F68b45c37-875d-4faf-86f9-cd03f902d4a3%2F3y2tolq_processed.jpeg&w=3840&q=75)
Transcribed Image Text:The firm is currently in the process of forecasting sales, asset requirements, and required funding for the coming year. In the year that just ended,
Green Caterpillar Garden Supplies Inc. generated $500,000 net income on sales of $14,000,000. The firm expects sales to increase by 18% this
coming year and also expects to maintain its long-run dividend payout ratio of 45%.
Suppose Green Caterpillar Garden Supplies Inc.'s assets are fully utilized. Use the additional funds needed (AFN) equation to determine the increase in
total assets that is necessary to support Green Caterpillar Garden Supplies Inc.'s expected sales. (Note: Do not round intermediate calculations.)
O $621,000
O $432,000
O $540,000
O $459,000
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning