final study.xlsx - Purchase Price Down Payment Rate Nper Pv...

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

Purchase Price $ 250,000.00 Down Payment Pct. Down Payment 25,000.00 10.0% Rate 4.0% Nper 5 Pv 225,000.00 Payment 4,143.72 Total Cost 248,623.05 Bank Profit 1,376.95 Per IPMT() PPMT() Balance Remaining $ 248,623.05 1 $ 750.00 $ 3,393.72 244,479.33 2 738.69 3,405.03 240,335.61 3 727.34 3,416.38 236,191.90 4 715.95 3,427.77 232,048.18 5 704.52 3,439.19 227,904.46 6 693.06 3,450.66 223,760.74 7 681.56 3,462.16 219,617.03 8 670.02 3,473.70 215,473.31 9 658.44 3,485.28 211,329.59 10 646.82 3,496.90 207,185.87 11 635.16 3,508.55 203,042.16 12 623.47 3,520.25 198,898.44 13 611.73 3,531.98 194,754.72 14 599.96 3,543.76 190,611.00 15 588.15 3,555.57 186,467.29 16 576.30 3,567.42 182,323.57 17 564.41 3,579.31 178,179.85 18 552.47 3,591.24 174,036.13 19 540.50 3,603.21 169,892.42 20 528.49 3,615.22 165,748.70 21 516.44 3,627.28 161,604.98 22 504.35 3,639.37 157,461.26 23 492.22 3,651.50 153,317.55 24 480.05 3,663.67 149,173.83 25 467.84 3,675.88 145,030.11 26 455.58 3,688.13 140,886.39 27 443.29 3,700.43 136,742.68 28 430.95 3,712.76 132,598.96 29 418.58 3,725.14 128,455.24
Image of page 1

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

Image of page 2
Image of page 3

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

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '13
  • Sharbaf

{[ 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