Hello Bartleby team,

I've gone ahead and attached a screenshot of my question.

Please note: The screenshot image with the Quantitative Problem is the question needing to be answered. The other screenshot is for reference if you need any of the information from that page.

Let me know if you need any further details. Thank you for any answers and/or explanations you may provide!
Transcribed Image Text:CENGAGE MINDTAP Q Search this course Ch 17- Blueprint Problems - Financial Planning and Forecasting Back to Assignment Attempts Keep the Highest / 18 1. Financial Planning and Forecasting: The AFN Equation: Introduction Managers use projected financial statements in four principal ways. (1) They use the projected statements to assess whether the firm's anticipated performance is in line with its own internal targets and with investors' expectations. (2) They use them to estimate the impact of proposed operating changes. (3) They use them to anticipate the firm's future financing needs and to arrange necessary financing. (4) Finally, they use them to estimate free cash flows, which determine the firm's overall value. Managers forecast free cash flows under different operating plans, forecast their capital requirements, and then choose the plan that maximizes shareholder value. Security analysts make the same types of projections as managers, and influence investors, who determine the future of firms' managers. Increasing sales require additional assets, these assets must be financed, and it may or may not be possible to obtain all the funds needed for the firm's business plan. A key element in the financial forecasting process is to determine the external v financing requirements through the AFN equation. Additional funds needed are the amount of external v capital (interest-bearing debt and preferred and common stock) that will be necessary to acquire the required assets. The AFN equation approximates the funds needed assuming that ratios remain constant v. The AFN equation is written as follows: Additional Spontaneous Projected = increase Increase in funds increase in retained needed, or AFN in assets liabilities earnings AFN = (Ao */So)AS - (Lo */So)AS - MS;(1 - Payout) The AFN equation shows the relationship of external v funds needed by a firm to its projected increase in assets, the spontaneous increase in liabilities, and the increase in retained earnings. Rapidly growing companies require larger increases in assets; v growth is an important factor to the firm's AFN. The capital intensity v ratio is the ratio of assets required per dollar of sales. Companies with higher assets-to-sales ratios require more assets for a given increase in other things held constant, so sales sales, hence a greater v need for external financing. Spontaneously generated v funds arise out of normal business operations from its suppliers, employees, and the government that reduce the firm's need for external financing. The higher v the profit margin, the larger the net income available to support increases in assets, hence the smaller v the need for external financing. The retention v ratio is the proportion of net income that is reinvested in the firm, and it is calculated as 1 minus the dividend payout ratio v. The higher the retention v ratio, the lower the firm's AFN. The sustainable v growth rate is the maximum achievable growth rate without the firm having to raise external funds. In other words, it is the growth rate at which the firm's AFN equals zero.
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 $2 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 $770,000, consisting of $150,000 of accounts payable, $450,000 of notes payable, and $170,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. $ 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: Actual sales Full capacity sales = Percentage of capacity at which fixed assets were operated Next, management would calculate the firm's target fixed assets ratio as follows: Total fixed assets Actual fixed assets Full capacity sales Sales 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 Quantitative Problem 2: Mitchell Manufacturing Company has $1,600,000,000 in sales and $290,000,000 in fixed assets. Currently, the company's fixed assets are operating at 75% 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. 24 b. What is Mitchell's Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to two decimal places. % c. If Mitchell's sales increase by 35%, how large of an increase in fixed assets will the company need to meet its Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to the nearest dollar.

Question

Hello Bartleby team,

I've gone ahead and attached a screenshot of my question.

Please note: The screenshot image with the Quantitative Problem is the question needing to be answered. The other screenshot is for reference if you need any of the information from that page.

Let me know if you need any further details. Thank you for any answers and/or explanations you may provide!

CENGAGE MINDTAP
Q Search this course
Ch 17- Blueprint Problems - Financial Planning and Forecasting
Back to Assignment
Attempts
Keep the Highest / 18
1. Financial Planning and Forecasting: The AFN Equation: Introduction
Managers use projected financial statements in four principal ways. (1) They use the projected statements to assess whether the firm's anticipated performance is in line with its own internal targets and with investors' expectations. (2) They use them to
estimate the impact of proposed operating changes. (3) They use them to anticipate the firm's future financing needs and to arrange necessary financing. (4) Finally, they use them to estimate free cash flows, which determine the firm's overall value.
Managers forecast free cash flows under different operating plans, forecast their capital requirements, and then choose the plan that maximizes shareholder value. Security analysts make the same types of projections as managers, and influence investors,
who determine the future of firms' managers.
Increasing sales require additional assets, these assets must be financed, and it may or may not be possible to obtain all the funds needed for the firm's business plan. A key element in the financial forecasting process is to determine the external v
financing requirements through the AFN equation. Additional funds needed are the amount of external v capital (interest-bearing debt and preferred and common stock) that will be necessary to acquire the required assets. The AFN equation approximates
the funds needed assuming that ratios remain constant v. The AFN equation is written as follows:
Additional
Spontaneous
Projected
= increase
Increase in
funds
increase in
retained
needed, or AFN
in assets
liabilities
earnings
AFN = (Ao */So)AS - (Lo */So)AS - MS;(1 - Payout)
The AFN equation shows the relationship of external v funds needed by a firm to its projected increase in assets, the spontaneous increase in liabilities, and the increase in retained earnings. Rapidly growing companies require larger increases in assets;
v growth is an important factor to the firm's AFN. The capital intensity v ratio is the ratio of assets required per dollar of sales. Companies with higher assets-to-sales ratios require more assets for a given increase in
other things held constant, so sales
sales, hence a greater v need for external financing. Spontaneously generated v funds arise out of normal business operations from its suppliers, employees, and the government that reduce the firm's need for external financing. The higher v the profit
margin, the larger the net income available to support increases in assets, hence the smaller v the need for external financing. The retention v ratio is the proportion of net income that is reinvested in the firm, and it is calculated as 1 minus the
dividend payout ratio v. The higher the retention v ratio, the lower the firm's AFN. The sustainable v growth rate is the maximum achievable growth rate without the firm having to raise external funds. In other words, it is the growth rate at which the firm's
AFN equals zero.

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 $2 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 $770,000, consisting of $150,000 of accounts payable, $450,000 of notes payable, and $170,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.
$
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:
Actual sales
Full capacity sales =
Percentage of capacity
at which fixed assets
were operated
Next, management would calculate the firm's target fixed assets ratio as follows:
Total fixed assets
Actual fixed assets
Full capacity sales
Sales
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
Quantitative Problem 2: Mitchell Manufacturing Company has $1,600,000,000 in sales and $290,000,000 in fixed assets. Currently, the company's fixed assets are operating at 75% 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.
24
b. What is Mitchell's Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to two decimal places.
%
c. If Mitchell's sales increase by 35%, how large of an increase in fixed assets will the company need to meet its Target fixed assets/Sales ratio? Do not round intermediate calculations. Round your answer to the nearest dollar.

Accepted Answer

Additional Funds Needed:

Additional funds needed is a business concept applied when a firm looks to…

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. 24