Attachment # 00001233 - Financial_Analysis_Spreadsheet_(1).xlsx
Financial_Analysis_Spreadsheet_(1).xlsx (49.28 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
46.3% of Sales Revenue is available to cover Selling & Admin expenses.The company earned 15.3-centsof Net Income profits per share of Common Stock.Every $1 of Stockholders' Equity returned $1.76 in Sales Revenue.Every $1 invested in PPE Capital returned $9.16 in Sales Revenue. $7,374,000 worth of Current Assets to "work with" to cover Current Liab. 10.0% of every $1 in Sales Revenue drops to bottom-line Net Income Profits.For every $1 in current liabilities, the company has $1.14 worth of cash assetsFor every $1 in current liabilities, the company has $2.95 worth of current assetsThe company waited, on average, 64.19 days to collect A/R balances from customers.On average, the inventory sat around for 114.3 days before being sold!The company earned enough Sales Revenue to completely replace assets 1.28 times. Put another way…. Every dollar of assets generated $1.28 in Revenue.The company earned enough Sales Revenue to completely replace Invested Capital 1.72 times. -or- Every $1 of Invested Capital returned $1.72 in Sales Revenue.STEP 1: Print out this tab's 2 pages & make notes about how you should interpret/apply each itemSTEP 2: Key Data & Print TabtimesdaysEarnings Per Share (of Common Stock)Profit Margin (percentage) Accounts Receivable Turnover (as times)STEP 3: Print this tab & review each item's analyses. Make notes on trends or issues to discuss in your paper.Profit Margin (Percentage)Inventory Turnover(or Collection Period)Days ReceivablesInvestment & Asset Utilization(Common Stock) Accounts Receivable TurnoverInventory Turnover (as times)Days Receivables (or Collection Period)Key in SHADED cells ONLY!Ex: Working capital tells us the value of all our Current Assets that we have on hand to "work" with inCells below are available for typing comments. All other cells on this tab are password protected.order to meet our upcoming Current Liabilities that will be due in the next 12 months. Higher levelstime to collect and we cannot send a pallet of inventory to pay the electric bill. We must write a check.are optimal--we especially want to see Cash being the largest part of Current Assets. Afterall, A/R takesABC MANUFACTURING, INC. (in thousands)A/R was completely collected & reestablished 5.69 times this year.Inventories were completely sold out & replaced 3.19 times this year.Profitability MeasuresGross Margin PercentageGross MarginNet Sales RevenuesNet SalesSales RevenueProfit MarginNet IncomeEarnings Per Share. #5 #6 #7Income Statement dataYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8 year-to-year change percentage changed# outstanding SharesExcel Formula: =+C19/C15 =+D19/D15 =+E19/E15Excel Formula: =+C23/C15 =+D23/D15 =+E23/E15etc.Balance Sheet dataExcel Formula: =+C23/C28 =+D23/D28 =+E23/E28 #18 #19Current RatioCurrent LiabilitiesAll Current AssetsCash Current AssetsInventoriesTotal Assets - Current Liabilities All Current Assets Working CapitalAcid Test (Quick) RatioCost of Goods SoldNet Accounts Rec. #14Days of Inventory#15#16 #9Asset Turnover #10Invested Capital Turnover#11Equity Turnover#12Capital IntensityStockholders' EquityAccounts ReceivableInventoryCost of SalesCurrent Assets (all)Monetary Current AssetsInterest ExpensePreTax Operating ProfitLong-Term LiabilitiesTotal LiabilitiesProperty, Plant, & Equip.shade = data; plain = formulaPropery Plant Equip.Shareholders' EquityReplace with Name of Company 1Replace with Name of Company 2Cost of Sales (COGS)Replace with name of companyTest of Investment & Asset Utilization(Accounts Receivable Turnover as Days)(Inventory Turnover as Days)( Sales ÷ 365 )( Cost of Goods Sold ÷ 365 )( LongTerm Liabilities + Stockholders' Equity ) Working Capital# Shares Outstanding
Accounting assignments

Accounting assignments

Question # 00013202 Posted By: honestabe Updated on: 04/22/2014 11:37 PM Due on: 04/30/2014
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
Accounting assignments

Accounting assignments

walmart and target for my assignment 2

http://stock.walmart.com/annual-reports

http://investors.target.com/phoenix.zhtml?c=65828&p=irol-reportsannual


Dot Image
Attachments
Assignment_2.docx (53.17 KB)
Financial_Analysis_Spreadsheet_(1).xlsx (49.28 KB)
Tutorials for this Question
  1. ACCOUNTS_GURU
    Tutorial # 00012844 Posted By: ACCOUNTS_GURU Posted on: 04/23/2014 10:40 PM
    Puchased By: 3
    Tutorial Preview
    The solution of down payment...
      Get the Solution
    Attachments
    Solution-00012844.zip (83 KB)
Whatsapp Lisa