Financial Modeling II
Financial Modeling on Credit Risk VaR
Financial Model by Ho-Lee Stochastic Model
Result on Rating with VaR
Chart
Financial Modeling
FINANCIAL MODELING
Balance Sheet Review
Complete Cash Flow
Property NPV
ACID Ratio Test
Financial Stress Index
Return on Asset
(RMA) – Business vs. Industry
Structures for Banks
Capacity of Borrower
Capital of Borrowers
Condition of the Borrower
Character of the Borrower
Collateral of the Borrower
Rating of the Loan
Executive Summary of the Loan
Financing Structure
Static Stress Test of the Loan
Dynamic Stress Test of the Loan
LTV Financial Chart
Total Property NPV
Mortgage Component PV
Equity of PV
DSCR Chart
Property Present Value
Present Value Income Factor
DSCR with Cash Flow
Balance Sheet Chart
Income Statement
