Overview


Sheet 1: Dashboard

September, 2019 Q2

























Amounts in $ mn Total Retail Hospitality Ecommerce
Q2 September, 2019

Budget FTM Actual FTM Budget FTM Actual FTM Budget FTM Actual FTM Budget FTM Actual FTM

CY 2019-20 Budget CY 2019-20 Actuals LY 2018-19 Actuals
Gross Sales $144.06 $18.32 $108.53 $15.54 $29.69 $2.28 $5.84 $0.50
NET SALES


EBITDA $3.50 $(0.48) $2.77 $(0.47) $1.20 $0.09 $(0.47) $(0.10)
Retail $102,376.44 $14,378.63 $92,424.48
EBITDA Margin 2.4% -2.6% 2.6% -3.0% 4.0% 4.2% -8.0% -20.2%
Hospitality $29,077.30 $2,225.14 $28,392.18
PBT (Bef. Extra. Items) $2.11 $(0.66) $1.70 $(0.58) $0.94 $0.03 $(0.52) $(0.10)
Ecommerce $5,331.55 $463.54 $4,104.54
PBT % 1.5% -3.6% 1.6% -3.8% 3.2% 1.3% -9.0% -20.8%
TOTAL SALES $136,785.29 $17,067.30 $124,921.20














Amounts in $ mn Total Retail Hospitality Ecommerce
PBT



Budget YTD Actual YTD Budget YTD Actual YTD Budget YTD Actual YTD Budget YTD Actual YTD
Retail $1,699.52 $(584.37) $(1,118.00)
Gross Sales $144.06 $56.34 $108.53 $44.44 $29.69 $8.46 $5.84 $3.44
Hospitality $935.97 $30.06 $563.01
EBITDA $3.50 $(0.27) $2.77 $0.50 $1.20 $(0.76) $(0.47) $(0.01)
Ecommerce $(523.91) $(104.38) $(862.71)
EBITDA Margin 2.4% -0.5% 2.6% 1.1% 4.0% -8.9% -8.0% -0.2%
TOTAL PBT $2,111.57 $(658.69) $(1,417.71)
PBT (Bef. Extra. Items) $2.11 $(0.89) $1.70 $0.09 $0.94 $(0.96) $(0.52) $(0.02)




PBT % 1.5% -1.6% 1.6% 0.2% 3.2% -11.3% -9.0% -0.5%


















Amounts in $ mn Total Retail Hospitality Ecommerce





Budget QTD Actual QTD Budget QTD Actual QTD Budget QTD Actual QTD Budget QTD Actual QTD




Gross Sales $144,062.03 $35,884.35 $108,527.08 $28,218.51 $29,693.70 $4,720.73 $5,841.25 $2,945.11




EBITDA $3,499.24 $(993.17) $2,768.62 $(826.57) $1,199.65 $(243.64) $(469.02) $77.04




EBITDA Margin 2.4% -2.8% 2.6% -2.9% 4.0% -5.2% -8.0% 2.6%




PBT (Bef. Extra. Items) $2,111.57 $(1,359.36) $1,699.52 $(1,060.21) $935.97 $(370.12) $(523.91) $70.96




PBT % 1.5% -3.8% 1.6% -3.8% 3.2% -7.8% -9.0% 2.4%





Sheet 2: FTM

XYZ USA Inc.














Profit & Loss Statement for the month ended September 2019














SEGMENT: Total






























Channel Total













Month Sep-19





























Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Sep-19 % of Sales
Sep-19 % of Sales
Sep-18 % of Sales
Amount %
Amount %
Gross Sales $144,062 100.0%
$18,321 100.0%
$132,500 100.0%
($125,741) -87.3%
($114,179) -623.2%
Less:














Allowances and Discounts $6,697 4.6%
$1,022 5.6%
$6,103 4.6%
$5,675 84.7%
$5,081 497.1%
Chargebacks $250 0.2%
$95 0.5%
$345 0.3%
$155 62.1%
$250 264.0%
Obsolescence $220 0.2%
$46 0.2%
$355 0.3%
$174 79.2%
$309 676.1%
Internal Accruals $110 0.1%
$91 0.5%
$776 0.6%
$19 17.2%
$685 751.5%
NET SALES $136,785 94.9%
$17,067 93.2%
$124,921 94.3%
($119,718) -87.5%
($107,854) -631.9%
















Cost of Goods Sold $123,318 85.6%
$15,280 83.4%
$112,653 85.0%
$108,039 87.6%
$97,373 637.3%
Inventory provision created per policy $0 0.0%
$0 0.0%
$0 0.0%
$0

$0

GROSS PROFIT $13,467 9.3%
$1,788 9.8%
$12,268 9.3%
($11,679) -86.7%
($10,481) -586.3%
















Other Direct Expenses $1,399 1.0%
$629 3.4%
$1,403 1.1%
$770 55.0%
$774 123.1%
FBA Expenses $0 0.0%
$0 0.0%
$0 0.0%






Warehouse OPEX $4,451 3.1%
$907 4.9%
$4,760 3.6%
$3,545 79.6%
$3,854 425.1%
CONTRIBUTION MARGIN $7,617 5.3%
$252 1.4%
$6,106 4.6%
($7,364) -96.7%
($5,853) -2319.9%
















