Financial Statement Analysis – Part 1 (LO2) and Calculate and Interpret Descriptive Statistics in Excel (LO1)

June 17, 2023June 17, 2023 Discipline: Finance

You are required to create an Excel spreadsheet to perform the required analysis on your company which must be submitted for grading. You are required to use Excel formulas to perform all calculations to earn the full number of points. The FIN-5823 Financial Analysis Example illustrates how to format your analysis and how to use formulas for the calculations.

  1. Use the FIN-5823 Financial Analysis Example to help you create your won Excel spreadsheet to compare the results of your company for the last two years and perform the following analysis:
    1. Prepare a Horizontal Analysis of the Balance Sheet.
    2. Prepare a Horizontal Analysis of the Income Statement.
    3. Prepare a Component Percentage Balance Sheet.
    4. Prepare a Component Percentage Income statement.
    5. Calculate the following financial ratios for last year and the current year:
    6.  Return on Equity.
      1. Earnings per Share
      2. Total Asset Turnover Ratio
      3. Current Ratio
      4. Debt to Equity Ratio
      5. Price/Earnings (P/E) Ratio
Second assignment:

For this assignment, you will download the FIN-5823_Week 2_Descriptive Statistics_Population and perform the necessary calculations to answer the questions. The data is on one sheet, the questions on the next sheet and you will typed your answers on the third sheet which is formatted. 

Instructions:

  1. Use the FIN-5823_Week 2_Descriptive Statistics_Population to perform the analyses required to answer the following questions:
    1. Which state was ranked 25th in population in 1993?
    2. Which state had the largest percentage increase in population from 1990 to 1999?
    3. Which states had populations of more than 1 million and less than 2 million in 1995?
    4. Create a histogram of the population by state for 1999 and interpret it.
    5. Calculate the mean and median by state from 1990 to 1999.
    6. Compare and interpret the mean, median, and mode for Illinois, Indiana, Iowa, Ohio, Michigan, Wisconsin and Minnesota? What can we learn from this information? Why is it important?
    7. Calculate the annual percentage population growth for Illinois, Indiana Iowa, and create a line chart that compares the growth trends in these states.
    8. Interpret the meaning of the line chart created in #7.
    9. Which state had the largest standard deviation?
    10. Which state had the lowest standard deviation?

Are you struggling with your paper? Let us handle it - WE ARE EXPERTS!

Whatever paper you need - we will help you write it

Get started

Starts at $9 /page

Login Register Reset

How our paper writing service works

It's very simple!

  • Fill out the order form

    Complete the order form by providing as much information as possible, and then click the submit button.

  • Choose writer

    Select your preferred writer for the project, or let us assign the best writer for you.

  • Add funds

    Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.

  • Ready

    Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.

Place order now