please send me the calculation and the things i need yo prepare too thanks a lot good luck

QUESTION 1 0 Suppose that you are working as a capital budgeting analyst in a finance department of a firm and you are going to evaluate two mutually exclusive projects by implementing different capital budgeting techniques. The cash flows for these two projects are given below. YEAR CASH FLOW (A) CASH FLOW (B) -$17,000 -$17,000 8,000 2,000 2 7,000 5,000 3 5,000 9,000 4 3,000 9,500 1 Calculate the Payback Period of each project. Which project should you accept according to this method? Explain whether the Payback Period is or is not an appropriate method in this case. (5 points) 2 Suppose that the discount rate is 11%. Calculate the Net Present Values (NPV) of both projects. Which project should you accept according to NPV? Evaluate your findings (10 points) 3. Calculate the Internal Rate of Returns (IRR) for both projects (use excel). Which project should you accept? Evaluate the IRR values of these two projects. (10 points). (UPLOAD YOUR EXCEL FILE TO SAKAI) 4. The crossover point on NPV profile is 12.18%. Above that point which project should you accept? Explain the relevance of the crossover point. How should you convince your boss that the NPV method is the way to go when it is compared with IRR? In other words what are the shortcomings of IRR method? (5 points) 5. Calculate the Profitability Index for each proposal. Which project should you accept? Can this measure help to solve the dilemma? Explain. (5 points) 6. What can be the last decision? Why? Explain (5 points) (SHOW YOUR CALCULATIONS AND MAKE YOUR EVALUATIONS) QUESTION 2 The web page of each bank in Turkey has a financial calculator that will prepare a loan amortization table based on your inputs. If you follow the "Auto Loan Calculator" link, you can calculate the monthly payments of your loan and this link will prepare a payment plan for your loan. Suppose that you want to buy an automobile with a bank loan. Search for different "auto loans" of different banks in Turkey and choose the most appropriate one for you. Give the name of the bank. Determine how much you want to borrow and in how many years you can pay it back with monthly payments by yourself. 1. What is the Annual Percentage Rate (APR) (Nominal rate) on this loan? What is the Effective Annual Rate (EAR)? (10 points) (SHOW YOUR CACULATIONS) 2. Prepare loan amortization table (payment plan) by using the calculator on the web page of the bank for the loan you choose with monthly payments at the rate quoted by this bank. (10 points) (UPLOAD THE PAYMENT PLAN OF YOUR LOAN TO SAKAT) 3. What is the monthly payment? What percentage of your first month's payment is the principal? What percentage of your last month's payment is the principal? What is the total interest paid on the loan? (20 points) (SHOW YOUR CACULATIONS) I QUESTION 3 Why is it important for a firm to minimize the length of its cash conversion cycle (CCC)? How can the firm minimize it? What are the strategies that the firm should consider while trying to minimize the CCC? (20 points)