Excel Project- return excel sheet attached- instructions attached separate
blueamber95
Assignment8econ213-C.W-EX2016-SkillReview-6-2.xlsxAnalysis
| Inventory Analysis | Average Selling Price | Median Selling Price | Most Common (Single) | Most Common (Multiple) | ||
| Total value of inventory | ||||||
| Total number of blue shoes in inventory | ||||||
| Average selling price for blue shoes | ||||||
| Number of blue shoe inventory items | ||||||
| Inventory Lookup | ||||||
| Average Price of Football Items | ||||||
| Number of Football Items in Stock Sold for Less Than $20.00 | ||||||
| Price Lookup | ||||||
| Item Inventory Number | FO-1002 | |||||
| Item Description | ||||||
| Quantity in Stock | ||||||
| Price | ||||||
| Where does this item rank in price? |
Inventory
| Hank's Sporting Goods | |||||||
| Item Description | Inventory Number | Color | Manufacturer | Size | Cost | Selling Price | Stock |
| Basic Basketball | BA-1001 | Orange | Cole | Small | $ 5.75 | $ 14.39 | 5 |
| Basic Football | FO-1001 | Brown | Cole | Small | $ 5.75 | $ 14.39 | 9 |
| Basketball Air Pump | BA-2002 | Silver | Zinks | NA | $ 3.45 | $ 7.80 | 6 |
| Basketball Goal | BA-2000 | Black | Zinks | Regulation | $ 16.25 | $ 29.99 | 8 |
| Basketball Goal Net | BA-2001 | White | Zinks | Regulation | $ 1.15 | $ 3.99 | 21 |
| Flash Basketball | FL-1001 | Red | Jackson | Youth | $ 3.45 | $ 8.40 | 13 |
| Flash Football | FL-1002 | Blue | Jackson | Youth | $ 4.60 | $ 10.79 | 15 |
| Football Air Pump | FO-1003 | Black | Zinks | NA | $ 4.60 | $ 10.79 | 22 |
| Football Tee | FO-1002 | Orange | Jackson | Medium | $ 1.15 | $ 3.49 | 18 |
| Junior Basketball | BA-1002 | Brown | Cole | Small | $ 6.90 | $ 15.59 | 23 |
| Junior Football | FO-1004 | Brown | Cole | Small | $ 6.90 | $ 15.59 | 0 |
| Youth Basketball | BA-1002 | Orange | Cole | Youth | $ 5.75 | $ 13.19 | 0 |
| Youth Basketball Shoes | BA-5001 | Red | Assuage | 6 to 3 | $ 23.00 | $ 50.39 | 20 |
| Youth Basketball Shoes | BA-5002 | Blue | Nuke | 6 to 3 | $ 25.30 | $ 57.59 | 15 |
| Youth Basketball Shoes | BA-5003 | Red | Nuke | 6 to 3 | $ 26.45 | $ 56.39 | 11 |
| Youth Basketball Shoes | BA-5004 | White | Nuke | 6 to 3 | $ 23.00 | $ 52.99 | 20 |
| Youth Basketball Shoes | BA-5005 | Gray | Nuke | 6 to 3 | $ 24.15 | $ 51.59 | 4 |
| Youth Football Cleats | FO-1005 | Brown | Cole | Youth | $ 6.90 | $ 12.60 | 20 |
| Youth Football Cleats | FO-5001 | Black | Assuage | 6 to 3 | $ 29.90 | $ 61.19 | 19 |
| Youth Football Cleats | FO-5002 | White | Assuage | 6 to 3 | $ 29.90 | $ 62.99 | 23 |
| Youth Football Cleats | FO-5003 | Red | Nuke | 6 to 3 | $ 31.05 | $ 51.99 | 6 |
| Youth Football Cleats | FO-5004 | Silver | Assuage | 6 to 3 | $ 31.05 | $ 63.59 | 3 |
| Youth Football Cleats | FO-5005 | Orange | Assuage | 6 to 3 | $ 31.05 | $ 63.59 | 23 |
Financials
| Financial Analysis | |||
| Interest Rates | Inventory Loan | ||
| Inventory Loan | 11.49% | Loan Amount | $ 20,000.00 |
| Money Market | 0.25% | Monthly Payment | $ (653.17) |
| Length of Loan (Years) | 3 | ||
| Total Cost of Loan | $ (23,514.15) | ||
| Money Market Investment | |||
| Future Value | |||
| Alternate Loan Schedule | |||
| Alternate loan payment per month | $ (900.00) | ||
| How many months to pay off the loan? | |||
| What is the new total cost of the loan? | $ - 0 |
Equipment Decision
| Equipment Decision | Equipment Depreciation Schedule | |||||||||
| Option 1 | Option 2 | Option 3 | Cost | Year | Using Declining Balance | Using Straight-Line | ||||
| Initial Investment (Purchase) | $ (15,000.00) | $ (25,000.00) | $ (35,000.00) | Life (in years) | 1 | |||||
| NPV Calculation | Salvage | 2 | ||||||||
| Net Present Value of Investment | 3 | |||||||||
| 4 | ||||||||||
| Net Revenue Increase | Option 1 | Option 2 | Option 3 | 5 | ||||||
| 1 | 1,000 | 2,000 | 1,000 | 6 | ||||||
| 2 | 3,000 | 5,000 | 8,000 | 7 | ||||||
| 3 | 4,000 | 6,000 | 8,000 | 8 | ||||||
| 4 | 4,000 | 6,000 | 8,000 | 9 | ||||||
| 5 | 2,000 | - 0 | (2,000) | 10 | ||||||
| 6 | 4,000 | 6,000 | 8,000 | |||||||
| 7 | 2,000 | 5,000 | 8,000 | |||||||
| 8 | 2,000 | 4,500 | 2,000 | |||||||
| 9 | 2,000 | 4,000 | 7,000 | |||||||
| 10 | 1,000 | 3,000 | 5,000 | |||||||
