Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mike Jones bought a new split-level home for $150,000 with 20% down. He decided to use Quicken Loans for his mortgage. Quicken was offering 343%
Mike Jones bought a new split-level home for $150,000 with 20\% down. He decided to use Quicken Loans for his mortgage. Quicken was offering 343% for 25 -year mortgages. Provide Mike with an amortization schedule for three periods. (Use Table 15.1) Note: Do not round Intermedlete celculetions. Round your answers to the nearest cent. Amortization table \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Rate & \begin{tabular}{c} Interest \\ Only \\ \end{tabular} & 10 Year & 15 Year & 20 Year & 25 Year & 30 Year & 40 Year \\ \hline 2.000 & 0.16667 & 9.20135 & 6.43509 & 5.05883 & 4.23854 & 3.69619 & 3.02820 \\ \hline 2.12 & 0.17708 & 9.25743 & 6.49281 & 5.11825 & 4.29966 & 3.75902 & 3.09444 \\ \hline 2.250 & 0.18750 & 9.31374 & 6.55085 & 5.17808 & 4.36131 & 3.82246 & 3.1614 \\ \hline 2.375 & 0.19792 & 9.37026 & 6.60921 & 5.23834 & 4.42348 & 3.88653 & 3.22921 \\ \hline 2.500 & 0.20833 & 9.42699 & 6.66789 & 5.29903 & 4.48617 & 3.95121 & 3.29778 \\ \hline 2.025 & 0.21875 & 9.48394 & 6.72689 & 5.36014 & 4.54938 & 4.01651 & 3.36714 \\ \hline 2.750 & 0.22917 & 9.54110 & 6.78622 & 5.42166 & 4.61311 & 4.08241 & 3.43728 \\ \hline 2.875 & 0.23958 & 9.59848 & 6.84586 & 5.48361 & 4.67735 & 4.14892 & 3.50818 \\ \hline 3.000 & 0.25000 & 9.65607 & 6.90582 & 5.54598 & 4.74211 & 4.21604 & 3.5798 \\ \hline 3.125 & 0.26042 & 9.71388 & 6.96609 & 5.60876 & 4.80738 & 4.28375 & 3.65220 \\ \hline 3.250 & 0.27083 & 9.77190 & 7.02669 & 5.67196 & 4.87310 & 4.35206 & 3.7254 \\ \hline 3.375 & 0.28125 & 9.83014 & 7.08760 & 5.73557 & 4.93945 & 4.42096 & 3.79930 \\ \hline 3.500 & 0.29167 & 9.88859 & 7.14883 & 5.79960 & 5.00624 & 4.49045 & 3.8739 \\ \hline 3.025 & 0.30208 & 9.94725 & 7.21037 & 5.86404 & 5.07352 & 4.56051 & 3.9492 \\ \hline 3.750 & 0.31250 & 10.00612 & 7.27222 & 5.92888 & 5.14131 & 4.63116 & 4.02520 \\ \hline 3.875 & 0.32292 & 10.06521 & 7.33440 & 5.99414 & 5.20959 & 4.70237 & 4.1019 \\ \hline 4.000 & 0.33333 & 10.12451 & 7.39688 & 6.05980 & 5.27837 & 4.77415 & 4.17938 \\ \hline 4.125 & \begin{tabular}{r} 0.34375 \\ \end{tabular} & 10.18403 & 7.45968 & 6.12587 & 5.34763 & 4.84650 & 4.2574 \\ \hline 4.250 & 0.35417 & 10.24375 & 7.52278 & 6.19234 & 5.41738 & 4.91940 & 4.3362 \\ \hline 4.375 & 0.36458 & 10.30369 & 7.58620 & 6.25922 & 5.48761 & 4.99285 & 4.4155 \\ \hline 4.500 & 0.37500 & 10.36384 & 7.64993 & 6.32649 & 5.55832 & 5.06685 & 4.4956 \\ \hline 4.025 & 0.38542 & 10.42420 & 7.71397 & 6.39417 & 5.62951 & 5.14140 & 4.57625 \\ \hline 4.750 & 0.39583 & 10.48477 & 7.77832 & 6.46224 & 5.70117 & 5.21647 & 4.65758 \\ \hline 4.875 & 0.40625 & 10.54556 & 7.84297 & 6.53070 & 5.77330 & 5.29208 & 4.7394 \\ \hline 5.000 & 0.41667 & 10.6065 & 7.90794 & 6.59956 & 5.84590 & 5.36822 & 4.82197 \\ \hline 5.125 & 0.42708 & 10.66776 & 7.97320 & 6.66881 & 5.91896 & 5.44487 & 4.90505 \\ \hline 5.250 & 0.43750 & 10.72917 & 8.03878 & 6.73844 & 5.99248 & 5.52204 & 4.98870 \\ \hline 5.375 & 0.44792 & 10.79079 & 8.10465 & 6.80847 & 6.06645 & 5.59971 & 5.07293 \\ \hline 5.500 & 0.45833 & 10.85263 & 8.17083 & 6.87887 & 6.14087 & 5.67789 & 5.1577 \\ \hline 5.025 & 0.46875 & 10.91467 & 8.23732 & 6.94966 & 6.21575 & 5.75656 & 5.24302 \\ \hline 5.750 & 0.47917 & 10.97692 & 8.30410 & 7.02084 & 6.29106 & 5.83573 & 5.32888 \\ \hline 5.875 & 0.48958 & 11.03938 & 8.37118 & 7.09238 & 6.36682 & 5.91538 & 5.4152 \\ \hline 6.000 & 0.50000 & 11.10205 & 8.43857 & 7.16431 & 6.44301 & 5.99551 & 5.5021 \\ \hline 6.125 & 0.51042 & 11.16493 & 8.50625 & 7.23661 & 6.51964 & 6.07611 & 5.58952 \\ \hline 6.250 & 0.52083 & 11.22801 & 8.57423 & \begin{tabular}{r} 7.30928 \\ \end{tabular} & 6.59669 & 6.15717 & 5.67740 \\ \hline 6.375 & 0.53125 & 11.29130 & 8.64250 & 7.38232 & 6.67417 & 6.23870 & 5.76575 \\ \hline 6.500 & 0.54167 & 11.35480 & 8.71107 & 7.45573 & 6.75207 & 6.32068 & 5.8545 \\ \hline 6.625 & 0.55208 & 11.41850 & 8.77994 & 7.52950 & 6.83039 & 6.40311 & 5.94385 \\ \hline 6.750 & 0.5625 & 11.48241 & 8.84909 & 7.60364 & 6.90912 & 6.48598 & 6.03357 \\ \hline 6.875 & 0.57292 & 11. 54653 & 8.91854 & 7.67814 & 6.98825 & 0.56929 & 6.12373 \\ \hline 7.000 & 0.58333 & 11.61085 & 8.98828 & \begin{tabular}{r} 7.75299 \\ \end{tabular} & 7.06779 & 6.65302 & 6.21431 \\ \hline 7.12 & 0.59375 & 11.67537 & 9.05831 & \begin{tabular}{r} 7.82820 \\ \end{tabular} & \begin{tabular}{r} 14773 \\ \end{tabular} & 6.73715 & 6.30531 \\ \hline 7250 & 0.60417 & 11.74010 & 9.12863 & 7.90376 & 7.22807 & 6.82170 & 6.39672 \\ \hline 7.37 & 0.61458 & 11.80504 & 9.19923 & 7.9790 & 7.30880 & 6.90675 & 6.4885 \\ \hline 7.50 & 0.06250 & 11.87017 & 9.27101 & 8.0559 & \begin{tabular}{r} 73899 \\ \end{tabular} & 6.9921 & 6.5807 \\ \hline 7.62 & 0.63542 & 11.93552 & 9.34130 & 8.1325 & 7.4714 & 7.0779 & 6.67327 \\ \hline 7.75 & 0.64583 & 12.00100 & 941270 & 8.2094 & \begin{tabular}{r} 755329 \\ \end{tabular} & 7.16412 & 6.76620 \\ \hline 7.87 & 0.65625 & 12.06681 & 9.4BA50 & 8.2807 & 7.03554 & 7.25069 & 6.8594 \\ \hline 8.00 & 0.66607 & 12.13270 & 9.55052 & 8.36440 & 7.71816 & 7.3376 & 6.9531 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started