Please help me solve the NPV for this project. Excel spreadsheet is recommended. Thanks!

Homework #1 Capital Budgeting Problems 1. Carolyn Fulton, the CFO of Nuts and Bolts Inc. is considering a proposed project to launch an on-line catalog that would allow customers to by-pass the retail store and have items delivered directly to their homes. Nuts and Bolts Retail got its start as modest Do-it-yourself (DIY) supply store in 1985. It grew from one store, in Charlotte, North Carolina, to over 1000 stores nationwide with revenues over $20 billion and net profit over $250 million. The explosive growth began to slow in the late 1990s, but the firm has remained profitable. To re-ignite revenue growth, management is currently evaluating an on-line sales channel. Studies done by the firm's marketing department indicate that a large component of the customer base are buying DIY products on-line from other sources, or would like to buy DIY products if available from a reliable retailer. The design and the development of the web infrastructure would cost an estimated $10 million at time 0 and an additional $10 million at time 1 to acquire and integrate the hardware and software (these are capital expenditures). Estimated depreciation for the equipment is included below. Start-up expenses would be $2 million plus an investment in inventory of $10 million. The entire net working capital investment will be an additional $5 million in year 1, and the NWC balance would then grow by 15% each year in years 2 through 5. All NWC will be recovered at the end of the project. The on-line catalog is expected to generate new sales of $100 million in the first year and then sales would grow by 15% per year. However the marketing department estimated that the on-line sales would cut into sales at the existing retail stores by as much as $15 million in the first year and this cannibalization would grow by 15% each year in years 2 through 5. Additionally the company would have to hire additional staff to manage the website and shipping logistics, and incur additional cost to configure warehouse operations to efficiently process on-line orders. Operating margins excluding depreciation (the EBITDA margin) on the on-line sales were expected to be the same as retail sales: 8% for the first two years, then 10% thereafter. After 5 years it is expected that the technology will become obsolete and it will have no residual value. Carolyn wants to determine whether or not to proceed. When analyzing an investment of this risk, the firm assumes a hurdle rate (cost of capital) of 10%. Assume the effective tax rate is 40%. Estimated Depreciation Expense (000's) Year 0 1 2 3 4 5 $2,000 $5,200 $5,120 $3,072 $2,304 $2,304 What is the Net Present Value of the proposed project? (12 pts.) 1 MFIN 1127 - Fall 2017