Finance Assessment by Dealflow for Startups in EU

Question 1/18:
The value of a share of stock A and the value of a share of stock B each increase by 22%. If the value of a share of stock A increased by 22 cents and the value of a share of stock B increased by $1.21, what is the difference between the value of stock B and the value of stock A before the increases?

1.82
4.50
2.66
4.00
6.23

Question 2/18:
Investors invest 4m into a company through a capital increase at a pre-money valuation of 20m. What is the resulting ownership percentage of the investors?

1/8
1/4
1/5
1/7
1/6

Question 3/18:
If y is 25% larger than x what percent is x of y (nearest %)?

125%
133%
80%
120%
75%

Question 4/18:
Which of the following is the correct formula to calculate the weighted average score in cell C9 as shown below?

=SUMPRODUCT(B2:B5,C2:C5)
=AVERAGE(C2:C5)*B6
=SUMPRODUCT(B2:B5,C2:C5)/SUM(B2:B5)
=SUMPRODUCT(B2:B5,C2:C5)/C6
=SUMPRODUCT(B2:B6,C2:C6)/B6

Question 5/18:
Founders are raising a 2m round at an 8m pre money valuation. However, during the negotiations, the investors require the startup to create an ESOP (Employee Share Option Pool) before the series A round, which should result in 10% after the Series A. How large is the ESOP before the series A?

10%
8%
12.5%
14%
15%

Question 6/18:

A
B
C
D
E

Question 7/18:
What result do you get in the cell B9 (Total)?

1300
1800
1600
#VALUE!
1200

In which year was the average speed for a pushbike 30km per hour?

Year 1
Year 2
Year 3
Year 4
Year 5
Year 6

Question 9/18:
What was the percentage increase in the cost of exploration from Year 1 to Year 2? (to the nearest %)

42.31%
65.26%
71.85%
75.28%
76.47%
78.92%

Question 10/18:
If you want to find the average of the numbers in cells C5 to C70, and show output of this in cell A3. Which formula do you need to use?

Write in Cell A3, =SUM(C5:C70)/65
Write in Cell C5, A3=Average(C5:C70)
Write in Cell A3, =AVG(C5-C70)
Write in Cell A3, =AVERAGE(C5:C70)

Question 11/18:
If the Inflation Indices were rebased at 100 again at the 3rd Quarter, what would be the 4th Quarter inflation index for Foods?

(94/100)*100
(94/97.5)*100
(94/95)*100
(100/94)*100
Cannot Say

Question 12/18:
What comes next in the sequence?

A
B
C
D
E

Question 13/18:

60% decrease
30% decrease
No change
140% increase
280% increase

Question 14/18:
What percentage of the total Deutshel revenue was accounted for by their Premium market segment share?

25%
37.5%
43.75%
47.75%
50%

Question 15/18:
In 2018, what was the ratio of Asset Management revenue to International Insurance revenue?

5:15
1:2
2:3
3:2
2:1

Question 16/18:
What is the difference in the value of the revenues between Life and Savings and Property and Casualty in 2020?

12.5 billion
16.5 billion
17.5 billion
18.9 billion
22.5 billion

Question 17/18:
What is the right formula to retrieve the yellow marked cell (H4)?

=INDEX(D2:D17,MATCH(0,(H1=A2:A17)&(H2=B2:B17)&(H3=C2:C17),0))
=INDEX(D2:D17,MATCH(1,(H1=A2:A17)*(H2=B2:B17)*(H3=C2:C17),0))
=INDEX(D2:D17,MATCH(1,(H1=A2:A17)+(H2=B2:B17)+(H3=C2:C17),0))
=INDEX(A2:D17,MATCH(1,(H1=A2:A17)+(H2=B2:B17)+(H3=C2:C17),0))
=INDEX(D2:D17,MATCH(“Venture Capital”;”Mar”;”Equity”,(A2:C17),0))

Question 18/18:
The following figure shows the number of Housing starts per quarter.

Assuming housing starts declined at a constant rate, which of the following is the closest estimate
of the annual percentage drop in the number of housing starts between 3 years ago and
this year?

20%
25%
40%
55%

Online Assessment

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question