FIN 3100 INTRO TO FINANCIAL MARKETS

FIN 3100 INTRO TO FINANCIAL MARKETS
TAKE-HOME PORTION OF THE FINAL EXAM

This take-home portion counts for 10% of your final exam grade and is due via dropbox. Late submissions will not be graded. Download the Cash ‘n’ Careers tool from https://wmich.edu/businessnews/mattross.html Use the instructions and comments in this tool to earn points by completing the ten following items:
1) Identify a sibling, friend, acquaintance, or some other individual graduating from a US high school in May of 2017. This individual can be fictitious or a younger version of you. Edit the orange colored cells on row 9 of the Career Comparison worksheet to reflect this individual. Search the BLS website to explore career options. Select potential career paths and adjust the default values for this individual. Enter the career/job name and estimated salary in all orange colored cells. Paste an image with the new information. (10 points)
Example:

2) Use one sentence per career path to indicate why your selections suit this individual. (10 points)

3) Enter the cost of living, tuition, and other expected cash flows for this individual in the orange cells on row 20. Paste an image with the new information. (5 points)
Example:

4) Use one sentence per figure – six total sentences – to indicate why you selected each value. (25 points)

5) Complete step 4 in the spreadsheet. Paste an image with the loans, savings, and monthly payment information and output values. (10 points)
Example:

6) In two sentences explain why you would recommend either option. (10 points)

7) Go to the Government Figures worksheet. Divide your age by 4 and enter the result as the rate of Annual Inflation (C8). Paste an image with the new value. (5 points)
Example if your age is 38:

8) Return to the Career Comparison worksheet and complete step 4 again. Paste an image with the new values including all of the pink colored cells. (5 points)
Example:

9) In one sentence, explain how the new inflation rate changes your NPV projections. (10 points)

10) Would an FOMC focus on reducing inflation or reducing unemployment be a better for the college track you just modeled? Explain in one sentence. (10 points)

Extra Credit: Identify an error or suggest a substantial improvement to the Cash ‘n’ Careers tool. If I make a change resulting from your comment, I will award 5 points of extra credit to your homework grade in FIN31

Get a 10 % discount on an order above $ 100
Use the following coupon code :
BEST16
error: Content is protected !!