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

• views 730
• 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

Education

• Gadjah Mada University Gadjah Mada University is a computer & network security company based out of Indonesia.

Tags

budgetsfinancial projectionsmonthly planningbarbershopcoffee shopfinancial statementshair cut

Social

Categories

• 

  Financial Projections Models

• 

  Industry Specific Financial Models

• views 730
• 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

  4072add_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

  323Discussadd_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

  9,423Discussadd_shopping_cart

  free

  by 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

  15,8053add_shopping_cart

  free

  by Aswath Damodaran
• 

  Debt Modeling Workbook (Training)

  Train yourself at generating loan schedules for personal loans

  financedebtmodelingprincipal repaymentdebt profile

  1,432Discussadd_shopping_cart

  free

  by Lance Rubin
• 

  Box IPO (Initial Public Offering)

  Indepth analysis of BOX IPO with DCF and relative valuation

  financevaluationboxipodiscounted cash flows

  451Discussadd_shopping_cart

  free

  by Dheeraj Vaidya CFA FRM
• 

  Alibaba IPO Financial Model

  A full IPO financial model ready to be adapted and tweaked to any other company

  cash flowsipofinancial modelbalance sheetdepreciation schedule

  1,070Discussadd_shopping_cart

  free

  by Dheeraj Vaidya CFA FRM
• 

  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,259Discussadd_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,506Discussadd_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,686Discussadd_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

  4,621Discussadd_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,638Discussadd_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

  23,0211add_shopping_cart

  free

  by Matt Carroll
• 

  LBO model - Leveraged Buyout Analysis

  A step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!

  financevaluationleveraged buyoutprivate equityinvestment banking

  20,5257add_shopping_cart

  free

  by Business-Valuation.net
• 

  Sample Financial Model

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

  financesimplefinancial modelinvestorsstartups

  31,3231add_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

  859Discussadd_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,443Discussadd_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

  6,4614add_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

  919Discussadd_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,338Discussadd_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

  36,6146add_shopping_cart

  free

  by 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,9542add_shopping_cart

  free

  by Robert H. Hacker
• 

  Internet Business Financial Model SIBM - Spartina

  Manage your Cash, Increase Startup Revenue & Grow your Profits

  revenuefinancefinancial modelstartupentrepreneurship

  2,074Discussadd_shopping_cart

  free

  by David Hehman
• 

  Commercial Real Estate Financial Model

  Compute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel model

  investmentfinancereal estateassumptionsproject finance

  7,4594add_shopping_cart

  free

  by Will Ferrigno
• 

  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,881Discussadd_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

  2,537Discussadd_shopping_cart

  free

  by Prof. Zach Shulman
• 

  Financial Model Template for Startups

  Tell the story of your business in numerical terms.

  financialmodelsimplestartupstartups

  2,550Discussadd_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,929Discussadd_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

  9,310Discussadd_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

  1,181Discussadd_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

  167Discussadd_shopping_cart

  free

  by Jack Avon
• 

  Returns Analysis Template

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

  strategyinvestmentinvestorsroiventure capital

  13,565Discussadd_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

  830Discussadd_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

  1,220Discussadd_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,402Discussadd_shopping_cart

  free

  by Prof. Ed Bodmer
• 

  Real Estate Excel Model

  Comprehensive excel model for tracking and projecting the finances of your real estate investments.

  real estatefinancial modelingreal estate financereal estate investmentreal estate financial model

  1,174Discussadd_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

  13,2571add_shopping_cart

  free

  by Asen Gyczew
• 

  Income Property Valuation Model Excel Template

  An Income Property Valuation Model template in excel along with step-by-step instructions.

  valuationreal estatesaassoftware as a serviceexcel

  1,030Discussadd_shopping_cart

  free

  by Ben Murray
• 

  Warehouse Inventory Management Excel Template

  Excel template for warehouse inventory tracking and management

  templateexcelinventory managementstock managementinventory tracker

  12,6531add_shopping_cart

  free

  by App Sheet
• 

  IPO Valuation Excel Model - Spotify

  A comprehensive overview of Spotify's financial performance and analysis of its IPO

  growthfinancial planningipoipo case studyspotify

  2,442Discussadd_shopping_cart

  free

  by Aswath Damodaran
• 

  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

  5,2114add_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

  2,426Discussadd_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

  5562add_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

  8376add_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

  808Discussadd_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

  5,277Discussadd_shopping_cart

  free

  by CFI
• 

  2017 Finals: Data Diving

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

  mapcompetitionanalysismodelingdata

  368Discussadd_shopping_cart

  free

  by ModelOff
• 

  2017 Finals: Castles in the Air

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

  competitionpropertymodelingportfolio

  209Discussadd_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

  212Discussadd_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

  197Discussadd_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

  567Discussadd_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

  95Discussadd_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

  224Discussadd_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

  19,896Discussadd_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

  5,166Discussadd_shopping_cart

  free

  by Faheem Moosa
• 

  Acquisition Schedule - Excel Model Template

  This is an Excel Template of the Acquisition Schedule

  acquisitionacquisition schedulecapital acquisition

  423Discussadd_shopping_cart

  free

  by Wall Street Oasis
• 

  Financial model Free Excel Template to fight COVID-19

  Free Financial Model Excel Template to run sensitivity analysis against COVID-19

  sensitivity analysisfinancial modelexcel templatecovid-19excel financial templates

  632Discussadd_shopping_cart

  free

  by Henry Sheykin

+ More Best Practices

Discuss with Hanz Hargianto

Ask Hanz Hargianto questions about their Best Practices. Go ahead!

Post Comment