Analyzing startup finances with excel.
This will be a financial model for a startup. This model is based on an app for mobile platform.

I assume many things in this model. Do not take the numbers as is.

First the Basic finances for starting.

These expenses are based on my quick online research and my own assumptions (some wrong).
I am assuming at least to be a part of startup. There is no employee share plans, travel or miscellaneous cost involved.

The formulas:

Now that we have a basic cost out of the way. We need to look ahead some years to how the business will do.
Here I will use three cases to show growth.
There is normal case, best case, worst case scenario.

The normal case scenario.

CPI is referral installation for application.
Partnership referrals are product placement adds for a partner product.
Impressions are clicks, large popups or videos.

Here we are generating revenue and start to gain income after third year.

Again I assume expenses will stay the same. I assure you it will not in a real business.

Formulas for this Scenario:

The worst case scenario.

Here we are in a constant loss for 5 years. User generation is very low while cost stayed the same.

Use the same formula pattern as normal case.

The best case scenario:

In this scenario very user generation is higher, we start to create income after the second year.

Change the data to see your own scenario.
The workbook is available for download on google drive.