PART 1: Basic Calculations via Excel Using the information given in tutorial video, now it is your turn to understand how to use the basic formulations via Excel. 1. Choose any question from time value of money of your book and solve the question via excel. Do not forget to clearly show the given values of the question. You can choose a similar question from other sources, but do not forget to include source name and page numbers. 2. After you solve the question and find the answer, now alter the question at least once and calculate your new answer for the altered question (for example if the question asks you to find F given P, n, i you can change the question by asking annual payments and find A/P values. Play around as much as you want).

PART 2: Calculations with Different Compounding and Payment Periods Similar to what has been done in Part 1, now it is time to move on to more advanced questions. We had 2 cases to calculate equivalence analysis using effective interest rates. These cases were when payment periods and compounding periods coincide and differ. 1. Find and solve a question where payment and compounding periods are the same. Make neccesary calculations for your interest rate. 2. Find and solve a question where payment and compounding periods differ. This time, create a formula in excel that automatically calculates your effective interest rate. Using this formula, solve your question.

PART 3: Project Selection via Present Worth/Annual Equiavlance/Rate of Return Analysis This part will require you to be more creative compared to previous parts. We have learned 3 ways to compare mutually exclusive projects as present worth/annual equiavlance/rate of return analysis. 1. Choose your favorite analysis method when comparing mutually exclusive projects. Add small explanation why you have chosen this method in one of the excel cells. 2. Similar to what has been shown in tutorial video, analyze and compare at least 3 different projects (the information about the projects can be taken from related questions from your book/course slides or any other material you can find but do not forget to show your sources and references) 3. Now compare these projects using visual tools such as graphs. Think yourself as a project manager and your job is to find the best possible project and present it to the company owner. The visual tools therefore should be understandable, effective and efficient