Hanz Hargianto
Financial Modelling | Budgeting | Planning | Credit Analytics | Project Manager - Numarus Follow

• views 536
• users 4
• reviews 0
• Downloadable Tools 2

•  
• free

Hanz Hargianto

Financial Modelling | Budgeting | Planning | Credit Analytics | Project Manager - Numarus

Discuss with Hanz Hargianto!

mailPrivate message

Follow

Bio

He has strong passion in Financial Modelling.More than 6 years experiences in banking industry in Business Process Re-engineering and Business FinanceMore than 3 years experiences in building various decision making tools (financial models) for various industries, such as seaport, logistics - shipping, entertainment media, power generation, consumer financing, and fertilizer. Those models were credit analysis model for project finance, corporate planning model (RJPP) with numerous fina

Tags

budgetsfinancial projectionsmonthly planningbarbershopcoffee shopfinancial statementshair cut

Social

Categories

• 

  Financial Projections Models

• 

  Industry Specific Financial Models

• views 536
• users 4
• reviews 0
• Downloadable Tools 2

• free

• 

  Monthly Planning Model - Barbershop - 3 Years Excel Model

  An effective model for planning and monitoring a barbershop business performance on monthly basis.

  financial projectionsfinancial statementsbudgetsbarbershophair cut

  2902add_shopping_cart

  $35.00
• 

  Monthly Planning & Analysis - Coffee Shop - 3 Years Excel Model

  An effective model for planning and monitoring a coffee shop business performance on monthly basis.

  financial projectionsbudgetsmonthly planningcoffee shop

  246Discussadd_shopping_cart

  $35.00

Publish your own Best Practice

People using these Best Practices also downloaded

Best Practices Downloaded & Rated by Hanz Hargianto

• 

  Merger & LBO Model Valuation Excel

  This LBO model in excel analyzes the value of equity and the firm in a leveraged buyout operation.

  financemodelfirmmergersleveraged buyout

  8,717Discussadd_shopping_cart

  free

  by Prof. Aswath Damodaran
• 

  Capital Budgeting Analysis Excel Model

  This Excel Model allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI

  analysiscorporate financecapital budgetingprojectequity

  12,7152add_shopping_cart

  free

  by Prof. Aswath Damodaran
• 

  Debt Modeling Workbook (Training)

  Train yourself at generating loan schedules for personal loans

  financedebtmodelingprincipal repaymentdebt profile

  1,271Discussadd_shopping_cart

  free

  by Lance Rubin
• 

  Colgate Financial Model (Unsolved & Solved Versions)

  A full financial model ready to be adapted to any other company + a blank template

  income statementcash flowsfinancial modelbalance sheetdepreciation schedule

  1,112Discussadd_shopping_cart

  free

  by Dheeraj Vaidya CFA FRM
• 

  Startup Financial Model Template

  A simple financial model for an early-stage startup/anyone building a model for a company

  financefinancial modelentrepreneurshipstartupsearly-stage

  6,141Discussadd_shopping_cart

  free

  by David Teten
• 

  Freemium Business Model

  Customize a ready-made financial model for your Freemium Web Services Business

  financemodelingfinancial modelstartupsventure capital

  3,368Discussadd_shopping_cart

  free

  by Giff Constable
• 

  Liquidation Model - Waterfall Analysis

  Educate employees, founders, and others in how liquidation preferences affect financial distribution in exit scenarios

  financestartupsventure capitalraising capitalliquidation preferences

  3,633Discussadd_shopping_cart

  free

  by Michael Dempsey
• 

  SaaS Financial Plan

  A financial plan template for SaaS startups based on a model created for Zendesk

  roadmapsalesmarketingfinancemodel

  9,282Discussadd_shopping_cart

  free

  by Christoph Janz
• 

  E-Commerce Financial Model for Startups

  An extremely detailed, methodical package for entrepreneurs on how to build a financial model for an e-commerce startup.

  financestartupskpisfinancial modelingproduct management

  21,4071add_shopping_cart

  free

  by Matt Carroll
• 

  Sample Financial Model

  Template for determining cost realities and financial projections for potential investors' demands.

  financesimplefinancial modelinvestorsstartups

  30,8841add_shopping_cart

  $15.00

  by Marty Zwilling
