Set Up Budget and Reporting Package for Club

See more projects
Work Remotely
Payment Rate
$125.00 /hour
Est. Duration
14 days
Est. Intensity
5 hr/week

About The Work

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.

Other Prerequisites

1-5 years professional experience
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