finance quiz

profileLeila@
Quiz5datasheet10202.xlsx
Home>Business & Finance homework help>Financial markets homework help>finance quiz

Coolette

Cool-ette Company The Most Likely case
Income Statement
Week 1 2 3 4 5 6 7 8 9 10 Total
Sales
Units 66 43 86 78 52 56 70 113 74 87 725
Revenue 607.20 395.60 791.20 717.60 478.40 515.20 644.00 1,039.60 680.80 800.40 6,670.00
Cost of Goods Sold 214.50 139.75 279.50 253.50 169.00 160.72 200.90 324.31 212.38 249.69 2,204.25
GROSS PROFIT 392.70 255.85 511.70 464.10 309.40 354.48 443.10 715.29 468.42 550.71 4,465.75
Expenses:
SGA (10%) 60.72 39.56 79.12 71.76 47.84 51.52 64.40 103.96 68.08 80.04 667.00
Marketing Expense 168.00 0.00 0.00 166.00 0.00 166.00 0.00 0.00 0.00 0.00 500.00
Sales tax (9.5%) 57.68 37.58 75.16 68.17 45.45 48.94 61.18 98.76 64.68 76.04 633.65
Gateway fee 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 100.00
Interest Expense 2.50 2.50 2.06 1.63 1.19 0.75 0.50 0.25 0.00 0.00 11.38
Merchant fee 1.15 0.75 1.50 1.36 0.91 0.98 1.22 1.98 1.29 0.00 11.15
TOTAL 300.06 90.39 167.85 318.92 105.38 278.19 137.30 214.95 144.05 166.08 1,923.18
Net Income (EBT) 92.64 165.46 343.85 145.18 204.02 76.29 305.80 500.34 324.37 384.63 2,542.57
Selling price 10.00 Selling price (discount) 8 Avg. Selling price 9.20
Cost per unit (200) 3.25 Cost per unit (400) 2.87

Pawp Up

Pawp Up
Income Statement
Week 1 2 3 4 5 6 7 8 9 10 Total
Sales
Units 65 30 110 45 50 65 100 50 60 25 600
Revenue 780.00 360.00 1,320.00 540.00 600.00 780.00 1,200.00 600.00 720.00 300.00 7,200.00
Cost of Goods Sold 178.75 82.50 302.50 123.75 137.50 178.75 275.00 137.50 165.00 68.75 1,650.00
GROSS PROFIT 601.25 277.50 1,017.50 416.25 462.50 601.25 925.00 462.50 555.00 231.25 5,550.00
Expenses:
SGA (10%) 78.00 36.00 132.00 54.00 60.00 78.00 120.00 60.00 72.00 30.00 720.00
Marketing Expense 200.00 0.00 0.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 300.00
Sales tax (9.5%) 74.10 34.20 125.40 51.30 57.00 74.10 114.00 57.00 68.40 28.50 684.00
Gateway fee 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 100.00
Interest Expense 2.04 2.04 2.04 2.04 2.04 2.04 2.04 2.04 2.04 2.04 20.43
Merchant fee 7.41 3.42 12.54 5.13 5.70 7.41 11.40 5.70 6.84 0.00 65.55
TOTAL 371.55 85.66 281.98 122.47 234.74 171.55 257.44 134.74 159.28 70.54 1,889.98
Net Income (EBT) 229.70 191.84 735.52 293.78 227.76 429.70 667.56 327.76 395.72 160.71 3,660.02
Single 12.00 75%
Bundle 10.00 20%
Bulk 9.00 5%
Selling price 12.00
Cost per unit 2.75
Gross Profit Per Unit 9.25
Net Profit Per Unit 6.10
Units to Pay Loan 410

Purifighters

PURIFIGHTERS MOST LIKELY
Income Statement
Week 1 2 3 4 5 6 7 8 9 10 Total
Sales
Units 50 25 45 45 40 45 40 45 45 20 400
Revenue 1,250.00 625.00 1,125.00 1,125.00 1,000.00 1,125.00 1,000.00 900.00 900.00 400.00 9,450.00
Cost of Goods Sold 495.00 247.50 445.50 445.50 396.00 445.50 396.00 445.50 445.50 198.00 3,960.00
GROSS PROFIT 755.00 377.50 679.50 679.50 604.00 679.50 604.00 454.50 454.50 202.00 5,490.00
Expenses:
SGA (10%) 125.00 62.50 112.50 112.50 100.00 112.50 100.00 90.00 90.00 40.00 945.00
Marketing Expense 200.00 0.00 0.00 50.00 0.00 50.00 0.00 0.00 0.00 0.00 300.00
Sales tax (9.50%) 118.75 59.38 106.88 106.88 95.00 106.88 95.00 85.50 85.50 38.00 897.75
Gateway fee 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 100.00
Interest Expense 3.13 3.13 3.13 3.13 3.13 3.13 3.13 3.13 3.13 3.13 31.25
Merchant fee 17.50 8.75 15.75 15.75 14.00 15.75 14.00 15.75 15.75 0.00 133.00
TOTAL 474.38 143.75 248.25 298.25 222.13 298.25 222.13 204.38 204.38 91.13 2,407.00
Net Income (EBT) 280.63 233.75 431.25 381.25 381.88 381.25 381.88 250.13 250.13 110.88 3,083.00
Selling price 25.00
Cost per unit 9.90
Selling Price (DISCOUNT) 20.00