Please help with the below minicase.

Directions:

The best way to do this case is to use relevant credit information and calculate some financial ratios: ROA, debt ratio, liquidity ratios, ROE, profit margin, Inventory and Asset turnover. Then look at breakeven point probability, and finally the possibility of a repeat order.

What can you say about Miami Spice’s creditworthiness? What is the break-even probability of default? How is it affected by the delay before MS pays its bills? How should George Stamper’s decision be affected by the possibility of repeat orders?

MiniCase:

George Stamper a credit analyst with Micro-Encapsulators Corp. (MEC) needs to respond to an urgent email request from the southeast sales office. The local sales manager reported that she had an opportunity to clinch an order from Miami Spice (MS) for 50 encapulators at $10,000 each She added that she was particularly keen to secure this order since MS was likely to have a continuing need for 50 encapulators a year and could therefore prove a very valuable customer. However, orders of this size to a new customer generally required head office agreement, and it was therefore George's responsibility to make a rapid assessment of MS's creditworthiness and to approve or disapprove the sale.

Mr. Stamper knew that MS was a medium-sized company with a patchy earnings record. After growing rapidly in the 1980s, MS had encountered strong competition in its principal markets and earnings had fallen sharply. Mr. Stamper was not sure exactly to what extent this was a bad omen. New management had been brought in to cut costs, and there were some indicators that the worst was over for the company. Investors appeared to agree with this assessment, for the stock price had risen to $5.80 from its low of $4.25 the previous year. Mr. Stamper had in from of him MS's latest financial statements, which are summarized in table 20.4. He rapidly calculated a few key financial ratio's and the companies Z score. Mr. Stamper also made a number of other checks on MS. The company had a small issue of bonds outstanding, which were rated B by Moody's. Inquiries through MEC's bank indicated that MS had unused lines of credit totaling $5 million but had entered into discussions with its bank for a renewal of a $15 million bank loan that was due to be repaid at the end of the year. Telephone calls to MS's other suppliers suggested that the company had recently been 30 day's late in paying its bills.

Mr. Stamper also needed to take into account the profit that the company could make on MS's order. Encapulators were sold on standard terms of 2/30, net 60. So if MS paid promptly, MEC would receive additional revenues of 50 X $9,800 =$490,000. However, given MS;s cash position, it was more than likely that it would forgo the cash discount and would not pay until sometime after the 60 days. Since interest rates were about 8%, any such delays in payment could reduce the present value to MEC of the revenues. Mr. Stamper also recognized that there were production and transportation costs in filling MS's order. These worked out at $475,000 or $9,500 a unit. Corporate profits were taxed at 21%.

Please provide the Profit Margin, Inventory and Asset turnover, Breakeven point probability. In excel.
Transcribed Image Text:Balance Sheet 2019 2018 Assets Current asscts Cash and marketable securitices 5.0 12.2 Accounts receivable 16.2 15.7 Inventories 27.5 32.5 Total current assets 48.7 60.4 Fixed assets Property, plant, and equipment 228.5 228.1 Less accumulated depreciation 129.5 127.6 Net fixed asscts 99.0 100.5 Total assets 147.7 160.9 Liabilities and Shareholders' Equity Current liabilities Debt due for repayment 22.8 28.0 Accounts payable 19.0 16.2 Total current liabilities 41.8 44.2 Long-term debt 40.8 42.3 Sharcholders' cquity Common stock 10.0 10.0 Retained carnings 55.1 64.4 Total sharcholders' equity 65.1 74.4 Total liabilities and sharcholders' equity 147.7 160.9 Income Statement 2019 2018 Revenue 149.8 134.4 Cost of goods sold 131.0 124.2 Other expenses 1.7 8.7 Depreciation 8.1 8.6 Earnings before interest and taxes 9.0 -7.1 Interest expense 5.1 5.6 Income taxcs 1.4 -4.4 Net income 2.5 -8.3 Allocation of net income Addition to retained carnings 1.5 -9.3 Dividends 1.0 1.0

Question

Please help with the below minicase.

Directions:

The best way to do this case is to use relevant credit information and calculate some financial ratios: ROA, debt ratio, liquidity ratios, ROE, profit margin, Inventory and Asset turnover. Then look at breakeven point probability, and finally the possibility of a repeat order.

What can you say about Miami Spice’s creditworthiness? What is the break-even probability of default? How is it affected by the delay before MS pays its bills? How should George Stamper’s decision be affected by the possibility of repeat orders?

MiniCase:

George Stamper a credit analyst with Micro-Encapsulators Corp. (MEC) needs to respond to an urgent email request from the southeast sales office. The local sales manager reported that she had an opportunity to clinch an order from Miami Spice (MS) for 50 encapulators at $10,000 each She added that she was particularly keen to secure this order since MS was likely to have a continuing need for 50 encapulators a year and could therefore prove a very valuable customer. However, orders of this size to a new customer generally required head office agreement, and it was therefore George's responsibility to make a rapid assessment of MS's creditworthiness and to approve or disapprove the sale.

Mr. Stamper knew that MS was a medium-sized company with a patchy earnings record. After growing rapidly in the 1980s, MS had encountered strong competition in its principal markets and earnings had fallen sharply. Mr. Stamper was not sure exactly to what extent this was a bad omen. New management had been brought in to cut costs, and there were some indicators that the worst was over for the company. Investors appeared to agree with this assessment, for the stock price had risen to $5.80 from its low of $4.25 the previous year. Mr. Stamper had in from of him MS's latest financial statements, which are summarized in table 20.4. He rapidly calculated a few key financial ratio's and the companies Z score. Mr. Stamper also made a number of other checks on MS. The company had a small issue of bonds outstanding, which were rated B by Moody's. Inquiries through MEC's bank indicated that MS had unused lines of credit totaling $5 million but had entered into discussions with its bank for a renewal of a $15 million bank loan that was due to be repaid at the end of the year. Telephone calls to MS's other suppliers suggested that the company had recently been 30 day's late in paying its bills.

Mr. Stamper also needed to take into account the profit that the company could make on MS's order. Encapulators were sold on standard terms of 2/30, net 60. So if MS paid promptly, MEC would receive additional revenues of 50 X $9,800 =$490,000. However, given MS;s cash position, it was more than likely that it would forgo the cash discount and would not pay until sometime after the 60 days. Since interest rates were about 8%, any such delays in payment could reduce the present value to MEC of the revenues. Mr. Stamper also recognized that there were production and transportation costs in filling MS's order. These worked out at $475,000 or $9,500 a unit. Corporate profits were taxed at 21%.

Please provide the Profit Margin, Inventory and Asset turnover, Breakeven point probability. In excel.

Balance Sheet
2019
2018
Assets
Current asscts
Cash and marketable securitices
5.0
12.2
Accounts receivable
16.2
15.7
Inventories
27.5
32.5
Total current assets
48.7
60.4
Fixed assets
Property, plant, and equipment
228.5
228.1
Less accumulated depreciation
129.5
127.6
Net fixed asscts
99.0
100.5
Total assets
147.7
160.9
Liabilities and Shareholders' Equity
Current liabilities
Debt due for repayment
22.8
28.0
Accounts payable
19.0
16.2
Total current liabilities
41.8
44.2
Long-term debt
40.8
42.3
Sharcholders' cquity
Common stock
10.0
10.0
Retained carnings
55.1
64.4
Total sharcholders' equity
65.1
74.4
Total liabilities and sharcholders' equity
147.7
160.9
Income Statement
2019
2018
Revenue
149.8
134.4
Cost of goods sold
131.0
124.2
Other expenses
1.7
8.7
Depreciation
8.1
8.6
Earnings before interest and taxes
9.0
-7.1
Interest expense
5.1
5.6
Income taxcs
1.4
-4.4
Net income
2.5
-8.3
Allocation of net income
Addition to retained carnings
1.5
-9.3
Dividends
1.0
1.0

Accepted Answer

Formula :
a. Return on Assets is calculated by the following formula = Net Income/Average Total…