Running a hotel can be an exciting and dynamic venture that offers a range of interesting aspects. If you have a passion for making people comfortable and happy, it might be a good industry to dive into as an investor or general partner that is more involved in decisions.
Manufacturing Productivity Sensitivity Tables - Excel Template
This is a sensitivity analysis model for any manufacturing business or high volume seller of goods. It sensitizes a wide range of variables in three different base models. There are a total of 21 data tables included in the template. The 'What-if Analysis' feature under the 'Data' ribbon in Excel was utilized to build each table.
SLAs and Your SaaS Business
Software-as-a-Service (SaaS) is a type of business model that really took off in the last 10 years. More and more companies are finding that they can offer subscriptions to services that they provide instead of offering one-time fee services. The nature of software makes it a really good candidate for recurring revenue subscriptions, however there is one thing you've got to get right and that is the SLA or Service Level Agreement. It is more of a point of emphasis with B2B SaaS, but can also apply at some level to B2C.
Scaling a Professional Services Organization
Scaling a professional services business requires careful planning and strategic implementation. This is a people business and that should be the basis of how you track, plan, and measure.
Mobile App Business: KPIs
If you are a mobile app developer, some applications are going to do great and some not so great. What you can do to track success and focus on what does well is develop some KPIs to track. This will help you focus on the right things over the long term and improve decision making. It is all about data driven insights and if it doesn't make dollars, it doesn't make sense.
Used Car Dealership KPIs
Honestly, any business can think of KPIs for their specific industry and start tracking them. There is nothing stopping you from doing this. It could be on a piece of paper or in a spreadsheet or what have you. The point is, this can be a really good way to know if you are growing, hitting goals (it will help you set goals if you start tracking things). Here I'm going to focus on some KPIs for a used car dealership.
Average Pawn Shop Annual Profits
Annual profits will vary based on the pawn shop size, the types of things being sold, the area / demographics, and all sorts of things, but we can get into some general metrics that are comparable and give a few broad pieces of data to try and give you an idea of what may be possible.
Scaling a Loan Business: Strategy Development Guide
A loan business is just a business that lends money to organizations and received interest and principal back. It may have origination fees and late fees that contribute to revenue as well. There are actually m any points of entry in the lending industry. You could enter as a P2P platform, an originator, or a buyer and seller of loan batches. Here I am going to talk about the business of lending out money.
Jewelry Industry: Key Market Stats
When you are just starting a new business, looking at macro level data can be insightful to give an idea of future expectations, market opportunities, and general strategy.
Car Wash Business Analytics
Using your own businesses data to make decisions can be powerful, lets jump in. Car wash analytics can provide valuable insights into your business operations and customer behavior, enabling you to make data-driven decisions to improve your car wash. Here are some key analytics and how you can utilize them:
Trucking Business: 5-Year Financial Model
This financial model turned out to be a work of art. Anybody looking to start a trucking company (or organization) will benefit from this financial forecasting template. It has all the assumptions you need for this type of business and was built to handle large- or small-scale operations as well as scaling from small to large.
Car Wash KPIs - Track and Improve
Car wash KPI (Key Performance Indicator) metrics are specific measurements used to evaluate the performance and effectiveness of a car wash business. These metrics help owners and managers assess the overall health of their operations and make informed decisions to improve efficiency, customer satisfaction, and profitability.
Sustainability of Airbnb Businesses
What do I mean by 'airbnb businesses'? Well this involves anybody who uses any kind of booking site to rent out properties they own. The idea is that you can make a lot more money by renting out properties as if it was a hotel rather than long-term 1-5 year leases.
Some Tips for Buying Apartment Buildings: Real Estate Investment
This is not investment advice, but just some things to think about if you are a real estate investor and have been looking into acquiring or building apartment buildings. Note, I've done all sorts of models for clients that are doing this right now.
Real Estate Syndication Deal Overview
Real estate syndication deals are a popular investment model where multiple investors pool their capital to collectively purchase and manage real estate properties.
Accounting for Cost of Goods Sold: Manufacturing Plant
One of the more complex financial models I built was for a general manufacturing plant. The logic required to get the cost of goods sold and average cost per unit flowing correctly was extensive. Driving down to cash flow was even more complicated. This is one of the only businesses where you can have non cash items that are hitting cost of goods sold (property/plant/equipment depreciation).
SaaS Modeling Technique: AE and SDR Assumption Drivers
This kind of business model has sales directors sitting their making sales calls all day long trying to sign up new recurring revenue customers that might be paying $300 to $600 per month. It is often B2B SaaS that is being sold. If this is your model, it is important to create economic forecasts to figure out if the math works for what you are paying sales people vs. the lifetime value of new customers.
Difference Between B2B and B2C SaaS Businesses
I've done all sorts of models for B2C businesses and a couple B2B businesses. There are some primary differences between the two types. Sometimes there are modeling crossovers in the logic required, but many differences exist.
Most Popular Things to Build an Equipment Rental Business Around
Equipment rental businesses have been around for many years, dating back to at least the early 20th century. In fact, one of the earliest known equipment rental companies was the U.S. Rental Company, which was founded in 1902 and provided equipment such as steam shovels, cranes, and other heavy machinery for construction projects.
Consistently Profitable Vehicles to Sell as a Used Car Dealership Business
If you are running or looking to open a used car dealership, one big question is what types of vehicles should be focused on? The goal is to have consistent demanded categories so that things don't sit in inventory forever. You need good sales, but you also need good product. Let's look at some types as well as inventory strategies.
Coffee Shop / Café / Restaurant - 5 Year Financial Model
If you are starting up a new coffee shop, this financial model is perfectly designed for you. It will also work great for a general restaurant or café. The assumptions are flexible and robust to provide the right framework for conducting proper bottom-up financial forecasting and using generally accepted methodologies.
What is Your Lending Businesses Credit Scoring Model?
If you are in the lending business, you will have a risk model or general credit scoring model that is relied on to determine interest rates as well as loan eligibility for borrowers that want to get a loan. The question is, what is the best model or methodology for doing this in a way that minimizes defaults and maximizes profits. Remember, you want to have a balanced portfolio to get healthy returns (higher interest rates) but also steady payments from good borrowers that don't default (higher interest rates don't mean much if you the default rate is too high).
Sensitivity Data Table Usage in Financial Models
If you deal with financial models, use them, or build them, one of the most interesting things you can do is data table creation through Excel's Data ribbon under 'what-if' analysis. It can be done with all sorts of assumptions and it is one of the reasons why it is so important to have all inputs called out in their own cells rather than trying to hard code in numbers into formulas. For example, if your expense growth rate is 0.03 and you just put that number into the formula rather than putting it into an input cell and referencing it with a formula, then you can't run a sensitivity analysis on expense growth.
Successful Business Strategy: Running Synergistic or Complementary Businesses
Running different businesses that are complementary to each other can be a good idea if done correctly. When businesses are complementary, they can create synergies and economies of scale that can increase efficiency and profitability. However, there are several factors to consider before pursuing this strategy.
How to Automate Your Profit and Loss Statements
At a high level, your profit and loss statement shows the revenues earned, any refunds / chargebacks, expenses, and any amount remaining is your profit/loss for each period. Using QuickBooks or other Software / ERP systems will often give you automated exports of profit and loss statements, balance sheets, and other reports. What if you don't use those software programs, or what if you want to build budgets and actuals without those programs? Well, then you can still produce automated financial statements with spreadsheets (Excel or Google Sheets).
Seller Financing Amortization and Spreadsheet Basics
The first model I technically built was probably in college all the way back in 2009 when we had to code in a simple amortization schedule for a loan. I remember it was not that easy and took me a few tries to make it work right. We also studied IRR (internal rate of return) and little did I know how important that metrics would be in my professional career at the time. So, today we are going to look at doing an amortization schedule for seller financing and all the relevant pieces it should have.
What is Average Rent per Available Room (RevPAR) in Real Estate Analytics?
One of my favorite types of financial models to build is real estate. I got my very first real job building one of these things out on Upwork and just kept going with it. In these kinds of models there are all sorts of things that can be good to focus on. You have cash-on-cash return, IRR, equity multiple. DCF Analysis, NOI, entry/exit cap rates, occupancy, and more. One of the most important things that can be used as a measure of performance is the average revenue per available room.
Customer Segmentation and Accounts Receivable Management
Customer segmentation is the process of dividing a company's customer base into smaller groups based on similar characteristics such as demographics, behavior, needs, or preferences. By grouping customers together, businesses can tailor their marketing, sales, and customer service strategies to each group's specific needs and preferences, which can improve customer satisfaction and loyalty.
Trends in the Equipment Rental Business Industry and How it Impacts Your Bottom Line
There are all kinds of equipment rental / leasing businesses. I've done models for a wide range myself for various clients. Today we'll talk about some overarching trends in the industry and how it can effect your potential profits over time. One of the ones I have not done a template for is leasing contracts with a sale at the end of a defined contract term. I've had two different versions of that to work through. General rental businesses are one of the most popular requested templates I do work for.
Depreciation Recapture Financial Model for Accountants
I was working on depreciation recapture in a financial model and it is quite complicated to build correctly with formulas. There are lots of moving pieces and things to take into account so that you have the correct taxable income (what is recaptured vs. capital gain/loss). They can offset each other so let's get into it.
Subscribe to:
Posts (Atom)