FINANCIAL SPREADSHEET CALCULATORS FOR CHAPTER 4
Below are links to the spreadsheet calculators used for exercises and activities in chapter 4.
SECTION 4A
Simple Interest (referred to on page
210 in text), Compound Interest Formula for Interest Paid n Times per Year
(page 217 in text) and Annual Percentage Yield (APY) (page 219 in text).
SECTION 4A
SPREADSHEET
SECTION 4B
Savings Plan Formula with Regular Payments (page
228 in text) and Savings Plan Formula Solved for Payments (page 232 in text).
SECTION 4B SPREADSHEET
#1
Total Return and Annual Return (page 234 in text), Total
Return on a Stock, and Current Yield of a Bond (page 243 in text).
SECTION 4B SPREADSHEET
#2
SECTION 4C
Loan Payment Formula for Installment Loans (page 252 in
text) and Amortization Table.
SECTION 4C
SPREADSHEET