Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is a complete question. It needs to be answered in excel format Question 2 8 pts A local supermarket is planning to install a

this is a complete question. It needs to be answered in excel format
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behavioral Finance And Capital Markets

Authors: A. Szyszka

5th Edition

1137338741, 9781137338747

More Books

Students also viewed these Finance questions

Question

What is Tax Planning?

Answered: 1 week ago