View the step-by-step solution to:

Question

hello can you please help me figure this answer out. thanks Screen Shot</h1><p class='abPRemoveTitle'> 2019-08-05 at 12.28.29 PM.pngScreen Shot 2019-08-05 at 12.27.48 PM.png

Screen Shot 2019-08-05 at 12.27.48 PM.png

Suppose you are considering opening a store . After looking at many potential locations, you find one which you believe is ideal. You purchase a the location of a
former store. The purchase price of the buidling was $350,000. In addiition, you need to invest another $200,000 to make the location suitable as a shoe store.
Assume these capital investments have an average life of five years with a $100,000 salvage value. You estimate your initial investment in working capital is $150,000. Assume going forward that net working capital is 25% of sales You estimate first year sales of $1,200,000 and your expect sales to grow at an annual rate of 3%. Your cost of goods (COGS) is estimated at 50% of sales. Assume
your annual rent, utilities, insurance and other related costs (SG&amp;A) is $175,000 per year. Assume an income tax rate of 30% Assume a required rate of return of 20%. Derive the project's NPV or XNPV. Should the project be undertaken? Why or why not? What is the project's IRR or
XIRR?

Screen Shot 2019-08-05 at 12.28.29 PM.png

Initial Sales
Sales Growth Rate
COGS as a % of sales
Annual SG&amp;A
Annual Depreciation
Initial Capital Investment
Salvage Value
Life of Capital Investment (years)
Initial NWC Investment
NWC as a Percent of Sales
Tax Rate
RRR
Year
0
2
3
4
5
Date
8/5/19
8/4/20
8/4/21
8/4/22
8/4/23
8/3/24
Sales
$
COGS
SG&amp;A
Depreciation
EBIT (Operating Income)
Tax
Net Income
Cash Earnings After Taxes (EBITDA-T)
Capital Investment
Net Working Capital
Change in NWC
Future Total Free Cash Flow (FCF)
PV Cash Flows

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question