Finance dashboard F&L Format for who need

finance dashboard

1. Income Expenses
Net profit Margin %
% of Expenses BudgetNet Profit Cash at EOM Quick Ratio Current Ratio
741 4.167 1,47 3,66
Statement Income and Expenses
Accounts Receivable Accounts Payable% of Income Budget
4.800 3.059 991 867
94%
83%
4800
6023
-1.259
+3.541 -1.800 +1.741 -1.000
Total
Income
Cost of
Goods Sold
Gross ProfitTotal
Operating
Expenses
Operating
Profit (EBIT)
TaxesNet Profit6,6% 1,9% -6,5% -1,9% 5,9% -5,0% 10,5% -10,9% 15,4% 1,4%
vs.previous month vs.previous month vs.previous month vs.previous month
vs.previous month vs.previous month vs.previous month vs.previous month
4501 4800 4300 5100 4800 5200 5100 4100 5200 5184 4800
3001
3059 3040
2974 2979 2993 3020
3087
3264
2939
2794
2668
-1.500
-1.741
-1.260
-2.126
-1.821
-2.207
-2.080
-1.013
-1.936 -2.245
-2.006

4. Current Ratio
3,66
Income and Expenses
Accounts Payable
867
previous month
previous month
4800 4625
2668
-2.006
-1.957

7. FEB
5111
-311
Budget 3674
Balance -615

10. #REF! 15,4%
0,154375#REF!