Question

Please post answers and indicate: Net income, total asset turnover, equity multiplier, ROA, and ROE

You are considering investing in Dakota's Security Services. You have been able to locate the following information on the firm: Total assets are $33 4 mililion, accounts receivable are $4.54 milifion, ACP is 25 days, net income is $4.80 million, and debt-to-equity is 12 times. All sales are on credit. Dakota's is considering loosening its credit policy such that ACP will increase to 30 days. The change is expected to increase credit sales by 5 percent Any change in accounts receivable will be offset with a change in debt. No other balance sheet changes are expected. Dakota's profit margin will remain unchanged How will this change in accounts receivable policy affect Dakota's net income, total asset turnover, equity multiplier, ROA, and ROE? Do not round intermediate calculetions. Enter your answer in millions of dollars. Round your answers to 2 decimal places. Use 365 days a year.) Net income Totai asset turnover Equity multipler ROA ROE milion increase times laster tmes more % rncrease

Answer 1

Given,

• Total assets = $33.4 million
• accounts receivable = $4.54 million
• ACP = 25 days
• net income = $4.80 million
• debt-to-equity = 1.2
• All sales are on credit.
• ACP is changing to 30 days
• The change in ACP is expected to increase credit sales by 5%
• Any change in receivable will be off set by change in debt
• profit margin will remain same

Calculation of sales:

average accounts receivable turnover = 365/ accounts receivable turnover ratio

25 = 365/ accounts receivable turnover ratio

accounts receivable turnover ratio = 365/ 25 = 14.6

accounts receivable turnover ratio = net credit sales/ average accounts receivable

14.6 = net credit sales/ $4.54 million

net credit sales = 14.6 * $4.54 million = $66.284 million

Therefore sales = $66.284 million

Calculation of Profit margin:

Profit margin = net income/ sales

= $4.80 million/ $66.284 million = 0.072415 = 7.24%

Profit margin = 7.24%

Calculation of total debt and total equity:

Debt to equity ratio = total debt/ total equity

1.2 = total debt/ total equity

1.2 = total debt/ (total assets - total debt)

1.2 (total assets - total debt) = total debt

1.2 ($33.4 million - total debt) = total debt

$40.08 million - 1.2 total debt = total debt

$40.08 million = total debt + 1.2 total debt =2.2 total debt

2.2 total debt = $40.08 million

total debt = $40.08 million/ 2.2 =$18.2181 million

total debt =$18.2 million

Therefore, total equity = total assets - total debt = $33.4 million - $18.2 million = $15.2 million

total equity = $15.2 million

Change in sales because of change in ACP:

Sales = $66.284 million

increase in sales = 5%

New sales = $66.284 million * 105% = $69.5982 million = $69.6 million

New profit = new sales * profit margin = = $69.6 million * 7.24% = $5.039 million = $5.04 million

average accounts receivable turnover = 365/ accounts receivable turnover ratio

30= 365/ accounts receivable turnover ratio

accounts receivable turnover ratio = 365/ 30 = 12.166

accounts receivable turnover ratio = new credit sales/ new average accounts receivable

12.166 = $69.6 million/ new average accounts receivable

new average accounts receivable= $69.6 million/ 12.166

new average accounts receivable = $5.72 million

Change in average accounts receivable = new average accounts receivable - old average accounts receivable

= $5.72 million - $4.54 million = $1.18 million

New debt = old debt + Change in average accounts receivable = $18.2 million + $1.18 million = $19.38 million

Calculations:

New net income = $5.04 million

New total assets turnover = new sales/ average total assets = $69.6 million/ $33.4 million = 2.083

Equity multiplier = total assets/ total equity = $33.4 million/ $15.2 million = 2.1973

Return on assets = net income/ total assets = $5.04 million/ $33.4 million = 0.15089 = 15.089%

Return on equity = net income/ total equity = $5.04 million/ $15.2 million = 0.33157 = 33.157%