Financial modeling and forecast project 2

Project 2 Instructions and Due Date

(FIN 4453 – Gary Smith)

1) Project 2 materials may be found in the Module: Project 2 Fall 2023 on the Canvas course site.

2) There are 10 questions on Project 2. Some of the questions have multiple parts. Be sure to answer each part of each question. Clearly identify your answer to each part of each question.

3) Due Date: By 5:00 pm on Monday, November 20, 2023.

4) You are expected to work on this project by yourself. You may consult with me if you have any questions.

5) Please provide me a Printed (no electronic copies will be accepted) copy of each problem in Project 2.

6) The Printed copy should be formatted and assembled in the following manner:

a. Staple all problems together so they are not lost or separated

b. Print your name, course number (FIN 4453), and section number at the top of each page

c. Print Row and Column Headings for each problem as demonstrated in class

d. Print out formulas used in each problem as demonstrated in class

e. Clearly identify your answer to each part of each question.

f. If you use Goal Seek to determine an answer, please identify the

i. Set Cell

ii. To Value

iii. By Changing Cell

g. If you use Solver to determine an answer, please identify the

i. Set Objective (Cell)

ii. To Value

iii. By Changing Variables Cell

iv. Subject to (if used)

7) Please format and present the problem solutions is such a manner that another individual would be able to look at your solutions and follow your logic in solving the problem. If you were not available, then another individual should be able to solve a similar problem by following the logic of your solution.

8) In order to achieve the above, you may need to document and comment on your solution logic.

9) The project will be graded on the basis of correct solutions, presentation and formatting of solutions, and the explanation of solutions. You should view this as a professional report you would submit to your supervisor in a professional setting. Be sure to use proper grammar in your explanations.