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

Info iconThis 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 i e/month Payment ( Part A )
Background image of page 1

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

View Full DocumentRight Arrow Icon
0 $21,000 $157.50 1 $20,459.09 $153.44 2 $19,914.11 $149.36 3 $19,365.06
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/31/2009 for the course PHYS 1234 taught by Professor Judge during the Fall '09 term at USC.

Page1 / 3

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

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

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