Excel File: Your own model
Your group has the choice between a full model and a basic model.
Full Model
The considered case is the same for all groups, described in the feasibility study on the Korle Bu diagnostic centre in Accra, Ghana. Imagine yourself preparing a model for a bank considering providing debt to the project. Your main output is the DSCR for each period, and the minimum DSCR over all periods. Your model will further need a balance sheet and a cash flow statement. It should be flexible regarding main inputs. For a top grade, it needs a scenario manager covering main risk factors.
A full model is to be constructed on the basis of the provided template model. The grading criteria is the model qualities of transparency, flexibility and reliability described during lectures. Following the detailed rules presented generally will be regarded as best practice.
The template used for the gas power plant example provides a rich and extremely useful infrastructure. During lectures you get acquainted to the sheets scenarios, timing, L, N, C, Comments. It is highly recommended to use all of this infrastructure as much and as strictly as possible. Nevertheless, You should not copy those elements from the templates, but rather code and format them yourself. Any deviance will be captured in the grading. If You use differently structured elements, it is absolute fine. They will be judged by the same standards.
All information sources should be exactly documented in the model.
You will not find all data necessary for your calculations in the feasibility study. When you find some data to be missing, you should first try to find out with the help of thefeasibility study or external sources. If you need to infer indirectly, e.g. performing backwards calculations from results presented there, report your approximation method and your results to me. If you deem it impossible to derive the missing information, ask me for a sensible assumption.
I will publish both mentioned kinds of results to all groups, but the first group asking will be credited with being frontrunner regarding the concerned question. The same applies even stronger, if you publish information from any external sources, which you are generally expected to do. For anycreativeinput or model feature, publishing it as the first group will improve your grading compared to only documenting it in the model. If you are not the first group to publish it, you will not be credited with the idea, but with any successful use of it.
Basic Model
A basic model derives the DSCR for the Korle Bu Diagnostic Centre during a typical period, much in the same way as we practiced it in the one-period "back of an envelope" calculation for the gas power plant example. It is not necessary to use the model template. The remaining framework of the full model delivery applies to the basic model delivery as well.