• 

  Abercrombie & Fitch Valuation Model

  A full PDF of an Excel Valuation Model created for fundamental analysis of Abercrombie & Fitch ($ANF) in 2006

  financevaluationfcfffcfefree cash flow to equity

  805Discussadd_shopping_cart

  free

  by Lindsay Meyer
• 

  3-way Banking Financial Model converted into an App

  Demonstration tool of a 3-way banking financial model converted into an interactive visualisation App

  modelerfinancial modellingbankingvisualisationdynamic influencing

  1,271Discussadd_shopping_cart

  $9.50

  by Lance Rubin
• 

  Combination Model

  A 22 section excel model to assess the impact on the financials of the combination of companies

  combinationimpactfinancemergersm&a

  5,8694add_shopping_cart

  free

  by John P. Burns
• 

  Saudi Cement Financial Model

  This model shows that you can make a reasonable simple model from the data in TAWDAL

  acquisitionprojectionslearningvaluationroic

  739Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Leveraged Buyout LBO Model

  A fully customizable excel LBO model to assess the debt level your firm can take in a deal & expected investor returns

  mergersleveraged buyoutprivate equitylbom&a

  4,182Discussadd_shopping_cart

  free

  by Firmex
• 

  Startup Excel Model

  A startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.

  financecash flowprivate equityfinancial modelstartup

  35,0666add_shopping_cart

  free

  by Prof. Robert H. Hacker
• 

  Real Estate Excel Model

  A Real Estate Financial Model where new property owners purchase their houses outright

  financereal estatefinancial modelproceedstown house

  4,4882add_shopping_cart

  free

  by Prof. Robert H. Hacker
• 

  Internet Business Financial Model SIBM - Spartina

  Manage your Cash, Increase Startup Revenue & Grow your Profits

  revenuefinancefinancial modelstartupentrepreneurship

  1,888Discussadd_shopping_cart

  free

  by David Hehman
• 

  Excel Revolving Credit Calculator for annual models

  An automatic excel algebraic approach for revolving loan facility in annual financial models (no macro & circular links)

  financedebt schedulefinancial modelingcredit calculatordebt structure

  2,366Discussadd_shopping_cart

  free

  by Ivan Klykov
• 

  Excel Cap Table with Waterfall for Start-Ups

  Model for pre-funded start-ups showing pre-money and post-money financing.

  financingventure capitalcaptemplatetable

  1,796Discussadd_shopping_cart

  free

  by Prof. Zach Shulman
• 

  Financial Model Template for Startups

  Tell the story of your business in numerical terms.

  financialmodelsimplestartupstartups

  2,050Discussadd_shopping_cart

  free

  by Vince Scafaria
• 

  Financial Model for Mobile Payment Startup

  Includes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.

  income statementfinancemodelbalance sheetstartup

  2,547Discussadd_shopping_cart

  free

  by Tayfun Uslu
• 

  Social Media Metrics Excel Dashboard

  An excel template for employees to understand the performance of social media channels for their organisation.

  salesmarketingsocial mediametricsdashboard

  7,734Discussadd_shopping_cart

  free

  by Joakim Nilsson
• 

  Cohort Analysis Calculation Excel Model

  Perform an in depth cohort analysis, in 5 minutes, in 3 simple steps.

  strategystartupcohort analysiskpiecommerce

  953Discussadd_shopping_cart

  free

  by Samaipata Ventures
• 

  Commercial Bid and Contract model

  Working Commercial bid Excel model used in several real case contracts

  commercial modelbid modelcontract model

  118Discussadd_shopping_cart

  free

  by Jack Avon
• 

  Returns Analysis Template

  Easily calculate your investment returns - simply enter your data into the table!

  strategyinvestmentinvestorsroiventure capital

  12,875Discussadd_shopping_cart

  free

  by Matthew Nordan
• 

  Monte Carlo Simulation Excel Model

  Monte Carlo Model generated in excel with explanatory article included to guide you block-by-block through the code.

  modelingexcelsimulationmonte carlo

  539Discussadd_shopping_cart

  free

  by Frank Gary
