Scribd
Upload
48 views3 pages

July 2019 Café Financial Overview

The document provides monthly financial and operational metrics for a café over a 12 month period from January to December 2019. It shows metrics such as revenue, expenses, profit margin, opening cash, number of cups sold, and highest/lowest forecast profit and cash points. Overall, the café had highest revenue and profit margin in July 2019 with $8,554 in revenue, 18% profit margin, and $3,113 in opening cash.

Uploaded by

Kimberly Vicente
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
48 views3 pages

July 2019 Café Financial Overview

The document provides monthly financial and operational metrics for a café over a 12 month period from January to December 2019. It shows metrics such as revenue, expenses, profit margin, opening cash, number of cups sold, and highest/lowest forecast profit and cash points. Overall, the café had highest revenue and profit margin in July 2019 with $8,554 in revenue, 18% profit margin, and $3,113 in opening cash.

Uploaded by

Kimberly Vicente
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

enter title here Jul-19

Current Mth Last Mth Full 12 mths Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19
Revenue 5,702 5,832 7,128 5,832 8,197 8,165 8,554 7,841 6,480 6,480 6,415 4,925
Total Expenses 5,884 5,905 6,121 5,905 6,300 6,294 6,359 6,240 6,013 6,013 6,003 5,754
Opening Cash - 1,119 2,345 526 1,753 4,951 3,113 6,608 9,508 6,096 7,863 9,576
Number of cups sold 2,112 2,160 2,640 2,160 3,036 3,024 3,168 2,904 2,400 2,400 2,376 1,824
Profit Margin -2% -1% 10% -1% 16% 16% 18% 14% 5% 5% 5% -12%

Revenues
Q1
Q2
Q3
Q4

Other Metrics Amount Month


The lowest forecast profit after tax is:
The highest forecast profit after tax is:
The lowest cash point is:
The highest cash point is:
Jul-2019 Dashboard Report for Our Caf Jul-19

Profit after Tax vs Closing Cash


$12,000 Current Mth Last MthFull 12 mths
Revenue $8,554 $8,165 $81,551
$10,000
Total Expenses $6,359 $6,294 $72,792
$8,000 Opening Cash $3,113 $4,951 $53,458
$6,000 Number of cups sold $3,168 $3,024 $30,204
$4,000 Profit Margin 18% 16% 73%

$2,000

$0 Jul-19

Aug-19

Sep-19

Nov-19

Dec-19
Jan-19

Feb-19

Mar-19

Apr-19

May-19

Jun-19

Oct-19
-$2,000

Profit after Tax Closing Cash

Profit Margin No Cups Sold vs Revenue


18% 3,500 $9,000
16% 16%
14% 3,000 $8,000
$7,000
10% 2,500
$6,000
5% 5% 5% 2,000 $5,000
1,500 $4,000
Ja-2% -1% Mar-19 Apr-19
n-19 Feb-19 -1% May-19 Jun-19 Jul -19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19
$3,000
1,000
$2,000
500 $1,000
-12% - $0
Jan-19 Mar-19 May-19 Jul-19 Sep-19 Nov-19
Profit Margi n Number of cups sold Revenue

Actual & Average Profits Expenses


$2,000 Other Costs Staff Costs
$7,000
$1,500
$6,000
$1,000 $5,000

$500 $4,000
$3,000
$0
$2,000
Mar-19

Apr-19

May-19

Jul-19

Sep-19

Nov-19

Dec-19
Jan-19

Feb-19

Jun-19

Aug-19

Oct-19

-$500 $1,000

-$1,000 $0
Jan-19 Mar-19 May-19 Jul-19 Sep-19 Nov-19
Profit after Tax 3 Month Average Profit

Revenues
Q1 $18,662
Yearly Expenses
Quarterly P&L Q2 $22,194 Staff Costs Rent & Utilities Consumables

Q3 $22,874
Q4 $17,820
$25,000

Other Metrics Amount Month


The lowest forecast profit after tax is: -$581 Dec-19
The highest forecast profit after tax is: $1,536 Jul-19
The lowest cash point is: $526 Mar-19
The highest cash point is: $9,576 Nov-19

$20,000

$15,000

$10,000

$5,000

$0
Q1 Q2 Q3 Q4
Forecast Profit & Loss for Caf

Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19
Revenue $5,702 $5,832 $7,128 $5,832 $8,197 $8,165 $8,554 $7,841 $6,480 $6,480 $6,415 $4,925

Expenses
Staff Costs $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633
Other Costs $2,250 $2,272 $2,488 $2,272 $2,666 $2,661 $2,726 $2,607 $2,380 $2,380 $2,369 $2,121
Total Expenses $5,884 $5,905 $6,121 $5,905 $6,300 $6,294 $6,359 $6,240 $6,013 $6,013 $6,003 $5,754

Profit -$181 -$73 $1,007 -$73 $1,898 $1,871 $2,195 $1,601 $467 $467 $413 -$829
Tax -$54 -$22 $302 -$22 $569 $561 $658 $480 $140 $140 $124 -$249
Profit after Tax -$127 -$51 $705 -$51 $1,328 $1,309 $1,536 $1,120 $327 $327 $289 -$581

Forecast Cashflow for Caf

Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Totals
Opening Cash $1,119 $2,345 $526 $1,753 $4,951 $3,113 $6,608 $9,508 $6,096 $7,863 $9,576 $53,458
Revenue $5,702 $5,832 $7,128 $5,832 $8,197 $8,165 $8,554 $7,841 $6,480 $6,480 $6,415 $4,925 $81,551
Expenses
Staff Costs $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $3,633 $43,600
Rent & Utilities $3,900 $3,900 $3,900 $3,900 $15,600
Consumables $950 $972 $1,188 $972 $1,366 $1,361 $1,426 $1,307 $1,080 $1,080 $1,069 $821 $13,592
Total Expenses $4,584 $4,605 $8,721 $4,605 $5,000 $8,894 $5,059 $4,940 $8,613 $4,713 $4,703 $8,354 $72,792
Tax $226 $1,109 $1,279 $15 $2,628
Closing Cash $1,119 $2,345 $526 $1,753 $4,951 $3,113 $6,608 $9,508 $6,096 $7,863 $9,576 $6,131 $59,589

Number of cups sold 2,112 2,160 2,640 2,160 3,036 3,024 3,168 2,904 2,400 2,400 2,376 1,824

Profit Margin -2% -1% 10% -1% 16% 16% 18% 14% 5% 5% 5% -12%
3 Month Average Profit -$127 -$89 $175 $201 $661 $862 $1,391 $1,322 $994 $591 $314 $12

Quarterly Data
Q1 Q2 Q3 Q4 Total
Revenues $18,662 $22,194 $22,874 $17,820 $81,551
Staff Costs $10,900 $10,900 $10,900 $10,900 $43,600
Other Costs $7,010 $7,599 $7,712 $6,870 $29,192
Total Expenses $17,910 $18,499 $18,612 $17,770 $72,792
Profit $752 $3,695 $4,262 $50 $8,759
Tax $226 $1,109 $1,279 $15 $2,628
Profit after Tax $526 $2,587 $2,983 $35 $6,131

You might also like