100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten 4,6 TrustPilot
logo-home
Samenvatting

Summary Excel template (exam)

Beoordeling
-
Verkocht
-
Pagina's
70
Geüpload op
30-10-2024
Geschreven in
2024/2025

Excel template to prepare for Finance and Accounting 4 (Fundamentals of corporate finance) exam. It includes all types of exercises needed to prepare or use during the exam.












Oeps! We kunnen je document nu niet laden. Probeer het nog eens of neem contact op met support.

Documentinformatie

Heel boek samengevat?
Nee
Wat is er van het boek samengevat?
Chapters 6,7,,8,11,12,16,18,22, all chapters needed to pass finance 4 from han
Geüpload op
30 oktober 2024
Aantal pagina's
70
Geschreven in
2024/2025
Type
Samenvatting

Voorbeeld van de inhoud

Final Exam of DAF1-ACF4

CH.6. Q.1: Bond Valuation 15p

settlement date 1/1/2010
maturity date 1/1/2040
coupon rate 2%
YTM 2.20%
FV (%) 100 £ 100,000 excel does not allow 1000… Always
semi-annual 2

Price (%) 95.6247
Price $ £ 95,624.70 (Price%/FV%)* FV $



CH.7 Question 2: Equity Valuation 15p

XYZ plc is expected to pay the following dividends

T0 T1 T2 T3
Dividends 24 € 20 € 18 €



constant growth rate 5%
RRR 8%
current share price? P0?

P5 = D5(1+g)/(r-g)
p0 = D/(1+DR)+D/((1+DR)^2)+D/((1+DR)^3)+D/((1+DR)^4)+D/((1+DR)^5)+P5/((1+DR)^5)

p5 350.00 €
p0 308.96 €



CH.11&12 Question 3: Return & Risk 20p

Rate of returns if state occurs
Scenario prob. Equity A Equity B
Boom 0.25 0.35 0.45
Good 0.35 0.15 0.12
Poor 0.4 0.05 -0.15

, Weights 0.25 0.55

A. Portfolio return (PR) 11.65%
portfolio variance 0.018 sumproduct(prob;(PR-PERs)^2)
portfolio SD 13.54% sqrt Pvariance
B.
expected T-bill rate 1.65%
portfolio's expected risk Premium?* 10.00% PR - T-bill rate
*excess return as compensation
for taking extra risk



CH.16 Question 4: Stock Dividends 15 p

stock dividend 10% (1+0.10)
sahre € 35.00
par value € 1.00

Equity accounts (now)
Ordinary shares (1 eur par value) € 1,000,000.00
Capital Surplus € 1,500,000.00
Retained earnings € 5,500,000.00
Total Owner's Equity € 8,000,000.00

Initial share outstanding 1,000,000.00
What effects on the equity accounts
will the distribution of the stock dividend have?

new shares outstanding 1,100,000
ordinary shares € 1,100,000.00 (*1 euro pra value)
new shares issued 100,000
capital surplus for new shares € 3,400,000.00
Capital surplus € 4,900,000.00 after issuing new shares you get…
Total market value of new shares 3500000
RE € 2,000,000.00

The new equity portion of the balance sheet will look like this:
Ordinary shares (1 eur par value) € 1,100,000.00
Capital Surplus € 4,900,000.00
Retained earnings € 2,000,000.00
Total Owner's Equity € 8,000,000.00



CH.18 Question 5: Exchange Market 15p

, Spot rate Kr/€ 10.65
macroeconomic data :
Eurozone Norway
Interest rate (per annum) 2% 4%
Inflation rate (per annum) 1.50% 2%

A. What is the exact real rate of return in Norway and eurozone?



(1+n) = (1+r) × (1+inf) is the same formula as Fisher Effect.
r = ((1+n)/(1+inf))-1 real interest rate rrr:
rrr eurozone 0.49%
rrr Norway 1.96%

B. What is the expected one-year spot rate based on the Purchasing Power Parity (PPP)?
St+1 = St ((1+infnr)/(1+infeu))
Expected One-Year Spot Rate (Using PPP):

st + 1 = St * ((1+inf norw)/(1+inf eur)) 10.70246 Kr/€

C. What would you expect the one-year forward rate to be if no immediate arbitrage opportuniti
(use real interest rate calculated in part a)

Ft+1 = St ((1+rnr)/(1+reu))
One-Year Forward Rate (Using Interest Rate Parity): 10.8056



Question 6: Merger and Acquisition 20p



Consider the following pre-merger information about two Dutch firms:

Firm A Firm B
Total earnings (€) 1100 400
Shares outstanding 500 150
Price per share (€) 50 20

Assume that firm A acquires firm B via an exchange of equity

share price of B's equity € 23.00

a. What is the cost of the acquisition?
b. How many shares should firm A offer to buy firm B?
c. After the merger, what is the shares outstanding of firm A?

, d. What will the earnings per share (EPS) of firm A be after the merger?

e. What will the price–earnings (P/E) ratio of the
post-merger firm be if the market analyses the transaction correctly?
€7,96
Krijg toegang tot het volledige document:

100% tevredenheidsgarantie
Direct beschikbaar na je betaling
Lees online óf als PDF
Geen vaste maandelijkse kosten

Maak kennis met de verkoper
Seller avatar
carlalpez

Maak kennis met de verkoper

Seller avatar
carlalpez Hogeschool Arnhem en Nijmegen
Bekijk profiel
Volgen Je moet ingelogd zijn om studenten of vakken te kunnen volgen
Verkocht
0
Lid sinds
2 jaar
Aantal volgers
0
Documenten
2
Laatst verkocht
-
International Business student at HAN University of Applied Sciences

I study International Business, specialising in Finance. I am a highly dedicated student with a bachelor's degree in education. Please reach out for specific materials that are not uploaded, and I will sumbit them. Message me on LinkedIn for this and other requests.

0,0

0 beoordelingen

5
0
4
0
3
0
2
0
1
0

Recent door jou bekeken

Waarom studenten kiezen voor Stuvia

Gemaakt door medestudenten, geverifieerd door reviews

Kwaliteit die je kunt vertrouwen: geschreven door studenten die slaagden en beoordeeld door anderen die dit document gebruikten.

Niet tevreden? Kies een ander document

Geen zorgen! Je kunt voor hetzelfde geld direct een ander document kiezen dat beter past bij wat je zoekt.

Betaal zoals je wilt, start meteen met leren

Geen abonnement, geen verplichtingen. Betaal zoals je gewend bent via iDeal of creditcard en download je PDF-document meteen.

Student with book image

“Gekocht, gedownload en geslaagd. Zo makkelijk kan het dus zijn.”

Alisha Student

Veelgestelde vragen