Financial Models

profileexcel2010
 

Research a company of your choice and locate the latest financial statements published by the company.

For the following year, construct a pro-forma income statement and a pro-forma balance sheet for the company, using the assumption that sales will increase 20% in the first quarter and decrease by 10% in the third quarter. Sales will remain flat in the second and fourth quarters.

In addition, submit a three-page financial analysis of the company's current condition.

Submit the original company statements you researched, the pro-forma statement, and the analysis to the The analysis should be a Microsoft Word document, formatted in Times New Roman 12 point font, double- spaced. Ensure you use the current APA standards when formatting your paper.

All written assignments and responses should follow APA rules for attributing sources.

    • 12 years ago
    • 15
    Answer(2)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      financial_analysis.docx
    • attachment
      financial_model.xlsx
    • attachment
      filing.pdf
    • attachment
      q1fy12datasum.pdf
    • attachment
      q2fy12datasum.pdf
    • attachment
      q3fy12datasum.pdf
    • attachment
      q4fy12datasum.pdf

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      week_4_assignment_-_analyzing_proforma_statement.docx