Rygnestad
UK

Spreadsheet
Models

Spreadsheet Models

I design spreadsheet models for clients to assist them in their financial decision-making processes. As required, I work with clients' engineering, technical, finance, accounting, and marketing departments to design models that reflect their businesses accurately.

Example 1:

While the model described below was designed for an energy company, most features are applicable to all my clients' model requirements.

Hover your mouse pointer over listed items to see further details

Model Assumptions	Model Output	Model Analysis
Revenue	Income Statement	Sensitivity Analysis
Expenses	Cash Flow Statement	Risk Analysis
Depreciation and Tax	Balance Sheet	Reconciliation
Financing	Indicators	Checks and Balances

Example 2:

A spreadsheet model of an underground mining project.

Hover your mouse pointer over listed items to see further details

Model Assumptions	Model Output	Model Analysis
Revenue	Operating Statement	Sensitivity Analysis
Expenses	Cash Flow Statement	Risk Analysis
Depreciation and Tax	Balance Sheet	Reconciliation
Financing	Indicators	Checks and Balances

Example 3:

I added features to the existing model designed by an investment bank for an open pit mining project with multiple metals.

Hover your mouse pointer over listed items to see further details

Additional Features Added

Ability to run different cases with the same model

Calculation of life of mine totals and averages

Calculation of annual and cumulative cash flows

An Excel Solver-based tool to calculate break-even prices

Reconciliation back to original Feasibility Study results

Client Login (password required):

	Growth Analyses:
	Jobs Growth Analysis Tools
	Jobs Global Database
	MTI Growth Analysis Tools

	Investments:
	Vida Tools
	CGC Tools
	CGC VC Model
	CGC FN Model
	CGC NB Model

	Economic and Financial Analyses:
	Burundi PRASAB - EFA model
	Ethiopia SLMP2 - EFA model
	Ethiopia RLLP - EFA model
	Ethiopia CALM - EFA model
	Ethiopia OFLP-ERP - EFA model
	Malawi ACP - EFA model
	Malawi ASWAp - EFA model
	Mozambique FIP - EFA model
	Mozambique SREP - EFA model
	Myanmar FREDIP - EFA model
	Rwanda Ag PforR - EFA model
	Rwanda VCRP - EFA model
	South Sudan EFCRP - EFA model
	Sudan SSNRMP2 - EFA model
	Tanzania ASDP2 - EFA model
	Uganda ATAAS - EFA model
	Uganda FRL - EFA model
	Zambia IDSP - EFA model
	Zambia TRALARD - EFA model

	Other Models:
	Model for Cost Adjustment Factors

Internal   |  

Web design by Hild Rygnestad
Last updated October 2024
Copyright © Rygnestad UK - All Rights Reserved