MBA – FIN 6806
Midterm Project
Instructions: Read these instructions and each question carefully. Failure to follow these instructions will result in deductions from your grade. This is a take home project, and it is open note and open book. You may use internet resources. You can use anything to help you complete the project except for the assistance of another individual or individuals. Additional instructions follow:
, each student will electronically submit his or her Midterm Project in an MS Word document via the link within the Canvas course shell. This link will be directly located on the course homepage and named “Midterm Project”. Follow submission instruction from there closely to turn in your project. When asked for a “Paper Title”, each student will use their name followed by FIN 6806 Midterm Project as their “Paper Title”. For example, “Ken Johnson FIN 6806 Midterm Project”. The first page (title page) of the project should contain the student’s name and FIN 6806 Midterm Project, as well.
If there is a conflict between these instructions and any prior information provided, including your syllabus, these instructions take precedence.
If you believe a question is unanswerable, explain why and make any necessary assumption(s) and then answer the question. Make these assumptions at the beginning of your answer in Italic print (or otherwise highlighted) in order to stand out from the remainder of your answer.
If you believe a question has incorrect information, you are to make explicit reference to the incorrect information, provide corrected information, and answer the question. Make these corrections at the beginning of your answer in Italic print (or otherwise highlighted) in order to stand out from the remainder of your answer.
If you leave a question unanswered, partial credit cannot be granted. Therefore, make an attempt to answer all questions. Show your work for the maximum award of partial credit. In general, show your work. It helps the grader decipher your thought process.
There is a “blackout” during the project period. Therefore, there is to be no contacting the instructor or GAs (Graduate Assistants) during the project period with questions about the project or subject matter.
As you have significant time to complete the project, your work product is to be organized and presented at a professional level, i.e. do not submit “sloppy” work. See sample projects in Old Projects & Answers under Course Content in the course’s Canvas shell.
Include a Title page, Table of Contents, and the Grading Rubric (found below) in that order as the first three pages of your project.
Assume you are working with KHJ Consulting Inc., and the reader of your work product is a client of the firm. The reader is sound mathematically and has good comprehension and reasoning skills. You are to deliver a professional report, in terms of both quantitative and qualitative rigor, to the client summarizing the questions below.
If needed, attach a Reference section to the end of your project. You may follow any citation and referencing style that you desire; however, you must be consistent with its use.
Where applicable use the same notation as in class.
While you may employ Excel to calculate answers, do not submit Excel Spreadsheets.
You are being asked throughout the project to replicate topics/materials. You MAY NOT use examples from class, the course textbook, other textbooks, the internet, or any other outside sources. This includes your own existing work product. Your old projects are considered your own existing work product. You must always create your own work product. You may never represent the work product of others as your work product. You must only produce current/original work product. Work product is defined as the answers that you provide to the hypothetical client. Violation of these instructions will result in a maximum score of 50% on the project. Said another way, rewrite everything, every time, in your own words.
Projects are to be submitted in a Microsoft Word document or be readable in Microsoft Word. The readability of the electronic file/document that contains your project is your responsibility.
Once a project/work product has been submitted, you may not resubmit. Therefore, proof your work carefully before submitting.
You may not place jpeg files in your work product, i.e. no pictures/images. They are not readable by Turnitin.
Produce a professional work product (answers to the questions below) for the client.
Have fun and good luck.
Grading Rubric
FIN 6806 Final Project
Spring 2022
Requirements Deductions
Quantitative Understanding
Qualitative Understanding
Communication/Teaching
Instructions
Total Score
Instructor Comments (if any):
Time Value of Money Template
INPUTS
N I/YR PV PMT FV
OUTPUTS
P/Y =
Project Questions
All questions are equally weighted
Our client ITech Geek has several questions for us to answer as their consultant firm concerning valuation, which cash flows matter, the calculation of these cash flows, convergence to a perpetuity, and bond pricing, among others. These are outlined below.
Question 1
ITech Geek is a publicly traded technology company and has 5,000,000 shares outstanding. Their marginal tax rate of 30%. Assume ITech Geek plows-back 60% of its net income into retained earnings.
First, you are to create the necessary Balance Sheets and Income Statement and then calculate the annual Cash Flow from Assets (aka: CFFA or Free Cash Flows (FCF)) for ITech Geek. A constraint here, however, is that your CFFA must range between $20,000,000 and $24,000,000 annually. Second, assuming ITech Geek’s annualized WACC is 8% and its annualized CFFA are growing at 5%, you are to estimate the current value of ITech Geek.
Question 2
ITech Geek is not familiar with the mechanics of corporate bond valuation. They are interested in the fact that bond prices converge to their PAR value as the date to maturity nears. Explain this concept to ITech Geek management.
Question 3
We have often discussed the formulas for the present value of a perpetuity (aka: no-growth perpetuity) and the present value of an ordinary annuity (aka: finite series of cash flows):
PV=CF/r (I)
PV= ∑_(i=1)^n▒CF/〖(1+r)〗^i (II)
With CF>0 and 0