Administration $1,585 1.1%
$262 1.4%
$1,718 1.3%
$1,323 83.5%
$1,457 556.8%
Payroll and Benefit $3,994 2.8%
$585 3.2%
$4,374 3.3%
$3,408 85.3%
$3,788 647.2%
Selling and Marketing Expenses $1,505 1.0%
$344 1.9%
$1,769 1.3%
$1,161 77.1%
$1,426 414.5%
TOTAL FIXED OVERHEAD $7,084 4.9%
$1,191 6.5%
$7,862 5.9%
($5,893) -83.2%
($6,671) -560.1%
Other Income $2,966 2.1%
$463 2.5%
$1,473 1.1%
($2,504) -84.4%
($1,010) -218.3%
EBITDA $3,499 2.4%
($476) -2.6%
($283) -0.2%
($3,975) -113.6%
($193) 40.5%
















Finance Expense $1,058 0.7%
$125 0.7%
$815 0.6%
$933 88.2%
$690 551.6%
Depreciation $330 0.2%
$58 0.3%
$221 0.2%
$272 82.5%
$164 283.8%
PROFIT BEFORE TAX AND OTHER ITEMS $2,112 1.5%
($659) -3.6%
($1,320) -1.0%
($2,770) -131.2%
$661 -100.4%
One time events/ adjustments $0 0.0%
$0 0.0%
($98) -0.1%
$0

($98)

PROFIT BEFORE TAX $2,112 1%
($659) -4%
($1,418) -1%
($2,770) -131%
$759 -115%

Sheet 3: FTM Columnar

XYZ USA Inc.





























Profit & Loss Statement for the month ended September 2019




























































Month Sep-19



























































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY







Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Amount %
Amount %






Gross Sales $144,062 $108,527 $29,694 $5,841 100.0%
$18,321 $15,542 $2,276 $502 100.0%
$132,500 $98,958 $28,933 $4,609 100.0%
($125,741) -87.3%
($114,179) -623.2%






Less:





























Allowances and Discounts $6,697 $5,693 $536 $468 4.6%
$1,022 $986 $18 $19 5.6%
$6,103 $5,449 $443 $211 4.6%
$5,675 84.7%
$5,081 497.1%





`
Chargebacks $250 $208 $0 $41 0.2%
$95 $89 $0 $6 0.5%
$345 $296 $0 $49 0.3%
$155 62.1%
$250 264.0%






Obsolescence $220 $140 $81 $0 0.2%
$46 $30 $12 $4 0.2%
$355 $197 $91 $67 0.3%
$174 79.2%
$309 676.1%






Internal Accruals $110 $110 $0 $0 0.1%
$91 $60 $22 $10 0.5%
$776 $592 $7 $178 0.6%
$19 17.2%
$685 751.5%






NET SALES $136,785 $102,376 $29,077 $5,332 94.9%
$17,067 $14,379 $2,225 $464 93.2%
$124,921 $92,424 $28,392 $4,105 94.3%
($119,718) -87.5%
($107,854) -631.9%





































Cost of Goods Sold $123,318 $93,198 $26,030 $4,089 85.6%
$15,280 $12,973 $1,935 $372 83.4%
$112,653 $82,955 $26,020 $3,678 85.0%
$108,039 87.6%
$97,373 637.3%






Inventory provision created per policy $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0







GROSS PROFIT $13,467 $9,178 $3,047 $1,242 9.3%
$1,788 $1,406 $290 $91 9.8%
$12,268 $9,469 $2,373 $426 9.3%
($11,679) -86.7%
($10,481) -586.3%





































Other Direct Expenses $1,399 $632 $767 $0 1.0%
$629 $583 $41 $5 3.4%
$1,403 $753 $639 $11 1.1%
$770 55.0%
$774 123.1%






FBA Expenses $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0







Warehouse OPEX $4,451 $3,207 $238 $1,007 3.1%
$907 $853 $16 $37 4.9%
$4,760 $4,054 $176 $531 3.6%
$3,545 79.6%
$3,854 425.1%






CONTRIBUTION MARGIN $7,617 $5,339 $2,042 $235 5.3%
$252 ($31) $234 $49 1.4%
$6,106 $4,663 $1,558 ($115) 4.6%
($7,364) -96.7%
($5,853) -2319.9%





































Administration $1,585 $1,440 $101 $44 1.1%
$262 $226 $28 $7 1.4%
$1,718 $1,519 $95 $104 1.3%
$1,323 83.5%
$1,457 556.8%






Payroll and Benefit $3,994 $3,029 $531 $434 2.8%
$585 $448 $76 $61 3.2%
$4,374 $3,504 $509 $360 3.3%
$3,408 85.3%
$3,788 647.2%






Selling and Marketing Expenses $1,505 $1,069 $210 $226 1.0%
$344 $224 $38 $82 1.9%
$1,769 $1,328 $179 $262 1.3%
$1,161 77.1%
$1,426 414.5%






TOTAL FIXED OVERHEAD $7,084 $5,537 $843 $704 4.9%
$1,191 $899 $142 $151 6.5%
$7,862 $6,352 $783 $727 5.9%
($5,893) -83.2%
($6,671) -560.1%






Other Income $2,966 $2,966 $0 $0 2.1%
$463 $460 $3 $0 2.5%
$1,473 $1,468 $5 $0 1.1%
($2,504) -84.4%
($1,010) -218.3%






EBITDA $3,499 $2,769 $1,200 ($469) 2.4%
($476) ($469) $95 ($101) -2.6%
($283) ($221) $780 ($842) -0.2%
($3,975) -113.6%
($193) 40.5%





































Finance Expense $1,058 $799 $214 $44 0.7%
$125 $94 $28 $3 0.7%
$815 $629 $172 $14 0.6%
$933 88.2%
$690 551.6%






Depreciation $330 $270 $49 $11 0.2%
$58 $21 $37 $0 0.3%
$221 $170 $45 $6 0.2%
$272 82.5%
$164 283.8%






PROFIT BEFORE TAX AND OTHER ITEMS $2,112 $1,700 $936 ($524) 1.5%
($659) ($584) $30 ($104) -3.6%
($1,320) ($1,020) $563 ($863) -1.0%
($2,770) -131.2%
$661 -100.4%






One time events/ adjustments $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
($98) ($98) $0 $0 -0.1%
$0

($98)







PROFIT BEFORE TAX $2,112 $1,700 $936 ($524) 1%
($659) ($584) $30 ($104) -4%
($1,418) ($1,118) $563 ($863) -1%
($2,770) -131.2%
$759 -115.2%







Sheet 4: YTD

XYZ USA Inc.














YTD Profit & Loss Statement for the period ended September 2019














SEGMENT: Total






























Channel Total













Month Sep-19





























Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Sep-19 % of Sales
Sep-19 % of Sales
Sep-18 % of Sales
Amount %
Amount %
Gross Sales $144,062 100.0%
$56,344 100.0%
$132,500 100.0%
($87,718) -60.9%
($76,156) -135.2%
Less:














Allowances and Discounts $6,697 4.6%
$2,801 5.0%
$6,103 4.6%
$3,896 58.2%
$3,302 117.9%
Chargebacks $250 0.2%
$234 0.4%
$345 0.3%
$15 6.1%
$110 47.1%
Obsolescence $220 0.2%
($1,306) -2.3%
$355 0.3%
$1,526 693.0%
$1,661 -127.2%
Internal Accruals $110 0.1%
$411 0.7%
$776 0.6%
($301) -273.5%
$365 88.9%
NET SALES $136,785 94.9%
$54,203 96.2%
$124,921 94.3%
($82,582) -60.4%
($70,718) -130.5%
















Cost of Goods Sold $123,318 85.6%
$48,263 85.7%
$112,653 85.0%
$75,055 60.9%
$64,389 133.4%
Inventory provision created per policy $0 0.0%
$0 0.0%
$0 0.0%
$0

$0

GROSS PROFIT $13,467 9.3%
$5,939 10.5%
$12,268 9.3%
($7,528) -55.9%
($6,329) -106.6%
















Other Direct Expenses $1,399 1.0%
$1,067 1.9%
$1,403 1.1%
$332 23.7%
$336 31.5%
FBA Expenses $0 0.0%
$0 0.0%
$0 0.0%






Warehouse OPEX $4,451 3.1%
$3,054 5.4%
$4,760 3.6%
$1,398 31.4%
$1,706 55.9%
CONTRIBUTION MARGIN $7,617 5.3%
$1,819 3.2%
$6,106 4.6%
($5,798) -76.1%
($4,287) -235.7%
















Administration $1,585 1.1%
$1,038 1.8%
$1,718 1.3%
$547 34.5%
$680 65.5%
Payroll and Benefit $3,994 2.8%
$1,924 3.4%
$4,374 3.3%
$2,070 51.8%
$2,450 127.3%
Selling and Marketing Expenses $1,505 1.0%
$559 1.0%
$1,769 1.3%
$946 62.9%
$1,211 216.6%
TOTAL FIXED OVERHEAD $7,084 4.9%
$3,521 6.2%
$7,862 5.9%
($3,563) -50.3%
($4,341) -123.3%
Other Income $2,966 2.1%
$1,435 2.5%
$1,473 1.1%
($1,532) -51.6%
($39) -2.7%
EBITDA $3,499 2.4%
($268) -0.5%
($283) -0.2%
($3,767) -107.6%
$15 -5.8%
















Finance Expense $1,058 0.7%
$453 0.8%
$815 0.6%
$604 57.1%
$362 79.8%
Depreciation $330 0.2%
$167 0.3%
$221 0.2%
$163 49.3%
$54 32.5%
PROFIT BEFORE TAX AND OTHER ITEMS $2,112 1.5%
($888) -1.6%
($1,320) -1.0%
($3,000) -142.1%
$432 -48.6%
One time events/ adjustments $0 0.0%
$0 0.0%
($98) -0.1%
$0

($98)

PROFIT BEFORE TAX $2,112 1%
($888) -2%
($1,418) -1%
($3,000) -142.1%
$530 -59.7%

Sheet 5: YTD Columnar

XYZ USA Inc.























YTD Profit & Loss Statement for the period ended September 2019
















































Month Sep-19















































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Amount %
Amount %
Gross Sales $144,062 $108,527 $29,694 $5,841 100.0%
$56,344 $44,443 $8,461 $3,439 100.0%
$132,500 $98,958 $28,933 $4,609 100.0%
($87,718) -60.9%
($76,156) -135.2%
Less:























Allowances and Discounts $6,697 $5,693 $536 $468 4.6%
$2,801 $2,590 $63 $148 5.0%
$6,103 $5,449 $443 $211 4.6%
$3,896 58.2%
$3,302 117.9%
Chargebacks $250 $208 $0 $41 0.2%
$234 $187 $2 $46 0.4%
$345 $296 $0 $49 0.3%
$15 6.1%
$110 47.1%
Obsolescence $220 $140 $81 $0 0.2%
($1,306) ($1,374) $37 $31 -2.3%
$355 $197 $91 $67 0.3%
$1,526 693.0%
$1,661 -127.2%
Internal Accruals $110 $110 $0 $0 0.1%
$411 $247 $97 $67 0.7%
$776 $592 $7 $178 0.6%
($301) -273.5%
$365 88.9%
NET SALES $136,785 $102,376 $29,077 $5,332 94.9%
$54,203 $42,794 $8,262 $3,147 96.2%
$124,921 $92,424 $28,392 $4,105 94.3%
($82,582) -60.4%
($70,718) -130.5%

























Cost of Goods Sold $123,318 $93,198 $26,030 $4,089 85.6%
$48,263 $37,124 $8,453 $2,687 85.7%
$112,653 $82,955 $26,020 $3,678 85.0%
$75,055 60.9%
$64,389 133.4%
Inventory provision created per policy $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0

GROSS PROFIT $13,467 $9,178 $3,047 $1,242 9.3%
$5,939 $5,669 ($191) $461 10.5%
$12,268 $9,469 $2,373 $426 9.3%
($7,528) -55.9%
($6,329) -106.6%

























Other Direct Expenses $1,399 $632 $767 $0 1.0%
$1,067 $882 $169 $16 1.9%
$1,403 $753 $639 $11 1.1%
$332 23.7%
$336 31.5%
FBA Expenses $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0

Warehouse OPEX $4,451 $3,207 $238 $1,007 3.1%
$3,054 $2,943 $59 $52 5.4%
$4,760 $4,054 $176 $531 3.6%
$1,398 31.4%
$1,706 55.9%
CONTRIBUTION MARGIN $7,617 $5,339 $2,042 $235 5.3%
$1,819 $1,845 ($419) $394 3.2%
$6,106 $4,663 $1,558 ($115) 4.6%
($5,798) -76.1%
($4,287) -235.7%

























Administration $1,585 $1,440 $101 $44 1.1%
$1,038 $860 $119 $58 1.8%
$1,718 $1,519 $95 $104 1.3%
$547 34.5%
$680 65.5%
Payroll and Benefit $3,994 $3,029 $531 $434 2.8%
$1,924 $1,531 $263 $130 3.4%
$4,374 $3,504 $509 $360 3.3%
$2,070 51.8%
$2,450 127.3%
Selling and Marketing Expenses $1,505 $1,069 $210 $226 1.0%
$559 $380 ($33) $212 1.0%
$1,769 $1,328 $179 $262 1.3%
$946 62.9%
$1,211 216.6%
TOTAL FIXED OVERHEAD $7,084 $5,537 $843 $704 4.9%
$3,521 $2,771 $350 $400 6.2%
$7,862 $6,352 $783 $727 5.9%
($3,563) -50.3%
($4,341) -123.3%
Other Income $2,966 $2,966 $0 $0 2.1%
$1,435 $1,423 $12 $0 2.5%
$1,473 $1,468 $5 $0 1.1%
($1,532) -51.6%
($39) -2.7%
EBITDA $3,499 $2,769 $1,200 ($469) 2.4%
($268) $496 ($757) ($7) -0.5%
($283) ($221) $780 ($842) -0.2%
($3,767) -107.6%
$15 -5.8%

























Finance Expense $1,058 $799 $214 $44 0.7%
$453 $354 $90 $9 0.8%
$815 $629 $172 $14 0.6%
$604 57.1%
$362 79.8%
Depreciation $330 $270 $49 $11 0.2%
$167 $56 $111 $0 0.3%
$221 $170 $45 $6 0.2%
$163 49.3%
$54 32.5%
PROFIT BEFORE TAX AND OTHER ITEMS $2,112 $1,700 $936 ($524) 1.5%
($888) $86 ($958) ($16) -1.6%
($1,320) ($1,020) $563 ($863) -1.0%
($3,000) -142.1%
$432 -48.6%
One time events/ adjustments $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
($98) ($98) $0 $0 -0.1%
$0

($98)

PROFIT BEFORE TAX $2,112 $1,700 $936 ($524) 1%
($888) $86 ($958) ($16) -2%
($1,418) ($1,118) $563 ($863) -1%
($3,000) -142.1%
$530 -59.7%

Sheet 6: QTD

XYZ USA Inc.














QTD Profit & Loss Statement for the period ended September 2019














SEGMENT: Total






























Channel Total













Month Sep-19













Quarter Q2





























Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Sep-19 % of Sales
Sep-19 % of Sales
Sep-18 % of Sales
Amount %
Amount %
Gross Sales $144,062 100.0%
$35,884 100.0%
$132,500 100.0%
($108,178) -75.1%
($96,616) -269.2%
Less:














Allowances and Discounts $6,697 4.6%
$1,998 5.6%
$6,103 4.6%
$4,699 70.2%
$4,105 205.5%
Chargebacks $250 0.2%
$177 0.5%
$345 0.3%
$73 29.3%
$168 95.2%
Obsolescence $220 0.2%
$111 0.3%
$355 0.3%
$109 49.4%
$244 218.8%
Internal Accruals $110 0.1%
$255 0.7%
$776 0.6%
($145) -131.8%
$521 204.3%
NET SALES $136,785 94.9%
$33,344 92.9%
$124,921 94.3%
($103,442) -75.6%
($91,577) -274.6%
















Cost of Goods Sold $123,318 85.6%
$30,055 83.8%
$112,653 85.0%
$93,263 75.6%
$82,598 274.8%
Inventory provision created per policy $0 0.0%
$0 0.0%
$0 0.0%
$0

$0

GROSS PROFIT $13,467 9.3%
$3,289 9.2%
$12,268 9.3%
($10,178) -75.6%
($8,980) -273.0%
















Other Direct Expenses $1,399 1.0%
$822 2.3%
$1,403 1.1%
$577 41.3%
$581 70.7%
FBA Expenses $0 0.0%
$0 0.0%
$0 0.0%






Warehouse OPEX $4,451 3.1%
$1,797 5.0%
$4,760 3.6%
$2,654 59.6%
$2,963 164.9%
CONTRIBUTION MARGIN $7,617 5.3%
$670 1.9%
$6,106 4.6%
($6,947) -91.2%
($5,436) -811.6%
















Administration $1,585 1.1%
$650 1.8%
$1,718 1.3%
$935 59.0%
$1,069 164.4%
Payroll and Benefit $3,994 2.8%
$1,259 3.5%
$4,374 3.3%
$2,735 68.5%
$3,115 247.5%
Selling and Marketing Expenses $1,505 1.0%
$784 2.2%
$1,769 1.3%
$721 47.9%
$985 125.6%
TOTAL FIXED OVERHEAD $7,084 4.9%
$2,693 7.5%
$7,862 5.9%
($4,391) -62.0%
($5,169) -192.0%
Other Income $2,966 2.1%
$1,030 2.9%
$1,473 1.1%
($1,937) -65.3%
($444) -43.1%
EBITDA $3,499 2.4%
($993) -2.8%
($283) -0.2%
($4,492) -128.4%
($710) 71.5%
















Finance Expense $1,058 0.7%
$254 0.7%
$815 0.6%
$804 76.0%
$562 221.5%
Depreciation $330 0.2%
$113 0.3%
$221 0.2%
$217 65.9%
$109 96.7%
PROFIT BEFORE TAX AND OTHER ITEMS $2,112 1.5%
($1,359) -3.8%
($1,320) -1.0%
($3,471) -164.4%
($40) 2.9%
One time events/ adjustments $0 0.0%
$0 0.0%
($98) -0.1%
$0

($98)

PROFIT BEFORE TAX $2,112 1%
($1,359) -4%
($1,418) -1%
($3,471) -164.4%
$58 -4.3%

Sheet 7: QTD Columnar

XYZ USA Inc.























QTD Profit & Loss Statement for the period ended September 2019
















































Month Sep-19






















Quarter Q2















































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Total Retail Hospitality Ecommerce % of Sales
Amount %
Amount %
Gross Sales $144,062 $108,527 $29,694 $5,841 100.0%
$35,884 $28,219 $4,721 $2,945 100.0%
$132,500 $98,958 $28,933 $4,609 100.0%
($108,178) -75.1%
($96,616) -72.9%
Less:























Allowances and Discounts $6,697 $5,693 $536 $468 4.6%
$1,998 $1,832 $35 $130 5.6%
$6,103 $5,449 $443 $211 4.6%
$4,699 70.2%
$4,105 67.3%
Chargebacks $250 $208 $0 $41 0.2%
$177 $135 $2 $40 0.5%
$345 $296 $0 $49 0.3%
$73 29.3%
$168 48.8%
Obsolescence $220 $140 $81 $0 0.2%
$111 $63 $21 $27 0.3%
$355 $197 $91 $67 0.3%
$109 49.4%
$244 68.6%
Internal Accruals $110 $110 $0 $0 0.1%
$255 $136 $62 $57 0.7%
$776 $592 $7 $178 0.6%
($145) -131.8%
$521 67.1%
NET SALES $136,785 $102,376 $29,077 $5,332 94.9%
$33,344 $26,052 $4,601 $2,691 92.9%
$124,921 $92,424 $28,392 $4,105 94.3%
($103,442) -75.6%
($91,577) -73.3%

























Cost of Goods Sold $123,318 $93,198 $26,030 $4,089 85.6%
$30,055 $23,596 $4,153 $2,306 83.8%
$112,653 $82,955 $26,020 $3,678 85.0%
$93,263 75.6%
$82,598 73.3%
Inventory provision created per policy $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0

GROSS PROFIT $13,467 $9,178 $3,047 $1,242 9.3%
$3,289 $2,456 $448 $385 9.2%
$12,268 $9,469 $2,373 $426 9.3%
($10,178) -75.6%
($8,980) -73.2%

























Other Direct Expenses $1,399 $632 $767 $0 1.0%
$822 $725 $85 $11 2.3%
$1,403 $753 $639 $11 1.1%
$577 41.3%
$581 41.4%
FBA Expenses $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
$0

$0

Warehouse OPEX $4,451 $3,207 $238 $1,007 3.1%
$1,797 $1,720 $33 $44 5.0%
$4,760 $4,054 $176 $531 3.6%
$2,654 59.6%
$2,963 62.2%
CONTRIBUTION MARGIN $7,617 $5,339 $2,042 $235 5.3%
$670 $11 $330 $329 1.9%
$6,106 $4,663 $1,558 ($115) 4.6%
($6,947) -91.2%
($5,436) -89.0%

























Administration $1,585 $1,440 $101 $44 1.1%
$650 $573 $64 $13 1.8%
$1,718 $1,519 $95 $104 1.3%
$935 59.0%
$1,069 62.2%
Payroll and Benefit $3,994 $3,029 $531 $434 2.8%
$1,259 $994 $174 $91 3.5%
$4,374 $3,504 $509 $360 3.3%
$2,735 68.5%
$3,115 71.2%
Selling and Marketing Expenses $1,505 $1,069 $210 $226 1.0%
$784 $293 $343 $147 2.2%
$1,769 $1,328 $179 $262 1.3%
$721 47.9%
$985 55.7%
TOTAL FIXED OVERHEAD $7,084 $5,537 $843 $704 4.9%
$2,693 $1,860 $581 $252 7.5%
$7,862 $6,352 $783 $727 5.9%
($4,391) -62.0%
($5,169) -65.7%
Other Income $2,966 $2,966 $0 $0 2.1%
$1,030 $1,022 $7 $0 2.9%
$1,473 $1,468 $5 $0 1.1%
($1,937) -65.3%
($444) -30.1%
EBITDA $3,499 $2,769 $1,200 ($469) 2.4%
($993) ($827) ($244) $77 -2.8%
($283) ($221) $780 ($842) -0.2%
($4,492) -128.4%
($710) 251.0%

























Finance Expense $1,058 $799 $214 $44 0.7%
$254 $195 $52 $6 0.7%
$815 $629 $172 $14 0.6%
$804 76.0%
$562 68.9%
Depreciation $330 $270 $49 $11 0.2%
$113 $38 $74 $0 0.3%
$221 $170 $45 $6 0.2%
$217 65.9%
$109 49.2%
PROFIT BEFORE TAX AND OTHER ITEMS $2,112 $1,700 $936 ($524) 1.5%
($1,359) ($1,060) ($370) $71 -3.8%
($1,320) ($1,020) $563 ($863) -1.0%
($3,471) -164.4%
($40) 3.0%
One time events/ adjustments $0 $0 $0 $0 0.0%
$0 $0 $0 $0 0.0%
($98) ($98) $0 $0 -0.1%
$0

($98) 100.0%
PROFIT BEFORE TAX $2,112 $1,700 $936 ($524) 1%
($1,359) ($1,060) ($370) $71 -4%
($1,418) ($1,118) $563 ($863) -1%
($3,471) -164.4%
$58 -4.1%

Sheet 8: FTM FOH Columnar

XYZ USA Inc.























Profit & Loss Statement for the month ended September 2019
















































Month Sep-19















































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Amount %
Amount %
Admin























Dues & Subscriptions $10 $7 $2 $0 0.13%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($10) -100.0%
$0

Communication & IT $301 $248 $40 $13 4.25%
$93 $93 $0 $0 7.84%
$0 $0 $0 $0 0.00%
($208) -69.0%
$93

Computer maintenance $74 $56 $15 $3 1.04%
$43 $43 $0 $0 3.61%
$0 $0 $0 $0 0.00%
($30) -41.4%
$43

EDI $122 $116 $6 $0 1.73%
$10 $10 $0 $0 0.85%
$0 $0 $0 $0 0.00%
($112) -91.7%
$10

Internet $52 $40 $10 $2 0.74%
$18 $18 $0 $0 1.53%
$0 $0 $0 $0 0.00%
($34) -65.0%
$18

Telephone $8 $6 $2 $0 0.11%
$18 $18 $0 $0 1.51%
$0 $0 $0 $0 0.00%
$10 129.1%
$18

Website Maintenance and Hosting $40 $30 $8 $3 0.57%
$4 $4 $0 $0 0.34%
$0 $0 $0 $0 0.00%
($36) -90.0%
$4

Other $5 $0 $0 $5 0.07%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($5) -100.0%
$0

General Liability Ins. $63 $45 $15 $3 0.89%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($63) -100.0%
$0

Postage & Shipping $49 $29 $18 $2 0.69%
$34 $12 $15 $7 2.83%
$0 $0 $0 $0 0.00%
($15) -31.4%
$34

Legal & Professional Fees $301 $298 $3 $0 4.25%
$27 $16 $11 $0 2.30%
$1,718 $1,519 $95 $104 21.86%
($274) -90.9%
($1,691) -98.4%
Audit & Tax Fees (Annual) $45 $34 $9 $2 0.64%
$8 $6 $2 $0 0.63%
$0 $0 $0 $0 0.00%
($38) -83.3%
$8

Audit & Tax Fees (Internal) $9 $6 $2 $0 0.12%
$1 $1 $0 $0 0.12%
$0 $0 $0 $0 0.00%
($7) -83.7%
$1

Donations $42 $31 $11 $0 0.59%
$11 $11 $0 $0 0.94%
$0 $0 $0 $0 0.00%
($30) -72.9%
$11

Office/Showroom/Apt Rent $609 $588 $0 $21 8.60%
$35 $35 $0 $0 2.92%
$0 $0 $0 $0 0.00%
($574) -94.3%
$35

Office Supplies $18 $18 $0 $0 0.25%
$1 $1 $0 $0 0.12%
$0 $0 $0 $0 0.00%
($16) -91.7%
$1

Utilities $27 $27 $0 $0 0.38%
$0 $0 $0 $0 0.01%
$0 $0 $0 $0 0.00%
($26) -99.5%
$0

Other Rate and Taxes $46 $46 $0 $0 0.65%
$17 $17 $0 $0 1.45%
$0 $0 $0 $0 0.00%
($28) -62.1%
$17

Misc G&A Expenses $67 $62 $2 $3 0.95%
$33 $33 $0 $0 2.78%
$0 $0 $0 $0 0.00%
($34) -50.8%
$33

Other Admin Expenses $0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.02%
$0 $0 $0 $0 0.00%
$0

$0

Payroll

















$0

$0

Salaries & Benefits $3,994 $3,029 $531 $434 56.38%
$585 $448 $76 $61 49.15%
$4,374 $3,504 $509 $360 55.63%
($3,408) -85.3%
($3,788) -86.6%
Selling & Marketing Expenses

















$0

$0

Sample Expense $16 $11 $0 $5 0.22%
$10 $10 $0 $1 0.87%
$0 $0 $0 $0 0.00%
($6) -34.6%
$10

Marketing Expense $542 $227 $115 $200 7.64%
$95 $41 $9 $44 7.94%
$0 $0 $0 $0 0.00%
($447) -82.5%
$95

Travel $232 $158 $53 $22 3.27%
$63 $43 $9 $11 5.29%
$0 $0 $0 $0 0.00%
($169) -72.9%
$63

Showroom Expense $68 $68 $0 $0 0.96%
$7 $7 $0 $0 0.55%
$0 $0 $0 $0 0.00%
($61) -90.3%
$7

Design Development - Supply and Art Work $113 $110 $3 $0 1.60%
$17 $17 $0 $0 1.44%
$0 $0 $0 $0 0.00%
($96) -84.8%
$17

Freight Charges - Customers $24 $0 $24 $0 0.34%
$103 $84 $19 $0 8.69%
$1,769 $1,328 $179 $262 22.51%
$79 331.1%
($1,666) -94.2%
Photography Expense $13 $13 $0 $0 0.19%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($13) -100.0%
$0

Misc Selling Expense $498 $482 $16 $0 7.03%
$3 $3 ($0) $0 0.29%
$0 $0 $0 $0 0.00%
($494) -99.3%
$3

Bad Debts $0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
$0

$0

Other Expenses $0 $0 $0 $0 0.00%
$45 $19 $0 $26 3.81%
$0 $0 $0 $0 0.00%
$45

$45




















$0




Grand Total $7,084 $5,537 $843 $704

$1,191 $899 $142 $151

$7,862 $6,352 $783 $727

($5,893) ($0)
($6,671) ($0)

Sheet 9: YTD FOH Columnar

XYZ USA Inc.























Profit & Loss Statement for the month ended September 2019
















































Month Sep-19















































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Amount %
Amount %
Admin























Dues & Subscriptions $10 $7 $2 $0 0.13%
$1 $1 $0 $0 0.02%
$0 $0 $0 $0 0.00%
($9) -91.5%
$1

Communication & IT $301 $248 $40 $13 4.25%
$229 $196 $13 $20 6.50%
$0 $0 $0 $0 0.00%
($72) -24.0%
$229

Computer maintenance $74 $56 $15 $3 1.04%
$58 $58 $0 $0 1.64%
$0 $0 $0 $0 0.00%
($16) -21.6%
$58

EDI $122 $116 $6 $0 1.73%
$32 $13 $0 $20 0.92%
$0 $0 $0 $0 0.00%
($90) -73.7%
$32

Internet $52 $40 $10 $2 0.74%
$93 $93 $0 $0 2.64%
$0 $0 $0 $0 0.00%
$41 78.4%
$93

Telephone $8 $6 $2 $0 0.11%
$34 $33 $1 $0 0.96%
$0 $0 $0 $0 0.00%
$26 333.6%
$34

Website Maintenance and Hosting $40 $30 $8 $3 0.57%
$12 $0 $12 $0 0.34%
$0 $0 $0 $0 0.00%
($28) -70.1%
$12

Other $5 $0 $0 $5 0.07%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($5) -100.0%
$0

General Liability Ins. $63 $45 $15 $3 0.89%
$22 $22 $0 $0 0.62%
$0 $0 $0 $0 0.00%
($41) -65.5%
$22

Postage & Shipping $49 $29 $18 $2 0.69%
$140 $36 $66 $38 3.98%
$0 $0 $0 $0 0.00%
$91 185.3%
$140

Legal & Professional Fees $301 $298 $3 $0 4.25%
$171 $136 $34 $0 4.85%
$1,718 $1,519 $95 $104 21.86%
($130) -43.3%
($1,548) -90.1%
Audit & Tax Fees (Annual) $45 $34 $9 $2 0.64%
$23 $17 $5 $1 0.64%
$0 $0 $0 $0 0.00%
($23) -50.0%
$23

Audit & Tax Fees (Internal) $9 $6 $2 $0 0.12%
$4 $3 $1 $0 0.12%
$0 $0 $0 $0 0.00%
($4) -51.0%
$4

Donations $42 $31 $11 $0 0.59%
$11 $11 $0 $0 0.32%
$0 $0 $0 $0 0.00%
($30) -72.9%
$11

Office/Showroom/Apt Rent $609 $588 $0 $21 8.60%
$327 $327 $0 $0 9.28%
$0 $0 $0 $0 0.00%
($282) -46.4%
$327

Office Supplies $18 $18 $0 $0 0.25%
$6 $6 $0 $0 0.17%
$0 $0 $0 $0 0.00%
($12) -65.9%
$6

Utilities $27 $27 $0 $0 0.38%
$11 $11 $0 $0 0.30%
$0 $0 $0 $0 0.00%
($16) -60.0%
$11

Other Rate and Taxes $46 $46 $0 $0 0.65%
$39 $39 $0 $0 1.09%
$0 $0 $0 $0 0.00%
($7) -15.8%
$39

Misc G&A Expenses $67 $62 $2 $3 0.95%
$56 $56 $0 $0 1.59%
$0 $0 $0 $0 0.00%
($11) -16.8%
$56

Other Admin Expenses $0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.01%
$0 $0 $0 $0 0.00%
$0

$0

Payroll

















$0

$0

Salaries & Benefits $3,994 $3,029 $531 $434 56.38%
$1,924 $1,531 $263 $130 54.64%
$4,374 $3,504 $509 $360 55.63%
($2,070) -51.8%
($2,450) -56.0%
Selling & Marketing Expenses

















$0

$0

Sample Expense $16 $11 $0 $5 0.22%
$11 $19 ($8) $0 0.32%
$0 $0 $0 $0 0.00%
($5) -29.2%
$11

Marketing Expense $542 $227 $115 $200 7.64%
$212 $67 $11 $135 6.03%
$0 $0 $0 $0 0.00%
($329) -60.8%
$212

Travel $232 $158 $53 $22 3.27%
$112 $82 ($7) $38 3.19%
$0 $0 $0 $0 0.00%
($120) -51.6%
$112

Showroom Expense $68 $68 $0 $0 0.96%
$17 $17 $0 $0 0.49%
$0 $0 $0 $0 0.00%
($51) -74.8%
$17

Design Development - Supply and Art Work $113 $110 $3 $0 1.60%
$46 $46 $0 $0 1.32%
$0 $0 $0 $0 0.00%
($67) -58.9%
$46

Freight Charges - Customers $24 $0 $24 $0 0.34%
$96 $126 ($30) $0 2.73%
$1,769 $1,328 $179 $262 22.51%
$72 301.1%
($1,673) -94.6%
Photography Expense $13 $13 $0 $0 0.19%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($13) -100.0%
$0

Misc Selling Expense $498 $482 $16 $0 7.03%
$5 $4 $1 $0 0.14%
$0 $0 $0 $0 0.00%
($493) -99.0%
$5

Bad Debts $0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
$0

$0

Other Expenses $0 $0 $0 $0 0.00%
$58 $19 $0 $39 1.65%
$0 $0 $0 $0 0.00%
$58

$58


























Grand Total $7,084 $5,537 $843 $704

$3,521 $2,771 $350 $400

$7,862 $6,352 $783 $727

($3,563) ($0)
($4,341) ($0)

Sheet 10: QTD FOH Columnar

<
XYZ USA Inc.























Profit & Loss Statement for the month ended September 2019
















































Month Sep-19






















Quarter Q2















































Amounts in $ '000 Budget
CY Actual
LY Actual
Variance to Budget
Variance to LY

Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Total Retail Hospitality Ecommerce % of FOH
Amount %
Amount %
Admin























Dues & Subscriptions $10 $7 $2 $0 0.13%
$0 $0 $0 $0 0.00%
$0 $0 $0 $0 0.00%
($10) -100.0%
$0

Communication & IT $301 $248 $40 $13 4.08%
$181 $180 $0 $0 6.71%
$0 $0 $0 $0 0.00%
($120) -40.0%
$181

Computer maintenance $74 $56 $15 $3 1.00%
$54 $54 $0 $0 2.01%
$0 $0 $0 $0 0.00%
($19) -26.3%
$54

EDI $122 $116 $6 $0 1.66%
$17 $17 $0 $0 0.62%
$0 $0 $0 $0 0.00%
($106) -86.3%
$17

Internet $52 $40 $10 $2 0.71%
$79 $79 $0 $0 2.93%
$0 $0 $0 $0 0.00%
$27 51.6%
$79

Telephone $8 $6 $2 $0 0.11%
$23 $22 $0 $0 0.84%
$0 $0 $0 $0 0.00%