Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all questions The report is based on the computation i posted with all the work, and the letter is to follow through with
Please answer all questions
The report is based on the computation i posted with all the work, and the letter is to follow through with it, what is missing from what is needed?
1. Prepare a report that presents ALL your computations and discussions in Part 2. The report should be ORGANIZED AND easy to follow (i.e., put your computation in labeled tables like Exhibit A of this document). 2. Prepare a letter to accompany the report. The LETTER should NOT go into detail about formulas and how amounts were determined. Instead, the letter should immediately (in the first paragraph) state the purpose of the analysis and your RECOMMENDATION. The paragraphs to follow should discuss HOW and WHY you make the recommendation. Most importantly, your letter MUST reference the report throughout. Be sure to mention in the first paragraph that you have attached a detailed report on which your recommendation is based. 3. The Letter and report are to be submitted ( in that order) as one file, via the Bb link FinStatAnalysis Proj by Monday, June 22, 2020 at 11:59 p.m. Be sure the letter IS NOT a part of the report. You have one file, but two distinct documents. 4. In a separate link, FinStatAnalysis Proj-SuppDoc, You MUST also submit copies of the financial statements, and other information, that you used as a basis for your ratios and trend analysis. HINT: Submitting a pdf file of your information is recommended. 7:34 for Amazon.de Ano Analytis . Pelitability i Droft Margin. 2013 Net.com 33,033 Net Sales $11.866 Net somt 100 Net Sales KRONE Net Incont 3.10.073 Net Sales = $ 232,387 10.03 Profil Margin = 3.033X100 177,866 252,23 PREM Margin= Abiela Margin = 1.21% 120121 Net Pacom Profit margin Protit Margin $11,58 Net Sales $280,522 1.5A 280,523 54.13 > Aset Net Sale Average Tous les 2017 Net Salu = $111.866 Jul 2013 131 310 2013) Net Salas = $232,387 Tetod Pets - Beginning = 513,310 Average Total ek $131,310 Tohul Ads Ending = 5162,643 Auct tumen IT.866 Dec 31, 2013 tef Meet turnevet 1.35 times ] Average Total Bring thing (2019 Net Sales Anthony Total = $106.979 Totales Beguering 5.162.648 Asset Have 292.217 Tolol Anda - Ending a $225,243 146.979 Average Total Aneka Baharing Seling ng boset tunces = 1.53 limes 1313104152.60 2 $ 290,522 Ack 162/425,247 2 Average Toll Ages 23193.948 Asset beh 280.522 193.948 kur 1.44 times (3) Return on Assets Net Incom 100 Average Total Atels (2017 (2018) Net Income = $3,032 Net Datome $10.073 Average Total Anek- $131,310 Average Total Astek = $146.79 calculated Endlich Rehnen Assels 3.033 YIDD on Anet tuote 131,310 Rent Assels = 2.31% Rehan Bu Audi 10.013 146,979 Trehan om Arseks = 6.25% 2019 Net Incomt = $11,588 Average. Total Assels = $ 193,94 Colululed farlier ou Anet V Return Assets 11.582 193,943 XIOD 044 Aus Return Assets 5.91%, - (4) Return on Common_stockholden's Equity Net come Average Tohul comercom Stockholderis Equity 100 12011 2015 Net Income = 53,033 Net Income - $10,073 Average Stockholderia Equity Bezinny z belong Common $27,709 Cumin Stockholded $27,709 Equity - Beginning Return on Commen Net Income in common stockholderis $43.549 Stockholder's Equity Average te Equity - Ending Equity Com Bal 3,033 -X100 27,709 27,709 +390 Relu o COM 10.94%) Stockholders Equity Adope con 2 $35,629 Steldulity 2019 Reborn in Lome 10.073X100 Net alonu - $11,583 Stockholdusa Equity 35629 29.23 Lowinstockholder II. stood holdad Equity 2019 N Rehbu lot 0.013-X100 Net Dulonu 311,583 Stockholms Spily Common Stockhollock $43.549 Rehan Com 29.21% Stockholdid Equity Equity - Beginning Common slock helder $62,060 Equity Ending + Ending Average common stock heldud Equity = Beginning 43,549 +52,060 Avenge common stockholders' Equity orps $52.3ous 2 X100 Return on Common 11.583 Stockholders Equity 52804.5 Rehem ou common Stockholle 21.94% Equity 21.947.) A Liquielity Curent Ratio Cuent Assets Cursul 2017 2017 Cuent Aneks 560,197 Cumut ballite 51,883 Cuent Asels = $75.101 Luanit Labilitie$13,391 Curent Ralio =__60,197 51,883 Cuxhend Ratio - 1.04 Custheit Ratio - 15.101 63,391 Cu Palio 1.1021 2013 2 cwchart Astek 96,334 cument Vabi Whey 37,812 Current Ratio 96,334 Cut Ratio (2) Acid - test ratio : 2011 Cuant els 560,197 Indones 16,043 quid mets Cuticle (2018) Cut Aseks $75.10 Tuvies > $17,074 Liquid Assets - Cushionek duck Curut Anet Tvoris Inventories = 16,040 Liquid Assets Currend Assels "Inventories = 60,197 - 16,047 Liquid Auets = $44.150 cuount Waliches $57,383 Acid - test Ratio MAISO 57,823 Tacid test Ratio 0.-16:1 Tvodones Liquid Meck Current Anete -Two 75,101-17,174 Liquid felets $57.927 Cum Libris 163,391 Acid-tex Ratio - 51.927 65,39) 0.16.213 acid-test Ratio - 0.3431) 2019 Current Assels = $ 96,334 Tuveteries 20,497 Liquid Assels = Cuchard Avels - Invenfonet 96,334 - 20,497 575,837 Cucent liable > 87,812 Acid - test Ratio = 15.337 87,812 test Ratio 0.36 Liquid Amets (3) Receivable turnover Net Credit Sullet Sales Nldle It Net Credit Salu is not given, then take Net Sales Awang Accounts Receivables 12017) Net Sales = $19.866 Average Accounts - $1,665 Keleivables Receivable Lumove_177.866 7665 23. 13) Receivable twee Net Cesi Saluor Netsal Average Accounts Receivables Total Note If Net Credit sales is not given then take Mer sales 2017 2013 Net Sales $177, 866 Net Sales = $232,337 - $11,829 Actor Account $16.251 Reclinables Relivables Receivablexhumove_117,866 Receivables de 232.617 16.251 2011 Average Accounts 15 0. Receivable 17.866 7665 23 (3) Receivable weten Net Cuci Salur Nehsal Average Accounts Receivables Total Note: Net Credit Sales is not given then take Sals 12017 2013 Net Sale $17,866 Net sales $ 232,317 Average Account = $11,829 are Accounts > 5 16.251 Reclivables Redivables Receivablestumover 177,866 Receivables chevel 232,337 11,829 16.251 Trecevablen tumane = 15.04. tioned Treceivables Tummas 14.33) 12019 Net Sales 5230.522 20,495 Average Tobal Accounts Receivables = $20,495 Receivables en 280 522 A Receivables tumores 13.69 times 14) Parentory turnover > Coat of Goods sold Auchage Tela vending 2012 2018 stof Goods sold = $11.934 Cast of Gooda Sokl= $ 139,156 Average Twentory$ 15,049 Alape Tohd Zered try 17,134 Possutory Love_111.934 Inventory tumeha 139.156 = 6.98 timer. Rannuchong dume 3.10 Dubenlovy turnover 6.98 6.98 times cest 16,047 17,179 Cost of Goods Sold = $165,536 Average Tuventory takes 2 $ 20,497 Tuventory tumbven 165.526 Inventory turnover 20,497 3.01 times 1. Prepare a report that presents ALL your computations and discussions in Part 2. The report should be ORGANIZED AND easy to follow (i.e., put your computation in labeled tables like Exhibit A of this document). 2. Prepare a letter to accompany the report. The LETTER should NOT go into detail about formulas and how amounts were determined. Instead, the letter should immediately (in the first paragraph) state the purpose of the analysis and your RECOMMENDATION. The paragraphs to follow should discuss HOW and WHY you make the recommendation. Most importantly, your letter MUST reference the report throughout. Be sure to mention in the first paragraph that you have attached a detailed report on which your recommendation is based. 3. The Letter and report are to be submitted ( in that order) as one file, via the Bb link FinStatAnalysis Proj by Monday, June 22, 2020 at 11:59 p.m. Be sure the letter IS NOT a part of the report. You have one file, but two distinct documents. 4. In a separate link, FinStatAnalysis Proj-SuppDoc, You MUST also submit copies of the financial statements, and other information, that you used as a basis for your ratios and trend analysis. HINT: Submitting a pdf file of your information is recommended. 7:34 for Amazon.de Ano Analytis . Pelitability i Droft Margin. 2013 Net.com 33,033 Net Sales $11.866 Net somt 100 Net Sales KRONE Net Incont 3.10.073 Net Sales = $ 232,387 10.03 Profil Margin = 3.033X100 177,866 252,23 PREM Margin= Abiela Margin = 1.21% 120121 Net Pacom Profit margin Protit Margin $11,58 Net Sales $280,522 1.5A 280,523 54.13 > Aset Net Sale Average Tous les 2017 Net Salu = $111.866 Jul 2013 131 310 2013) Net Salas = $232,387 Tetod Pets - Beginning = 513,310 Average Total ek $131,310 Tohul Ads Ending = 5162,643 Auct tumen IT.866 Dec 31, 2013 tef Meet turnevet 1.35 times ] Average Total Bring thing (2019 Net Sales Anthony Total = $106.979 Totales Beguering 5.162.648 Asset Have 292.217 Tolol Anda - Ending a $225,243 146.979 Average Total Aneka Baharing Seling ng boset tunces = 1.53 limes 1313104152.60 2 $ 290,522 Ack 162/425,247 2 Average Toll Ages 23193.948 Asset beh 280.522 193.948 kur 1.44 times (3) Return on Assets Net Incom 100 Average Total Atels (2017 (2018) Net Income = $3,032 Net Datome $10.073 Average Total Anek- $131,310 Average Total Astek = $146.79 calculated Endlich Rehnen Assels 3.033 YIDD on Anet tuote 131,310 Rent Assels = 2.31% Rehan Bu Audi 10.013 146,979 Trehan om Arseks = 6.25% 2019 Net Incomt = $11,588 Average. Total Assels = $ 193,94 Colululed farlier ou Anet V Return Assets 11.582 193,943 XIOD 044 Aus Return Assets 5.91%, - (4) Return on Common_stockholden's Equity Net come Average Tohul comercom Stockholderis Equity 100 12011 2015 Net Income = 53,033 Net Income - $10,073 Average Stockholderia Equity Bezinny z belong Common $27,709 Cumin Stockholded $27,709 Equity - Beginning Return on Commen Net Income in common stockholderis $43.549 Stockholder's Equity Average te Equity - Ending Equity Com Bal 3,033 -X100 27,709 27,709 +390 Relu o COM 10.94%) Stockholders Equity Adope con 2 $35,629 Steldulity 2019 Reborn in Lome 10.073X100 Net alonu - $11,583 Stockholdusa Equity 35629 29.23 Lowinstockholder II. stood holdad Equity 2019 N Rehbu lot 0.013-X100 Net Dulonu 311,583 Stockholms Spily Common Stockhollock $43.549 Rehan Com 29.21% Stockholdid Equity Equity - Beginning Common slock helder $62,060 Equity Ending + Ending Average common stock heldud Equity = Beginning 43,549 +52,060 Avenge common stockholders' Equity orps $52.3ous 2 X100 Return on Common 11.583 Stockholders Equity 52804.5 Rehem ou common Stockholle 21.94% Equity 21.947.) A Liquielity Curent Ratio Cuent Assets Cursul 2017 2017 Cuent Aneks 560,197 Cumut ballite 51,883 Cuent Asels = $75.101 Luanit Labilitie$13,391 Curent Ralio =__60,197 51,883 Cuxhend Ratio - 1.04 Custheit Ratio - 15.101 63,391 Cu Palio 1.1021 2013 2 cwchart Astek 96,334 cument Vabi Whey 37,812 Current Ratio 96,334 Cut Ratio (2) Acid - test ratio : 2011 Cuant els 560,197 Indones 16,043 quid mets Cuticle (2018) Cut Aseks $75.10 Tuvies > $17,074 Liquid Assets - Cushionek duck Curut Anet Tvoris Inventories = 16,040 Liquid Assets Currend Assels "Inventories = 60,197 - 16,047 Liquid Auets = $44.150 cuount Waliches $57,383 Acid - test Ratio MAISO 57,823 Tacid test Ratio 0.-16:1 Tvodones Liquid Meck Current Anete -Two 75,101-17,174 Liquid felets $57.927 Cum Libris 163,391 Acid-tex Ratio - 51.927 65,39) 0.16.213 acid-test Ratio - 0.3431) 2019 Current Assels = $ 96,334 Tuveteries 20,497 Liquid Assels = Cuchard Avels - Invenfonet 96,334 - 20,497 575,837 Cucent liable > 87,812 Acid - test Ratio = 15.337 87,812 test Ratio 0.36 Liquid Amets (3) Receivable turnover Net Credit Sullet Sales Nldle It Net Credit Salu is not given, then take Net Sales Awang Accounts Receivables 12017) Net Sales = $19.866 Average Accounts - $1,665 Keleivables Receivable Lumove_177.866 7665 23. 13) Receivable twee Net Cesi Saluor Netsal Average Accounts Receivables Total Note If Net Credit sales is not given then take Mer sales 2017 2013 Net Sales $177, 866 Net Sales = $232,337 - $11,829 Actor Account $16.251 Reclinables Relivables Receivablexhumove_117,866 Receivables de 232.617 16.251 2011 Average Accounts 15 0. Receivable 17.866 7665 23 (3) Receivable weten Net Cuci Salur Nehsal Average Accounts Receivables Total Note: Net Credit Sales is not given then take Sals 12017 2013 Net Sale $17,866 Net sales $ 232,317 Average Account = $11,829 are Accounts > 5 16.251 Reclivables Redivables Receivablestumover 177,866 Receivables chevel 232,337 11,829 16.251 Trecevablen tumane = 15.04. tioned Treceivables Tummas 14.33) 12019 Net Sales 5230.522 20,495 Average Tobal Accounts Receivables = $20,495 Receivables en 280 522 A Receivables tumores 13.69 times 14) Parentory turnover > Coat of Goods sold Auchage Tela vending 2012 2018 stof Goods sold = $11.934 Cast of Gooda Sokl= $ 139,156 Average Twentory$ 15,049 Alape Tohd Zered try 17,134 Possutory Love_111.934 Inventory tumeha 139.156 = 6.98 timer. Rannuchong dume 3.10 Dubenlovy turnover 6.98 6.98 times cest 16,047 17,179 Cost of Goods Sold = $165,536 Average Tuventory takes 2 $ 20,497 Tuventory tumbven 165.526 Inventory turnover 20,497 3.01 times 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