You should answer the below questions in one MS Excel file and upload accordingly.

1) Assume that you want to buy a house, a car or a household appliance (Fridge, A smart TV, A washing machine etc.) and you decide to borrow from a bank. However, you dont know which bank you will choose. Hence:

a) Display your borrowing options by referring to actual values from the web sites of banks. Then, specify the interest rate for taking credit from three different banks for minimum 36 periods payment plan. Indicate the multiple cash flow analysis for these three banks and compare the total present value of the money. Which one do you prefer?

b) For the bank which you choose; form the loan amortization table that includes minimum 36 payment period.

c) Prepare a meaningful Scenario (reflected with a Scenario Summary Report) to represent the above (or a part of it) case. Moreover, display your scenario with a suitable and a meaningful chart

2) Present the financial statements of a real company; either balance sheet or income statement or cash flow statement for four periods (e.g. annual (for recent four years) or quarterly). For these financial statements follow the below instructions1:

a) Write (& solve) a meaningful question in order to conduct a sensitivity analysis by having one variable data table.

b) Write a meaningful (& solve) question in order to conduct a sensitivity analysis by having two variables data table. Display your analysis with a chart that includes the required formatting issues such as horizontal/vertical axis titles etc.

c) Give logical names to the required places and accordingly create three different scenarios by considering the below instructions: i. Define the necessary instructions for each of the scenario. Compose the scenarios in line with the directions. ii. Compare these scenarios with each other by having charts, which include the required formatting issues. iii. Write a scenario summary report question and display the scenarios that you have created in the (i) part.

* You can use different financial statements for part (a), (b) and (c). If so, please show the related financial statement at the beginning of each part.