Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    02 Task Performance 1 - ARG-MA-PONCE

    Uploaded by

    Von Marvic Ponce
    The document is a financial analysis task that provides comparative financial statements for years 201A and 201B. It includes: 1) A horizontal analysis of the statement of financial position showing peso and percentage changes between the two years. 2) A vertical analysis of the 201B income statement showing percentages of total sales. 3) A request to compute 10 financial ratios using the information provided.

    Copyright:

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

    02 Task Performance 1 - ARG-MA-PONCE

    Uploaded by

    Von Marvic Ponce
    22 views3 pages
    The document is a financial analysis task that provides comparative financial statements for years 201A and 201B. It includes: 1) A horizontal analysis of the statement of financial position showing peso and percentage changes between the two years. 2) A vertical analysis of the 201B income statement showing percentages of total sales. 3) A request to compute 10 financial ratios using the information provided.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a financial analysis task that provides comparative financial statements for years 201A and 201B. It includes: 1) A horizontal analysis of the statement of financial position showing peso and percentage changes between the two years. 2) A vertical analysis of the 201B income statement showing percentages of total sales. 3) A request to compute 10 financial ratios using the information provided.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    22 views3 pages

    02 Task Performance 1 - ARG-MA-PONCE

    Uploaded by

    Von Marvic Ponce
    The document is a financial analysis task that provides comparative financial statements for years 201A and 201B. It includes: 1) A horizontal analysis of the statement of financial position showing peso and percentage changes between the two years. 2) A vertical analysis of the 201B income statement showing percentages of total sales. 3) A request to compute 10 financial ratios using the information provided.

    Copyright:

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

    BM1915

    Name: VON MARVIC M. PONCE DATE: Sep. 26 2023 SCORE:

    TASK PERFORMANCE

    Instructions: Analyze the following financial statements. Write your answers on the space provided. (100
    points)

    I. HORIZONTAL ANALYSIS

    Accomplish the comparative statement of financial position by showing the peso changes and percentage
    changes for 201B as compared with 201A. (38 items x 1 point)

    201B 201A Peso Change % Change


    Cash P 290,000 P 150,000 P140,000 93.33%
    Marketable Securities 1,000,000 850,000 P150,000 17.64%
    Accounts Receivable, net 1,000,000 500,000 P500,000 100%
    Inventories 500,000 750,000 P250,000 33.33%
    Prepaid expenses 90,000 100,000 P10,000 10%
    Total Current Assets 2,880,000 2,350,000 P530,000 22.55%

    Land 700,000 500,000 P200,000 40%


    Building, net 500,000 550,000 P50,000 9.09%
    Machinery and Equipment, net 1,500,000 1,700,000 P200,000 11.76%
    Total Noncurrent Assets 2,700,000 2,750,000 P50,000 1.81%
    Total Assets P 5,580,000 P 5,100,000 P480,000 9.41%

    Notes Payable, trade P 150,000 P 100,000 P50,000 50%


    Accounts Payable, net 635,000 610,000 P25,000 4.09%
    Expenses Payable 20,000 40,000 P20,000 50%
    Total Current liabilities 805,000 750,000 P55,000 7.33%
    Long-Term Notes 2,250,000 2,350,000 P100,000 4.25%
    Total Liabilities 3,055,000 3,100,000 P45,000 1.45%
    Owner’s Capital 2,525,000 2,000,000 P525,000 26.25%
    Total Liabilities and Equity P 5,580,000 P 5,100,000 P480,000 9.41%

    02 Task Performance 1 *Property of STI


    Page 1 of 3
    BM1915

    II. VERTICAL ANALYSIS

    Create a vertical analysis for the income statement for 201B given below. (12 items x 1 point)

    201B Percentage
    Gross Sales P 5,250,000 100%
    Less: Sales Returns and Allowances 250,000 4.76%
    Net Sales 5,000,000 95.23%
    Less: Cost of Goods Sold
    Inventory, Dec. 31, 2018 P 750,000 29.41%
    Purchases 2,750,000 52.38%
    Inventory, Dec. 31, 2019 500,000 3,000,000 57.14%
    Gross Profit 2,000,000 38.09%
    Less: Selling Expenses 400,000 7.61%
    Administrative expenses 600,000 11.42%
    Income from operations 1,000,000 19.04%
    Interest expense 250,000 4.76%
    Income before taxes 750,000 14.28%
    Income taxes 225,000 4.28%
    Net Income 525,000 10%

    02 Task Performance 1 *Property of STI


    Page 2 of 3
    BM1915

    III. RATIO ANALYSIS

    Compute for the following ratios using the financial statements above. (10 items x 5 points)

    1. Net working capital


    2. Current ratio
    3. Acid-test ratio
    4. Profit margin =
    5. Return on equity
    6. Return on assets
    7. Accounts receivable turnover
    8. Inventory turnover
    9. Debt ratio
    10. Debt-to-equity ratio

    Rubric for problem solving:

    Performance Indicators Points


    Correct accounts and amounts used 3
    Computed final amounts are correct/balanced 2
    Total 5

    02 Task Performance 1 *Property of STI


    Page 3 of 3

    You might also like