Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. jane has the opportunity to expand her business on

Jane has the opportunity to expand her business one of two ways: 1....

70.2K

Verified Solution

Question

Finance

Jane has the opportunity to expand her business one of two ways:

1. For $50,000 she can open a new store. She will use a 7% loan to finance 100% of this project. She expects to need an additional $10,000 up front to purchase inventory and other working capital items. She will operate the store for 3 years and will sell it for $80,000 at the end of year 3, at which time she will recover her working capital. She expects to make $1,500 in year 1, $2,000 in year 2 and $3,000 in year 3 before selling the store.

2. For $75,000 she can open a web site retail business. She will finance this with a 10% loan. It is a higher rate as it is not secured by real estate. She will not need any additional working capital to start this business. She expects to make 5,000 in year 1, $6,000 in year 2, $7,500 in year 3 and $10,000 for years 4-7. At the end of year 7 she expects to sell his business for $100,000.

Using Excel, prepare a statement showing investment and cash flows by year. Calculate the NPV and IRR for each of these projects. Write a recommendation as to which project she should pursue and support this with information from your calculations. She cannot due both projects.

Please make an excel spreadsheeet of all this data and post the link

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

Q

The following table contains prices and dividends for a stock. All prices are after the dividend...

Finance
Q

Describe how gravity alters ventilation and especially perfusion in the lungs.

Medical Sciences
Q

A technical engineer is interested in understanding the battery life of two different laptops for student...

Statistics
Q

Study the binomial distribution table. Notice that the probability of success on a single trial p...

Basic Math
Q

Which of the following is equivalent to tan x 2 Select the correct answer below...

Calculus
Q

Given the parent function f x 2 how would the function g x 4 2...

Algebra
Q

The controller of the Red Wing Corporation is in the process of preparing...

Accounting
Q

Mr. Cameron operates a sole proprietorship with a December 31 year-end. He calculated his accounting...

Accounting
Q

Below is the selected information for a company for last year: Budgeted fixed overhead cost...

Accounting
Q

please i need the ans ASAP IRR: Mutually exclusive projects Nele inc...

Finance
Q

Computing Earnings per Share: Stock Options Falcon Company has a compensatory stock option plan under...

Accounting
Q

Total sales, revenue susoog $125,099 150,099 In the past, cost of goods sold has been...

Accounting