e06h2Mortgage_TriplettCoral - 400,405.91 No Payment Periods...

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

View Full Document Right Arrow Icon
Scenario Summary Best-Case Scenario Worst_Case Scenario Most Likely Scenario Changing Cells: Cost of Home $ 250,000.00 $ 250,000.00 $ 250,000.00 Down Payment $ 10,000.00 $ 15,000.00 $ 8,500.00 APR 2.25% 6.00% 425.00% Years 15 45 30 Result Cells: Monthly Payment $ 1,572.20 $ 1,260.27 $ 85,531.25 Total to Repay Loan $ 282,996.62 $ 680,545.12 $ 30,791,250.00 Total Interest Paid $ 42,996.62 $ 445,545.12 $ 30,549,750.00
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
Input Area One-Variable Data Table: APR Cost of home $ 250,000.00 Calculated Results for Each APR Down Payment $ 15,000.00 APR Payment Total Repaid Total Interest APR 6.00% 4.00% $ 939.02 $ 507,069.26 $ 272,069.26 No. Years for Loan 45 4.25% $ 977.11 $ 527,639.21 $ 292,639.21 Payments Per Year 12 4.50% $ 1,015.84 $ 548,555.73 $ 313,555.73 4.75% $ 1,055.19 $ 569,804.77 $ 334,804.77 Output Area 5.00% $ 1,095.13 $ 591,372.22 $ 356,372.22 Amount of Loan $ 235,000.00 5.25% $ 1,135.64 $ 613,243.95 $ 378,243.95 Periodic Rate 0.50% 5.50% $ 1,176.68 $ 635,405.91 $ 400,405.91
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 400,405.91 No. Payment Periods 540 5.75% $ 1,218.23 $ 657,844.21 $ 422,844.21 Monthly Payment $ 1,260.27 6.00% $ 1,260.27 $ 680,545.12 $ 445,545.12 Total to Repay Loan $ 680,545.12 Total Interest Paid $ 445,545.12 Two-Variable Data Table: APR and Cost of Home Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% $ 739.23 $ 839.12 $ 939.02 4.25% $ 769.21 $ 873.16 $ 977.11 4.50% $ 799.71 $ 907.78 $ 1,015.84 4.75% $ 830.68 $ 942.94 $ 1,055.19 5.00% $ 862.13 $ 978.63 $ 1,095.13 5.25% $ 894.01 $ 1,014.82 $ 1,135.64 5.50% $ 926.32 $ 1,051.50 $ 1,176.68 5.75% $ 959.03 $ 1,088.63 $ 1,218.23 6.00% $ 992.13 $ 1,126.20 $ 1,260.27 6.25% $ 1,025.58 $ 1,164.18 $ 1,302.77 6.50% $ 1,059.39 $ 1,202.55 $ 1,345.71 6.75% $ 1,093.51 $ 1,241.28 $ 1,389.06 7.00% $ 1,127.95 $ 1,280.37 $ 1,432.80 7.25% $ 1,162.67 $ 1,319.79 $ 1,476.90 7.50% $ 1,197.66 $ 1,359.51 $ 1,521.36 7.75% $ 1,232.92 $ 1,399.53 $ 1,566.14 8.00% $ 1,268.41 $ 1,439.81 $ 1,611.22...
View Full 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