• 

  Tollway Project Finance Excel Model

  Toll roads generate revenue on a user-pay system - this model will help you plan the finances of your tollway projects

  projecttoll roadtollwaytollway financetollway financial model

  686Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Hydro Excel Model - with Commodity Price Risk and Monte Carlo Simulation

  Financial model for hydro investments including commodity price risk and monte carlo simulation

  financial modelrenewable energyhydro powerrenewable energy modelrenewable energy finance

  1,152Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Restaurant Financial Excel Model

  In this file I will show you how to calculate whether your business idea for a restaurant makes sense or not.

  business planbusiness modelfinancial modelstartuprestaurant

  11,4891add_shopping_cart

  free

  by Asen Gyczew
• 

  Warehouse Inventory Management Excel Template

  Excel template for warehouse inventory tracking and management

  templateexcelinventory managementstock managementinventory tracker

  8,2361add_shopping_cart

  free

  by App Sheet
• 

  Sales Mix, Menu Mix and Menu Engineering Spreadsheet

  A series of sales mix worksheets that allows you to analyze menus based on a series of factors.

  restaurantrestaurant financesales mixmenu engineeringmenu mix

  3,9962add_shopping_cart

  free

  by Chef David Buchanan
• 

  Hotel Project Finance Model

  Extensive financial model for your hotel projects and investments.

  cash flowbalance sheetdepreciation scheduledebt scheduleprofit and loss

  1,906Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Financial Model for Ports with Alternative Scenarios for Shipment Growth and Danger of Surplus Capacity

  This is an incredibly detailed financial model for your port and shipping projects.

  cash flowcorporate financedebt scheduleproject financecapital expenditure

  394Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Startup Home Health Care Financial Projections

  Detailed financial model for your startup home health care project and projections

  revenuesfinancial projectionsfinancial statementcapexgross profit

  5696add_shopping_cart

  free

  by Mahender K. Punhani
• 

  Cohort Analysis Excel Template

  Excel model template for conducting cohort analysis and customer behaviour analytics for your business.

  cohort analysiscustomer retentioncustomer analysiscustomer behaviourexcel model

  552Discussadd_shopping_cart

  free

  by CFI
• 

  Cost of Goods Manufactured Excel Model Template

  Excel model for scheduling the cost of good manufactured for your business

  cogscost of goods soldinventorycost of goods manufacturedcogm

  3,992Discussadd_shopping_cart

  free

  by CFI
• 

  2017 Finals: Data Diving

  Excel training/competition model from the 2017 Financial Modeling World Championships

  mapcompetitionanalysismodelingdata

  226Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2017 Finals: Castles in the Air

  Excel training/competition model from the 2017 Financial Modeling World Championships

  competitionpropertymodelingportfolio

  147Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2014 Round 2: Time is Money

  Excel training/competition model from the 2014 Financial Modeling World Championships

  financial modelingm&aacquisitionsfinancial statementsexcel skills

  130Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2014 Round 1: Snakes and Ladders

  Excel training/competition model from the 2014 Financial Modeling World Championships

  financial modelingexcel skillsexcel trainingfinancial modeling trainingfinancial modeling competition

  143Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2013 Round 1: Energy Operations

  Excel training/competition model from the 2013 Financial Modeling World Championships

  financial modelingenergysolar rooftopexcel skillsfinancial modeling skills

  350Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2012 Round 2: Find That Error

  Excel training/competition model from the 2012 Financial Modeling World Championships

  excel skillsfinancial modeling skillsexcel trainingfinancial modeling trainingfinancial modeling competition

  65Discussadd_shopping_cart

  free

  by MODELOFF
• 

  2012 Round 2: Monte Carlo

  Excel training/competition model from the 2012 Financial Modeling World Championships

  monte carlo simulationexcel skillsfinancial modeling skillsexcel trainingfinancial modeling training

  130Discussadd_shopping_cart

  free

  by MODELOFF
• 

  Corporate Summary Excel Dashboard

  A succinct Corporate Summary Excel dashboard report which displays a range of organisational metrics (actual vs plan).

  financialcorporatedashboardexcelsummary

  11,704Discussadd_shopping_cart

  free

  by Marcus Small
• 

  Comprehensive Restaurant Financial Excel Model Template (Pro Forma Statements for Business Plan)

  Complete Financial Model to Start Your Own Restaurant and Bar Anywhere in the World

  projectionsbusiness planfinancial modelstartuptemplate

  3,340Discussadd_shopping_cart

  free

  by Faheem Moosa

+ More Best Practices

Discuss with Hanz Hargianto

Ask Hanz Hargianto questions about their work or tools. Go ahead!

Post Comment