Usi good spreadsheet modelling practice to build three types of spreadsheet model

The guiding principles of spreadsheet model building

The work involved in getting ready to build a spreadsheet model, including identifying stakeholders and defining the problem that the model will address

How to develop models for pricing decisions including identifying the profit-maximising price for a business

How to build a cashflow model to support a wide variety of business situations

How to extend the cashflow model to include an Income Statement and Balance Sheet

The project lifecycle

How to select an appropriate discount rate for use in Net Present Value analysis

How to compare projects using Net Present Value

How to apply the Discounted Cashflow Valuation Model to business projects

How to compare investment opportunities

There are no pre-course requirements

This course is a companion to my course Building a Spreadsheet Forecasting Model which covers the structure for building a spreadsheet forecasting or planning model. You do not need to have completed that course to undertake this course. The focus of this course - Spreadsheet Models: Cashflow, Net Present Value and Pricing - is practical examples of some of the most important spreadsheet models.

There are many types of financial model that can be built using Microsoft Excel. These include:

· A Project Finance Model. Large projects will use a financial model as a basis for budgeting and to forecast outcomes, including cashflows to match debt repayment.

· A Pricing Model. The price charged for products or services is part of the "marketing mix" for the operation. Pricing has a significant impact on demand and, therefore, profitability.

· A Cashflow Model and Integrated Financial Statements. A financial model can be built to integrate the cashflow, profit and loss and balance sheet statements. These models can easily become very complex, and the challenge is to keep to the principle of keeping it simple and flexible.

· A Valuation Model. A valuation model will be built to assess the value of a business or business unit, or potential new business opportunity. In the case of a business acquisition, the seller will present a model that maximises the value of the business; and the potential buyer will critically analyse that model to detee its feasibility and to establish their own valuation. The model may also be required to illustrate how debt raised for the purchase will be serviced.

Spreadsheet Models: Cashflow, Net Present Value and Pricing will provide learners with the skills they need to develop a flexible spreadsheet models for all of these scenarios.

This course assumes a good basic knowledge of Microsoft Excel, but advanced knowledge is not necessary and, as with the previous course, Macros and visual basic are avoided.

Finance staff

Managers

Students of business finance and management




DOWNLOAD
uploadgig.com


rapidgator.net


nitro.download