QUIZ1 - - 20 year 4% annuity paid $50,000 end of each year,...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Build the Payment Calculator Shown Below - Maintain general appearance and formatting - Name the three input cells "IntRate", "NumPmts", "LoanAmt" - Name the Payment output cell "Pmt" PAYMENT CALCULATOR RATE NUMBER OF PMTS LOAN AMOUNT PAYMENT = 2. Find the payment for the following; Answer - 5 year loan of $25,000 at 8%; monthly payments - 10 year loan of $100,000 at 10%; annual payments - 4 year loan of $10,000 at 5%; quarterly payments 3. Build the Present Value Calculator Shown Below Returns the present value of an investment, the value now of a series of future pay - Maintain general appearance and formatting - Name the four input cells "AnnuityRate", "NumAnnuityPmts", "AnnuityPmt", "A - Name the Present Value output cell "PresentValue" PRESENT VALUE CALCULATOR RATE NUMBER OF PMTS PAYMENT AMOUNT REMAINING VALUE PRESENT VALUE = 4. Find the present value for the following (all pmts made at end of period); - 5 year annuity paid $500 monthly at 6%, nothing remaining in account
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: - 20 year 4% annuity paid $50,000 end of each year, $100,000 remaining- 10 year annuity of quarterly $20,000 payments at 3%, nothing remaining 5. Build the Future Value Calculator Shown Below Returns the present value of an investment, the value now of a series of future pay- Maintain general appearance and formatting- Name the four input cells "fvRate", "fvNumPmts", "PeriodicPmt", "LumpSumPm- Name the Present Value output cell "PresentValue" FUTURE VALUE CALCULATOR RATE NUMBER OF PMTS AMT OF EACH PMT LUMP SUM PMT FUTURE VALUE = 6. Find the future value for the following (all pmts made at beginning of period);- Invest $100,000 today, compounded annually at 6% for 20 years- Invest $1000 monthly for 35 years at 8%- Invest one lump sum of $5,000, then 1000% monthly for 35 years at 8%. yments mtRemaining) Answer yments t") Answer...
View Full Document

This note was uploaded on 01/24/2011 for the course FIA 111 taught by Professor Matta during the Spring '10 term at Hocking.

Page1 / 4

QUIZ1 - - 20 year 4% annuity paid $50,000 end of each year,...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online