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
Advanced Exam 2
Chapter 3
Learning objectives:
Show how an investment in a subsidiary account is maintained under the simple equity,
sophisticated equity, and cost methods.
Complete a consolidated worksheet using the simple equity method for the parents i
Advanced Exam 3
Chapter 6
Consolidated statement of cash flows
FASB requires a statement of CF accompany a companys published income statement and
balance sheet
Analysis of changes in cash begins with a consolidated balance sheet, intercompany transaction
Chapter 2 homework
Fin 341
Terms:
1. Monetary base Currency in circulation plus financial institution reserve deposits at the Federal
Reserve. The monetary base consists of all assets that can be used to satisfy legal reserve
requirements. Thus, if it gro
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
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,
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
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
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
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
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
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
Advanced Exam 1
Advanced Ch. 1 Notes
Learning objectives:
Describe the major economic advantages of business combinations
Differentiate between accounting for an acquisition of assets and accounting for an acquisition
of a controlling interest in the comm