Financial Planning & Treasury Assistant Test

1.

What is the correct fraction for 28.8?

28 8/15

28 1/8

432/8

432/15

2.

If the cost of building each house is £100k in year 1 and £110k in year 2. Assume we have £15m to spend on development in year 1 and £15m to spend in year 2.

How many more houses can we build in year 1 compared to year 2?

10

14

Cannot say

3.

A function inside another function is called?

Round function

Text function

Nested function

Sum function

4.

If you borrowed £250,000 interest only loan at 5% interest rate for 10 years. What are your total interest payments over the next 5 years?

6,250

50,000

12,500

62,500

5.

Recent budget announcements have stated that social housing rent will decrease by 1% per year.

Based on this information, would you expect Turnover to increase?

Yes

No

6.

Which of the below show one hundred and ninety-five million?

195,000k

195m

195,000

1.95m

7.

What function would you use to add numbers based on a specific criteria?

SUM

SUMIF

COUNTIF

VLOOKUP

8.

Income (£k)
Cadbury 954
Winston 1,231
Georges 543

Costs (£k)
Cadbury 873
Winston 993
Georges 409

Select as many of the options below:

Winston has the highest profit

Winston has the highest profit margin

Cadbury has the lowest profit margin

Georges profit margin is approx. 25%

9.

If Midland Heart's Operating costs are £137,174,000 and their Operating Surplus £53,338,000. Is their Turnover £190,512?

True

False

10.

Formulas in excel start with?

11.

This year ending March 2016 we are expecting a rental income of £140m. Assume rent for all properties will decrease by 1% per year, what is the total rental income for the year ending March 2020?

Answer to the nearest whole million.

£139m

£138m

£137m

£136m

£135m

£134m

£133m

12.

What does it actually mean when someone says "There is a 30% chance of rain in Birmingham tomorrow"?

For every 10 days like today, it will rain on 3 of the following days

It will rain for 30 percent of the day, on average, over all of Birmingham

The volume of rain that will fall in Birmingham will be 30 percent of a full day's rain

It will rain on 30 percent of Birmingham at some point during the day

13.

7 - 1 x 0 + 3 x 3 = ?

14.

Last year, Midland Heart's Turnover was £179,439k. This year the turnover has increased to £190,512k.

What is the approximate percentage increase?

6.2%

7.2%

94.0%

5.8%