Module 2: Excel

Module 2: Excel

  • Due Sunday by 11:59pm
  • Points 15
  • Submitting a file upload

Assignment – DCF Valuation


Complete Module 2- Handout #3 spreadsheet handout by watching the accompanying (three videos) this handout (from Week 2). Submit the completed spreadsheet by the due date on Canvas. Make sure that the numbers in your spreadsheet match those in the video.

Grading Rubric


Your assignment will be graded according to the grading rubric below.

Full credit: 15 points

Part I- Key Performance Measures for MicroDrive (5 points)

Part I- MicroDrive’s Forecast of Operations for the Selected Scenario (5 points)

Part III: Projections (5 points).

For each part:

  • Award 5 points if it is complete
  • Deduct 2 points off it is partially complete
  • Deduct 5 points off if the student did not attempt to complete (left it as is)

Module 2: FIN502 Project1

  • Due Sunday by 11:59pm
  • Points 15
  • Submitting a file upload
  • File Types docx and pdf

In a document, answer the following questions.

All group members should have the same answers, so each person can submit the same document.

Answer the following 4 questions in a word document. 15 points total.

  1. Who are in your group? — Names of all group members (1 to 5). —- 3 points
  2. What S&P company will you research? — It must be in the S&P 500. Its name and ticker — 4 points
  3. When does the company’s fiscal year end? — It needs to be December 31st. — 4 points
  4. Is it a company in real estate, financials, and energy? — We try to avoid these sectors. — 4 points

This assignment’s purpose is to make sure that you think about this project a few weeks in advance. I hope that you will start to work on your Project as soon as you figure out this information. This project will take a while.

WRITE MY PAPER

Comments

Leave a Reply