AutoSave S007312 File Home Insert Page Layout Formulas Data Review View Help Acrobat Search Calibri 10 Number X Cut [b Copy Format Painter Paste AA == 25 Wrap Text A Merge & Center BTU KEB%9 Clipboard Font Alignment Number A43 > A B D E F G H 24 TABLE A 25 Use the provided data in this model to answer the questions 26 Initial Cost Cost of Capital Selling Price Revenue Annual Cost 415619,00 0,25 730000,00 27 28 29 30 31 32 33 34 35 Revenue - Cost Table Revenue 640,00 on weekdays per day 850,00 6 on weekends per day 36 37 Revenue (Weekly Revenue [Yearly 38 39 Costs 0,55 of the weekly revenue 40 Variable Cost (Weekly) Fixed Cost Monthly) Annual Cost 850,00 41 42 43 Instructions Answers 1 Answers + Select destination and press ENTER or choose Paste Aramak iin buraya yazn O BI ED - 29 Wrap Text General Calibri -10 A A BIU-EB a. A Format Painter ED: Merge Center 2005 - %) Conditional Formatas Cell Formatting Table - Style Chipboard Font fi E 5 min and Sinem are old friends. One day, Sinem had an opportunity and she can take evera caleat Takim for a low price due to the CONVID 19. You can points/Questiom see the financial values in the tables given below Tahle Al. Emin wants to help and maybe become a partner of the cale by making finance calculations to see whether the cale bas profitable enough for 7 years. Sinem wants to modify the cale a little bit and then start serving in year 1 and they will sell the cafe at the end of year 7. Moreover, Emink curto Part 1 about the investment and wants to analyze it by assuming the sales at Revenue Cost Table. Use TABLE 1 and TABLE A 1 What is the cash flow in the year that they started to operate? 1 Report the value of revenue that is expected in the 3rd year, in terms of today 1 What is the amount of money that the business Eenebes above their expectations in today's terms? Sinem is excited about the idea that they will gain so much money at the end of 7 years Report the difference between the values of first year's d revenue and last year's revenue in terms of today. (Report a positive number.) What is the internal rate of return of the cale investment 1 1 Part 2 1 1,5 D Part 3 3 b Please choose the correct choice to complete the sentence and answer the question An NPV value that is equal to zero means that the business makes the amount they expected to make It Sinem finds another investment option with the same initial cost and 30% rate of return, should they take the this new option over the cafe? (Compare to the IRR of Table) Indeed, Sinem and Emin are waiting for the COVID-19 Pandemic to end. Assume that normalization will be completed after 3 years from now. After that, there are several possible scenarios given below. (Hint: All scenarios have to be considered independently so you should solve them separately on separate tables.) (Compare each question with TABLE 1 when the difference is asked.) As a result, weekday revenue increases by 35%, and weekend revenue increases by 60% at the beginning of the 3rd year, and then they remain the same. What is the difference between the new and old internal rate of return? (Report a positive value.) (Hint: Variable cost also increasest)(Use TABLE 2) After the normalization, Sinem organizes parties, each has a revenue of 4500 & and a cost of 2800 t twice per week starting from year 3. Report the change in the NPV. (Report a positive number.) (Use TABLE 3) In order to have better quality. Sinem wants to use better products variable cost ratio (percentage according to revenue given in TABLE 1) increases. Emin says that the variable cost shouldn't exceed a ratio if you want to gain exactly the expected amount of money Report this treshold ratio. (Use TABLE 4) (Start from year 1) At the end of the business, Emin thinks that they will have a valuable cafe brand. Hence, he doesn't want to sell the place for the given value instead he wants to sell it for a price that will increase the IRR to 359 Report the selling price value that Emin needs. (Use TABLE 5) Rather than paying all of the initial costs themselves, Emin and Sinem decide to take a loan. The loan will cover 50% of its initial cost, has an annual interest rate of 15%. They will start paying the loan in the first year and pay for it until the 7th year, included. The government decided to support the small business after the pandemic, so they will pay 10% of the loan's yearly payments. (Use TABLE 6) (Hint: If the yearly loan payments are 100 TL, Emin and Sinem will pay 90 TL and the government will pay 10 TL.) What is their yearly loan payment that Emin and Sinem should pay? What is the new NPV now, after the loan payments and government support? What is the total present value of government payments? c d Part 4 a b 3 3 4 225 TARIFA Answers 1 Answers Instructions tination and press ENTER or choose Paste O Aramak iin buraya yazn Paste BIU a-A- Merge & Center e % % 088 Formatting Table Styles Format Painter Number Clipboard Alignment Styles Font Al 1 M 5 7 b Emin and Sinem are old friends. One day, Sinem had an opportunity and she can take over a cafe at Taksim for a low price due to the COVID-19. You can Points Ouestion see the financial values in the tables given below (Table A). Emin wants to help and maybe become a partner of the cafe by making financial calculations to see whether this cafe is profitable enough for 7 years. Sinem wants to modify the cafe a little bit and then start serving in year 1 and they will sell the cafe at the end of year 7. Moreover, Emin is curious about Part 1 the investment and wants to analyze it by assuming the sales at Revenue Cost Table. Use TABLE 1 and TABLE A. 1 . What is the cash flow in the year that they started to operate? 1 Report the value of revenue that is expected in the 3rd year in terms of today 1 What is the amount of money that the business generates above their expectations in today's terms? Sinem is excited about the idea that they will gain so much money at the end of 7 years. Report the difference between the values of first year's 2 d revenue and last year's revenue in terms of today (Report a positive number.) 1 What is the internal rate of return of the care investment? Part 2 Please choose the correct choice to complete the sentence and answer the question. 1 An NPV value that is equal to zero means that the businness makes the amount they expected to make I Sineminds another investment option with the same initial cost and 30% rate of return, should they take the this new option over the cafe? 15 Compare to the IRR of Tablel) 10 11 12 13 14 3 15 16 Indeed, Sinem and Emin are waiting for the COVID-19 Pandemic to end. Assume that normalization will be completed after 3 years from now. After that, Part there are several possible scenarios given below. (Hint: All scenarios have to be considered independently so you should solve them separately on separate tables.) (Compare each question with TABLE 1 when the difference is asked.) As a result, weekday revenue increases by 35%, and weekend revenue increases by 60% at the beginning of the 3rd year, and then they remain the seme What is the difference between the new and old internal rate of return? (Report a positive value.) (Hint: Variable cost also increases!)(Use TABLE 2) After the normalization, Sinem organizes parties, cach has a revenue of 4500 4 and a cost of 2800 t twice per week starting from year 3. Report the change in the NPV. (Repart a positive number. (Use TABLE 3) in order to have better quality, Sinem wants to use better products so the variable cost ratio (percentage according to revenue given in TABLE 1) increases. Emin says that the variable cost shouldn't exceed a ratio if you want to gain exactly the expected amount of money Report this treshhold ratio (Use TABLE 4 (Start from year 1) At the end of the business, Emin thinks that they will have a valuable cafe brand Hence, he doesn't want to sell the place for the given value, instead he wants to sell it for a price that will increase the IRR to 35%. Report the selling price value that Emin needs. (Use TABLE 5) Rather than paying all of the initial costs themselves, Emin and Sinem decide to take a loan. The loan will cover 50% of its initial cost, has an annual interest rate of 15%. They will start paying the loan in the first year and pay for it until the 7th year, included. The government decided to support the small business after the pandemic, so they will pay 10% of the loan's yearly payments. (Use TABLE 6) (Hint: If the yearly loan payments are 100 TL, Emin and Sinem will pay 90 TL and the government will pay 10 TL) What is their yearly loan payment that Emin and Sinem should pay? What is the new NPV now, after the loan payments and government support? What is the total present value of government payments? Instructions Answers Answers 18 d 15 3 a 21 4 Select destination and press ENTER or choose Paste HE Aramak iin buraya yazn o i AutoSave S007312 File Home Insert Page Layout Formulas Data Review View Help Acrobat Search Calibri 10 Number X Cut [b Copy Format Painter Paste AA == 25 Wrap Text A Merge & Center BTU KEB%9 Clipboard Font Alignment Number A43 > A B D E F G H 24 TABLE A 25 Use the provided data in this model to answer the questions 26 Initial Cost Cost of Capital Selling Price Revenue Annual Cost 415619,00 0,25 730000,00 27 28 29 30 31 32 33 34 35 Revenue - Cost Table Revenue 640,00 on weekdays per day 850,00 6 on weekends per day 36 37 Revenue (Weekly Revenue [Yearly 38 39 Costs 0,55 of the weekly revenue 40 Variable Cost (Weekly) Fixed Cost Monthly) Annual Cost 850,00 41 42 43 Instructions Answers 1 Answers + Select destination and press ENTER or choose Paste Aramak iin buraya yazn O BI ED - 29 Wrap Text General Calibri -10 A A BIU-EB a. A Format Painter ED: Merge Center 2005 - %) Conditional Formatas Cell Formatting Table - Style Chipboard Font fi E 5 min and Sinem are old friends. One day, Sinem had an opportunity and she can take evera caleat Takim for a low price due to the CONVID 19. You can points/Questiom see the financial values in the tables given below Tahle Al. Emin wants to help and maybe become a partner of the cale by making finance calculations to see whether the cale bas profitable enough for 7 years. Sinem wants to modify the cale a little bit and then start serving in year 1 and they will sell the cafe at the end of year 7. Moreover, Emink curto Part 1 about the investment and wants to analyze it by assuming the sales at Revenue Cost Table. Use TABLE 1 and TABLE A 1 What is the cash flow in the year that they started to operate? 1 Report the value of revenue that is expected in the 3rd year, in terms of today 1 What is the amount of money that the business Eenebes above their expectations in today's terms? Sinem is excited about the idea that they will gain so much money at the end of 7 years Report the difference between the values of first year's d revenue and last year's revenue in terms of today. (Report a positive number.) What is the internal rate of return of the cale investment 1 1 Part 2 1 1,5 D Part 3 3 b Please choose the correct choice to complete the sentence and answer the question An NPV value that is equal to zero means that the business makes the amount they expected to make It Sinem finds another investment option with the same initial cost and 30% rate of return, should they take the this new option over the cafe? (Compare to the IRR of Table) Indeed, Sinem and Emin are waiting for the COVID-19 Pandemic to end. Assume that normalization will be completed after 3 years from now. After that, there are several possible scenarios given below. (Hint: All scenarios have to be considered independently so you should solve them separately on separate tables.) (Compare each question with TABLE 1 when the difference is asked.) As a result, weekday revenue increases by 35%, and weekend revenue increases by 60% at the beginning of the 3rd year, and then they remain the same. What is the difference between the new and old internal rate of return? (Report a positive value.) (Hint: Variable cost also increasest)(Use TABLE 2) After the normalization, Sinem organizes parties, each has a revenue of 4500 & and a cost of 2800 t twice per week starting from year 3. Report the change in the NPV. (Report a positive number.) (Use TABLE 3) In order to have better quality. Sinem wants to use better products variable cost ratio (percentage according to revenue given in TABLE 1) increases. Emin says that the variable cost shouldn't exceed a ratio if you want to gain exactly the expected amount of money Report this treshold ratio. (Use TABLE 4) (Start from year 1) At the end of the business, Emin thinks that they will have a valuable cafe brand. Hence, he doesn't want to sell the place for the given value instead he wants to sell it for a price that will increase the IRR to 359 Report the selling price value that Emin needs. (Use TABLE 5) Rather than paying all of the initial costs themselves, Emin and Sinem decide to take a loan. The loan will cover 50% of its initial cost, has an annual interest rate of 15%. They will start paying the loan in the first year and pay for it until the 7th year, included. The government decided to support the small business after the pandemic, so they will pay 10% of the loan's yearly payments. (Use TABLE 6) (Hint: If the yearly loan payments are 100 TL, Emin and Sinem will pay 90 TL and the government will pay 10 TL.) What is their yearly loan payment that Emin and Sinem should pay? What is the new NPV now, after the loan payments and government support? What is the total present value of government payments? c d Part 4 a b 3 3 4 225 TARIFA Answers 1 Answers Instructions tination and press ENTER or choose Paste O Aramak iin buraya yazn Paste BIU a-A- Merge & Center e % % 088 Formatting Table Styles Format Painter Number Clipboard Alignment Styles Font Al 1 M 5 7 b Emin and Sinem are old friends. One day, Sinem had an opportunity and she can take over a cafe at Taksim for a low price due to the COVID-19. You can Points Ouestion see the financial values in the tables given below (Table A). Emin wants to help and maybe become a partner of the cafe by making financial calculations to see whether this cafe is profitable enough for 7 years. Sinem wants to modify the cafe a little bit and then start serving in year 1 and they will sell the cafe at the end of year 7. Moreover, Emin is curious about Part 1 the investment and wants to analyze it by assuming the sales at Revenue Cost Table. Use TABLE 1 and TABLE A. 1 . What is the cash flow in the year that they started to operate? 1 Report the value of revenue that is expected in the 3rd year in terms of today 1 What is the amount of money that the business generates above their expectations in today's terms? Sinem is excited about the idea that they will gain so much money at the end of 7 years. Report the difference between the values of first year's 2 d revenue and last year's revenue in terms of today (Report a positive number.) 1 What is the internal rate of return of the care investment? Part 2 Please choose the correct choice to complete the sentence and answer the question. 1 An NPV value that is equal to zero means that the businness makes the amount they expected to make I Sineminds another investment option with the same initial cost and 30% rate of return, should they take the this new option over the cafe? 15 Compare to the IRR of Tablel) 10 11 12 13 14 3 15 16 Indeed, Sinem and Emin are waiting for the COVID-19 Pandemic to end. Assume that normalization will be completed after 3 years from now. After that, Part there are several possible scenarios given below. (Hint: All scenarios have to be considered independently so you should solve them separately on separate tables.) (Compare each question with TABLE 1 when the difference is asked.) As a result, weekday revenue increases by 35%, and weekend revenue increases by 60% at the beginning of the 3rd year, and then they remain the seme What is the difference between the new and old internal rate of return? (Report a positive value.) (Hint: Variable cost also increases!)(Use TABLE 2) After the normalization, Sinem organizes parties, cach has a revenue of 4500 4 and a cost of 2800 t twice per week starting from year 3. Report the change in the NPV. (Repart a positive number. (Use TABLE 3) in order to have better quality, Sinem wants to use better products so the variable cost ratio (percentage according to revenue given in TABLE 1) increases. Emin says that the variable cost shouldn't exceed a ratio if you want to gain exactly the expected amount of money Report this treshhold ratio (Use TABLE 4 (Start from year 1) At the end of the business, Emin thinks that they will have a valuable cafe brand Hence, he doesn't want to sell the place for the given value, instead he wants to sell it for a price that will increase the IRR to 35%. Report the selling price value that Emin needs. (Use TABLE 5) Rather than paying all of the initial costs themselves, Emin and Sinem decide to take a loan. The loan will cover 50% of its initial cost, has an annual interest rate of 15%. They will start paying the loan in the first year and pay for it until the 7th year, included. The government decided to support the small business after the pandemic, so they will pay 10% of the loan's yearly payments. (Use TABLE 6) (Hint: If the yearly loan payments are 100 TL, Emin and Sinem will pay 90 TL and the government will pay 10 TL) What is their yearly loan payment that Emin and Sinem should pay? What is the new NPV now, after the loan payments and government support? What is the total present value of government payments? Instructions Answers Answers 18 d 15 3 a 21 4 Select destination and press ENTER or choose Paste HE Aramak iin buraya yazn o i