100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Previously searched by you
Previously searched by you
logo
  • Universiteit Van Amsterdam (UvA)
  • Corporate finance (6612ZB019Y)
To add items to your wishlist, you must be logged in
Other

Bank Loan practise in Excel

Rating
-
Sold
-
Pages
2
Uploaded on
23-02-2023
Written in
2022/2023

The case of a certain bank loan amount versus the mortgage that has to be paid. Can also be done the different way around.

Institution
Universiteit Van Amsterdam (UvA)
Course
Corporate finance (6612ZB019Y)








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

Written for

Institution
Universiteit van Amsterdam (UvA)
Study
Management studies
Course
Corporate finance (6612ZB019Y)
All documents for this subject (2)

Document information

Uploaded on
February 23, 2023
Number of pages
2
Written in
2022/2023
Type
Other
Person
Unknown

Subjects

  • finance
  • loan
  • loans
  • bankloan
  • npv
  • corporate finance
  • uva

Content preview

Year Total Loan start of the year Total payment Repayment Interest End of the year loan balance
1 € 174,687.02 € 15,517.00 € 1,542.04 € 13,974.96 € 173,144.99
2 € 173,144.99 € 15,517.00 € 1,665.40 € 13,851.60 € 171,479.58
3 € 171,479.58 € 15,517.00 € 1,798.63 € 13,718.37 € 169,680.95
4 € 169,680.95 € 15,517.00 € 1,942.52 € 13,574.48 € 167,738.43
5 € 167,738.43 € 15,517.00 € 2,097.93 € 13,419.07 € 165,640.50
6 € 165,640.50 € 15,517.00 € 2,265.76 € 13,251.24 € 163,374.74
7 € 163,374.74 € 15,517.00 € 2,447.02 € 13,069.98 € 160,927.72
8 € 160,927.72 € 15,517.00 € 2,642.78 € 12,874.22 € 158,284.94
9 € 158,284.94 € 15,517.00 € 2,854.20 € 12,662.80 € 155,430.73
10 € 155,430.73 € 15,517.00 € 3,082.54 € 12,434.46 € 152,348.19
11 € 152,348.19 € 15,517.00 € 3,329.14 € 12,187.86 € 149,019.05
12 € 149,019.05 € 15,517.00 € 3,595.48 € 11,921.52 € 145,423.57
13 € 145,423.57 € 15,517.00 € 3,883.11 € 11,633.89 € 141,540.46
14 € 141,540.46 € 15,517.00 € 4,193.76 € 11,323.24 € 137,346.70
15 € 137,346.70 € 15,517.00 € 4,529.26 € 10,987.74 € 132,817.43
16 € 132,817.43 € 15,517.00 € 4,891.61 € 10,625.39 € 127,925.83
17 € 127,925.83 € 15,517.00 € 5,282.93 € 10,234.07 € 122,642.89
18 € 122,642.89 € 15,517.00 € 5,705.57 € 9,811.43 € 116,937.32
19 € 116,937.32 € 15,517.00 € 6,162.01 € 9,354.99 € 110,775.31
20 € 110,775.31 € 15,517.00 € 6,654.98 € 8,862.02 € 104,120.33
21 € 104,120.33 € 15,517.00 € 7,187.37 € 8,329.63 € 96,932.96
22 € 96,932.96 € 15,517.00 € 7,762.36 € 7,754.64 € 89,170.60
23 € 89,170.60 € 15,517.00 € 8,383.35 € 7,133.65 € 80,787.24
24 € 80,787.24 € 15,517.00 € 9,054.02 € 6,462.98 € 71,733.22
25 € 71,733.22 € 15,517.00 € 9,778.34 € 5,738.66 € 61,954.88
26 € 61,954.88 € 15,517.00 € 10,560.61 € 4,956.39 € 51,394.27
27 € 51,394.27 € 15,517.00 € 11,405.46 € 4,111.54 € 39,988.81
28 € 39,988.81 € 15,517.00 € 12,317.89 € 3,199.11 € 27,670.92
29 € 27,670.92 € 15,517.00 € 13,303.33 € 2,213.67 € 14,367.59
30 € 14,367.59 € 15,517.00 € 14,367.59 € 1,149.41 € 0.00

More courses for Universiteit van Amsterdam (UvA) > Management studies

  • Theories of leadership and management
  • Management research 2
  • Managing people strategically
  • Psychology and behaviour
  • Business research
  • Manamgement research 1
  • Strategy and organisation
  • The adaptive organisation
  • Theories of strategy
R60,71
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
basschaap
1,0
(1)

Get to know the seller

Seller avatar
basschaap Universiteit van Amsterdam
View profile
Follow You need to be logged in order to follow users or courses
Sold
5
Member since
2 year
Number of followers
3
Documents
12
Last sold
10 months ago

1,0

1 reviews

5
0
4
0
3
0
2
0
1
1

Recently viewed by you

Thumbnail
Summary
module 2: anatomie - ademhalingsstelsel
-
2023
R 101,31 More info
Thumbnail
Exam (elaborations)
Test Bank for Introduction to Critical Care Nursing, 8th Edition – Sole, Klein, Moseley – Complete Chapter-by-Chapter Multiple Choice Questions with Answers and Rationales
-
1 2025
€ 22,10 More info
Thumbnail
Summary
Stress & Coping
-
2025
R 212,98 More info
Thumbnail
Package deal
ALL articles and lectures Digital Marketing and Technology
-
15 2022
$ 17.37 More info
Thumbnail
Exam (elaborations)
AHIP 2025 Mod I| ALL QUESTIONS & CORRECT VERIFIED ANSWERS | LATES UPDATE 2025
-
2025
$ 14.49 More info
Thumbnail
Exam (elaborations)
LOWA CORE EXAM REVIEW PESTICIDE APPLICATORS EXAM LATEST 2024/2025 QUESTIONS AND CORRECT ANSWERS(100% CORRECT VERIFIED ANSWERS)ALREADY GRADED A+
-
2024
$ 22.99 More info
Thumbnail
Exam (elaborations)
Testing and Remediation Advanced Test | Question with 100% correct Answer | Verified
-
2023
€ 5,39 More info
Thumbnail
Package deal
CSET Multiple Subjects Subtest II Mathematics & Science (Latest 2025 / 2026 Updates STUDY BUNDLE PACKAGE WITH SOLUTIONS) Questions & Answers | Grade A | 100% Correct (Verified Answers)
-
2025
£ 20.06 More info

Why students choose Stuvia

Created by fellow students, verified by reviews

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

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT 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