Pawn Shop / Broker 5 Year Financial Model

Video Tutorial:

The model have revenue assumptions that split the expected type of items you want to sell into 3 main high level categories. From there, you define each lower level category, give it an expected value range (low/mid/high) define your desired margins and enter the expected sales growth per year of each low level category.

COGS auto populates per the expected margins and then you enter running monthly costs, startup costs, and capex assumptions.

There are also assumptions for an exit and the possibility of financing as well as an exit multiple (EBITDAx or Revenuex).

After all the assumptions are entered, a monthly and annual P&L / cash flow will populate. The debt will automatically come out of cash flow if there is an exit.

An executive summary is also shown that gives a nice clean picture of key financial performance without much scrolling. There are also lots of charts to visualize the performance over time.

Industry , ,
Summary A forecast that has revenue and expense assumptions directly related to a pawn shop business.
Screenshots / Pictures











Use Cases , , , , , , , , , , , , , , , , , , , , , , , ,

Write a Review

Get these templates too for a discount!

Price: $79.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 7.7% tax

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as: tracking, inventory management, budget vs. actual, break-even analysis, payment schedule, P&L tracker, etc. The bundle…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are the financial model templates included in this product bundle: Jewelry Store Startup Financial Model Robotic…

Add to wish list
Add to cart Excluding 7.7% tax