itand off ta a Eew chner and retire to Hicrida. 1. The revenues at Mils current located are as fothanst - Salce value- 39 per hotdsy. 5ale price for bethogs increase every year by sote. - Dralso sico,0co - Oulver frod aalese. 8.55,000 - License ame rent costa 5150,600 - Mawe materialas - Hotdoge 22 per hotdog Rare material price per letuleg goes up by lows every year. -Drinias 538,480 Other food mupplies- 558,900 - Vonfoces rupplicse 390,200 3. John eqtimates that the cost of atarting up a stand wils he as fallowst - Furchase of retail kiodk (molik retail food outled) 5 whecose - Specintired kitchen equipmeat 350600 - I ratailitisa of the ke seben cquipment 310.000 - Fureitare and fittings 550,000 itand off ta a Eew chner and retire to Hicrida. 1. The revenues at Mils current located are as fothanst - Salce value- 39 per hotdsy. 5ale price for bethogs increase every year by sote. - Dralso sico,0co - Oulver frod aalese. 8.55,000 - License ame rent costa 5150,600 - Mawe materialas - Hotdoge 22 per hotdog Rare material price per letuleg goes up by lows every year. -Drinias 538,480 Other food mupplies- 558,900 - Vonfoces rupplicse 390,200 3. John eqtimates that the cost of atarting up a stand wils he as fallowst - Furchase of retail kiodk (molik retail food outled) 5 whecose - Specintired kitchen equipmeat 350600 - I ratailitisa of the ke seben cquipment 310.000 - Fureitare and fittings 550,000 2. John estimates that anneal eperating costs for Mis sthad as followis - Kitchea and service staff ( 5 people)- tect of 5200,000 per yese - License ased reat coss 3150,000 - Raw maserials: - Hodogs- 52 per boedog. Rew material peice per hotdog goes ap by Iow every year. - Drieler $38,400 - Other food repplies- 558,900 -Nonfood supplies- 550,200 3. Jobn extimates that the cont of atarting up a stand will be as fallownt - Phurchase of retail libek (mobile readil foed ouded) 5500,000 - Specialined kitchen tquiparient 550,000 - Fumiture and fitinges 350,000 4. Orer informatleat - Margiral tax rate is 3sy - Cost of Capieal is 10% - Cost of the stand (kionk), together with the cost of the equipment, finniture and fintings and the Note: The deflinaion of an assets cost is all costs that are nosevary te get an asect in place and ready for use. 1. Construct a model in Fxeel to evaluate the project. (linpot values in sheet I) 2. What is the NPV of this irvestment 3. Considat several values of cest of capital ftem 7 th to 13\%. Loelting at the chart, insert your ebservations and cocelusion ea pese 2 . itand off ta a Eew chner and retire to Hicrida. 1. The revenues at Mils current located are as fothanst - Salce value- 39 per hotdsy. 5ale price for bethogs increase every year by sote. - Dralso sico,0co - Oulver frod aalese. 8.55,000 - License ame rent costa 5150,600 - Mawe materialas - Hotdoge 22 per hotdog Rare material price per letuleg goes up by lows every year. -Drinias 538,480 Other food mupplies- 558,900 - Vonfoces rupplicse 390,200 3. John eqtimates that the cost of atarting up a stand wils he as fallowst - Furchase of retail kiodk (molik retail food outled) 5 whecose - Specintired kitchen equipmeat 350600 - I ratailitisa of the ke seben cquipment 310.000 - Fureitare and fittings 550,000 itand off ta a Eew chner and retire to Hicrida. 1. The revenues at Mils current located are as fothanst - Salce value- 39 per hotdsy. 5ale price for bethogs increase every year by sote. - Dralso sico,0co - Oulver frod aalese. 8.55,000 - License ame rent costa 5150,600 - Mawe materialas - Hotdoge 22 per hotdog Rare material price per letuleg goes up by lows every year. -Drinias 538,480 Other food mupplies- 558,900 - Vonfoces rupplicse 390,200 3. John eqtimates that the cost of atarting up a stand wils he as fallowst - Furchase of retail kiodk (molik retail food outled) 5 whecose - Specintired kitchen equipmeat 350600 - I ratailitisa of the ke seben cquipment 310.000 - Fureitare and fittings 550,000 2. John estimates that anneal eperating costs for Mis sthad as followis - Kitchea and service staff ( 5 people)- tect of 5200,000 per yese - License ased reat coss 3150,000 - Raw maserials: - Hodogs- 52 per boedog. Rew material peice per hotdog goes ap by Iow every year. - Drieler $38,400 - Other food repplies- 558,900 -Nonfood supplies- 550,200 3. Jobn extimates that the cont of atarting up a stand will be as fallownt - Phurchase of retail libek (mobile readil foed ouded) 5500,000 - Specialined kitchen tquiparient 550,000 - Fumiture and fitinges 350,000 4. Orer informatleat - Margiral tax rate is 3sy - Cost of Capieal is 10% - Cost of the stand (kionk), together with the cost of the equipment, finniture and fintings and the Note: The deflinaion of an assets cost is all costs that are nosevary te get an asect in place and ready for use. 1. Construct a model in Fxeel to evaluate the project. (linpot values in sheet I) 2. What is the NPV of this irvestment 3. Considat several values of cest of capital ftem 7 th to 13\%. Loelting at the chart, insert your ebservations and cocelusion ea pese 2
