Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please make a note and show working. thanks Clipboard Font Alignment Nurnber E1 G H B D E F 2 Create an amortization schedules using

please make a note and show working. thanks
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Clipboard Font Alignment Nurnber E1 G H B D E F 2 Create an amortization schedules using the following assumptions: 3 4 Please make note of the following: 5 Show your work 6 7 8 Loan Term 30 Year - ARM 9 Purchaes Price $150,000.00 10 Down Payment 7.00% 11 Loan Amount $139,500.00 12 Interest Rate 9.00% 11% 15% 12% 13 Balance @ End of Year 5 Year 10 Year 15 Year 20 14 $133,752.68 15 16 Debt Service Beginning Monthly Interest Amortization 17 Month Balance Payment Rate Interest / Principal 18 1 $139,500.00 $1,122.45 0.75% $1,046.25 $76.20 19 2 $139,423.80 $1,122.45 0.75% $1,045.68 $76.77 20 3 $139,347.03 $1,122.45 0.75% $1,045.10 $77.35 21 4 $139,269.68 $1,122.45 0.75% $1,044.52 $77.93 Sheet2 Ending Balance $139,423.80 $139,347.03 $139,269.68 $139,191.76 Paste BIU. A 3. Merge & Center $ - % 000 Con Form Clipboard Font 19 Alignment Number K23 f H A B 21 4 $139,269.68 $1,122.45 22 5 $139,191.76 $1,122.45 23 6 $139,113.24 $1,122.45 24 7 $139,034.14 $1,122.45 25 8 $138,954.45 $1,122.45 26 9 $138,874.16 $1,122.45 27 10 $138,793.26 $1,122.45 28 11 $138,711.76 $1,122.45 29 12 $138,629.65 $1,122.45 30 13 $138,546.92 $1,122.45 31 14 $138,463.58 $1,122.45 32 15 $138,379.60 $1,122.45 33 16 $138,295.00 $1,122.45 34 17 $138,209.76 $1,122.45 35 18 $138,123.88 $1,122.45 36 19 $138,037.36 $1,122.45 37 20 $137,950.19 $1,122.45 38 21 $137,862.37 $1,122.45 39 22 $137,773.89 $1,122.45 40 23 $137,684.74 $1,122.45 41 24 $137,594.93 $1,122.45 Sheet2 + Readly Accessibility: Investigate D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,044.52 $1,043.94 $1,043.35 $1,042.76 $1,042.16 $1,041.56 $1,040.95 $1,040.34 $1,039.72 $1,039.10 $1,038.48 $1,037.85 $1,037.21 $1,036.57 $1,035.93 $1,035.28 $1,034.63 $1,033.97 $1,033.30 $1,032.64 $1,031.96 F $77.93 $78.51 $79.10 $79.69 $80.29 $80.89 $81.50 $82.11 $82.73 $83.35 $83.97 $84.60 $85.24 $85.88 $86.52 $87.17 $87.82 $88.48 $89.15 $89.81 $90.49 $139,191.76 $139,113.24 $139,034.14 $138,954.45 $138,874.16 $138,793.26 $138,711.76 $138,629.65 $138,546.92 $138,463.58 $138,379.60 $138,295.00 $138,209.76 $138,123.88 $138,037.36 $137,950.19 $137,862.37 $137,773.89 $137,684.74 $137,594.93 $137,504.44 U A. Merge & Center $ - % Clipboard Font Alignment Number K23 fi H 41 42 43 44 24 25 26 27 28 29 45 46 47 48 30 31 49 32 D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 33 B $137,594.93 $1,122.45 $137,504.44 $1,122.45 $137,413.27 $1,122.45 $137,321.42 $1,122.45 $137,228.88 $1,122.45 $137,135.65 $1,122.45 $137,041.72 $1,122.45 $136,947.08 $1,122.45 $136,851.73 $1,122.45 $136,755.67 $1,122.45 $136,658.89 $1,122.45 $136,561.38 $1,122.45 $136,463.14 $1,122.45 $136,364.16 $1,122.45 $136,264.45 $1,122.45 $136,163.98 $1,122.45 $136,062.76 $1,122.45 $135,960.78 $1,122.45 $135,858.04 $1,122.45 $135,754.52 $1,122.45 $135,650.23 $1,122.45 34 35 E $1,031.96 $1,031.28 $1,030.60 $1,029.91 $1,029.22 $1,028.52 $1,027.81 $1,027.10 $1,026.39 $1,025.67 $1,024.94 $1,024.21 $1,023.47 $1,022.73 $1,021.98 $1,021.23 $1,020.47 $1,019.71 $1,018.94 $1,018.16 $1,017.38 F $90.49 $91.17 $91.85 $92.54 $93.23 $93.93 $94.64 $95.35 $96.06 $96.78 $97.51 $98.24 $98.98 $99.72 $100.47 $101.22 $101.98 $102.74 $103.51 $104.29 $105.07 50 51 52 53 54 55 56 57 58 59 60 61 $137,504.44 $137,413.27 $137,321.42 $137,228.88 $137,135.65 $137,041.72 $136,947.08 $136,851.73 $136,755.67 $136,658.89 $136,561.38 $136,463.14 $136,364.16 $136,264.45 $136,163.98 $136,062.76 $135,960.78 $135,858.04 $135,754.52 $135,650.23 $135,545.16 36 37 38 39 40 41 42 0.75% 43 0.75% 0.75% 44 Sheet2 Draw Formulas Data Review Page Layout View File Home Insert Help Tell me what you want to do X General Calibri 11 TAA = = 2 Wrap Text A Merge & Center $ - % .00.0 BIU.LT Condition Formatting Paste Number 15 Alignment Clipboard Font K23 > fa H 61 62 63 64 65 66 67 68 69 70 A 44 45 46 47 48 49 50 51 52 53 B $135,650.23 $1,122.45 $135,545.16 $1,122.45 $135,439.30 $1,122.45 $135,332.64 $1,122.45 $135,225.18 $1,122.45 $135,116.92 $1,122.45 $135,007.85 $1,122.45 $134,897.96 $1,122.45 $134,787.24 $1,122.45 $134,675.70 $1,122.45 $134,563.32 $1,122.45 $134,450.09 $1,122.45 $134,336.02 $1,122.45 $134,221.09 $1,122.45 $134,105.30 $1,122.45 $133,988.64 $1,122.45 $133,871.10 $1,122.45 D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,017.38 $1,016.59 $1,015.79 $1,014.99 $1,014.19 $1,013.38 $1,012.56 $1,011.73 $1,010.90 $1,010.07 $1,009.22 $1,008.38 $1,007.52 $1,006.66 $1,005.79 $1,004.91 $1,004.03 F $105.07 $105.86 $106.66 $107.46 $108.26 $109.07 $109.89 $110.72 $111.55 $112.38 $113.23 $114.07 $114.93 $115.79 $116.66 $117.54 $118.42 G $135,545.16 $135,439.30 $135,332.64 $135,225.18 $135,116.92 $135,007.85 $134,897.96 $134,787.24 $134,675.70 $134,563.32 $134,450.09 $134,336.02 $134,221.09 $134,105.30 $133,988.64 $133,871.10 $133,752.68 54 71 72 73 74 55 56 57 58 59 60 75 76 77 78 79 80 Clipboard Font Alignment Nurnber E1 G H B D E F 2 Create an amortization schedules using the following assumptions: 3 4 Please make note of the following: 5 Show your work 6 7 8 Loan Term 30 Year - ARM 9 Purchaes Price $150,000.00 10 Down Payment 7.00% 11 Loan Amount $139,500.00 12 Interest Rate 9.00% 11% 15% 12% 13 Balance @ End of Year 5 Year 10 Year 15 Year 20 14 $133,752.68 15 16 Debt Service Beginning Monthly Interest Amortization 17 Month Balance Payment Rate Interest / Principal 18 1 $139,500.00 $1,122.45 0.75% $1,046.25 $76.20 19 2 $139,423.80 $1,122.45 0.75% $1,045.68 $76.77 20 3 $139,347.03 $1,122.45 0.75% $1,045.10 $77.35 21 4 $139,269.68 $1,122.45 0.75% $1,044.52 $77.93 Sheet2 Ending Balance $139,423.80 $139,347.03 $139,269.68 $139,191.76 Paste BIU. A 3. Merge & Center $ - % 000 Con Form Clipboard Font 19 Alignment Number K23 f H A B 21 4 $139,269.68 $1,122.45 22 5 $139,191.76 $1,122.45 23 6 $139,113.24 $1,122.45 24 7 $139,034.14 $1,122.45 25 8 $138,954.45 $1,122.45 26 9 $138,874.16 $1,122.45 27 10 $138,793.26 $1,122.45 28 11 $138,711.76 $1,122.45 29 12 $138,629.65 $1,122.45 30 13 $138,546.92 $1,122.45 31 14 $138,463.58 $1,122.45 32 15 $138,379.60 $1,122.45 33 16 $138,295.00 $1,122.45 34 17 $138,209.76 $1,122.45 35 18 $138,123.88 $1,122.45 36 19 $138,037.36 $1,122.45 37 20 $137,950.19 $1,122.45 38 21 $137,862.37 $1,122.45 39 22 $137,773.89 $1,122.45 40 23 $137,684.74 $1,122.45 41 24 $137,594.93 $1,122.45 Sheet2 + Readly Accessibility: Investigate D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,044.52 $1,043.94 $1,043.35 $1,042.76 $1,042.16 $1,041.56 $1,040.95 $1,040.34 $1,039.72 $1,039.10 $1,038.48 $1,037.85 $1,037.21 $1,036.57 $1,035.93 $1,035.28 $1,034.63 $1,033.97 $1,033.30 $1,032.64 $1,031.96 F $77.93 $78.51 $79.10 $79.69 $80.29 $80.89 $81.50 $82.11 $82.73 $83.35 $83.97 $84.60 $85.24 $85.88 $86.52 $87.17 $87.82 $88.48 $89.15 $89.81 $90.49 $139,191.76 $139,113.24 $139,034.14 $138,954.45 $138,874.16 $138,793.26 $138,711.76 $138,629.65 $138,546.92 $138,463.58 $138,379.60 $138,295.00 $138,209.76 $138,123.88 $138,037.36 $137,950.19 $137,862.37 $137,773.89 $137,684.74 $137,594.93 $137,504.44 U A. Merge & Center $ - % Clipboard Font Alignment Number K23 fi H 41 42 43 44 24 25 26 27 28 29 45 46 47 48 30 31 49 32 D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 33 B $137,594.93 $1,122.45 $137,504.44 $1,122.45 $137,413.27 $1,122.45 $137,321.42 $1,122.45 $137,228.88 $1,122.45 $137,135.65 $1,122.45 $137,041.72 $1,122.45 $136,947.08 $1,122.45 $136,851.73 $1,122.45 $136,755.67 $1,122.45 $136,658.89 $1,122.45 $136,561.38 $1,122.45 $136,463.14 $1,122.45 $136,364.16 $1,122.45 $136,264.45 $1,122.45 $136,163.98 $1,122.45 $136,062.76 $1,122.45 $135,960.78 $1,122.45 $135,858.04 $1,122.45 $135,754.52 $1,122.45 $135,650.23 $1,122.45 34 35 E $1,031.96 $1,031.28 $1,030.60 $1,029.91 $1,029.22 $1,028.52 $1,027.81 $1,027.10 $1,026.39 $1,025.67 $1,024.94 $1,024.21 $1,023.47 $1,022.73 $1,021.98 $1,021.23 $1,020.47 $1,019.71 $1,018.94 $1,018.16 $1,017.38 F $90.49 $91.17 $91.85 $92.54 $93.23 $93.93 $94.64 $95.35 $96.06 $96.78 $97.51 $98.24 $98.98 $99.72 $100.47 $101.22 $101.98 $102.74 $103.51 $104.29 $105.07 50 51 52 53 54 55 56 57 58 59 60 61 $137,504.44 $137,413.27 $137,321.42 $137,228.88 $137,135.65 $137,041.72 $136,947.08 $136,851.73 $136,755.67 $136,658.89 $136,561.38 $136,463.14 $136,364.16 $136,264.45 $136,163.98 $136,062.76 $135,960.78 $135,858.04 $135,754.52 $135,650.23 $135,545.16 36 37 38 39 40 41 42 0.75% 43 0.75% 0.75% 44 Sheet2 Draw Formulas Data Review Page Layout View File Home Insert Help Tell me what you want to do X General Calibri 11 TAA = = 2 Wrap Text A Merge & Center $ - % .00.0 BIU.LT Condition Formatting Paste Number 15 Alignment Clipboard Font K23 > fa H 61 62 63 64 65 66 67 68 69 70 A 44 45 46 47 48 49 50 51 52 53 B $135,650.23 $1,122.45 $135,545.16 $1,122.45 $135,439.30 $1,122.45 $135,332.64 $1,122.45 $135,225.18 $1,122.45 $135,116.92 $1,122.45 $135,007.85 $1,122.45 $134,897.96 $1,122.45 $134,787.24 $1,122.45 $134,675.70 $1,122.45 $134,563.32 $1,122.45 $134,450.09 $1,122.45 $134,336.02 $1,122.45 $134,221.09 $1,122.45 $134,105.30 $1,122.45 $133,988.64 $1,122.45 $133,871.10 $1,122.45 D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,017.38 $1,016.59 $1,015.79 $1,014.99 $1,014.19 $1,013.38 $1,012.56 $1,011.73 $1,010.90 $1,010.07 $1,009.22 $1,008.38 $1,007.52 $1,006.66 $1,005.79 $1,004.91 $1,004.03 F $105.07 $105.86 $106.66 $107.46 $108.26 $109.07 $109.89 $110.72 $111.55 $112.38 $113.23 $114.07 $114.93 $115.79 $116.66 $117.54 $118.42 G $135,545.16 $135,439.30 $135,332.64 $135,225.18 $135,116.92 $135,007.85 $134,897.96 $134,787.24 $134,675.70 $134,563.32 $134,450.09 $134,336.02 $134,221.09 $134,105.30 $133,988.64 $133,871.10 $133,752.68 54 71 72 73 74 55 56 57 58 59 60 75 76 77 78 79 80

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Types of cultural maps ?

Answered: 1 week ago

Question

Discuss the various types of leasing.

Answered: 1 week ago

Question

Define the term "Leasing"

Answered: 1 week ago

Question

What do you mean by Dividend ?

Answered: 1 week ago