Joes Ice Cream Bar is looking to expand into offering espresso to offset some of...

60.1K

Verified Solution

Question

Finance

  1. Joes Ice Cream Bar is looking to expand into offering espresso to offset some of the slumps during the winter months. The initial investment to purchase the commercial grade machine will cost $30,000. The loan to purchase the machine will cost 7.5%, so the required rate of return is at least 7.5%.

Below are the estimated revenues expected over the next 5 years from the machine:

Year 1 - $6,250 Year 2 - $7,500 Year 3 - $8,500 Year 4 - $8,500 Year 5 - $8,000

Calculate the NPV using Excel. Is this a worthwhile investment? Why or why not? (Show all formulas/calculations)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students