100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Summary

Summary FINN1011 Finance Calculator Toolkit - 7 Excel Calculators

Rating
-
Sold
-
Pages
7
Uploaded on
24-12-2025
Written in
2025/2026

Complete interactive Excel toolkit for Finance calculations. Contains 7 worksheets: (1) NPV & IRR Calculator with decision rule, (2) WACC Calculator with tax shield, (3) CAPM Calculator with SML analysis, (4) Bond Pricing Calculator with premium/discount indicator, (5) Portfolio Beta Calculator for up to 10 stocks, (6) Gordon Growth Model (DDM) stock valuation, (7) Time Value of Money (FV, PV, Annuity, Perpetuity). All formulas built-in - just enter your numbers and get instant results. Colour-coded inputs (blue) and results (green). Perfect for assignments, exam prep, and understanding financial calculations.

Show more Read less
Institution
Course









Whoops! We can’t load your doc right now. Try again or contact support.

Written for

Institution
Study
Unknown
Course

Document information

Uploaded on
December 24, 2025
Number of pages
7
Written in
2025/2026
Type
Summary

Subjects

Content preview

NPV & IRR CALCULATOR

INPUTS (Blue = Enter Your Values)

Initial Investment (£): 10000 RESULTS
Discount Rate (%): 10
Number of Years: 5 NPV (£): £7,277.07
IRR (%): 26.34%
CASH FLOWS
Year Cash Flow (£) Decision: ACCEPT ✓
0 -10000
1 3000 Payback Period: 3.33 years
2 3000
3 3000
4 3000
5 3000
6 3000
7 3000
8 3000
9 3000

, WACC CALCULATOR

INPUTS

Market Value of Equity (£m): 60
Market Value of Debt (£m): 40
Cost of Equity (%): 12
Pre-tax Cost of Debt (%): 6
Corporate Tax Rate (%): 25

CALCULATIONS

Total Value (V): 100
Equity Weight (E/V): 60.00%
Debt Weight (D/V): 40.00%
After-tax Cost of Debt: 4.50%

RESULT
WACC (%): 9.00%

Formula: WACC = (E/V)×Re + (D/V)×Rd×(1-Tc)
$7.58
Get access to the full document:

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Get to know the seller
Seller avatar
kababbbbb

Also available in package deal

Get to know the seller

Seller avatar
kababbbbb Durham University
Follow You need to be logged in order to follow users or courses
Sold
New on Stuvia
Member since
1 day
Number of followers
0
Documents
21
Last sold
-

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions