Current Situation Milan Fashions is ultimately looking to expand its manufacturing operations and this means selling more...

80.2K

Verified Solution

Question

Accounting

Current Situation
Milan Fashions is ultimately looking to expand its manufacturingoperations and this means selling more of its products via theinternet. The company saw it would have to do the following:
Expand their presence on the internet by enhancing the company’swebsite. This meant making it more interactive as well asinnovative. Here a potential customer would have the ability todesign a coat or outerwear online given the fabric, styles, anddesigns that the company had available. This would allow thecustomer to be creative and add more accessories to the coat andhave an idea what the item would cost. This type of custom-madecoat or outwear would allow the customer to have variety in theirstyles and design, and stay within their budget.
The enhancement of the online sales would also mean a possiblecreation of a customer service department to handle technicalissues as well as customer complaints. These were bound to happensince there will always be some errors in the manufacturing processor with the online system.
The manufacturing operations would have to be enhanced andrearranged in order to handle unique customer orders. This meanthaving the variety of fabrics and materials available for the coatsand outwear, the cutting of the fabrics and materials, andassembling, inspecting, and preparation for shipment of the order.With enough orders coming in, then there would be little to no idletime of the employees in the manufacturing facility.
The logistics could be handled by working with noted deliverycompanies which could ship the completed product from themanufacturing facility as soon as the item was completed. Therewould be an extra charge for delivery on rush orders.

Financial Information
Joseph and Thomas decided to first approach the bank where they hada line of credit and had received business loans in the past, FirstUnited. They had approached the bank on numerous occasions forsmall and large loans and this would be the largest they had everapplied for. After consulting with the relationship manager at thebank, Joseph and Thomas would need to provide the bank with theirincome statements and balance sheets from 2012 to 2016. From therethe bank’s commercial lending officer and credit analyst wouldperform the following ratio analysis:
Current ratio Long-term debt-to-Equity ratio Debt-to-Equity ratioTotal Debt ratio Financial leverage ratio Inventory turnover Fixedasset turnover Debt-to-Capital ratio Interest coverage ratio Returnon Assets

Assignment:
First United Bank Paterson, New Jersey Serving the Greater PatersonCommunity since 1949
To: Associate Credit Analyst
From: Ralph Vicente – Senior Vice President, Commercial LoanDivision
Date: March 9, 2017
Re: Milan Fashions Coat Company

The Milan Fashions Coat Company produces and sells to retailstores various types of coats and outerwear including women’s,children’s and men’s outer garments. They are looking to expand anddiversify their product line and sell on-line so they are coming tous for a $3 million commercial loan. The company’s five most recentbalance sheets and income statements were presented to First Unitedin order to support their loan request. As you can see from theattached income statements and balance sheets from 2012 to 2016,they have had increases in net sales since 2012 but their netincome has been up and down for the same time period.

The amount requested is broken down as:
Expand, enhance, and maintain company website $1,000,000
Expand and enhance manufacturing operations $1,500,000
Creation and maintenance of customer service center $500,000
Total loan request $3,000,000

Milan Fashions Coat Company has been a long-time client of thebank and borrowed funds from us on previous occasions. The companyhas grown in terms of sales, assets, and equity; however, this isthe largest loan that the company has ever applied for in theirentire history.

I would like you to analyze the company’s loanrequest and financial statements. You must provide thefollowing:
A. Calculate the financial ratios for 2016 and 2015 comparing themto the industry norms found on the page following the financialstatements.
B. Of the financial ratios that are used for the industry standard,which do you feel are most important when determining whether FirstUnited should approve the loan to Milan Fashions? What do you feelare the strong and weak points of the company in your financialanalysis?
C. Based upon your financial ratio analysis, what questions wouldyou like to propose to management to gain clarity on the businessoperations?
D. Based upon the financial ratio analysis you will have performedon Milan Fashions, would do you recommend that there should be anapproval of the loan request? I want you to state your analysis ina detailed memorandum to me by Monday of next week. I would like todiscuss your analysis and hear your ideas on Milan Fashions in ameeting on Tuesday. The clients will be in our offices next Fridayto discuss their loan request. Please feel free to contact me ifthere are any questions on this matter.

Milan Fashions Income Statements As of December 31st, 2012, to2016

