Set Up Budget and Reporting Package for Club

See more projects
Intensity
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.
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
We use cookies for an optimal website experience. By using the site, you consent to our use of cookies as stated in our Privacy Policy.
Accept