Question

Problem SFP4-2 FINANCIAL PLANNING AND GROWTH CONSIDERATIONS Clueless, Inc. Balance Sheet at 12/31/2019 (000's) Cash & Marketable Securities 60 Accounts Payable 50 Accounts Receivable Long-Term Debt 293 Inventories 150 Total Liabilities Total Current Assets 321 Common Stock 145 Net Fixed Assets 250 Retained Earnings 83 Total Assets 571 Total Liabilities and Capi 571 Additional considerations: Sales for 2019 were $1,000,000; Net Income after Tax = $60,000 Management's estimates for the next years: Sales growth @30% for 2020 Net Income after Taxes estimated at 6% of Sales Proposed Dividend distribution = 40% of after-tax profits Proposed Debt to Assets ratio = 60% Projected Year-End Cash Balance = 6% of Sales Projected Year-End Accounts Receivable Duration=40 days Projected levels of Inventory = 15% of Sales Projected Accounts Payable levels = 5% of Sales Projected level of Net Fixed Assets – 25% of Sales No projected changes in the levels of Common Stock are proposed Required: Prepare a 2020 projected Income Statement. Balance Sheet and Statement of Cash Identify implications of excessive growth expectations upon capital structure Calculate a more responsible level of growth to avoid financial distress

Answer 1

Please give positive rating your feedback is valuable to me.

In case , any problem please leave a comment.

Note- We are supposed to answer one question during multiple questions under Chegg policy, please re-post the remaining question individual. Thanku!!

Answer-

Company has been generating a bottom line profit of 5% for past five years. Bottom line profit=total revenue - total expenses (including taxes and operating expenses) dividend distribution of 40% is prudent. such that at least 40% of profits should be distributed among the shareholder while remaining can be used to expand business equity through retained earnings. Asset turnover last year=total revenue / average assets[(assets at beginning + assets at the end)/2] 1.5x=total revenue / average assets total revenue = 1.5x * average assets The sales for the current year = $10,000,000 average assets=total revenue/1.5=$6666667 therefore, the asset turnover ratio for the coming year = 2 hence, the forecasted total revenue for the coming year if average assets remains same over the year = average assets * 2 =2 * 6666667=$13333333 The estimated target profit if the forecast sales is $13333333 = 6% * 13333333=$800000 They would be able to expand their market by $3000000 if the company obtains a asset turnover ratio of more 1.5 times of average assets. without purchasing additional assets they would be able to earn $13333333 if their assets turnover ratio is 2.

1.5x=total revenue / average assets total revenue = 1.5x * average assets The sales for the current year = $10,000,000 average assets=total revenue/1.5=$6666667 therefore, the asset turnover ratio for the coming year = 2 hence, the forecasted total revenue for the coming year if average assets remains same over the year = average assets * 2 =2* 6666667=$13333333 The estimated target profit if the forecast sales is $13333333 = 6% * 13333333=$800000 They would be able to expand their market by $3000000 if the company obtains a asset turnover ratio of more 1.5 times of average assets. without purchasing additional assets they would be able to earn $13333333 if their assets turnover ratio is 2. Hence, No need to approach more conservative dividend policy. but, if somehow the bond covenant allows to preclude debt less than 60% of assets then asset turnover ratio will decrease therefore, to increase the sales turnover, company needs more retained earnings hence, the company can decrease the amount to distribute to shareholder with view of increasing the retained earning.