Revenues20162015201420132012
Net Sales777,228774,635772,897770,524768,126
Rental Income36,00036,00036,00036,00036,000
Total Revenues813,228810,635808,897806,524804,126
Costs and Expenses
Cost of sales325,848315,698313,548312,587311,523
Operating, Selling, General & Administrative Expenses82,65380,56479,01278,24577,428
Depreciation325,789335,648337,840332,587331,429
Operating income78,93878,72578,49783,10583,746
Interest
Debt2,5252,7552,8742,9842,845
Capital leases1,2351,3361,1251,2491,352
Interest Income(198)(180)12511589
Interest, net3,9584,2713,8744,1184,108
Income from continuing operations before income taxes74,98074,45474,62378,98779,638
Provision for income taxes
Current income tax expense8,2017,9027,5257,6847,489
Deferred income tax expense(1,023)(946)876782658
Total provision for income taxes9,2248,8486,6496,9026,801
Income form continuing operations65,75665,60667,97472,08572,837
Income (loss) from discontinues operations, net of incometaxes0(657)525125257
Net Income$65,756$64,949$68,499$72,210$73,094

Milan Fashions Balance Sheets As of December 31st, 2012, to2016

Assets

20162015201420132012
Cash and cash equivalents$889,200$844,470$950,251$925,000

$901,250

Receivables, net748,505787,900725,253625,879610,253
Inventories55,07060,60050,16145,23240,649
Prepaid expenses83,39569,90052,12432,58998,536
Current assets of discontinued operations0(32,589)215350450
Total Current Assets1,807,6001,698,8511,778,0041,629,050

1,651,138

Property and Equipment
Property, plant and equipment, gross350,000400,000300,254250,623200,623
Less: Accumulated depreciation(90,500)(100,789)(80,456)(75,239)(50,467)
Property, plant and equipment, net259,500219,798175,384150,156299,211
Property under capital leases
Property under capital leases759,900700,564698,425658,954745,000
Less: Accumulated amortization(434,316)(425,687)(415,687)(400,253)(425,800)
Property under capital leases, net325,584274,877282,738258,701319,200
Goodwill15,86015,55914,62513,56812,569
Other assets and deferred charges689,577689,908568,356558,239568,542
Total Assets$3,131,478$2,989,372$2,855,660$2,658,979$2,641,106
Liabilities20162015201420132012
Current Liabilities
Short-term borrowings$50,000$90,074$41,922$35,698$37,894
Accounts Payable8,1805,0005,2505,2365,258
Accrued Liabilities4,8186,2395,6985,0004,689
Accrued Income Taxes4,4004,0004,1344,0364,235
Long-term debt due within 12 months13,76020,50019,43825,12028,369
Obligation under capital leases due within 12 months2,7602,4002,0082,958895
Total current liabilities83,918128,21378,45078,04881,340
Long-term debt88,16090,00087,63692,00095,456
Long-term obligations under capital leases94,48041,04847,87244,65845,254
Deferred income taxes14,48014,50015,49816,87917,568
Total liabilities281,038273,761229,456231,585239,618
Equity
Common stock2,728,0002,625,4112,543,8002,345,8942,280,879
Capital in excess of par value34,64028,20035,04035,23532,232
Retained Earnings17,80012,00015,68415,68714,127
Accumulated other comprehensive income (loss)70,00050,00031,68030,57874,250
Total equity2,850,4402,715,6112,626,2042,427,3942,401,488
Total liabilities and equity$3,131,478$2,989,372$2,855,660$2,658,979$2,641,106

Industry Financial Ratio Standards

RatioIndustry NormMilan Fashion Ratios 2015Milan Fashion Ratios 2016Evaluation
Current ratio4.5 times
Long-term debt-to-Equity ratio12%
Debt-to-Equity ratio30%
Total Debt ratio20%
Financial leverage ratio1.10
Inventory turnover7 times
Fixed asset turnover1.8 times
Debt-to-Capital ratio43.4%
Interest coverage ratio5.0 times
Return on Assets8.4%

Answer & Explanation Solved by verified expert
3.8 Ratings (373 Votes)
Current ratio Current assets Current liabilities 2015 Current ratio 1698851 128213 1325 2016 Current ratio 1807600 83918 2154 Since the current ratio ie the ability to meet short term liabilities with current assets has increased it it a GOOD SIGN Long term Debt to equity ratio Short term debt Long term debt Equity 2015 Long term Debt to equity ratio 273761 2715611 01008    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students