Manage meetings
Jasjeet
Meetingpaperexample1-Annualfinancialreport1.xlsxFinancial Report
| ANNUAL FINANCIAL REPORT | 2016 | Select report year in Cell L2 | |||||||||||
| La Bonne Assiette | To edit data, select the Financial Data Input sheet | ||||||||||||
| KEY METRICS | Click to change report Key Metrics | ||||||||||||
| REVENUES | NET PROFIT | INTEREST | DEPRECIATION | OPERATING PROFIT | |||||||||
| $180,584 | $67,475 | $3,789 | $5,547 | $73,426 | |||||||||
| 0% | 2% | 14% | 9% | -5% | |||||||||
| ALL METRICS | Do not modify the information below. Click to enter Financial Data | ||||||||||||
| METRIC | REPORT YEAR (2016) | PREVIOUS YEAR (2015) | % CHANGE | 5 YEAR TREND | |||||||||
| REVENUES | $180,583.88 | $180,026.63 | 0% | ||||||||||
| OPERATING EXPENSES | $94,419.45 | $80,883.33 | 17% | ||||||||||
| OPERATING PROFIT | $73,425.99 | $77,317.83 | -5% | ||||||||||
| DEPRECIATION | $5,546.88 | $5,068.42 | 9% | ||||||||||
| INTEREST | $3,789.47 | $3,338.30 | 14% | ||||||||||
| NET PROFIT | $67,474.85 | $66,272.10 | 2% | ||||||||||
| TAX | $31,408.25 | $29,424.53 | 7% | ||||||||||
| PROFIT AFTER TAX | $50,247.68 | $42,438.20 | 18% | ||||||||||
| METRIC 1 | $19.96 | $16.78 | 19% | ||||||||||
| METRIC 2 | $26.01 | $21.84 | 19% | ||||||||||
| METRIC 3 | $31.08 | $26.39 | 18% | ||||||||||
| METRIC 4 | $14.92 | $14.59 | 2% | ||||||||||
| METRIC 5 | $1.03 | $1.00 | 3% | ||||||||||
| METRIC 6 | $0.34 | $0.30 | 13% | ||||||||||
Financial Data Input
| FINANCIAL DATA | ||||||||
| YOU CAN DEFINE UP TO 25 KEY METRICS FOR 7 YEARS | ||||||||
| Click to view Financial Report | ||||||||
| METRIC NAME | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | |
| REVENUES | $125,000.00 | $134,137.45 | $142,728.38 | $150,687.46 | $165,044.56 | $180,026.63 | $180,583.88 | |
| OPERATING EXPENSES | $65,000.00 | $70,962.31 | $75,924.86 | $78,901.27 | $81,674.37 | $80,883.33 | $94,419.45 | |
| OPERATING PROFIT | $60,000.00 | $64,207.30 | $68,857.69 | $75,643.25 | $76,755.26 | $77,317.83 | $73,425.99 | |
| DEPRECIATION | $4,500.00 | $4,517.77 | $4,656.92 | $4,974.21 | $5,024.11 | $5,068.42 | $5,546.88 | |
| INTEREST | $2,500.00 | $2,745.82 | $2,893.11 | $3,136.12 | $3,148.53 | $3,338.30 | $3,789.47 | |
| NET PROFIT | $54,000.00 | $54,761.08 | $55,860.81 | $59,747.95 | $61,483.59 | $66,272.10 | $67,474.85 | |
| TAX | $22,000.00 | $23,920.54 | $25,576.74 | $27,498.86 | $28,335.67 | $29,424.53 | $31,408.25 | |
| PROFIT AFTER TAX | $32,000.00 | $34,943.49 | $38,418.53 | $39,895.05 | $40,607.73 | $42,438.20 | $50,247.68 | |
| METRIC 1 | $12.80 | $12.81 | $13.78 | $14.29 | $15.57 | $16.78 | $19.96 | |
| METRIC 2 | $18.20 | $18.59 | $19.22 | $20.17 | $20.48 | $21.84 | $26.01 | |
| METRIC 3 | $19.10 | $20.55 | $21.87 | $23.19 | $24.67 | $26.39 | $31.08 | |
| METRIC 4 | $12.10 | $12.21 | $12.59 | $13.70 | $13.76 | $14.59 | $14.92 | |
| METRIC 5 | $0.75 | $0.79 | $0.85 | $0.89 | $0.91 | $1.00 | $1.03 | |
| METRIC 6 | $0.23 | $0.25 | $0.27 | $0.28 | $0.29 | $0.30 | $0.34 | |
Key Metric Settings
| DEFINE KEY METRICS HERE | ||||
| SELECT UP TO 5 KEY METRICS TO SHOW AT THE TOP OF THE REPORT | ||||
| Click to view Financial Report | ||||
| 1 | REVENUES | |||
| 2 | NET PROFIT | |||
| 3 | INTEREST | |||
| 4 | DEPRECIATION | |||
| 5 | OPERATING PROFIT |
Calculations
| This worksheet is used for the Financial Report calculations and should remain hidden. | ||||||||
| Position | ||||||||
| This year | 2016 | 8 | ||||||
| Previous Year | 2015 | 7 | ||||||
| Position | 4 | 5 | 6 | 7 | 8 | 5 | ||
| Key Metrics | 2012 | 2013 | 2014 | 2015 | 2016 | |||
| 1 | REVENUES | 142728.38 | 150687.46 | 165044.56 | 180026.63 | 180583.88 | 0% | |
| 6 | NET PROFIT | 55860.81 | 59747.95 | 61483.59 | 66272.1 | 67474.85 | 2% | |
| 5 | INTEREST | 2893.11 | 3136.12 | 3148.53 | 3338.3 | 3789.47 | 14% | |
| 4 | DEPRECIATION | 4656.92 | 4974.21 | 5024.11 | 5068.42 | 5546.88 | 9% | |
| 3 | OPERATING PROFIT | 68857.69 | 75643.25 | 76755.26 | 77317.83 | 73425.99 | -5% | |
| All Metrics (works up to 25 metrics) | ||||||||
| 1 | REVENUES | 142728.38 | 150687.46 | 165044.56 | 180026.63 | 180583.88 | ||
| 2 | OPERATING EXPENSES | 75924.86 | 78901.27 | 81674.37 | 80883.33 | 94419.45 | ||
| 3 | OPERATING PROFIT | 68857.69 | 75643.25 | 76755.26 | 77317.83 | 73425.99 | ||
| 4 | DEPRECIATION | 4656.92 | 4974.21 | 5024.11 | 5068.42 | 5546.88 | ||
| 5 | INTEREST | 2893.11 | 3136.12 | 3148.53 | 3338.3 | 3789.47 | ||
| 6 | NET PROFIT | 55860.81 | 59747.95 | 61483.59 | 66272.1 | 67474.85 | ||
| 7 | TAX | 25576.74 | 27498.86 | 28335.67 | 29424.53 | 31408.25 | ||
| 8 | PROFIT AFTER TAX | 38418.53 | 39895.05 | 40607.73 | 42438.2 | 50247.68 | ||
| 9 | METRIC 1 | 13.78 | 14.29 | 15.57 | 16.78 | 19.96 | ||
| 10 | METRIC 2 | 19.22 | 20.17 | 20.48 | 21.84 | 26.01 | ||
| 11 | METRIC 3 | 21.87 | 23.19 | 24.67 | 26.39 | 31.08 | ||
| 12 | METRIC 4 | 12.59 | 13.7 | 13.76 | 14.59 | 14.92 | ||
| 13 | METRIC 5 | 0.85 | 0.89 | 0.91 | 1 | 1.03 | ||
| 14 | METRIC 6 | 0.27 | 0.28 | 0.29 | 0.3 | 0.34 | ||
| 15 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 16 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 17 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 18 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 19 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 20 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 21 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 22 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 23 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 24 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||
| 25 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
