{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

hw_4 - #1 Savings Summer Winter Interest Rate of years...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
#1 Savings: Summer $35 Winter $60 Interest Rate 7% # of years 6 Investment at t=0 -$1.00 PV of Returns in months 1,2,3,4 $137.98 =-PV(B5/12,4,B3) PV of Returns in months 7,8,9 $171.82 =-PV(B5/12,6,,-PV(B5/12,3,B4)) PV of additional five years of saving $1,270.24 =-PV(B5,5,B10+B11) Total Savings = Investment $1,580.04 =B12+B11+B10 #2 Months 24 Days/Month 30 Days/Year 360 Interest Rate 7.25% 0.6059% =(1+B20/B19)^B18-1 Principal $7,250 Monthly Payment $325.49 =-PMT(B21,B17,B22) Interest $561.84 =B23*B17-B22 #3 Loan Amount $120,000 Interest Rate 5.85% Points 4 Months 360 Payment ($707.93) =PMT(B29/12,B31,B28) Principal $115,200.00 =B28*(1-B30/100) Rate 6.232% =12*RATE(B31,B32,B33) Effective Rate 6.413% =(1+B34/12)^12-1 #4 Loan Amount $21,000 Interest Rate 9% # of payments 36 Interest Accumulated in 6 months $962.90 =-FV(B40/12,6,,B39)-B39 ($698.41) =PMT(B40/12,B41,B39+B42) Month Balance Interest 0 $21,000 $157.50 1 $20,459.09 $153.44 2 $19,914.11 $149.36 3 $19,365.06 $145.24 4 $18,811.88 $141.09 5 $18,254.55 $136.91 i e/month Payment ( Part A )
Image of page 1

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

View Full Document Right Arrow Icon
6 $17,693.05 $132.70 7 $17,127.33 $128.45 8 $16,557.37 $124.18 9 $15,983.14 $119.87 10 $15,404.60 $115.53 11 $14,821.72 $111.16 12 $14,234.47 $106.76
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern