Question

In: Accounting

I understand this question has 7 ones following it so if you can't produce the answer...

I understand this question has 7 ones following it so if you can't produce the answer a.-g. can you please at least leave the formulas?

You have just been hired as a loan officer at San Diego State Bank. Your supervisor has given you a file containing a request from Mobile Company, a manufacturer of auto components, for a $1,000,000 five-year loan. Financial statement data on the company for the last two years are given below:

Mobile Company
Comparative Balance Sheet
This Year Last Year
  Assets   
  Current assets:   
       Cash $ 278,500 $ 355,750   
       Marketable securities 0 114,000   
       Accounts receivable, net 934,000 637,000   
       Inventory 1,352,500 752,500   
       Prepaid expenses 98,500 83,500   
  
  Total current assets 2,663,500 1,942,750   
  Plant and equipment, net 3,450,800 3,106,400   
  
  Total assets $ 6,114,300 $ 5,049,150   
  
  Liabilities and Stockholders’ Equity   
  Liabilities:   
       Current liabilities $ 1,274,000 $ 762,000   
       Bonds payable 1,310,000 1,110,000   
  
  Total liabilities 2,584,000 1,872,000   
  
  Stockholders' equity:   
       Preferred stock, 8%, $30 par value 600,000 600,000   
       Common stock, $40 par value 2,000,000 2,000,000   
       Retained earnings 930,300 577,150   
  
  Total stockholders' equity 3,530,300 3,177,150   
  
  Total liabilities and stockholders' equity $ 6,114,300 $ 5,049,150   
  


Mobile Company
Comparative Income Statement and Reconciliation
This Year Last Year
  Sales $ 5,490,000 $ 4,310,000   
  Cost of goods sold 4,115,000 3,205,000   
  
  Gross margin 1,375,000 1,105,000   
  Selling and administrative expenses 545,000 525,000   
  
  Net operating income 830,000 580,000   
  Interest expense 135,500 115,500   
  
  Net income before taxes 694,500 464,500   
  Income taxes (30%) 208,350 139,350   
  
  Net income 486,150 325,150   
  
  Dividends paid:   
       Preferred stock 48,000 48,000   
       Common stock 85,000 61,000   
  
  Total dividends paid 133,000 109,000   
  
  Net income retained 353,150 216,150   
  Retained earnings, beginning of year 577,150 361,000   
  
  Retained earnings, end of year $ 930,300 $ 577,150   
  

     Loretta Young, who just two years ago was appointed president of Mobile Company, admits that the company has been “inconsistent” in its performance over the past several years. But Young argues that the company has its costs under control and is now experiencing strong sales growth, as evidenced by the more than 27% increase in sales over the last year. Young also argues that investors have recognized the improving situation at Mobile Company, as shown by the jump in the price of its common stock from $47.00 per share last year to $57.00 per share this year. Young believes that with strong leadership and with the modernized equipment that the $1,000,000 loan will enable the company to buy, profits will be even stronger in the future.

     Anxious to impress your supervisor, you decide to generate all the information you can about the company. You determine that the following ratios are typical of companies in Mobile’s industry:

  Current ratio 2.3
  Acid-test ratio 1.2
  Average collection period 31 days
  Average sale period 60 days
  Return on assets 9.5 %
  Debt-to-equity ratio 0.65
  Times interest earned 5.7
  Price-earnings ratio 10

    

Required:
1.

You decide first to assess the rate of return that the company is generating. Compute the following for both this year and last year:

a.

The return on total assets. (Total assets at the beginning of last year were $4,390,000.) (Round your percentage answers to 1 decimal place i.e., 0.123 is considered as 12.3.)

b.

