follow the instructions in the first image
for this I am comparing two companies :ebay and etsy
i included both companies income statments and balance sheet which you can also find on yahoo finanace.
please help i need you to calculate the 9 ratios for both firms : ROA, ROE, Asset Turnover, Profit Margin, Leverage Ratio(assets/equity), inventory turnover, Average collection period, current ratio, and cash coverage ratio
pleas eput this on an excel spreadsheet that includes the formulas and inputs for all the calculations
nuveen W. income staserofer Balance Sheet: Use the information from the firm's financial statements to calculate the following 9 ratios of both firms: ROA, ROE, Asset Turnover, Profit Margin, Leverage ratio (Assets/Equity), Inventory tumover, Average collection period, Current ratio, and Cash coverage ratio, In your posting, please include the following 1. Screenshots of the companies' balance sheets and income statements ( 3 points) 2. Excel spreadsheets that include the formulas and inputs to show your calculations. (Screenshots of calculations are not acceptable) (10 points) Analysis report Please compare the ratios and use your calculated ratios to answer the following questions in details (15 points) a. Between the two firms, which firm is more profitable and Why? b. Which one is more etficient and Why? c. Which one has higher liquidity and Why? d. Which one has stronger solvency and Why? e. If you could provide some advice to the managers of the less profitable firm, how would vou advise them to improve the firm's profitability? You may apply the DuPont Identity and also incorporate the industry's characteristics to make your advice reasonable and applicable. \begin{tabular}{|c|c|c|c|c|c|c|} \hline & = & 10ks & & 7.302 & & \\ \hline & - & 14.14 & & 42025 & 2000 & \\ \hline & -130034 & & sin2 & ses300 & ans & \\ \hline & & 306 & & -422 & 1006 & \\ \hline O Sercie have Cown & -41211 & -2045022 & 0 & 46.45s & c & \\ \hline & 21211 & 10a5022 & = & * & a. & . \\ \hline Ohe Special Ourn: & . & & & ifins & & \\ \hline & & -2418 & & se:jos & tuns & \\ \hline Preun lovere & & texish & and 634 & & ascas & \\ \hline Tan Photsen & -57374 & & ans & & 15,240 & \\ \hline & Tr7sea & trean & anser: & 34524 & 9504 & \\ \hline Nethares & -71804 & -cacas & cos2sin & & asma & \\ \hline & Triose & thas & shes? & 209246 & 9594 & \\ \hline NetivaneCominsat of: & -Thess & then & ansen & 302.245 & atsing & \\ \hline & - & + & - & & 8 & \\ \hline & 2 & & & & & \\ \hline & -73025 & & inves & 242.246 & is 04 & \\ \hline & -5 & sin & & 2sin & 200= & \\ \hline oundros & & & 2.65 & 26 & Qr: & \\ \hline & & xem & mans & 101252 & tavess & \\ \hline & - & 126ny & & 13eats & 125020 & \\ \hline & & ctisses & & & ins: & \\ \hline lotai tuesen & 2201359 & & & 1.7etsus & masia & \\ \hline & -21) sca & chese & & 20234 & coseses & \\ \hline Nomuled incoes & & 4225 & 493(50)= & 34326 & 3res: & \\ \hline & - & zoves & & & pase: & \\ \hline Wentinese & - & -2634 & thes & & & \\ \hline & & A2n & arias & cos2x & & \\ \hline cant. & seopes & & cos72 & 424007 & & \\ \hline clinber & -50124 & anses & sones & ABzin & 06x2 & \\ \hline & rease & secha & & aceses & 221005 & \\ \hline & SLass & 4600 & 7400 & sans & atost & \\ \hline & & the Jat & cos05 & & xtas & \\ \hline & -10 mais & & 1160 & -2139 & 2006 & \\ \hline & & & 1300 & 203 & 2006 & \\ \hline & ses60 & & & Anzase & sec2 & \\ \hline & =9 & 8 & 2 & ef & 8 & \\ \hline & sen & 1362y & 80 & 9 & 0 & \\ \hline \end{tabular} 44.09+0.44(+1.01%)44.12+0.03(+0.07%) Discover new opportunities for today's market challenges. oxisct us UPMorgan Income Statement unenom zlomenas \begin{tabular}{|c|c|c|c|c|c|c|} \hline reation & m & 12/31/2022 & 12/1/2024 & 12/21/2aze & 22/1/2019 & \\ \hline Pathenser & 2340000 & 97m000 & 20,000000 & 10272000 & & \\ \hline & 236000 & 2000000 & 2 ssesese & 207000 & 2011000 & \\ \hline conter & 234000 & 2ns000 & & zonosos & 2006000 & \\ \hline & 2005000 & aresoose & watsoes & 50007000 & & \\ \hline & 2201000 & 22000000 & & 2711000 & 2201000 & \\ \hline & 12000 & .1050000 & -160.060 & mexosos & & \\ \hline roosives heres & 2011000 & -1706000 & 201500 & 1005000 & noso & \\ \hline Prentiven & & -1005000 & & & 2m000 & \\ \hline & 48,000 & & 146000 & moose & 417000 & \\ \hline & 2011000 & & Dest 000 & 3000000 & L,706000 & \\ \hline & 1302006 & 20000 & & sen0000 & 2006000 & \\ \hline tosin & & 20 & sow & 29 & 210 & \\ \hline Plentros. & - & 228 & nest & 2x & 20 & \\ \hline & & 350000 & & 7ne000 & sesose & \\ \hline & = & 581000 & 60000 & 710000 & w6000 & \\ \hline & & 2200000 & 2321000 & 2711000 & 2291000 & \\ \hline Besteres: & 2731000 & 2.465000 & 2,032000 & 2800000 & & \\ \hline & Det:000 & -1008060 & nesecose & & 127ac000 & \\ \hline & 1581445 & 1739096 & ISLA10 & 2002000 & treseces & \\ \hline serativen & & 2000 & 10000 & 20000 & 120000 & \\ \hline treakers & 298000 & 165000 & & & moso & \\ \hline Des menetionse & 46000 & .1650000 & -100000 & 2010000 & t:6000 & \\ \hline tort & 1512,000 & -2006000 & 7002000 & 2711000 & 21906 & \\ \hline \end{tabular} eBay lnc. (EBAY) 44.09+0.44(+1.01%)44.12+0.03(+0.07%) T.Roweffice Annual Quaners Balance Sheet Dinotimn novons: \begin{tabular}{|c|c|c|c|c|} \hline Areakdem & 12/31/2022 & 22/31/2021 & 22/31/2020 & 12/31/2019 \\ \hline & 20050.000 & 2562000 & 19.710 .000 & 17727,000 \\ \hline & 15,657,000 & is 340060 . & 15,720000 & 15012000 \\ \hline & 5152000 & 9778000 & 2561.000 & 2702000 \\ \hline Youl Copitilisiane & 12.574 .000 & 17,5050,000 & 11206000 & 2.446000= \\ \hline Comensisoctiquity & 5152000 & 972000 & 3561000 & 2704000 \\ \hline Coptedtene Oblyption & 410000 & 200,000 & 300000 & 42000 \\ \hline Nes taryble tweti & 191000 & Kss92000: & -2126.000 & \\ \hline & 5,010,000 & 400000 & & \\ \hline "Inveated ciplal" & 1872000 & =2.01220001 & 7736000 & \\ \hline Tryste boot value & $91.000 & 3592000 & 1,126000 & 22393,000 \\ \hline Total best & 2209000 & 9202000 & 4:143000 & 0.272000 \\ \hline Ner Dobs: & 6717006 & 7201500 & coss 000 & \\ \hline Share laved & 1,2525000 & & 1705,000 & 1.596278 \\ \hline odvysues Ninibe: & 539,000 & 534000 & tas 600 & mosaga \\ \hline & 1,106000 & & 1021000 & \\ \hline \end{tabular} Etsy, Inc, (ETSV) 64.58+0.83(+1.30%)64.500.08(0.12%) Income Statement 4 cielaterat Income Statement \begin{tabular}{|c|c|c|c|c|c|} \hline Beakbon & rm & 12/21/2022 & 12/31/2021 & 12/31/2020 & 12/31/201s \\ \hline & 9940000 & 3755000 & 10,420,000 & 10,272000 & 10,47000 \\ \hline Cent ef hevesie & 2746000 & 2600000 & 2ssn000 & 2,47000 & 2412600 \\ \hline Goss hivir. & & 7,115,000 & 7370,000: & 7785000 & 4040000 \\ \hline P Qpentescepente & 43652000 & 4265000 & 4.007000 & s.047000 & 3755000 \\ \hline Opnreling beane & 2204000 & 2350.000 & 2.522000 & 2721006 & \\ \hline & 226,000 & -165000 & 160,000 & 203000 & .112 .000 \\ \hline & 23,000 & -2756000 & 2705000 & 1007000 & n,000 \\ \hline Pivtan hebse & 1790b00 & -2.601000 & 301060 & unosob & 2177000 \\ \hline ton Pertion & cas000 & 227,600 & 145,000 & 1710000 & 412,000 \\ \hline & 1341000 & 129,000 & nstos,000 & 5667000 & 1Jac000 \\ \hline & & 1265,000 & 1300.006 & 5667009 & vespob \\ \hline Linic DPS & = & -227 & & 790 & 270 \\ \hline Divent us & & -227 & 2054 & 78 & \\ \hline & = & 534000 & 652000 & 710000 & \\ \hline & = & 352000 & 061+100 & 728000 & asedocen \\ \hline & 2700000 & 2350000 & 2523000 & 2711000 & 22+1000 \\ \hline & 2331,000 & 2,405000 & 7,492,000 & 7360000 & tunoss \\ \hline & & -1264000 & 22006000 & 5,607000 & \\ \hline & 15016cs & 2738556 & 2751410 & 2502000 & 1. Nkano6: \\ \hline homeleoge & = & n000 & 19000 & 20,000 & 220,000 \\ \hline Nometries & 19000 & 265000 & 260000 & 237,000 & 711000 \\ \hline & -225000 & -165.000 & -160005 & 701000 & -1106060 \\ \hline rat: & 1359000 & -1.196 .000 & 2421000 & 2711000 & 2591000 \\ \hline rantest & & 920000 & 2025000 & 3320062 & 2244000 \\ \hline & 2,322.000 & 2202000 & 2.157,000 & 2.1201,000 & 2.004000 \\ \hline & neose & 42,000 & 502,000 & 605,000 & \\ \hline Watheneformivope- & 1342000 & -1274000 & 252.060 & 2502000 & 1760000 \\ \hline & -251000 & 4,746060 & -2.365000 & 1,007000 & \\ \hline Tabilused tims & -252000 & -2706500 & 2205000 & 1.8073000 & in 600 \\ \hline Norndind temen & 2701.000= & 2792000 & 17+0000 & 2320006 & 243000 \\ \hline Tanllote bercies & & 3 & 0 & & 8 \\ \hline & -7332 & 972344 & & is & e. \\ \hline \end{tabular} nuveen W. income staserofer Balance Sheet: Use the information from the firm's financial statements to calculate the following 9 ratios of both firms: ROA, ROE, Asset Turnover, Profit Margin, Leverage ratio (Assets/Equity), Inventory tumover, Average collection period, Current ratio, and Cash coverage ratio, In your posting, please include the following 1. Screenshots of the companies' balance sheets and income statements ( 3 points) 2. Excel spreadsheets that include the formulas and inputs to show your calculations. (Screenshots of calculations are not acceptable) (10 points) Analysis report Please compare the ratios and use your calculated ratios to answer the following questions in details (15 points) a. Between the two firms, which firm is more profitable and Why? b. Which one is more etficient and Why? c. Which one has higher liquidity and Why? d. Which one has stronger solvency and Why? e. If you could provide some advice to the managers of the less profitable firm, how would vou advise them to improve the firm's profitability? You may apply the DuPont Identity and also incorporate the industry's characteristics to make your advice reasonable and applicable. \begin{tabular}{|c|c|c|c|c|c|c|} \hline & = & 10ks & & 7.302 & & \\ \hline & - & 14.14 & & 42025 & 2000 & \\ \hline & -130034 & & sin2 & ses300 & ans & \\ \hline & & 306 & & -422 & 1006 & \\ \hline O Sercie have Cown & -41211 & -2045022 & 0 & 46.45s & c & \\ \hline & 21211 & 10a5022 & = & * & a. & . \\ \hline Ohe Special Ourn: & . & & & ifins & & \\ \hline & & -2418 & & se:jos & tuns & \\ \hline Preun lovere & & texish & and 634 & & ascas & \\ \hline Tan Photsen & -57374 & & ans & & 15,240 & \\ \hline & Tr7sea & trean & anser: & 34524 & 9504 & \\ \hline Nethares & -71804 & -cacas & cos2sin & & asma & \\ \hline & Triose & thas & shes? & 209246 & 9594 & \\ \hline NetivaneCominsat of: & -Thess & then & ansen & 302.245 & atsing & \\ \hline & - & + & - & & 8 & \\ \hline & 2 & & & & & \\ \hline & -73025 & & inves & 242.246 & is 04 & \\ \hline & -5 & sin & & 2sin & 200= & \\ \hline oundros & & & 2.65 & 26 & Qr: & \\ \hline & & xem & mans & 101252 & tavess & \\ \hline & - & 126ny & & 13eats & 125020 & \\ \hline & & ctisses & & & ins: & \\ \hline lotai tuesen & 2201359 & & & 1.7etsus & masia & \\ \hline & -21) sca & chese & & 20234 & coseses & \\ \hline Nomuled incoes & & 4225 & 493(50)= & 34326 & 3res: & \\ \hline & - & zoves & & & pase: & \\ \hline Wentinese & - & -2634 & thes & & & \\ \hline & & A2n & arias & cos2x & & \\ \hline cant. & seopes & & cos72 & 424007 & & \\ \hline clinber & -50124 & anses & sones & ABzin & 06x2 & \\ \hline & rease & secha & & aceses & 221005 & \\ \hline & SLass & 4600 & 7400 & sans & atost & \\ \hline & & the Jat & cos05 & & xtas & \\ \hline & -10 mais & & 1160 & -2139 & 2006 & \\ \hline & & & 1300 & 203 & 2006 & \\ \hline & ses60 & & & Anzase & sec2 & \\ \hline & =9 & 8 & 2 & ef & 8 & \\ \hline & sen & 1362y & 80 & 9 & 0 & \\ \hline \end{tabular} 44.09+0.44(+1.01%)44.12+0.03(+0.07%) Discover new opportunities for today's market challenges. oxisct us UPMorgan Income Statement unenom zlomenas \begin{tabular}{|c|c|c|c|c|c|c|} \hline reation & m & 12/31/2022 & 12/1/2024 & 12/21/2aze & 22/1/2019 & \\ \hline Pathenser & 2340000 & 97m000 & 20,000000 & 10272000 & & \\ \hline & 236000 & 2000000 & 2 ssesese & 207000 & 2011000 & \\ \hline conter & 234000 & 2ns000 & & zonosos & 2006000 & \\ \hline & 2005000 & aresoose & watsoes & 50007000 & & \\ \hline & 2201000 & 22000000 & & 2711000 & 2201000 & \\ \hline & 12000 & .1050000 & -160.060 & mexosos & & \\ \hline roosives heres & 2011000 & -1706000 & 201500 & 1005000 & noso & \\ \hline Prentiven & & -1005000 & & & 2m000 & \\ \hline & 48,000 & & 146000 & moose & 417000 & \\ \hline & 2011000 & & Dest 000 & 3000000 & L,706000 & \\ \hline & 1302006 & 20000 & & sen0000 & 2006000 & \\ \hline tosin & & 20 & sow & 29 & 210 & \\ \hline Plentros. & - & 228 & nest & 2x & 20 & \\ \hline & & 350000 & & 7ne000 & sesose & \\ \hline & = & 581000 & 60000 & 710000 & w6000 & \\ \hline & & 2200000 & 2321000 & 2711000 & 2291000 & \\ \hline Besteres: & 2731000 & 2.465000 & 2,032000 & 2800000 & & \\ \hline & Det:000 & -1008060 & nesecose & & 127ac000 & \\ \hline & 1581445 & 1739096 & ISLA10 & 2002000 & treseces & \\ \hline serativen & & 2000 & 10000 & 20000 & 120000 & \\ \hline treakers & 298000 & 165000 & & & moso & \\ \hline Des menetionse & 46000 & .1650000 & -100000 & 2010000 & t:6000 & \\ \hline tort & 1512,000 & -2006000 & 7002000 & 2711000 & 21906 & \\ \hline \end{tabular} eBay lnc. (EBAY) 44.09+0.44(+1.01%)44.12+0.03(+0.07%) T.Roweffice Annual Quaners Balance Sheet Dinotimn novons: \begin{tabular}{|c|c|c|c|c|} \hline Areakdem & 12/31/2022 & 22/31/2021 & 22/31/2020 & 12/31/2019 \\ \hline & 20050.000 & 2562000 & 19.710 .000 & 17727,000 \\ \hline & 15,657,000 & is 340060 . & 15,720000 & 15012000 \\ \hline & 5152000 & 9778000 & 2561.000 & 2702000 \\ \hline Youl Copitilisiane & 12.574 .000 & 17,5050,000 & 11206000 & 2.446000= \\ \hline Comensisoctiquity & 5152000 & 972000 & 3561000 & 2704000 \\ \hline Coptedtene Oblyption & 410000 & 200,000 & 300000 & 42000 \\ \hline Nes taryble tweti & 191000 & Kss92000: & -2126.000 & \\ \hline & 5,010,000 & 400000 & & \\ \hline "Inveated ciplal" & 1872000 & =2.01220001 & 7736000 & \\ \hline Tryste boot value & $91.000 & 3592000 & 1,126000 & 22393,000 \\ \hline Total best & 2209000 & 9202000 & 4:143000 & 0.272000 \\ \hline Ner Dobs: & 6717006 & 7201500 & coss 000 & \\ \hline Share laved & 1,2525000 & & 1705,000 & 1.596278 \\ \hline odvysues Ninibe: & 539,000 & 534000 & tas 600 & mosaga \\ \hline & 1,106000 & & 1021000 & \\ \hline \end{tabular} Etsy, Inc, (ETSV) 64.58+0.83(+1.30%)64.500.08(0.12%) Income Statement 4 cielaterat Income Statement \begin{tabular}{|c|c|c|c|c|c|} \hline Beakbon & rm & 12/21/2022 & 12/31/2021 & 12/31/2020 & 12/31/201s \\ \hline & 9940000 & 3755000 & 10,420,000 & 10,272000 & 10,47000 \\ \hline Cent ef hevesie & 2746000 & 2600000 & 2ssn000 & 2,47000 & 2412600 \\ \hline Goss hivir. & & 7,115,000 & 7370,000: & 7785000 & 4040000 \\ \hline P Qpentescepente & 43652000 & 4265000 & 4.007000 & s.047000 & 3755000 \\ \hline Opnreling beane & 2204000 & 2350.000 & 2.522000 & 2721006 & \\ \hline & 226,000 & -165000 & 160,000 & 203000 & .112 .000 \\ \hline & 23,000 & -2756000 & 2705000 & 1007000 & n,000 \\ \hline Pivtan hebse & 1790b00 & -2.601000 & 301060 & unosob & 2177000 \\ \hline ton Pertion & cas000 & 227,600 & 145,000 & 1710000 & 412,000 \\ \hline & 1341000 & 129,000 & nstos,000 & 5667000 & 1Jac000 \\ \hline & & 1265,000 & 1300.006 & 5667009 & vespob \\ \hline Linic DPS & = & -227 & & 790 & 270 \\ \hline Divent us & & -227 & 2054 & 78 & \\ \hline & = & 534000 & 652000 & 710000 & \\ \hline & = & 352000 & 061+100 & 728000 & asedocen \\ \hline & 2700000 & 2350000 & 2523000 & 2711000 & 22+1000 \\ \hline & 2331,000 & 2,405000 & 7,492,000 & 7360000 & tunoss \\ \hline & & -1264000 & 22006000 & 5,607000 & \\ \hline & 15016cs & 2738556 & 2751410 & 2502000 & 1. Nkano6: \\ \hline homeleoge & = & n000 & 19000 & 20,000 & 220,000 \\ \hline Nometries & 19000 & 265000 & 260000 & 237,000 & 711000 \\ \hline & -225000 & -165.000 & -160005 & 701000 & -1106060 \\ \hline rat: & 1359000 & -1.196 .000 & 2421000 & 2711000 & 2591000 \\ \hline rantest & & 920000 & 2025000 & 3320062 & 2244000 \\ \hline & 2,322.000 & 2202000 & 2.157,000 & 2.1201,000 & 2.004000 \\ \hline & neose & 42,000 & 502,000 & 605,000 & \\ \hline Watheneformivope- & 1342000 & -1274000 & 252.060 & 2502000 & 1760000 \\ \hline & -251000 & 4,746060 & -2.365000 & 1,007000 & \\ \hline Tabilused tims & -252000 & -2706500 & 2205000 & 1.8073000 & in 600 \\ \hline Norndind temen & 2701.000= & 2792000 & 17+0000 & 2320006 & 243000 \\ \hline Tanllote bercies & & 3 & 0 & & 8 \\ \hline & -7332 & 972344 & & is & e. \\ \hline \end{tabular}
