Question: please help :-) answer in Excel format Question 2 8 pts A local supermarket is planning to install a sushi vending machine. The machine will

please help :-) answer in Excel format please help :-) answer in Excel format Question 2 8 pts A

Question 2 8 pts A local supermarket is planning to install a sushi vending machine. The machine will cost $66,000 today. Your accountants tell you it must be depreciated evenly to zero over 6 years. Sushi revenues the first year are estimated to be $40,000, increasing by 6% each year. Sushi and labor costs will be $30,000 the first year, also increasing by 6% each year. Assume these revenues and costs are realized at the end of the year (so they show up for the first time in year 1). Health regulations mandate that supermarket sushi vending machines must be replaced every 5 years. You expect to be able to sell the machine to an eccentric foodie at the end of 5 years for $30,000. An initial $1,000 investment in inventory must also be made today. Inventory grows by 6% each year until year 5 when the inventory drops to zero. The tax rate is 20%, and the discount rate is 9%. Assume this machine will not impact the store in any other way (e.g.. increase foot traffic). Is installing this machine a good idea, financially? Prepare and upload a spreadsheet that calculates free cash flows, NPV and IRR of the free cash flows. Each correct element of free cash flows will earn points, so show them clearly in your spread sheet for each year as we did in our examples. Question 2 8 pts A local supermarket is planning to install a sushi vending machine. The machine will cost $66,000 today. Your accountants tell you it must be depreciated evenly to zero over 6 years. Sushi revenues the first year are estimated to be $40,000, increasing by 6% each year. Sushi and labor costs will be $30,000 the first year, also increasing by 6% each year. Assume these revenues and costs are realized at the end of the year (so they show up for the first time in year 1). Health regulations mandate that supermarket sushi vending machines must be replaced every 5 years. You expect to be able to sell the machine to an eccentric foodie at the end of 5 years for $30,000. An initial $1,000 investment in inventory must also be made today. Inventory grows by 6% each year until year 5 when the inventory drops to zero. The tax rate is 20%, and the discount rate is 9%. Assume this machine will not impact the store in any other way (e.g.. increase foot traffic). Is installing this machine a good idea, financially? Prepare and upload a spreadsheet that calculates free cash flows, NPV and IRR of the free cash flows. Each correct element of free cash flows will earn points, so show them clearly in your spread sheet for each year as we did in our examples

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!