3. Calculate the NPV and IRR for Memora-Ball. Show the calculations in the Homework data spreadsheet....

Transcribed Image Text:

3. Calculate the NPV and IRR for Memora-Ball. Show the calculations in the Homework data spreadsheet. The initial investment is $2,500 and the discount rate is 13.00 percent Memora-Ball Statement of Cash Flow Business Plan Most Likely Week 1 2 3 4 5 6 7 8 9 10 Total Starting Cash Balance 0.00 1,817.60 1,836.05 1,838.85 1,842.98 1,849.97 1,857.87 1,858.85 2,149.90 2,465.95 Cash Inflows Cash Sales 210.00 Credit Collections 315.00 Line of Credit 2,500.00 210.00 315.00 0.00 300.00 450.00 300.00 450.00 210.00 315.00 210.00 180.00 180.00 315.00 270.00 270.00 180.00 270.00 120.00 180.00 2,100.00 3,150.00 Total Cash Inflows 3,025.00 525.00 0.00 750.00 0.00 750.00 0.00 525.00 0.00 525.00 0.00 450.00 0.00 450.00 0.00 450.00 0.00 300.00 2,500.00 7,750.00 Cash Outflows Inventory 1,050.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,050.00 Sales tax (10.25%) 53.81 53.81 76.88 76.88 53.81 53.81 46.13 46.13 46.13 30.75 538.13 Marketing 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 300.00 Merchant fee (4.75%) 14.96 14.96 21.38 21.38 14.96 14.96 12.83 12.83 12.83 8.55 149.63 SGA (10%) 52.50 52.50 75.00 75.00 52.50 52.50 45.00 45.00 45.00 30.00 525.00 Interest (13.00%) 6.13 5.27 3.95 2.62 1.73 0.83 0.06 0.00 0.00 0.00 20.60 Loan Payment 350.00 540.00 540.00 365.00 365.00 315.00 25.00 2,500.00 Total Cash Outflows 1,207.40 506.55 747.20 745.87 518.00 517.11 449.01 158.95 133.95 99.30 5,083.35 Change in Cash 1,817.60 18.45 2.80 4.13 7.00 7.89 0.99 291.05 316.05 200.70 Ending Cash Balance 1,817.60 1,836.05 1,838.85 1,842.98 1,849.97 1,857.87 1,858.85 2,149.90 2,465.95 2,666.65 Sales tax 10.25% Merchant fee 4.75% Interest expense 13.00% Credit Sales 42 42 42 60 60 60 60 42 42 42 42 36 36 36 24 24 Cash Sales 28 28 40 40 28 TOTAL UNITS (per wk) 70 70 100 100 70 70 228 24 24 24 16 60 60 60 40 700.00 C2 x fx A B C D E F G H I J K L M N 1 Finance 330 spring 2024 Name 23 45678 4 Discount rate 0 2 3 4 5 6 7 8 9 10 8 Buckets of Love CFs 9 11 012345678 NPV IRR 12 Lock In CFs NPV IRR 16 Memora-Ball CFs NPV IRR 3. Calculate the NPV and IRR for Memora-Ball. Show the calculations in the Homework data spreadsheet. The initial investment is $2,500 and the discount rate is 13.00 percent Memora-Ball Statement of Cash Flow Business Plan Most Likely Week 1 2 3 4 5 6 7 8 9 10 Total Starting Cash Balance 0.00 1,817.60 1,836.05 1,838.85 1,842.98 1,849.97 1,857.87 1,858.85 2,149.90 2,465.95 Cash Inflows Cash Sales 210.00 Credit Collections 315.00 Line of Credit 2,500.00 210.00 315.00 0.00 300.00 450.00 300.00 450.00 210.00 315.00 210.00 180.00 180.00 315.00 270.00 270.00 180.00 270.00 120.00 180.00 2,100.00 3,150.00 Total Cash Inflows 3,025.00 525.00 0.00 750.00 0.00 750.00 0.00 525.00 0.00 525.00 0.00 450.00 0.00 450.00 0.00 450.00 0.00 300.00 2,500.00 7,750.00 Cash Outflows Inventory 1,050.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,050.00 Sales tax (10.25%) 53.81 53.81 76.88 76.88 53.81 53.81 46.13 46.13 46.13 30.75 538.13 Marketing 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 300.00 Merchant fee (4.75%) 14.96 14.96 21.38 21.38 14.96 14.96 12.83 12.83 12.83 8.55 149.63 SGA (10%) 52.50 52.50 75.00 75.00 52.50 52.50 45.00 45.00 45.00 30.00 525.00 Interest (13.00%) 6.13 5.27 3.95 2.62 1.73 0.83 0.06 0.00 0.00 0.00 20.60 Loan Payment 350.00 540.00 540.00 365.00 365.00 315.00 25.00 2,500.00 Total Cash Outflows 1,207.40 506.55 747.20 745.87 518.00 517.11 449.01 158.95 133.95 99.30 5,083.35 Change in Cash 1,817.60 18.45 2.80 4.13 7.00 7.89 0.99 291.05 316.05 200.70 Ending Cash Balance 1,817.60 1,836.05 1,838.85 1,842.98 1,849.97 1,857.87 1,858.85 2,149.90 2,465.95 2,666.65 Sales tax 10.25% Merchant fee 4.75% Interest expense 13.00% Credit Sales 42 42 42 60 60 60 60 42 42 42 42 36 36 36 24 24 Cash Sales 28 28 40 40 28 TOTAL UNITS (per wk) 70 70 100 100 70 70 228 24 24 24 16 60 60 60 40 700.00 C2 x fx A B C D E F G H I J K L M N 1 Finance 330 spring 2024 Name 23 45678 4 Discount rate 0 2 3 4 5 6 7 8 9 10 8 Buckets of Love CFs 9 11 012345678 NPV IRR 12 Lock In CFs NPV IRR 16 Memora-Ball CFs NPV IRR