Step 2: Creating the Investment Scenario

The calculations for this assignment will involve an imaginary investment scenario. The data shown represents outlays (expenses) in red, and inflows (revenues) in green. The interest rate provided is assumed to be a nominal annual rate, compounded annually. This can also be called an IRR (internal rate of return).

Beginning in Cell A17, you will create the problem/investment scenario that corresponds to the timeline generated using your student number. Every student will have a different scenario! Be creative. This scenario should be written in full sentences, using proper grammar and mathematical terminology. The scenario should incorporate all relevant information contained in the timeline. As a guide, think about what you would need to include if the timeline didn't already exist. Do not forget about any information.

You will not be given full marks if you simply state the values in the problem. You must create a realistic scenario on which the numbers could be based.

Step 3: Solve the Investment Problem

Solve the investment problem using Excel. Remember to include ALL work (show all the variables required in Excel), and communicate your process. Your final answer should be clearly visible and a final sentence and investment recommendation should be included.

X A17 D G H M N 0 P P R 5 T u V w w Y A B 1 1 Student ID 2 (last 6 digits) 3 238410 4 5 6 Yearly 0 5 6 S I = 8.41% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $61,500 $41,000 $23,841 7 8 Initial Investment $115,000 9 9 10 Reoccuring Outlay $3,000 11 12 Residual Value 13 14 Inflows 15 16 INVESTMENT SCENARIO: 17 18 19 20 21 22 23 SOLUTION: 74 25 26 27 28 29 30 31 32 33 24 Investment Project (+) 15 10:10 PM ENG IN 2021-11-07 5 X A17 D G H M N 0 P P R 5 T u V w w Y A B 1 1 Student ID 2 (last 6 digits) 3 238410 4 5 6 Yearly 0 5 6 S I = 8.41% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $61,500 $41,000 $23,841 7 8 Initial Investment $115,000 9 9 10 Reoccuring Outlay $3,000 11 12 Residual Value 13 14 Inflows 15 16 INVESTMENT SCENARIO: 17 18 19 20 21 22 23 SOLUTION: 74 25 26 27 28 29 30 31 32 33 24 Investment Project (+) 15 10:10 PM ENG IN 2021-11-07 5