2. Calculate the NPV and IRR for Lock In. Show the calculations in the Homework data spreadsheet. The initial investment is $2,500 and the discount rate is 13.00 percent. Team: Buckets of Love Statement of Cash Flow Business Plan Most Likely Week 1 2 3 5 7 8 10 Total Starting Cash Balance 0.00 1,179.74 1,615.55 1,796.41 2,047.06 2,295.91 1,125.47 1,405.30 2,078.56 2,736.16 Cash Inflows Cash Sales 419.79 Credit Collections 299.85 573.71 245.88 657.67 629.69 671.66 755.62 741.63 601.70 587.71 573.71 6,212.89 281.86 269.87 287.86 323.84 317.84 257.87 251.87 245.88 2,782.61 Line of Credit 2,500.00 0.00 0.00 0.00 0.00 Total Cash Inflows 3,219.64 819.59 939.53 899.55 959.52 0.00 1,079.46 0.00 1,059.47 0.00 859.57 0.00 839.58 0.00 2,500.00 819.59 11,495.50 Cash Outflows Inventory 1,673.80 0.00 0.00 0.00 0.00 1,464.58 0.00 0.00 0.00 0.00 3,138.38 Sales tax (10.25%) 73.76 84.01 96.30 92.20 98.35 110.64 108.60 88.11 86.06 84.01 922.04 Marketing 200.00 200.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 500.00 Merchant fee (4.75%) 14.24 11.68 13.39 12.82 13.67 15.38 15.10 12.25 11.96 11.68 132.17 SGA (10%) 71.96 81.96 93.95 89.96 95.95 107.95 105.95 85.96 83.96 81.96 899.55 Interest (13.00%) 6.13 6.13 5.03 3.92 2.70 1.35 0.00 0.00 0.00 0.00 25.25 Loan Payment 0.00 0.00 450.00 450.00 Total Cash Outflows 2,039.90 383.78 758.67 648.90 500.00 710.67 550.00 550.00 0.00 0.00 0.00 2,500.00 2,249.90 779.64 186.31 181.98 177.65 8,117.39 Change in Cash 1,179.74 435.81 180.86 250.65 248.85 -1,170.44 279.83 673.26 657.60 641.94 Ending Cash Balance 1,179.74 1,615.55 1,796.41 2,047.06 2,295.91 1,125.47 1,405.30 2,078.56 2,736.16 3,378.11 Sales tax 10.25% Merchant fee 4.75% Interest expense 13.00% Credit Sales 15 12 14 14 14 16 16 13 13 12 Cash Sales 21 29 33 32 34 38 37 30 29 29 TOTAL UNITS (per wk) 36 41 47 45 48 54 53 43 42 41 450.00