Cara has recently retired and is now considering starting a new business of selling tacos at local companies. She can purchase a used taco truck that has a useful life of $6$ years, but that is great because she only wants to work for another $6$ years. The salvage value of the truck will be zero at the end of the $6$ years $($can$$t even sell for junk$)$ and the value of her business will also be zero $($there are no barriers to entry, thus the value of the business is nil$).$ She estimates that the new business will have one of the two cash flows below for the next $6$ years. She requires a $15\%$ rate of return $($given the cost of capital and the opportunity costs of giving up her free time$).($You must show your work using Excel to calculate and must upload Excel spreadsheet. Do NOT submit PDF or picture of the Excel spreadsheet$).$

For both cashflows, answer the following $3$ questions:

$1)$ What is NPV for this investment? $($show your work using Excel spreadsheet$)$

$2)$ What is the IRR? $($show your work from Excel spreadsheet$)$

$3)$ Should she invest in the taco truck given the NPV and$/$or IRR? Why or why not?

Cash Flow Scenario $2($different cash flow during years $1$ through $6)$:

Initial Cost $$15,000$

Life of the Project $6$ years

Salvage Value $$0$

Required Rate of Return $15\%$

Annual Cash Flows

Year $0-$$$15,000$

Year $1$ $$2,000$

Year $2$ $$2,500$

Year $3$ $$3,000$

Year $4$ $$3,500$

Year $5$ $$4,000$

Year $6$ $$4,500$