Open navigation menu
Close suggestions
Search
Search
en
Change Language
Upload
Loading...
User Settings
close menu
Welcome to Scribd!
Upload
Read for free
FAQ and support
Language (EN)
Sign in
0 ratings
0% found this document useful (0 votes)
6 views
Loan Analysis
Uploaded by
nghthienbao0701
Copyright:
© All Rights Reserved
Available Formats
Download
as XLSX, PDF, TXT or read online from Scribd
Download
Save
Save Loan Analysis For Later
0%
0% found this document useful, undefined
0%
, undefined
Embed
Share
Print
Report
Loan Analysis
Uploaded by
nghthienbao0701
0 ratings
0% found this document useful (0 votes)
6 views
7 pages
Document Information
click to expand document information
Copyright
© © All Rights Reserved
Available Formats
XLSX, PDF, TXT or read online from Scribd
Share this document
Share or Embed Document
Sharing Options
Share on Facebook, opens a new window
Facebook
Share on Twitter, opens a new window
Twitter
Share on LinkedIn, opens a new window
LinkedIn
Share with Email, opens mail client
Email
Copy link
Copy link
Did you find this document useful?
0%
0% found this document useful, Mark this document as useful
0%
0% found this document not useful, Mark this document as not useful
Is this content inappropriate?
Report
Copyright:
© All Rights Reserved
Available Formats
Download
as XLSX, PDF, TXT or read online from Scribd
Download now
Download as xlsx, pdf, or txt
Save
Save Loan Analysis For Later
0 ratings
0% found this document useful (0 votes)
6 views
7 pages
Loan Analysis
Uploaded by
nghthienbao0701
Copyright:
© All Rights Reserved
Available Formats
Download
as XLSX, PDF, TXT or read online from Scribd
Save
Save Loan Analysis For Later
0%
0% found this document useful, undefined
0%
, undefined
Embed
Share
Print
Report
Download now
Download as xlsx, pdf, or txt
Jump to Page
You are on page 1
of 7
Search inside document
Interest per month 0.
004166666666667 Loan 36000
Monthly payment 1078.952
Time (months) Balance (beginning) Interest Balance (end)
0 36000.00 150.00 35071.05
1 35071.05 146.13 34138.22
2 34138.22 142.24 33201.52
3 33201.52 138.34 32260.90
4 32260.90 134.42 31316.37
5 31316.37 130.48 30367.90
6 30367.90 126.53 29415.48
7 29415.48 122.56 28459.10
8 28459.10 118.58 27498.72
9 27498.72 114.58 26534.35
10 26534.35 110.56 25565.96
11 25565.96 106.52 24593.53
12 24593.53 102.47 23617.05
13 23617.05 98.40 22636.50
14 22636.50 94.32 21651.87
15 21651.87 90.22 20663.13
16 20663.13 86.10 19670.28
17 19670.28 81.96 18673.28
18 18673.28 77.81 17672.14
19 17672.14 73.63 16666.82
20 16666.82 69.45 15657.31
21 15657.31 65.24 14643.60
22 14643.60 61.01 13625.66
23 13625.66 56.77 12603.48
24 12603.48 52.51 11577.04
25 11577.04 48.24 10546.33
26 10546.33 43.94 9511.32
27 9511.32 39.63 8472.00
28 8472.00 35.30 7428.35
29 7428.35 30.95 6380.34
30 6380.34 26.58 5327.98
31 5327.98 22.20 4271.22
32 4271.22 17.80 3210.07
33 3210.07 13.38 2144.49
34 2144.49 8.94 1074.48
35 1074.48 4.48 0.00
Duration 36
Loan amount 18000
Interest rate 0.004166666667
Monthly payment 539.4761873601
Time Balance (beginning) Interest incurred Balance (end)
0 $18,000.00 $75.00 $18,075.00
1 $17,535.52 $73.06 $17,608.59
2 $17,069.11 $71.12 $17,140.23
3 $16,600.76 $69.17 $16,669.93
4 $16,130.45 $67.21 $16,197.66
5 $15,658.19 $65.24 $15,723.43
6 $15,183.95 $63.27 $15,247.22
7 $14,707.74 $61.28 $14,769.02
8 $14,229.55 $59.29 $14,288.84
9 $13,749.36 $57.29 $13,806.65
10 $13,267.17 $55.28 $13,322.45
11 $12,782.98 $53.26 $12,836.24
12 $12,296.76 $51.24 $12,348.00
13 $11,808.52 $49.20 $11,857.73
14 $11,318.25 $47.16 $11,365.41
15 $10,825.93 $45.11 $10,871.04
16 $10,331.57 $43.05 $10,374.61
17 $9,835.14 $40.98 $9,876.12
18 $9,336.64 $38.90 $9,375.54
19 $8,836.07 $36.82 $8,872.88
20 $8,333.41 $34.72 $8,368.13
21 $7,828.65 $32.62 $7,861.27
22 $7,321.80 $30.51 $7,352.31
23 $6,812.83 $28.39 $6,841.22
24 $6,301.74 $26.26 $6,328.00
25 $5,788.52 $24.12 $5,812.64
26 $5,273.16 $21.97 $5,295.13
27 $4,755.66 $19.82 $4,775.47
28 $4,236.00 $17.65 $4,253.65
29 $3,714.17 $15.48 $3,729.65
30 $3,190.17 $13.29 $3,203.46
31 $2,663.99 $11.10 $2,675.09
32 $2,135.61 $8.90 $2,144.51
33 $1,605.03 $6.69 $1,611.72
34 $1,072.24 $4.47 $1,076.71
35 $537.24 $2.24 $539.47
36 $0.00 $0.00 $0.00
Loan amount 18000 Monthly payment 539.47618736
Duration 36
Interest per month 0.00416666667
Time (months) Balance (beginning) Interest incurred Balance (end)
0 $18,000.00 $75.00 $18,075.00
1 $17,535.52 $73.06 $17,608.59
2 $17,069.11 $71.12 $17,140.23
3 $16,600.76 $69.17 $16,669.93
4 $16,130.45 $67.21 $16,197.66
5 $15,658.19 $65.24 $15,723.43
6 $15,183.95 $63.27 $15,247.22
7 $14,707.74 $61.28 $14,769.02
8 $14,229.55 $59.29 $14,288.84
9 $13,749.36 $57.29 $13,806.65
10 $13,267.17 $55.28 $13,322.45
11 $12,782.98 $53.26 $12,836.24
12 $12,296.76 $51.24 $12,348.00
13 $11,808.52 $49.20 $11,857.73
14 $11,318.25 $47.16 $11,365.41
15 $10,825.93 $45.11 $10,871.04
16 $10,331.57 $43.05 $10,374.61
17 $9,835.14 $40.98 $9,876.12
18 $9,336.64 $38.90 $9,375.54
19 $8,836.07 $36.82 $8,872.88
20 $8,333.41 $34.72 $8,368.13
21 $7,828.65 $32.62 $7,861.27
22 $7,321.80 $30.51 $7,352.31
23 $6,812.83 $28.39 $6,841.22
24 $6,301.74 $26.26 $6,328.00
25 $5,788.52 $24.12 $5,812.64
26 $5,273.16 $21.97 $5,295.13
27 $4,755.66 $19.82 $4,775.47
28 $4,236.00 $17.65 $4,253.65
29 $3,714.17 $15.48 $3,729.65
30 $3,190.17 $13.29 $3,203.46
31 $2,663.99 $11.10 $2,675.09
32 $2,135.61 $8.90 $2,144.51
33 $1,605.03 $6.69 $1,611.72
34 $1,072.24 $4.47 $1,076.71
35 $537.24 $2.24 $539.47
36 $0.00 $0.00 $0.00
You might also like
Module 1 Special Topics in Financial Management
Document
22 pages
Module 1 Special Topics in Financial Management
kimjoshuadiaz12
100% (3)
Your Results For - Multiple Choice Questions
Document
5 pages
Your Results For - Multiple Choice Questions
Priyadarshini Mahakud
No ratings yet
Pursuing A High Risk Business Model, The Case of Lehman Brothers
Document
19 pages
Pursuing A High Risk Business Model, The Case of Lehman Brothers
ade
No ratings yet
Math, Grade 6
From Everand
Math, Grade 6
Carson Dellosa Education
Rating: 5 out of 5 stars
5/5 (4)
Hamza Report 1
Document
123 pages
Hamza Report 1
Wajeeh Mughal
No ratings yet
Fstep Manual Investment Banking Final
Document
208 pages
Fstep Manual Investment Banking Final
Thiện Phong
100% (3)
Valor Financiado R$ 29,700.00 Numero de Parcelas 36 Valor Da Parcela R$ 1,058.66 Juros Mensal 1.4154%
Document
2 pages
Valor Financiado R$ 29,700.00 Numero de Parcelas 36 Valor Da Parcela R$ 1,058.66 Juros Mensal 1.4154%
Maurício Amaro
No ratings yet
1 Trades
Document
6 pages
1 Trades
Huub S
No ratings yet
Tabla de Amortizacion Av Villas
Document
3 pages
Tabla de Amortizacion Av Villas
Maribeth Caro Meza
No ratings yet
Plazo (Mesesaldo Insoluto Pago Mensual Totalcapital Intereses Iva
Document
2 pages
Plazo (Mesesaldo Insoluto Pago Mensual Totalcapital Intereses Iva
onami
No ratings yet
Gerenciamento Juros Compostos
Document
4 pages
Gerenciamento Juros Compostos
VENHAN PARA O MUNDO PES.
No ratings yet
Real Estate Ammortization Problem
Document
70 pages
Real Estate Ammortization Problem
Charles Brusco
No ratings yet
Alton 4 Minimum - 4
Document
3 pages
Alton 4 Minimum - 4
api-427878403
No ratings yet
Gerenciamento Juros Compostos
Document
4 pages
Gerenciamento Juros Compostos
rafael rachadel
No ratings yet
Solution Slides
Document
8 pages
Solution Slides
shubham solanki
No ratings yet
Bybot Projeto Primeiro Milhã - o
Document
5 pages
Bybot Projeto Primeiro Milhã - o
Animes Com
No ratings yet
Credit
Document
3 pages
Credit
bgagaming2020
No ratings yet
AVIONES JAVIER 2.0 Axel
Document
3 pages
AVIONES JAVIER 2.0 Axel
faxel1266
No ratings yet
Gerenciamento Blaze 2.0
Document
16 pages
Gerenciamento Blaze 2.0
LEOzinho
No ratings yet
Jadual Perancangan 300 Hari Forex
Document
7 pages
Jadual Perancangan 300 Hari Forex
Encik Leng
100% (2)
School Loan Amortization
Document
3 pages
School Loan Amortization
Lea Smith
No ratings yet
Financiera GLOX Pagos Fijos
Document
4 pages
Financiera GLOX Pagos Fijos
LETICIA CRUZ GOMEZ
No ratings yet
Actividad 5. Mate
Document
9 pages
Actividad 5. Mate
Yahi Videz
No ratings yet
Copia de METODO-FRANCES-Y-ALEMAN-1
Document
5 pages
Copia de METODO-FRANCES-Y-ALEMAN-1
Nicholle Velastegui
No ratings yet
Tabela Price
Document
4 pages
Tabela Price
Charles Walls
No ratings yet
Tabla de Amortizacion2
Document
5 pages
Tabla de Amortizacion2
Maciel Dorville
No ratings yet
Tabla de Amortizacion2
Document
5 pages
Tabla de Amortizacion2
Heyssy Pacheco
No ratings yet
Tabla Amortizacion 22 Enero 2020
Document
2 pages
Tabla Amortizacion 22 Enero 2020
Only Japan
No ratings yet
Interes Compuesto
Document
28 pages
Interes Compuesto
Alexito Chuctaya
No ratings yet
Interes Compuesto
Document
42 pages
Interes Compuesto
AESS14
No ratings yet
Plazo (Mesesaldo Insoluto Pago Mensual Total Capital
Document
2 pages
Plazo (Mesesaldo Insoluto Pago Mensual Total Capital
Cristhian Navarro
No ratings yet
1 Trades v6
Document
6 pages
1 Trades v6
Huub S
No ratings yet
AmortizacionPDF
Document
2 pages
AmortizacionPDF
cristina ruales
No ratings yet
Symphonie System Weekly Growth Plan - 5%
Document
6 pages
Symphonie System Weekly Growth Plan - 5%
william
No ratings yet
Plazo (Meses, Semanas, Saldo Insoluto
Document
12 pages
Plazo (Meses, Semanas, Saldo Insoluto
Martín Forez
No ratings yet
Project 2
Document
5 pages
Project 2
ishrutikumari30
No ratings yet
Transaction Number Quantity Unit Price Total
Document
4 pages
Transaction Number Quantity Unit Price Total
dffdf fdfg
No ratings yet
Money Management
Document
10 pages
Money Management
ezio prakash
No ratings yet
Quiz 1 Solution
Document
283 pages
Quiz 1 Solution
Shahrukh
No ratings yet
Amortization
Document
12 pages
Amortization
Minza Jahangir
No ratings yet
TareaS7 MarvinZ (Escenarios)
Document
17 pages
TareaS7 MarvinZ (Escenarios)
Marvin Yovany Zelaya
No ratings yet
Gmaf U3 A2
Document
6 pages
Gmaf U3 A2
dulce nallely
No ratings yet
Tabla Francesa
Document
5 pages
Tabla Francesa
anggychochochoa
No ratings yet
Periodo Capital Insoluto Interes Cuota Capital Pagado Saldo Deuda
Document
9 pages
Periodo Capital Insoluto Interes Cuota Capital Pagado Saldo Deuda
Danny Salto
No ratings yet
Repayment Schedule Puternic
Document
60 pages
Repayment Schedule Puternic
andreicibo
No ratings yet
6 Risk of Ruin
Document
6 pages
6 Risk of Ruin
Cr Ht
No ratings yet
Exercise 2 - Data Visualization
Document
25 pages
Exercise 2 - Data Visualization
SK ATIAR RAHAMAN
No ratings yet
Small Bush Produccion Por Hora Produccion Neta
Document
5 pages
Small Bush Produccion Por Hora Produccion Neta
carlos airdrop
No ratings yet
Anualidades Ordinarias Monto
Document
19 pages
Anualidades Ordinarias Monto
Marian Garcia
No ratings yet
Tabla de Amortizacion
Document
2 pages
Tabla de Amortizacion
Carlos Colmenares
No ratings yet
Simulador Creditos Bancario
Document
2 pages
Simulador Creditos Bancario
Jhon Fredy Lugo
No ratings yet
Tablas de Amortización de Deudas Con Excel
Document
5 pages
Tablas de Amortización de Deudas Con Excel
JORGE
No ratings yet
Money Management Excel3000
Document
71 pages
Money Management Excel3000
5245triangles
No ratings yet
Practica Funcion Pago, Pagoint
Document
5 pages
Practica Funcion Pago, Pagoint
Esverlin Borges
No ratings yet
Doc. Gabriel U
Document
3 pages
Doc. Gabriel U
Kenia Michel Posadas Valerio
No ratings yet
EA Risk Calculation
Document
10 pages
EA Risk Calculation
Bang Amat
No ratings yet
Symphonie System Weekly Growth Plan - 5%
Document
6 pages
Symphonie System Weekly Growth Plan - 5%
ioana cuciureanu
No ratings yet
Tablas Amortización Cat 49%-1
Document
8 pages
Tablas Amortización Cat 49%-1
adan daniel rodriguez silva
No ratings yet
Cume - Dist For Highest Average Salaries
Document
72 pages
Cume - Dist For Highest Average Salaries
RJ A
No ratings yet
Crystall Ball
Document
15 pages
Crystall Ball
BISHAL Adhikari
No ratings yet
72 Monthloanchase
Document
4 pages
72 Monthloanchase
api-351687679
No ratings yet
Quiz Ni Merry
Document
3 pages
Quiz Ni Merry
Romulo Marquez
No ratings yet
Hari Modal Profit Saldo Saldo Hari Modal KE $ 20% $ Rp. KE $
Document
6 pages
Hari Modal Profit Saldo Saldo Hari Modal KE $ 20% $ Rp. KE $
Kotaro Minami
No ratings yet
Tabla - Amortización - Sistema - Francés y Alemán
Document
8 pages
Tabla - Amortización - Sistema - Francés y Alemán
Lizbeth Lara
No ratings yet
72 Monthloanboa
Document
4 pages
72 Monthloanboa
api-351687679
No ratings yet
Goods and Services Tax - HSN Codes-08!08!2023
Document
27 pages
Goods and Services Tax - HSN Codes-08!08!2023
ca.nikhilkamble
No ratings yet
6 Faysal Bank
Document
58 pages
6 Faysal Bank
Usman Saleem
No ratings yet
Initiating Coverage Report - YES Bank
Document
35 pages
Initiating Coverage Report - YES Bank
arnabmoitra11
No ratings yet
Social Studies Project
Document
5 pages
Social Studies Project
Marshellee
No ratings yet
Barclays Bank PLC Annual Report 2008
Document
159 pages
Barclays Bank PLC Annual Report 2008
Kay Chen
No ratings yet
Banking
Document
74 pages
Banking
Abhishek Dubey
No ratings yet
0 - Loan Estimate
Document
3 pages
0 - Loan Estimate
Sophia Alvarad
No ratings yet
Scale and Scope at Citigroup: Firms and Markets Mini-Case
Document
9 pages
Scale and Scope at Citigroup: Firms and Markets Mini-Case
Ahmed Mohye
No ratings yet
20230524-2421 建準-dw
Document
8 pages
20230524-2421 建準-dw
風雲造天
No ratings yet
Financial Services Notes
Document
13 pages
Financial Services Notes
Punam Pandey
No ratings yet
Nmims Interview
Document
8 pages
Nmims Interview
thea skywalker
No ratings yet
Default Servicing - E2 - Foreclosure
Document
33 pages
Default Servicing - E2 - Foreclosure
dmrajput611
No ratings yet
FIM CH 03 Non-Depository Financial Institutions
Document
30 pages
FIM CH 03 Non-Depository Financial Institutions
Marina Khan
No ratings yet
Private Equity, LBO & Hedge Funds (Bocconi University)
Document
14 pages
Private Equity, LBO & Hedge Funds (Bocconi University)
ah02618
No ratings yet
Motilal Oswal Diwali Picks 2021
Document
8 pages
Motilal Oswal Diwali Picks 2021
Aditya Mehta
No ratings yet
What Is A Bank?: Roles of The Financial System
Document
8 pages
What Is A Bank?: Roles of The Financial System
Marwa Hassan
No ratings yet
Viceroy - Adler 2
Document
40 pages
Viceroy - Adler 2
caydleong
No ratings yet
All You Need To Know About Private Lending
Document
7 pages
All You Need To Know About Private Lending
Julio Cardenas
No ratings yet
CH 6
Document
24 pages
CH 6
Joko Anila
No ratings yet
Hindalco Industries: India
Document
8 pages
Hindalco Industries: India
Ashok
No ratings yet
DisruptionsandDigitalBankingTrends Wewegeetal200718
Document
43 pages
DisruptionsandDigitalBankingTrends Wewegeetal200718
Khushi Bharti
No ratings yet
Aishwaryaravindranresume09 04 2015
Document
1 page
Aishwaryaravindranresume09 04 2015
api-300740104
No ratings yet
List of Investment Banks: From Wikipedia, The Free Encyclopedia
Document
10 pages
List of Investment Banks: From Wikipedia, The Free Encyclopedia
ankitmishraishan
No ratings yet
Craig Hallum Research Report
Document
5 pages
Craig Hallum Research Report
grkyiasou33
No ratings yet
Rights and Liabilities of Mortgagee
Document
5 pages
Rights and Liabilities of Mortgagee
pranjalkaushik
No ratings yet