Financial Markets and Institutions, 6th Edition, by Jeff Madura
Structure of Interest Rates-Chapter 3
Forward Interest Rate Template
This program calculates forward rates based on a liquidity premium.
Enter all three variables in Column B, and only one va
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Money Markets-Chapter 6
Treasury Bill Yield Template
This program calculates annualized Treasury Bill Yield.
Enter all three variables in Column B, and only one variable in Column C of the in
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Bond Valuation and Risk-Chapter 8
Bond Valuation Template
This program calculates PV of coupon payments and PV of par value and hence overall market price of a bond.
Enter all five variables
fc14f0191a3bab30f96e41a5c024ee86171f8f3f.xls
Output Area
Amortization Table For A 15-Year Mortgage
Monthly payment =
$1,797.66
Remaining
Month Payment
Interest
Principal
Balance
Page 1
fc14f0191a3bab30f96e41a5c024ee86171f8f3f.xls
Amortization Table For A
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Stock Valuation and Risk-Chapter 12
Constant Growth Valuation Template
This program calculates PV of stock using constant growth model
Enter all three variables in Column B, and only one vari
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Stock Markets-Chapter 10
Stock on Margin Template
This program calculates the return on a stock purchased on margin.
Enter all five variables in Column B, and only one variable in Column C of
Financial Markets and Institutions, 6th Edition, by Jeff Madura,
Derivative Security Markets-Chapter 14
Call Option Template
This program calculates net gain per share using call option.
Enter all the variables in Column B, and only one variable in Column
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Foreign Exchange Derivative Markets-Chapter 16
Interest Rate Parity Template
This program calculates the forward rate premium, holding the U.S. interest rate constant.
Enter all the variables
Financial Markets and Institutions, 6th Edition, by Jeff Madura
Commercial Banking-Chapter 20
Bank Income Statement Template
This program assesses the performance summary of a bank.
Enter all the variables in the input area (green cells).
The program retu