e06h2Mortgage_TriplettCoral

# e06h2Mortgage_TriplettCoral - Scenario Summary Best-Case...

• Homework Help
• 3

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

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

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

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

• Fall '15
• Culver,C
• monthly payment

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