Please I need a solution for this. Part 1,2,3

rage Layout Formulas S019383 Data Review View Help Calibri - 11 A === A A General Wrap Text Merge & Center - AutoSum BIU Ad Insert Delete Format Sort Conditional Formatas Cell Formatting Table Styles Styles Clear Alignment Number D F G H To start their chain of Videogame Cafes, the company requires an initial investment of 450.000 TL. However, the company only has 300,000 TL cash to Part 1 on hand, therefore Muratcan, the CEO of Game101 Center, is requesting a 150,000.00 TL loan from BANK KUM. The bank gives the annual interest rate for 7 years loan as 14%. 1 Report the yearly payment of the loan. Muratcan doesn't want to pay more than 30710 TL per year. He asks to pay the remainder as a lump sum payment at the end of the loan. What will be the lump sum payment amount? Answers 3 The other option is for Muratcan to lower the amount of the loan. What is the loan amount that will allow him to pay 30710 TL per year? -50 Another bank, BANK DALGA, has approached Muratcan with a better interest rate that will allow the payment 30710 TL for a loan of 150,000 TL. What is the new interest rate? (Assume that all the other variables are constant.) 00 1.00 1.00 2.00 Muratcan wants to see whether this Investment is worth or not. Hence, he consulted Jason Lau to calculate the NPV and IRR of the investment. Muratcan already Part 2 did his research and gave the Data Table A to Jason. Muratcan wants to make money at least 25% of his investment by selling the company for 1,050,000 TL Assume that Muratcan took the loan from BANK DALGA. 1 Calculate the NPV of the investment 2 Report the IRR for this investment. 3 Should Muratcan make the investment? Left Click Muratcan is worried about whether he can sell the cafes for for 1,050,000 TL after 7 years. What is the minimum selling price that will still provide him with an annual rate of return of %25. At the end of the 3rd year, Muratcan decided to make an advertisement to increase the income 4% each year, so he paid 42906 TL per year to the advertisement 5 company. Finally he asked Jason to calculate the expected rate of return which makes NPV O. (Hint: Use selling price mentioned at Part 2 independent from question 4) Advertisement starting from year 4) At second year of Game101 Cafe, Corona Virus Disease (COVID-19) appears and the government shut down all entertainment cafes for one year which means you Part 3 will pay all the costs but can't make money during the year. On the other hand, the bank has agreed to charge on for one year's payment. (Hint: remember Muratcan took the loan from BANK DALGA.) Muratcan has 2 option to sterilize his cafe. The first option is sterilizing it today for 8,500 TL and the second one is sterilizing at the end of the year for 9,500 TL How much Instructions Accounting Finance 2.00 Type here to search Faye Layout Formulas Data Review View Help Calibri AA == 11 - General AutoSum 3 Wrap Text Merge & Center - 37 BIU - A - %29 Formatting Table Styles Clear Moment Sort & Filters Editing Number stries G H At second year of Game101 Cafe, Corona Virus Disease (COVID-19) appears and the government shut down all entertainment cafes for one year which means you Part 3 will pay all the costs but can't make money during the year. On the other hand, the bank has agreed to charge 0% for one year's payment. (Hint: remember Muratcan took the loan from BANK DALGA.) Muratcan has 2 option to sterilize his cafe. The first option is sterilizing it today for 8,500 TL and the second one is sterilizing at the end of the year for 9,500 TL How much is the difference between two options in terms of today's money? The expected annual inflation rate is 10% (Report a positive number) 2 Report the difference between the old loan payment (before the Coronavirus Disease) and the new loan payment. 3 According to this new scenario, what is the NPV of the Videogame Caf project? Muratcan's Cost of Capital is still 25% ..00 200 1.00 With the government shutdown, Muratcan also wants to negotiate with the landlord to lower the rent that year. What is the rent he can afford to pay in Year 2 that will still allow him to earn 25% annually from the entire project? tal: Years Revenue Cost Cash Flow Data Table A - Financial data for Game 101 Center Initial Cost 450,000.00 Selling Price 1,050,000.00 Annual Revenue Income 210,000.00 Annual Expenses Human Resources 70,000.00 Maintenance 12,000.00 Rent 33,000.00 WNIO NPV Instructions Accounting Finance Type here to search