Startup KPI Analysis – Ecommerce/Digital Payment - Excel Model

An effective model to monitor and analyse financial performance of a startup.

by Dane Putranto
Financial Modeller | Financial Advisor | Project Manager at NumarusFollow

1,208 views|1 comment|Bookmark Add to cart - $99.00

Description
The excel model is useful and insightful tool for startups to evaluate their success at reaching targets. KPI analysis is being implemented with a clear main goal: ensuring growing profit over time. Business KPI analysis is a challenging task for which one needs to understand the data in place really well. This tool helps with this monitoring task and making the most of what the performance indicators are showing.

Time Series:
Monthly time period

The Model features:
• Table of Contents
• Navigation
• Error check and Alerts
• Key (legend for the model)
• Assumptions:
o Budget
-Income statement
-Transaction Value
-Transaction Volume
-Revenue Margin

o Revenue & Expenses
-Subscribers & Active Users
-Revenue Stream 1 (5 categories) & Revenue Stream 2 (5 categories)
•Calculation based on transaction volume, GMV, & revenue margin
-Revenue Stream 3 (5 categories)
•Calculation based on manual input
-Expenses:
•User Acquisition
•Merchant Acquisition
•User Retention
•Marketing (ATL, ABL, & Digital)
•Infrastructure & Maintenance, etc.
o Financing (equity)
o Capital Expenditure
o Others
o Outputs:
-Dashboard
-Income Statement (Annual & Monthly)
-Cash Flow Statement (Annual & Monthly

The model was developed using financial modelling best practice standards. This particular model was built using the Modano Software under the Best Practice Modelling Standard (BPMS). I used a specialist financial modelling software to incorporate flexibility into the time series

Should you have any questions on the model you're welcome to Private Message us via our Eloquens Channel or use the discussion feed below.

Your review and rating of the model is always appreciated.

Visit out website at www.numarus.com

This Best Practice includes
1 Excel File, 1 Dashboard Instructions