1.Add ratio analysis to your Excel spreadsheet for each of the pages: •The Consolidated Balance Sheets.•The Consolidated Statements of Income.•The...

profilesvelan

1.Add ratio analysis to your Excel spreadsheet for each of the pages: •The Consolidated Balance Sheets. •The Consolidated Statements of Income. •The Consolidated Statements of Cash Flows. 2.Then prepare a three-year forecast (as demonstrated in the case study) for: •A pro forma Consolidated Balance Sheets. •A pro forma Consolidated Statements of Income. •A pro forma Consolidated Statements of Cash Flows. 3.Use these statements to arrive at your calculation of value.

  • 11 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    ratio_analysis.xls
Bids(1)
other Questions(10)