Net Worth Tracker

Are you a person who gets satisfaction from tracking your net worth? Perhaps looking at your net worth is more enjoyable than following a strict budget or buying new electronics.

Using The Net Worth Tracker
Tracking your net worth is easy using this spreadsheet. Just update your actuals each month, and view your progress on the net worth chart.

Your net worth is just the difference between your assets and your liabilities. Your assets include things like checking accounts, property, and retirement accounts. Liabilities include things like credit card debt, student loans, and car notes.

Long Term Approach
Tracking your net worth gives you a long-term sense of your finances. For example, if you own a car and have payments you may notice that the car depreciates faster than the balance on the loan. This causes you to lose net worth, even though you are paying for the car each month. This leads to a good rule of thumb – don’t use credit to buy depreciating assets.

Tracking your net worth will also help you appreciate how stock market returns or the real estate market can affect your net worth. You can compare how much your net worth changes versus your income. If you make $5k in one month, did your net worth go up more or less than $5k? If more, you must have other assets that went up in value (or liabilities that went down). If your net worth did not go up $5k, you might have spent your income on things other than appreciating assets (like rent, food, gasoline, etc).

What You Get

  • Full unlocked model in Excel: save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Requirements: Microsoft Excel 2007 and above

Restaurant Business Model

This example restaurant business model is great for entrepreneurs considering opening their own restaurant.


This Excel model covers startup costs, operational planning and expenses, and projected financials. You can enter your own assumptions and verify the impact on the financial results.

There are metrics included to help make sure your assumptions are realistic. For example, updating the detailed build-out costs provides you with an estimate of cost per square foot. You can also see annual sales per square foot, and your estimated staffing level and cost.

Example – Estimating Sales
Estimating sales is an important step for evaluating a restaurant business. This model allows you to enter sales by day of week and shows you the % of total for the week. For example, if your restaurant does $30k in sales per week and $8k on Saturday, the model shows Saturday as providing 27% of the weekly sales. Sound right for your restaurant? You can also see the total number of customers based on your sales and average ticket. If the customer count sounds too high, just revisit your assumptions.

Also consider the product mix – such as percentage of alcohol sales by day. If Saturday has a higher mix of alcohol sales, update the model and see how much gross margins change. Changing your product mix assumptions will flow through to the P&L and let you test the impact of each assumption.

Features

  • Build-out costs
  • Staffing costs
  • Estimating and ramping sales
  • Margins and Cost of Goods Sold
  • Working capital requirements
  • Operational expenses

What You Get

  • Full unlocked model in Excel: save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Note: This model assumes you lease space for a restaurant, not own.

Call Center Staffing Model

This staffing model in Excel helps estimate the number of agents you need to answer the phones. Plan your your staffing model to balance agent utilization against the average waiting time for a caller.

This model considers the amount of calls by hour, the number of agents, and the length of a phone call. You can adjust these inputs to see impact on average waiting time and agent utilization.

For more background about call center staffing and operations research consider reading this entry on Wikipedia. This Excel staffing model is designed to be more simple and easy to use for estimating staffing levels and call center service levels. If your call center demands are more sophisticated (such as mixing inbound and outbound calls, using predictive dialers, or more than 30 agents simultaneously) we suggest hiring a specialist to analyze your call center operations.

What’s Included

  • Full unlocked model in Excel: save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Requirements: Microsoft Excel 2007 and above

Excel Recession Graph

Downloadable Recession Chart In Excel

Need to show your data set against recessions? This popular chart gives context to your data, whether showing historical billings for your company, economic indicators, or stock market levels.

What’s Included

  • Full-featured Excel source with example chart
  • Sample data for recessions, last updated Oct 2011
  • Free upgrades for life
  • 100% satisfaction guaranteed or full refund
Requirements: Microsoft Excel 2007 and above

Rent Roll

This rent roll dashboard in Excel was built for a client who owns commercial property. The property owner sublets to multiple tenants who pay weekly rent. This rent roll is used as a simple dashboard to manage the business with the on-site property manager.

What Is A Rent Roll?
A rent roll (definition) is a document to manage leased property. It shows a list of units, the tenants, the rent charged for each unit, and lease expiration date. A rent roll can be used for residential or commercial properties. Uses for residential rent rolls could include duplexes, fourplexes, or apartment complexes. Commercial rent roll uses could include retail subletting, storage facilities, or office space rentals.

How The Rent Roll Excel Model Is Used To Manage Client’s Business

  • Property manager tracks rent paid each week
  • Tenants receive printed receipts with history of rent payments
  • Property manager monitors expiring leases and professional licenses
  • Owner compares rent paid by week to bank deposits
  • Owner monitors occupancy levels for any risk*

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

*Bonus Tip: The owner found staggering leases reduced risk substantially. He found the easiest way to stagger leases is to offer a renewal discount on the tenant’s birthday.

Selling House vs Renting

Should You Sell or Rent Your House?

This model considers three scenarios: selling your house now, renting your house, and waiting for a better offer.

How Do You Decide Rent vs Sell?

There are many factors to consider. What would be your estimated net proceeds at closing, with closing costs and commissions included? If you rented your house, what would be the monthly maintenance? What vacancy do you anticipate?

Also consider your expectations about the housing market. How much would your house rent for today, and how much might it sell for a year from now? If you aren’t earning enough rental income to offset your expenses you have negative cashflow. Would any negative cashflow be offset by a higher future sales price?

We also include a table on time versus price changes. Both the length of time that passes and the amount the offer changes will help you determine if you should take a lower offer for your home today. You can calculate how much better a future offer needs to be to justify waiting 1 month, or even a full year.

Start Your Analysis Today
Download our Excel model today to help determine if you should sell your house today, rent it out, or wait for a better offer.

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Duplex Investment Model

Buying a Duplex?

Considering a duplex as an investment property? Calculate and analyze the key ratios, metrics, and financial returns for successful property investment.

Included Features

  • Compare metrics: cash-on-cash returns, cap rates, GRM and more
  • View investment detail by month
  • Model estimated costs: insurance, maintenance, vacancies
  • Test how rent growth and rising property values impact your investment

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Requirements: Microsoft Excel 2007 and above

P.S. Want to read how the model helped when I bought my first rental property? I posted those details here. Includes my actual rental property purchase price, initial and current rents, financial returns, and more.