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.
- Who are in your group? — Names of all group members (1 to 5). —- 3 points
- What S&P company will you research? — It must be in the S&P 500. Its name and ticker — 4 points
- When does the company’s fiscal year end? — It needs to be December 31st. — 4 points
- 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.
Leave a Reply
You must be logged in to post a comment.