The return on common stockholders’ equity. (Stockholders' equity at the beginning of last year totaled $4,519,185. There has been no change in preferred or common stock over the last two years.) (Do not round your intermediate calculations. Round your percentage answers to 1 decimal place i.e., 0.123 is considered as 12.3.)

c.

Is the company’s financial leverage positive or negative?

  

2.

You decide next to assess the well-being of the common stockholders. For both this year and last year, compute:

a.

The earnings per share. (Round your answers to 2 decimal places.)

b.

The dividend yield ratio for common stock. (Round your intermediate calculations to 2 decimal places and and your percentage answers to 1 decimal place i.e., 0.123 is considered as 12.3.)

c.

The dividend payout ratio for common stock. (Round your intermediate calculations to 2 decimal places and your percentage answers to 1 decimal place i.e., 0.123 is considered as 12.3.)

d.

The price-earnings ratio. (Round your intermediate calculations to 2 decimal places and final answers to 1 decimal place.)

e.

The book value per share of common stock. (Round your answers to 2 decimal places.)

f.

The gross margin percentage. (Round your percentage answers to 1 decimal place i.e., 0.123 is considered as 12.3.)

3.

You decide, finally, to assess creditor ratios to determine both short-term and long-term debt paying ability. For both this year and last year, compute:

a. Working capital.
b. The current ratio. (Round your answers to 2 decimal places.)
c. The acid-test ratio. (Round your answers to 2 decimal places.)
d.

The average collection period. (The accounts receivable at the beginning of last year totaled $520,000.) (Use 365 days in a year. Do not round intermediate calculations. Round your final answers to the nearest whole number.)

e.

The average sale period. (The inventory at the beginning of last year totaled $650,000.) (Use 365 days in a year. Round your intermediate calculations to 2 decimal and final answers to the nearest whole number.)

f. The debt-to-equity ratio. (Round your answers to 2 decimal places.)
g. The times interest earned. (Round your answers to 1 decimal place.)

Solutions

Expert Solution


Related Solutions

Please use EXCEL to answer and show all formulas. I can't understand the answer if I...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just​ completed, Grips earned $4.25 per share and paid cash dividends of ​$2.55 per share ​(D0=$2.55). Grips' earnings and dividends are expected to grow at 25​% per year for the next 3​ years, after which they are...
7. Big picture question: Now that you understand statistics. I want you to answer a couple...
7. Big picture question: Now that you understand statistics. I want you to answer a couple of questions. Can a skilled statistician “make anything significant”? How would this be/not be accomplished? How could you design a study to guarantee significance?
Please answer all If you can't answer all then please don't answer just one question. i...
Please answer all If you can't answer all then please don't answer just one question. i need all 2. You would like to buy a house in in 16 years and estimate that you will need a deposit of $73,014. You plan to make bi-weekly deposits into an account that you hope will earn 7.05%. How much do you have to deposit every two weeks? 3. You have accumulated $1,085.55 in debt by buying things on Amazon during quarantine.  The minimum...
(PLEASE ANSWER ALL PARTS OF THE QUESTION AND PROVIDE VARIOUS EXAMPLES SO I CAN UNDERSTAND, THANK...
(PLEASE ANSWER ALL PARTS OF THE QUESTION AND PROVIDE VARIOUS EXAMPLES SO I CAN UNDERSTAND, THANK YOU SO MUCH FOR YOUR HELP!!!) A critical difference between the Absorption Approach and the Elasticities Approach to the effect of a devaluation on the Current Account is the addition of income effects. How will income effects alter the effect of a devaluation, and does this tend to make it more or less difficult for a devaluation to strengthen the current account under the...
So for the following question I really want to understand how to approach the problem. I'm...
So for the following question I really want to understand how to approach the problem. I'm having a really hard time understanding the concept so a detailed answer (that's also dumbed down) will be much appreciated! If a drug has a half-life of 10 hours and is taken orally, how long will it take until the subject achieves a steady state drug concentration?
Kindly provide a detailed explanation to the following question. So i can understand and solve on...
Kindly provide a detailed explanation to the following question. So i can understand and solve on my own Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas. Cost of goods sold...
(Please show work so I can understand how you got to the answer - Thank you...
(Please show work so I can understand how you got to the answer - Thank you very much ) Via Gelato is a popular neighborhood gelato shop. The company has provided the following data concerning its operations: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 13.00 $ 72,540 Raw materials $ 4.75 $ 30,330 Wages $ 5,700 $ 1.50 $ 14,560 Utilities $ 1,730 $ 0.30 $ 3,800 Rent $ 2,700 $ 2,700 Insurance...
Here is the question. I understand what the answer is but need to know how you...
Here is the question. I understand what the answer is but need to know how you calculate the PV at 12% in year 5 to equal .567. You have worked in XYZ Corporation for the last five years and have a more optimistic view of the firm's future FCFs. In your personal/professional opinion, XYZ could generate $4 million FCF next year, $4.5 million in year two, $5 million in year three, $5.5 million in year four, $6 million in year...
Please answer all question. If you can't answer all question then don't answer just one question....
Please answer all question. If you can't answer all question then don't answer just one question. I need all and I'm having test. 12. You have started an investment club with your friend. You identified an account which you think will pay 8% per year. You are going to invest $1200 per year. Your friend is going to invest $100 per month. You plan to invest for 4 years. All else equal, which of the following is true. 13. Annuity...
please explain milio's framework for prevention i can't understand it
please explain milio's framework for prevention i can't understand it
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT