Lecture_3.1.xlsx - EAR MR NPER PV FV 6.0000 0.4868 120 0 100000-615.49 $ EAR QR NPER PV FV 9.000 2.178 20 0 25000-1,010.82 $ APR MR EAR MR NPER FV PV

Lecture_3.1.xlsx - EAR MR NPER PV FV 6.0000 0.4868 120 0...

This preview shows page 1 - 2 out of 2 pages.

EAR 6.0000% MR 0.4868% NPER 120 PV 0 FV 100000 -615.49 $ EAR 9.000% QR 2.178% NPER 20 PV 0 FV 25000 -1,010.82 $ APR 0.05 6mr 0.025 MR 0.0041239155 EAR 0.050625 MR 0.0041239155 NPER 48 FV 0 PV -173,867.22 $ 173,867.22 $ APR 0.08 3mr 0.02 EAR 0.08243216 MR 0.0066227096 0.00662271 NPER 36 PV 57,485.88 $ APR 6.75% MR 0.005625 NPER 60 PV 30000 PMT -590.50 $ APR 4.80% MR 0.40% NPER 336 PMT -2623.33 PV 484,331.98 $ Balance after 2 years 492,353.91 $ Balance after 1 year 8,021.93 $ Principal repayed -31479.96 -23,458.03 $ Interest 1.423 $ 2% 0 1 2 3 4 1.151 $ 3% -10
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '18
  • Bambang SBI

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes