Set Up Budget and Reporting Package for Club
See more projectsIntensity
5hr/week
Duration
14days
Location
Remote
Project Overview
1 to 8 years professional experience
Finance & Accounting - Financial Modeling
Small local night club. $2MM revenue. Kiss Kiss is name.
Need budget and excel reporting template.
I will provide historical financials for 2017.
I need:
- 12 month P&L forecast (2018)
- A sheet comparing forecast to actual for updating through the year.
- balance sheet and cash flow statement by month.
- ability to input expected owner distributions and CapX into the cash flow. (There is no debt.)
- sheet for allocation of owner distributions (there is a flip between two classes of owners when the first class recovers their capital). Approx 15 owners. We will need inputs at the top of a column for (i) quarterly distribution amount and (ii) whether ‘pre’ or ‘post’ flip and then and if...then function to look up the correct allocation percentage.
- To use similar P&L format as recent new locations template.
Need completed model week of March 5th.
Need budget and excel reporting template.
I will provide historical financials for 2017.
I need:
- 12 month P&L forecast (2018)
- A sheet comparing forecast to actual for updating through the year.
- balance sheet and cash flow statement by month.
- ability to input expected owner distributions and CapX into the cash flow. (There is no debt.)
- sheet for allocation of owner distributions (there is a flip between two classes of owners when the first class recovers their capital). Approx 15 owners. We will need inputs at the top of a column for (i) quarterly distribution amount and (ii) whether ‘pre’ or ‘post’ flip and then and if...then function to look up the correct allocation percentage.
- To use similar P&L format as recent new locations template.
Need completed model week of March 5th.
Preferred Skills and Certifications
Functional
Financial Modeling
About The Client
Top Skills Hiring For
Financial Modeling
Financial Statement Preparation
Financial Planning & Analysis (FP&A)
Corporate Finance
$117K
Total Spent
6 years
Time On Graphite
2
Hiring Managers