Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Performance Task Grade 12

    Uploaded by

    Kimberly Embang
    Computation of Horizontal and Vertical Analyses

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Performance Task Grade 12

    Uploaded by

    Kimberly Embang
    5 views1 page
    Computation of Horizontal and Vertical Analyses

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Computation of Horizontal and Vertical Analyses

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    5 views1 page

    Performance Task Grade 12

    Uploaded by

    Kimberly Embang
    Computation of Horizontal and Vertical Analyses

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    Name: ___________________________________Grade & Section:___________Score:_________

    Part 2: Vertical Analysis


    Part 1: Horizontal Analysis
    Instructions: You are given the following financial statements for XYZ Company. Compute the
    Instructions: Compute the amount change and percentage change for each line item from the previous year to vertical analysis for the income statements for the years 2015 and 2016. For each line item,
    the current year. calculate its percentage relative to Net Sales.
    Fantasy Football XYZ Company
    Income Statements Income Statements
    December 31, 2015 and December 31, 2014 December 31, 2015 and December 31, 2016
    2015 2014 Change in Amount Percentage 2015 2016
    Net Sales 60, 000 40, 000 Amount Percent Amount Percent
    Less: Cost of 25, 000 15, 000 Net Sales PhP 600, 000 100% PhP 500, 000 100%
    Goods Sold
    Gross Profit 35, 000 25, 000 Less: Cost of 483, 000 340, 000
    Goods Sold
    Less: Other 1, 500 800 Gross Profit 117, 000 80, 000
    Expenses
    Operating Income 32, 300 23, 500 Less: Other 57, 200 34, 000
    Expenses
    Less: Interest 500 350 Operating Income 60, 000 45, 000
    Expense
    Net Income 30, 600 22, 450 Less: Interest 35, 000 25, 000
    Expense
    Net Income PhP 79, 800 PhP 69, 000
    Fantasy Football
    Balance Sheets
    December 31, 2015 and December 31, 2014
    Part 3: Pro Forma Income Statement
    2015 2014 Change in Amount Percentage
    Cash 25, 000 20, 000 Instructions:
    Accounts 35, 000 30, 000
    Receivable, net Below is the income statement for Good Food Snack House for the end of the year. Assuming
    Inventories 30, 000 25, 000 sales are forecasted to grow by 10% next year, prepare the pro forma income statement for the
    Prepaid Rent 6, 000 5, 000 next year.
    Total Current 96, 000 80, 000
    Assets Income Statement Amount
    Sales 200, 000
    Equipment and 55, 000 50, 000 Costs 120, 000
    Fixtures Taxable Income 80, 000
    Less Accumulated 12, 000 10, 000 Taxes (30%) 24, 000
    Depreciation Net Income 56, 000
    Total Fixed Assets 43, 000 40, 000 Dividends (0%) 0
    TOTAL ASSETS 139, 000 120, 000 Addition to Earnings 56, 000

    Accounts Payable 18, 000 15, 000 Pro Forma Income Statement Percent of Sales
    Notes Payable 12, 000 10, 000 Projected Sales
    Accruals 6, 000 5, 000 Costs
    Taxable Income
    Total Current 36, 000 30, 000
    Liabilities Taxes (30%)
    Long-term Debt 22, 000 20, 000 Net Income
    Owner’s Capital 81, 000 70, 000 Dividends (0%)
    TOTAL LIABILITIES 139, 000 120, 000 Addition to Earnings
    AND CAPITAL

    You might also like