Financial Model for Indiana auto dealerships
See more projectsEst. Duration
5days
Work Remotely
Work from your own location. No travel is required to apply to this project.
Schedule Expectations
Expert can manage their own schedule
Communication Expectations
(None Provided)
Project Overview
1 to 8 years professional experience
Finance & Accounting - Financial Modeling
For two separate retail auto dealerships
Project and show income statements; balance sheets and cash flow statements. Importantly, this should show how changes in working capital affect cash flow and debt balances.
Investor Returns - show returns on these deals on a stand alone basis. This means we need to make assumptions on debt pay downs, distributions and exit valuations. Probably helpful to do this on both a unlevered and levered basis. Per leverage, we can start with the $5 mm suggested by potential capital partner and allocate between the Ford/Toyota stores. Include a line item into the return calculation for mgmt cost but leave it at zero for now.
Project and show income statements; balance sheets and cash flow statements. Importantly, this should show how changes in working capital affect cash flow and debt balances.
Investor Returns - show returns on these deals on a stand alone basis. This means we need to make assumptions on debt pay downs, distributions and exit valuations. Probably helpful to do this on both a unlevered and levered basis. Per leverage, we can start with the $5 mm suggested by potential capital partner and allocate between the Ford/Toyota stores. Include a line item into the return calculation for mgmt cost but leave it at zero for now.
Additional Notes
Private Equity financial modeling experience Preferred Skills and Certifications
Functional
Financial Modeling
About The Client
11 years
Time On Graphite