Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Spreadsheet Problem Financial Planning and Control Use the model in File C16 to solve this problem. Stendardi Industries’ financial statements for the past year are shown in the following tables. Stendardi Industries: Balance Sheet as of December 31 ($ million) Cash $ 4.0 Accounts payable $ 8.0 Receivables 12.0 Notes payable 5.0 Inventories 16.0 Current liabilities $13.0 Current assets $32.0 Long-term debt 12.0 Net fixed assets 40.0 Common stock 20.0 Retained earnings 27.0 Total assets $72.0 Total liabilities and equity $72.0 Stendardi Industries: Balance Sheet as of December 31 ($ million) Sales $ 80.0 Operating costs (71.3) Earnings before interest and taxes $ 8.7 Interest ( 2.0) Earnings before taxes $ 6.7 Taxes (40%) ( 2.7) Net income $ 4.0 Dividends (40%) $ 1.60 Addition to retained earnings $ 2.40 Assume that the firm has no excess capacity in fixed assets, the interest rate for short-term debt is 10 percent, the interest rate for long-term debt is 12 percent, and that the projected annual sales growth rate for the next five years is 15 percent. a. Stendardi plans to finance its additional funds needed with 50 percent short-term debt and 50 percent long-term debt. Using the projected balance sheet method, prepare the firm’s pro forma financial statements for the next five years. Determine the following: (1) the additional funds needed, (2) the current ratio, (3) the debt ratio, (4) the return on equity (ROE) and the return on assets (ROA), (5) profit margin, and (6) the total assets turnover. b. Sales growth could be five percentage points higher or lower than the projected 15 percent. Determine the effect of such variances on AFN and the key ratios. c. Perform an analysis to determine the sensitivity of AFN and the forecasted key ratios for Year 5 to changes in the dividend payout ratio as specified in the following, assuming that sales grow at a constant 15 percent. What happens to Stendardi’s AFN if the dividend payout ratio (1) increases from 40 percent to 70 percent or (2) decreases from 40 percent to 20 percent?
Although the use of debt can provide tax benefits to the firm, debt also puts pressure on the firm to:
What is XYX’s cost of equity before the change in capital structure? c) What will be cost of equity of XYZ under the new capital structure?
However, when it does this, the firm wants the stock price increased to at least twice its preferred minimum as it is concerned the price will fall further. Which one of the following stock split ratios is most appropriate for this situation?
We routinely assume that rational investors are risk-averse return-seekers;
Determine also the corresponding average production cost per thousand board feet of plywood at this level of production.
The annual percentage rate (APR) on your credit card is 14.5% (monthly compounded). During the first week of school, you racked up $700 in credit card debt. You do not have access to a cheaper source of financing, and you definitely do not want to te..
Five years? ago, a company in New Jersey installed a? diesel-electric unit costing $55,000 at a remote site because no dependable electric power was available from a publiFive years? ago, Annual operation and maintenance expenses are ?$18,000?, and p..
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $493,000 is estimated to result in $192,000 in annual pretax cost savings.
Increasing the interest rate will have what effect on an ordinary annuity?
Coverage ratios as covenants are calculated using values from the _________. Current ratios as covenants are calculated using values from the ______.
What is the return on equity for Firm A and Firm B?
The firm pays out all earnings as dividends; hence, its stock is a zero growth stock. What is the total corporate value?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd