SOLVE AND PART 3 SHOW FORMULA USED IN EXCEL FORMAT.

a Search the web a FD: XIUM S023159_13 - Microsoft Excel (Product Activation Tailed) Filc Home Insert Page Layout Formulas Data Reviw View Calibri - 12 AutoSum . Wran Tec Custom Accent1 Accent3 Accento PAS Accent2 . Conditional Format as Accents Torming Table A 2 Merge & Center 19 E Comma Insert Delete Format 1 Copy Format Painter Clipboard L11 Clear - Sort & Find Filter. Sed Editing For Alignment Number Styles Cels J K Document Recovery Excel has recovered the following files. Save the ones you wish to Available files 5023159 w. Ogral Version created in time the user... 13:00 Murday, 1 January 1001 a 13 B D E G H Since Al technologies are getting more advanced, smart home products are expected to attract more customers. So, at the beginning of year 3, Part 3 Milos believes that they can grow by 30 % once and stay the same after year 3. (Note that both revenues and expenses will increase.) (This part is independent of other parts, but the initial investment is still 2677437 TL.) 11 Milos thinks the store was achieving great success, and he decided to sell the store at the end of year 8 Instead of year 6. What is the new selling price of the company to achieve 45% IRR? (You can use tables D-1 and D-2 for this question. (This question is 12 independent.) After the brand got popular, they decided to open stores abroad to expand to the International market. An investor, Ece, wants a partnership with Milos in the NYC store. Ece is willing to cover 15% of the initial investment but demands 25% of the yearly b income as well as she will get 20% of the selling price. Report the new NPV. (The answer can be positive or negative.) (You can use tables E-1 and E-2 for this question. This question is independent.) Tolga came up with a new Idea for the R&D Team, which changed their annual expenses starting from and including year 3. If the new Net Present Value is 340.000TL, report the percentage change in the Annual Expenses. (Report a positive value.) (This 11 question is independent.) Eylul ll opens a savings account in FIBABANKA with a monthly interest rate of 2 %, solve the questions below accordingly. Assume that the savings Part 4 15 rate and lending rate are equal. Each question is independent. Eyll wants to buy a computer and she starts to deposit 450 TL each month to her account. After how many months can she a 16 buy the computer she wants that will cost 15.000 TL in the future? (Do not round the number.) She starts saving 120 TL into her account each month. She plans to save for one and a half years and use the saved money to b buy a new startphone. If the startphone custs 7800TL at the end of eighteen months how much more money does she need 17 to pay on top of her savings to buy the smartphone? in the begining Eyll deposits 12,000 TL into her account and plans to deposit surne armount to this account every month, so that she could buy her first car which will cost 155,000 TI at the end of 3 years. How much money does she need to deposit each month to buy her car after 3 years? (Return a positive number.) 18 Ali Vi has a savings account with an annual interest rate of 25%. Ali wants to invest his savings and he is considering three different options. Assume a Part 5 HEN Instructions Answers c ? Which file do I want to save CASA Ready BBW 100% 0 + Type here to search O X DE AJENG 22:11 2021-11-09 a Search the web a FD: S023159_13 - Microsoft Excel (Product Activation Tailed) XUN Filc Home Insert Page Layout Formula Data Review vien Calbri - 12 -AN AutoSum Wran Tec Accent1 Accent3 Accento BIU * Out 1 Copy Paste Format Painter Clipboard L11 A Custom Accent2 %. Conditional Format as Accents Torming Table Number BE Merge Center Comma Insert Delete Format 2 Clear Sort & Tind Ti Selec Editing For Alignment Styles Cels A B D 11 MN 0 Document Recovery Excel has recovered the following files. Save the ones you wish to 56 57 Year Available files 5023159 w. Congral Version created in time the user... 13:00 Murday, 1 January 1001 58 59 50 61 62 53 64 55 66 67 68 59 70 Table C.1 Initial Invest 267743/ revenue cast cash flow Cort of capital -2677437 Weekly Revenue 14,850 772200 202800 569400 Weekly Epenses 900 772200 202800 569400 772200 202800 569400 Ser Price G,000,000 841698 202800 638899 There are 52 weeks in a year. B41698 202800 638898 841698 202800 638898 NPV -927438.21 IRR 9.15% 1 1 2 3 + 5 Table C-2 2 Revenue Cost Cash Flow Discount factor present value $ 12.577 43700) 4 (2 671437.00) 1 -2577437 1 772,200.00 202.800.00 $ 560.400.00 0.8 455520 1 772,200.00 202,800.00 669.400.00 0.64 354416 t 772,200.00 202,800.000 569,400.00 0.512 291532.8 772,200.00 B 202.000.000 $69.400.00 0.4096 233229.24 1 772,200.00 202,800.00 669.400.00 0.32768 186500.992 1 772,200.00 202 800 000 569.400.00 0.262144 1402547935 NPV 1 ) (996,596.171 -9968951744 IRR 7.4495 G 72 Table D.1 Year Initial realment Cart of capital Weekly Revenue Weekly Epenses Selling Price 2677437 2555 14,850 3,900 6,000,000 74 75 75 77 78 79 80 B1 B2 1 1 2 2 3 3 4 Table D-2 Revenue Cost Cash Flow + $ 12.577 437.CO) (267T 437.00 1 772,200.00 202,800.00 $ 569.400.00 772,200.00 (202,800.00569.400.00 D 772,200.00 (202,800.00) D669.400.00 D 772,200.00 (202,000.00 D 469 400.00 ) + 772 200 009 202 03 00 569.400.00 1 772 200 00 (262,800.00 $ 569.400.00 1/2 200.000 202 HDO COMO 569 400.0D It 772,200.00 202,800.00 D 569,400.00 NPV (701.964,071 ( IRR 13 50 5 New Yearly Pren New Yearly penser There are 52 weeks in a year. 7 3 ? Which file do I want to save 34 85 85 R7 CASA Instructions Answers 10 Ready BBC || : + Type here to search o 22:12 O BE X DEI A ING 2021-11-09 a Search the web a FD: XIUM S023159_13 - Microsoft Excel (Product Activation Tailed) Filc Home Insert Page Layout Formulas Data Reviw View Calibri - 12 AutoSum . Wran Tec Custom Accent1 Accent3 Accento PAS Accent2 . Conditional Format as Accents Torming Table A 2 Merge & Center 19 E Comma Insert Delete Format 1 Copy Format Painter Clipboard L11 Clear - Sort & Find Filter. Sed Editing For Alignment Number Styles Cels J K Document Recovery Excel has recovered the following files. Save the ones you wish to Available files 5023159 w. Ogral Version created in time the user... 13:00 Murday, 1 January 1001 a 13 B D E G H Since Al technologies are getting more advanced, smart home products are expected to attract more customers. So, at the beginning of year 3, Part 3 Milos believes that they can grow by 30 % once and stay the same after year 3. (Note that both revenues and expenses will increase.) (This part is independent of other parts, but the initial investment is still 2677437 TL.) 11 Milos thinks the store was achieving great success, and he decided to sell the store at the end of year 8 Instead of year 6. What is the new selling price of the company to achieve 45% IRR? (You can use tables D-1 and D-2 for this question. (This question is 12 independent.) After the brand got popular, they decided to open stores abroad to expand to the International market. An investor, Ece, wants a partnership with Milos in the NYC store. Ece is willing to cover 15% of the initial investment but demands 25% of the yearly b income as well as she will get 20% of the selling price. Report the new NPV. (The answer can be positive or negative.) (You can use tables E-1 and E-2 for this question. This question is independent.) Tolga came up with a new Idea for the R&D Team, which changed their annual expenses starting from and including year 3. If the new Net Present Value is 340.000TL, report the percentage change in the Annual Expenses. (Report a positive value.) (This 11 question is independent.) Eylul ll opens a savings account in FIBABANKA with a monthly interest rate of 2 %, solve the questions below accordingly. Assume that the savings Part 4 15 rate and lending rate are equal. Each question is independent. Eyll wants to buy a computer and she starts to deposit 450 TL each month to her account. After how many months can she a 16 buy the computer she wants that will cost 15.000 TL in the future? (Do not round the number.) She starts saving 120 TL into her account each month. She plans to save for one and a half years and use the saved money to b buy a new startphone. If the startphone custs 7800TL at the end of eighteen months how much more money does she need 17 to pay on top of her savings to buy the smartphone? in the begining Eyll deposits 12,000 TL into her account and plans to deposit surne armount to this account every month, so that she could buy her first car which will cost 155,000 TI at the end of 3 years. How much money does she need to deposit each month to buy her car after 3 years? (Return a positive number.) 18 Ali Vi has a savings account with an annual interest rate of 25%. Ali wants to invest his savings and he is considering three different options. Assume a Part 5 HEN Instructions Answers c ? Which file do I want to save CASA Ready BBW 100% 0 + Type here to search O X DE AJENG 22:11 2021-11-09 a Search the web a FD: S023159_13 - Microsoft Excel (Product Activation Tailed) XUN Filc Home Insert Page Layout Formula Data Review vien Calbri - 12 -AN AutoSum Wran Tec Accent1 Accent3 Accento BIU * Out 1 Copy Paste Format Painter Clipboard L11 A Custom Accent2 %. Conditional Format as Accents Torming Table Number BE Merge Center Comma Insert Delete Format 2 Clear Sort & Tind Ti Selec Editing For Alignment Styles Cels A B D 11 MN 0 Document Recovery Excel has recovered the following files. Save the ones you wish to 56 57 Year Available files 5023159 w. Congral Version created in time the user... 13:00 Murday, 1 January 1001 58 59 50 61 62 53 64 55 66 67 68 59 70 Table C.1 Initial Invest 267743/ revenue cast cash flow Cort of capital -2677437 Weekly Revenue 14,850 772200 202800 569400 Weekly Epenses 900 772200 202800 569400 772200 202800 569400 Ser Price G,000,000 841698 202800 638899 There are 52 weeks in a year. B41698 202800 638898 841698 202800 638898 NPV -927438.21 IRR 9.15% 1 1 2 3 + 5 Table C-2 2 Revenue Cost Cash Flow Discount factor present value $ 12.577 43700) 4 (2 671437.00) 1 -2577437 1 772,200.00 202.800.00 $ 560.400.00 0.8 455520 1 772,200.00 202,800.00 669.400.00 0.64 354416 t 772,200.00 202,800.000 569,400.00 0.512 291532.8 772,200.00 B 202.000.000 $69.400.00 0.4096 233229.24 1 772,200.00 202,800.00 669.400.00 0.32768 186500.992 1 772,200.00 202 800 000 569.400.00 0.262144 1402547935 NPV 1 ) (996,596.171 -9968951744 IRR 7.4495 G 72 Table D.1 Year Initial realment Cart of capital Weekly Revenue Weekly Epenses Selling Price 2677437 2555 14,850 3,900 6,000,000 74 75 75 77 78 79 80 B1 B2 1 1 2 2 3 3 4 Table D-2 Revenue Cost Cash Flow + $ 12.577 437.CO) (267T 437.00 1 772,200.00 202,800.00 $ 569.400.00 772,200.00 (202,800.00569.400.00 D 772,200.00 (202,800.00) D669.400.00 D 772,200.00 (202,000.00 D 469 400.00 ) + 772 200 009 202 03 00 569.400.00 1 772 200 00 (262,800.00 $ 569.400.00 1/2 200.000 202 HDO COMO 569 400.0D It 772,200.00 202,800.00 D 569,400.00 NPV (701.964,071 ( IRR 13 50 5 New Yearly Pren New Yearly penser There are 52 weeks in a year. 7 3 ? Which file do I want to save 34 85 85 R7 CASA Instructions Answers 10 Ready BBC || : + Type here to search o 22:12 O BE X DEI A ING 2021-11-09