Midterm Exam, Fall 2015 Name Question 1 2 3 4 5 6 7 8 9 10 Late Total Score 0 0 0 0 0 0 0 0 0 0 0 0 Question 1 Score 0 John has accepted a new job
View the step-by-step solution to:

Question

Hello, I'm having difficulty with my midterm.  I would like to know if I could get help with questions 2 through

9. Disregard questions 1 and 10.  It's an Excel document.  Thank you.

Midterm Exam, Fall 2015 QuesTon Score 1 0 2 0 3 0 4 0 Name 5 0 6 0 7 0 8 0 9 0 10 0 Late 0 Total 0
Background image of page 01
Queston 1 Score 0 a John makes a $250 monthly contribuTon into a fund that oFers a return of 3.0% NAR with monthly compounding. b John makes a $1,000 quarterly contribuTon into a fund that oFers a return of 2.125% EAR with monthly compounding. Soluton a NAR 3.00% Monthly compounding EAR 3.04% =E±±EC²(NAR,12) NAR-monthly 3.00% =NOMINAL(EAR,12) PIR-monthly 0.25% =NAR-monthly/12 Periods 20 Years Periods 240 Monthly Deposits ($250) Upfront $0 ±V $82,075.50 =±V(C11,C13,C14,0) b NAR 2.11% EAR 2.125% NAR-quarterly 2.11% PIR-quarterly 0.53% Periods 20 Years Periods 80 Quarterly Deposits ($1,000) Upfront $0 ±V $99,189.19 John has accepted a new job and needs advice concerning the selecTon of a reTrement fund. Determine the amount that will be in each of the following reTrement funds a³er 20 years of payments? Assume all contribuTons are end of period.
Background image of page 02
Show entire document
Sign up to view the entire interaction

Top Answer

Kindly find the answers in the attached file... View the full answer

2015 Fall MidTerm.xls

Midterm Exam, Fall 2015 Name Question
1
2
3
4
5
6
7
8
9
10
Late
Total Score
0
0
0
0
0
0
0
0
0
0
0
0 Question 1 Score 0 John has accepted a new job and needs advice concerning the selection of a...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question