Question

In: Finance

Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in 2019, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2018, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 6%, and the forecasted retention ratio is 30%. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest cent.

Solutions

Expert Solution

Carlsbad's additional funds needed for the coming year

Expected Next Year Sales = $6,000,000

After Tax profit Margin

After Tax profit Margin = Expected Next Year Sales x Profit Margin

= $6,000,000 x 6%

= $360,000

Additions to Retained Earnings

Additions to Retained Earnings = After Tax profit Margin x Retention Ratio

= $360,000 x 30%

= $108,000

Increase in Total Assets

Increase in Total Assets = Total Assets x Percentage of Increase in sales

= $4,000,000 x 20%

= $800,000

Increase in Spontaneous liabilities

Increase in Spontaneous liabilities = [Accounts Payable + Accruals] x Percentage of Increase in sales

= [$250,000 + $250,000] x 20%

= $500,000 x 20%

= $100,000

Additional Funds Needed [AFN]

Therefore, the Additional Funds Needed [AFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings

= $80,0000 - $100,000 - $108,000

= $592,000

“Hence, Carlsbad's additional funds needed for the coming year will be $592,000”


Related Solutions

Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in 2019, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2018, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%, and the...
Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in 2019, or by 20%. Its assets totaled $2 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2018, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 6%, and the...
Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2018 to $6 million in 2019, or by 20%. Its assets totaled $4 million at the end of 2018. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2018, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%. Assume that...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $2 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%, and the...
Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $2 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%. Assume that...
Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%. Assume that...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $4 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%. Assume that...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $4 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%, and the...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $4 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%. sume that...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in...
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $5 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%, and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT