Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition

5

Example model

Introduction

Case study

Design

PPP 1

PPP 2

PPP 3

PPP 4

PPP 5

Documenting, testing and protecting

PPP 6

Summary

INTRODUCTION

This chapter builds on the design, features and methodology in previous chapters and demonstrates the development of a further model through six stages. The models are named MFM3_05_PPP_1 to PPP_6 and you can either follow the progress using the completed version for that stage or start with the first file and add the features yourself.

The case outlines some of the cash flows in an outsourcing model where government or business can contract with a third party to provide a service. In the UK, this is termed by government Public–Private Partnership (PPP) or Private Finance Initiative (PFI), where the ...