Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 3 You are the manager of the credit department of ABC Corporation Morr credit with ABC Corporation and you must alate their financial
Problem 3 You are the manager of the credit department of ABC Corporation Morr credit with ABC Corporation and you must alate their financial statements below to determine if you wil tended to them. Bosed upon your analys, what your remmendation-shoud Capon grad Magnus ferartyear decision on whether ABC Corporation westend credit to Marcel sing the formula functions in Excel wil be the most efficient way to calculate the rated Current ratio Cashrat Neting Total Debt/Equit tauity mult Tmes interest earned Inventory turnover Days' sa es in inventory receivables NWE Proft margin MARCEL INDUSTRIES State of Comp for the Year Ended D32 2019 Revenue (all credi 1,606,100 1841.300 1542,700 Cost of goods sold 1238910 1.337.400 1400 Gross Profit 346.200 443.900 363.900 Seling and administrative exper 245.610 256850 234,200 Depreciation 14,000 14.400 06,000 EBIT 66.550 172.650 57,700 66.100 50550 50,100 EBT 1,450 122.100 7,600 Income tax experee 350 27100 2,300 Net income 1.100 95.000 5,400 Statement Financial Desember 31 Cash Storm 2030 2018 2018 $14.900 534.700 $11.500 7,000 7.000 7.000 Accounts recebe 450800 361,800 297,300 Inventory 256600 Prepaid expenses 5.200 Not property, plant, and equipment 162.000 330,000 800 172.900 5500 184,300 Total Assets 25,400 2300 30600 588900 $95,000 $326.100 S&S EQUITY Accounts pel $145 $1,700 $200,00 Bankaan payable (due within 1 year) 154.000 Other current pe Longe Common shares Retained earnings 200,000 10,000 1700 23.00 14.400 151630 141,0 14.000 14000 14000 238.500 3740 278,000 Total & shady $88,500 $925,400 $825,100
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started