{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

#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 )

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern