0% found this document useful (0 votes)
15 views3 pages

12-Month Profit & Loss Projection

Uploaded by

son cao
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views3 pages

12-Month Profit & Loss Projection

Uploaded by

son cao
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

for more

theYOUNG Express information

Profit & Lost projection

TWELVE MONTHS
Revenue (Sales) Trend JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Revenue 1 $186.00 $108.00 $92.00 $122.00 $190.00 $71.00 $21.00 $37.00 $24.00 $178.00 $92.00 $97.00
Revenue 2 $15.00 $16.00 $198.00 $44.00 $25.00 $68.00 $43.00 $119.00 $37.00 $118.00 $29.00 $171.00
Revenue 3 $166.00 $185.00 $89.00 $170.00 $131.00 $70.00 $50.00 $149.00 $179.00 $104.00 $119.00 $187.00
Revenue 4 $21.00 $113.00 $83.00 $17.00 $130.00 $26.00 $167.00 $102.00 $82.00 $33.00 $88.00 $193.00
Revenue 5 $70.00 $160.00 $125.00 $84.00 $191.00 $97.00 $52.00 $45.00 $173.00 $136.00 $144.00 $167.00
Revenue 6 $61.00 $99.00 $70.00 $162.00 $28.00 $163.00 $101.00 $103.00 $78.00 $33.00 $162.00 $159.00
Revenue 7 $105.00 $55.00 $163.00 $12.00 $117.00 $83.00 $163.00 $120.00 $171.00 $79.00 $105.00 $69.00
Total Sales $624.00 $736.00 $820.00 $611.00 $812.00 $578.00 $597.00 $675.00 $744.00 $681.00 $739.00 $1,043.00

SEMI-ANNUAL REVENUE
$250.00

$200.00
$198.00
$190.00 $191.00
$186.00 $185.00

$166.00 $170.00 $163.00


$162.00 $163.00
$150.00 $160.00

$131.00 $130.00
$122.00 $125.00
$113.00 $117.00
$100.00 $108.00 $105.00
$97.00 $99.00
$92.00 $89.00
$83.00 $84.00 $83.00
$71.00 $68.00 $70.00 $70.00 $70.00
$50.00 $61.00
$55.00
$44.00

$25.00 $26.00 $28.00


$21.00 $17.00
$16.00
$15.00 $12.00
$0.00
Revenue 1 Revenue 2 Revenue 3 Revenue 4 Revenue 5 Revenue 6 Revenue 7

JAN FEB MAR APR MAY JUN


theYOUNG Express
Profit & Loss projection

TWELVE MONTHS
Cost of Sales Trend JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEARLY
Cost 1 $61.00 $78.00 $65.00 $29.00 $125.00 $49.00 $14.00 $26.00 $14.00 $129.00 $60.00 $65.00 $715.00
Cost 2 $7.00 $5.00 $69.00 $32.00 $11.00 $30.00 $27.00 $32.00 $10.00 $41.00 $13.00 $105.00 $382.00
Cost 3 $99.00 $95.00 $51.00 $90.00 $21.00 $34.00 $30.00 $24.00 $109.00 $16.00 $21.00 $52.00 $642.00
Cost 4 $13.00 $28.00 $15.00 $8.00 $84.00 $12.00 $54.00 $72.00 $49.00 $24.00 $60.00 $39.00 $458.00
Cost 5 $34.00 $78.00 $43.00 $30.00 $77.00 $54.00 $26.00 $13.00 $56.00 $30.00 $40.00 $63.00 $544.00
Cost 6 $33.00 $61.00 $42.00 $43.00 $19.00 $94.00 $46.00 $15.00 $55.00 $15.00 $37.00 $89.00 $549.00
Cost 7 $18.00 $11.00 $30.00 $9.00 $62.00 $39.00 $102.00 $44.00 $121.00 $19.00 $33.00 $40.00 $528.00
Total Cost of Sales $265.00 $356.00 $315.00 $241.00 $399.00 $312.00 $299.00 $226.00 $414.00 $274.00 $264.00 $453.00 $3,818.00

SALES

Cost 7 Cost 1
13% 16%

Cost 2
10%

Cost 6
30%
Cost 3
11%

Cost 5 Cost 4
17% 4%
theYOUNG Express
Profit & Loss projection
Expenses Trend JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEARLY
Salary expenses $10.00 $18.00 $13.00 $8.00 $22.00 $18.00 $8.00 $17.00 $20.00 $8.00 $4.00 $12.00 $158.00
Payroll expenses $23.00 $11.00 $7.00 $14.00 $12.00 $19.00 $19.00 $4.00 $7.00 $13.00 $25.00 $5.00 $159.00
Outside services $23.00 $20.00 $3.00 $16.00 $10.00 $5.00 $20.00 $7.00 $4.00 $22.00 $13.00 $14.00 $157.00
Supplies (office and operating) $19.00 $4.00 $7.00 $14.00 $22.00 $10.00 $22.00 $5.00 $4.00 $12.00 $18.00 $24.00 $161.00
Repairs and maintenance $11.00 $11.00 $17.00 $12.00 $2.00 $14.00 $12.00 $10.00 $18.00 $11.00 $23.00 $11.00 $152.00
Advertising $2.00 $16.00 $6.00 $13.00 $11.00 $22.00 $21.00 $3.00 $12.00 $7.00 $17.00 $20.00 $150.00
Car, delivery and travel $8.00 $17.00 $11.00 $11.00 $21.00 $9.00 $20.00 $3.00 $14.00 $22.00 $16.00 $12.00 $164.00
Accounting and legal $5.00 $13.00 $6.00 $15.00 $19.00 $10.00 $12.00 $9.00 $15.00 $16.00 $4.00 $9.00 $133.00
Rent $8.00 $4.00 $23.00 $25.00 $10.00 $24.00 $22.00 $5.00 $12.00 $24.00 $24.00 $12.00 $193.00
Telephone $25.00 $2.00 $12.00 $25.00 $10.00 $24.00 $3.00 $20.00 $3.00 $9.00 $20.00 $18.00 $171.00
Utilities $16.00 $19.00 $9.00 $16.00 $13.00 $2.00 $4.00 $24.00 $16.00 $22.00 $7.00 $18.00 $166.00
Insurance $12.00 $9.00 $16.00 $19.00 $25.00 $17.00 $20.00 $14.00 $5.00 $14.00 $5.00 $2.00 $158.00
Taxes (real estate, etc.) $16.00 $13.00 $10.00 $7.00 $13.00 $3.00 $13.00 $17.00 $9.00 $4.00 $22.00 $18.00 $145.00
Interest $3.00 $2.00 $19.00 $21.00 $13.00 $9.00 $7.00 $13.00 $3.00 $6.00 $10.00 $13.00 $119.00
Depreciation $8.00 $7.00 $6.00 $7.00 $7.00 $6.00 $15.00 $23.00 $21.00 $16.00 $19.00 $7.00 $142.00

You might also like