Create financial model and analysis for publicly traded

Assignment Help Operation Management

Reference no: EM131128526

Create a financial model and analysis for a publicly traded company, including historic and pro forma financial statement analysis. A suggested format for the model is shown below. In one excel file, include a worksheet for: Revenues Income Statements Balance Sheets Cash Flow Statements Ratios Peer firm ratios Collect 10 years of data, forecast 3 years into the future. Use a common sized and indexed statement below the nominal statements. Use cell address links to connect each statement for the 3 years you are forecasting into the future. For most companies, you can use CAGR to project revenues, and % of revenues for all other income statement items. For some kinds of firms, for example those with exponential growth, like TESLA, you cannot use CAGR but will have to rely on a best fitting quadratic function as suggested in Excel. Again, think about each problem, make a decision, and state your assumption.Include bar, line, and pie charts throughout to illustrate concepts and numbers. The report should be single spaced and in electronic (word and/or excel).

Reference no: EM131128526

Questions Cloud

Utilization of a constrained resource : Drums, bins, boxes, and other containers that are used in the petroleum industry are sold by Holden Inc. One of the company's products is a heavy-duty, environmentally friendly, corro- sion-resistant metal drum, called the STR drum, used to store ..

Monitoring and enforcing ethical standards : What systems are in place for monitoring and enforcing ethical standards in your workplace? Would you alter these in any way if you were constructing the monitoring system yourself? What else would you do to evaluate your ethics program?

What is inferred about the origin of a satellite : Provide an example of a regular satellite: Provide an example of an irregular satellite: What is inferred about the origin of a satellite from the regularity/irregularity of its orbit

Major reason for introducing budgetary control : The major reason for introducing budgetary control and standard costing systems is to influence human behaviour and to motivate the managers to achieve the goals of the organization.

Create financial model and analysis for publicly traded : Create a financial model and analysis for a publicly traded company, including historic and pro forma financial statement analysis. A suggested format for the model is shown below. In one excel file, include a worksheet for: Revenues Income Statement..

The expected cash inflow for year : Piccadilly Hospital has purchased new lab equipment for $200,000. The equipment is expected to last for three years and to provide cash inflows as follows:

How big is this object in everyday terms : "How big is this object in everyday terms? " (Give an example of an everyday object that has this size. Give an example of an everyday object that has this mass.)

Central in many private and public sector union contracts : Seniority is central in many private and public sector union contracts. What are the advantages to both employers and employees of using seniority to allocate employment opportunities? What are the disadvantages? How can a balance be struck between t..

Evaluate the pros and cons for formal disciplinary process : You are the vice president of Human Resources at Community State University. The president of the university has just informed you that the Maintenance Department is experiencing a high turnover rate in addition to an increase in disciplinary actions..

User Account

All Pages