Estimate the value of business at the end of marketplace

Reference no: EM131968026

Assignment -

This is the instructions for the marketplace end of game spreadsheet.

This spreadsheet is used to estimate the value of the business at the end of the Marketplace Live simulation. You will need to extract, copy and paste the income statement and the balance sheet into the spreadsheet. Then, you will need to project results for quarters 11 and 12 to finish year 3. Next, from the DCF sheet you will need to estimate growth for the next four years.

Since the value of the business depends upon cash available for distribution to shareholders, you will need to estimate non-income expenditures such as investment in plant and equipment, changes in inventory, and changes in the amount of cash held on hand to operate the business.

Future cash flows need to be discounted back to the present to value the business. The discount rate is calculated using the CAPM model. The firm specific rate is estimated based upon how risky the future cash flows are. You will use the WACC tab to calculate your cost of capital.

Attachment:- Assignment Files.rar

Reference no: EM131968026

Questions Cloud

Display the three steps of comparative advantage : Define comparative advantage and use an example to explain how a country gets a comparative adavantge in the production of a certain good.

How you incorporated guidelines for writing job descriptions : A job description is a useful tool in preparing for the interview process. It helps the interviewer understand the job and provides overview of job duties.

Good investment decision : Even if a company has been around for awhile should there potentially be red flags that it is not a good investment decision?

Employee stock purchase plans : Due to employee stock purchase plans, many elderly people thought they would be millionaire by the time they retired

Estimate the value of business at the end of marketplace : Marketplace end of game spreadsheet - This spreadsheet is used to estimate the value of the business at the end of the Marketplace Live simulation

What are the possible source of income : For the retirement stage of life, what are the possible source of income? Does your employer still pay you after retirement?

Investment in insurance and safe stock : Could you have made more money diversifying your investment in insurance and safe stock?

Venezuela exports oil to the united states : For each of the following trade relationships, choose the likely source of the comparative advantage of each of the exporting countries.

Wealthy and developing countries : How do you think HR priorities differ between wealthy and developing countries?

User Account

All Pages