1. Company:Pepsi

    1. Find latest 10-K financial statements – Income Statement, Balance Sheet, Statement of Cash Flows.

    1. Common Size all financial statements for all years available.

  1. 4. Ratio analysis for all years available

Income Statement
Gross Profit MarginGross Profit/Revenues
Operating Profit MarginOperating Income/Revenues
Net Profit Marginearning avliable for common stockholder/sales
Balance Sheet
Liquidity Ratios
CurrentCurrent Assets/Current liabilities
QuickCurrent Assets - Inventories / Current Liabilities
Cash(cash-marketable sec.)/Current liabilities
Solvency Ratios
Long-term debt to equityLTD/Tot equity
Debt to equityTotal Debt/Shareholder's Equity
Total DebtTotal Debt/Total Assets
Financial LeverageTotal Asset/Equity
Cash Flow Statement
Performance
Cash Flow to RevenueCFO/ Net Revenue
Cash Return on AssetsCFO/ Total Assets
Cash return on equityCFO / Avg. Shareholder's Equity
Cash to incomeCFO/Operating Income
Cash flow per shareCFO-Preferred Dividends/CSO
Coverage Ratios
Debt coverageCFO/Total Debt
Interest coverageEBIT/Interest Expense
ReinvestmentCFO/Cash Paid for long-term assets
Debt paymentCFO/ CASH PAID LONG TERM
Divident paymentCFO/DIVIDENDS PAID
Investing and FinancingCFO/Inv cash outflow + financing cash outflow
Cash FlowsEquation
Free Cash Flow to EquityCFO-FCInv+Net Borrowing-Net Debt Payment
Free Cash Flow to the FirmCFO+Int(1-Tax)-FCI
 
 
    • 8 years ago
    100% perfect solution guaranteed A1+++++plagiarism free always at the top solution+calculations
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      pepsi_company.xlsx