{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document

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

View Full Document
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online