Quantitative Problem 1: Beasley Industries' sales are expected to increase from $4 million in 2019 to $5 million in 2020, or by 25%. Its assets totaled 3 million at the end of 2019. Beasley is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $760,000, consisting of $170,000 of accounts payable, $500,000 of notes payable, and $90,000 of accrued liabilities. Its profit margin is forecasted to be 4%, and its dividend payout ratio is 50%. Using the AFN equation, forecast the additional funds Beasley will need for the coming vear. Do not round intermediate calculations. Round vour answer to the nearest dollar. The AFN equation assumes that ratios remain constant. However, firms are not always operating at full capacity so adjustments need to be made to the existing asset forecast. Excess capacity adjustments are changes made to the existing asset forecast because the firm is not operating at full capacity. For example, a firm may not be at full capacity with respect to its fixed assets. First, the firm's management must find out the firm's full capacity sales as follows: Full capacity sales = Aetal sales Percentage of capacity at which fired assets were operated Next, management would calculate the firm's target fixed assets ratio as follows: Total fired eta Actual fixed aseta Sales Full capacity aales Finally, management would use the target fixed assets ratio with the projected sales to calculate the firm's required level of fixed assets as follows: Required level of fixed assets (Target fixed assets/Sales) x Projected sales

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
**Quantitative Problem 1:**

Beasley Industries' sales are expected to increase from $4 million in 2019 to $5 million in 2020, or by 25%. Its assets totaled $3 million at the end of 2019. Beasley is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $760,000, consisting of $170,000 of accounts payable, $500,000 of notes payable, and $90,000 of accrued liabilities. Its profit margin is forecasted to be 4%, and its dividend payout ratio is 50%. Using the AFN equation, forecast the additional funds Beasley will need for the coming year. Do not round intermediate calculations. Round your answer to the nearest dollar.

*Answer:* \$ __________

The AFN equation assumes that ratios remain constant. However, firms are not always operating at full capacity so adjustments need to be made to the existing asset forecast. Excess capacity adjustments are changes made to the existing asset forecast because the firm is not operating at full capacity. For example, a firm may not be at full capacity with respect to its fixed assets. First, the firm's management must find out the firm's full capacity sales as follows:

**Full capacity sales =** (Actual sales) / (Percentage of capacity at which fixed assets were operated)

    Total fixed assets / Sales = Actual fixed assets / Full capacity sales

Next, management would calculate the firm's target fixed assets ratio as follows:

Finally, management would use the target fixed assets ratio with the projected sales to calculate the firm’s required level of fixed assets as follows:

**Required level of fixed assets = (Target fixed assets/Sales) × Projected sales**

**Quantitative Problem 2:**

Mitchell Manufacturing Company has $1,600,000,000 in sales and $390,000,000 in fixed assets. Currently, the company's fixed assets are operating at 70% of capacity.

a. What level of sales could Mitchell have obtained if it had been operating at full capacity? Do not round intermediate calculations. Round your answer to the nearest dollar.

*Answer:* \$ __________

b. What is Mitchell's Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to two decimal places.

*Answer:* __________%

c. If Mitchell's sales increase by 50%, how large of an increase in fixed assets will the company need
Transcribed Image Text:**Quantitative Problem 1:** Beasley Industries' sales are expected to increase from $4 million in 2019 to $5 million in 2020, or by 25%. Its assets totaled $3 million at the end of 2019. Beasley is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $760,000, consisting of $170,000 of accounts payable, $500,000 of notes payable, and $90,000 of accrued liabilities. Its profit margin is forecasted to be 4%, and its dividend payout ratio is 50%. Using the AFN equation, forecast the additional funds Beasley will need for the coming year. Do not round intermediate calculations. Round your answer to the nearest dollar. *Answer:* \$ __________ The AFN equation assumes that ratios remain constant. However, firms are not always operating at full capacity so adjustments need to be made to the existing asset forecast. Excess capacity adjustments are changes made to the existing asset forecast because the firm is not operating at full capacity. For example, a firm may not be at full capacity with respect to its fixed assets. First, the firm's management must find out the firm's full capacity sales as follows: **Full capacity sales =** (Actual sales) / (Percentage of capacity at which fixed assets were operated) Total fixed assets / Sales = Actual fixed assets / Full capacity sales Next, management would calculate the firm's target fixed assets ratio as follows: Finally, management would use the target fixed assets ratio with the projected sales to calculate the firm’s required level of fixed assets as follows: **Required level of fixed assets = (Target fixed assets/Sales) × Projected sales** **Quantitative Problem 2:** Mitchell Manufacturing Company has $1,600,000,000 in sales and $390,000,000 in fixed assets. Currently, the company's fixed assets are operating at 70% of capacity. a. What level of sales could Mitchell have obtained if it had been operating at full capacity? Do not round intermediate calculations. Round your answer to the nearest dollar. *Answer:* \$ __________ b. What is Mitchell's Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to two decimal places. *Answer:* __________% c. If Mitchell's sales increase by 50%, how large of an increase in fixed assets will the company need
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
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