Financial modelling Level One Flashcards

1
Q

Tell me about the main financial modelling software packages you are aware of.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a financial model?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the pros and cons of a particular piece of software you have used?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why may software be beneficial over Excel for modelling?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why is it important to clearly identify inputs/outputs/unit types?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Why is locking cells important?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is sensitivity analysis and why is it important?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What issues can arise with modelling spreadsheets/packages?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the limitations of modelling software/Excel?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How can you overcome these?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do you ensure that formulas and mechanics are working correctly?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How do you ensure that the figures are not a false pretence?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you check the reliability and accuracy of data?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Why are explicit valuation approaches popular?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Did the economic crisis impact the type of financial modelling carried out by investors and developers?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is discounting?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the time value of money and why is it important?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is compounding?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Tell me about an assumption you might make in a financial model.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Are you aware of any RICS guidance relating to financial modelling?

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What accounting concepts have you come across in relation to financial modelling?

A
22
Q

What is CAPEX?

A
23
Q

Tell me about the key elements of RICS DCF for Commercial Property Investments.

A
24
Q

How can a DCF be used to assess worth/investment value?

A
25
Q

Tell me about how you would arrive at a discount rate in a model.

A
26
Q

What factors affect the discount rate?

A
27
Q

How do you avoid double counting risk in both the cash flow and discount rate?

A
28
Q

What does the exit value reflect?

A
29
Q

How do you establish exit value?

A
30
Q

What information do you need to prepare a model/DCF?

A
31
Q

What tenure/physical attribute/lease/rental value/costs of ownership/holding costs/refurbishment/redevelopment/finance/gearing/taxation information would you need and why?

A
32
Q

How would you factor these into your model?

A
33
Q

When would you use current / forecast data?

A
34
Q

What are the issues around forecasted data?

A
35
Q

What period would you use for a cashflow?

A
36
Q

What is the impact of a shorter time horizon on value?

A
37
Q

Would you factor tax into a DCF?

A
38
Q

How would this differ from a Market Value assessment?

A
39
Q

How would you assess rental growth and reflect this in the DCF?

A
40
Q

What is IRR?

A
41
Q

How do you calculate IRR?

A
42
Q

What is TWRR?

A
43
Q

How do you reflect cash flow frequency in a model?

A
44
Q

What is a property risk premium?

A
45
Q

How do you assess the risk free rate?

A
46
Q

What are examples of market / specific risks?

A
47
Q

What are other ways of determining TRR?

A
48
Q

What is the CAPM?

A
49
Q

Tell me about your understanding of RICS Financial Viability in Planning and how this relates to your financial modelling work.

A
50
Q

What inputs would you include within this type of model?

A