FINITE MATH 100% ORIGINAL & A+ QUALITY WORK

profilesantth
math_solutin_2_1.xlsx
Home>Mathematics homework help>FINITE MATH 100% ORIGINAL & A+ QUALITY WORK

Sheet1

House Price $135,000.00
Downpayment $0.00
Original Principal $135,000.00
Number of Payments 36 Total Interest Paid = $13,070.92
Annual Interest Rate 6.1%
Payment Amount = $4,113.08
Period Beginning Balance Interest Principal Ending Balance
0 $135,000.00
1 $135,000.00 $686.25 $3,426.83 $131,573.17
2 $131,573.17 $668.83 $3,444.25 $128,128.92
3 $128,128.92 $651.32 $3,461.76 $124,667.16
4 $124,667.16 $633.72 $3,479.36 $121,187.80
5 $121,187.80 $616.04 $3,497.04 $117,690.76
6 $117,690.76 $598.26 $3,514.82 $114,175.94
7 $114,175.94 $580.39 $3,532.69 $110,643.25
8 $110,643.25 $562.44 $3,550.64 $107,092.61
9 $107,092.61 $544.39 $3,568.69 $103,523.91
10 $103,523.91 $526.25 $3,586.83 $99,937.08
11 $99,937.08 $508.01 $3,605.07 $96,332.01
12 $96,332.01 $489.69 $3,623.39 $92,708.62 The balance at the end of 1st year is $92708.62
13 $92,708.62 $471.27 $3,641.81 $89,066.81
14 $89,066.81 $452.76 $3,660.32 $85,406.48
15 $85,406.48 $434.15 $3,678.93 $81,727.55
16 $81,727.55 $415.45 $3,697.63 $78,029.92
17 $78,029.92 $396.65 $3,716.43 $74,313.49
18 $74,313.49 $377.76 $3,735.32 $70,578.17
19 $70,578.17 $358.77 $3,754.31 $66,823.86
20 $66,823.86 $339.69 $3,773.39 $63,050.46
21 $63,050.46 $320.51 $3,792.57 $59,257.89
22 $59,257.89 $301.23 $3,811.85 $55,446.04
23 $55,446.04 $281.85 $3,831.23 $51,614.81
24 $51,614.81 $262.38 $3,850.71 $47,764.10 The balance at the end of 2nd year is $47764.10
25 $47,764.10 $242.80 $3,870.28 $43,893.82
26 $43,893.82 $223.13 $3,889.95 $40,003.86
27 $40,003.86 $203.35 $3,909.73 $36,094.14
28 $36,094.14 $183.48 $3,929.60 $32,164.53
29 $32,164.53 $163.50 $3,949.58 $28,214.96
30 $28,214.96 $143.43 $3,969.66 $24,245.30
31 $24,245.30 $123.25 $3,989.83 $20,255.47
32 $20,255.47 $102.97 $4,010.12 $16,245.35
33 $16,245.35 $82.58 $4,030.50 $12,214.85
34 $12,214.85 $62.09 $4,050.99 $8,163.86
35 $8,163.86 $41.50 $4,071.58 $4,092.28
36 $4,092.28 $20.80 $4,092.28 -$0.00 The balance at the end of 3rd year is $0.00

Sheet2

House Price $135,000.00
Downpayment $10,000.00
Original Principal $125,000.00
Number of Payments 36 Total Interest Paid = $12,102.71
Annual Interest Rate 6.1%
Payment Amount = $3,808.41
Period Beginning Balance Interest Principal Ending Balance
0 $125,000.00
1 $125,000.00 $635.42 $3,172.99 $121,827.01
2 $121,827.01 $619.29 $3,189.12 $118,637.89
3 $118,637.89 $603.08 $3,205.33 $115,432.55
4 $115,432.55 $586.78 $3,221.63 $112,210.93
5 $112,210.93 $570.41 $3,238.00 $108,972.92
6 $108,972.92 $553.95 $3,254.46 $105,718.46
7 $105,718.46 $537.40 $3,271.01 $102,447.46
8 $102,447.46 $520.77 $3,287.63 $99,159.82
9 $99,159.82 $504.06 $3,304.35 $95,855.48
10 $95,855.48 $487.27 $3,321.14 $92,534.33
11 $92,534.33 $470.38 $3,338.03 $89,196.31
12 $89,196.31 $453.41 $3,354.99 $85,841.31 The balance at the end of 1st year is $85841.31
13 $85,841.31 $436.36 $3,372.05 $82,469.26
14 $82,469.26 $419.22 $3,389.19 $79,080.07
15 $79,080.07 $401.99 $3,406.42 $75,673.66
16 $75,673.66 $384.67 $3,423.73 $72,249.92
17 $72,249.92 $367.27 $3,441.14 $68,808.78
18 $68,808.78 $349.78 $3,458.63 $65,350.15
19 $65,350.15 $332.20 $3,476.21 $61,873.94
20 $61,873.94 $314.53 $3,493.88 $58,380.06
21 $58,380.06 $296.77 $3,511.64 $54,868.42
22 $54,868.42 $278.91 $3,529.49 $51,338.92
23 $51,338.92 $260.97 $3,547.44 $47,791.49
24 $47,791.49 $242.94 $3,565.47 $44,226.02 The balance at the end of 2nd year is $44226.02
25 $44,226.02 $224.82 $3,583.59 $40,642.42
26 $40,642.42 $206.60 $3,601.81 $37,040.62
27 $37,040.62 $188.29 $3,620.12 $33,420.50
28 $33,420.50 $169.89 $3,638.52 $29,781.98
29 $29,781.98 $151.39 $3,657.02 $26,124.96
30 $26,124.96 $132.80 $3,675.61 $22,449.35
31 $22,449.35 $114.12 $3,694.29 $18,755.06
32 $18,755.06 $95.34 $3,713.07 $15,041.99
33 $15,041.99 $76.46 $3,731.95 $11,310.05
34 $11,310.05 $57.49 $3,750.92 $7,559.13
35 $7,559.13 $38.43 $3,769.98 $3,789.15
36 $3,789.15 $19.26 $3,789.15 -$0.00 The balance at the end of 3rd year is $0.00

Sheet3

House Price $135,000.00
Downpayment $25,000.00
Original Principal $110,000.00
Number of Payments 36 Total Interest Paid = $10,650.38
Annual Interest Rate 6.1%
Payment Amount = $3,351.40
Period Beginning Balance Interest Principal Ending Balance
0 $110,000.00
1 $110,000.00 $559.17 $2,792.23 $107,207.77
2 $107,207.77 $544.97 $2,806.43 $104,401.34
3 $104,401.34 $530.71 $2,820.69 $101,580.65
4 $101,580.65 $516.37 $2,835.03 $98,745.62
5 $98,745.62 $501.96 $2,849.44 $95,896.17
6 $95,896.17 $487.47 $2,863.93 $93,032.25
7 $93,032.25 $472.91 $2,878.49 $90,153.76
8 $90,153.76 $458.28 $2,893.12 $87,260.64
9 $87,260.64 $443.57 $2,907.82 $84,352.82
10 $84,352.82 $428.79 $2,922.61 $81,430.21
11 $81,430.21 $413.94 $2,937.46 $78,492.75
12 $78,492.75 $399.00 $2,952.39 $75,540.36 The balance at the end of 1st year is $75540.36
13 $75,540.36 $384.00 $2,967.40 $72,572.95
14 $72,572.95 $368.91 $2,982.49 $69,590.47
15 $69,590.47 $353.75 $2,997.65 $66,592.82
16 $66,592.82 $338.51 $3,012.89 $63,579.93
17 $63,579.93 $323.20 $3,028.20 $60,551.73
18 $60,551.73 $307.80 $3,043.59 $57,508.14
19 $57,508.14 $292.33 $3,059.07 $54,449.07
20 $54,449.07 $276.78 $3,074.62 $51,374.45
21 $51,374.45 $261.15 $3,090.25 $48,284.21
22 $48,284.21 $245.44 $3,105.95 $45,178.25
23 $45,178.25 $229.66 $3,121.74 $42,056.51
24 $42,056.51 $213.79 $3,137.61 $38,918.90 The balance at the end of 2nd year is $38918.90
25 $38,918.90 $197.84 $3,153.56 $35,765.33
26 $35,765.33 $181.81 $3,169.59 $32,595.74
27 $32,595.74 $165.70 $3,185.70 $29,410.04
28 $29,410.04 $149.50 $3,201.90 $26,208.14
29 $26,208.14 $133.22 $3,218.17 $22,989.96
30 $22,989.96 $116.87 $3,234.53 $19,755.43
31 $19,755.43 $100.42 $3,250.98 $16,504.45
32 $16,504.45 $83.90 $3,267.50 $13,236.95
33 $13,236.95 $67.29 $3,284.11 $9,952.84
34 $9,952.84 $50.59 $3,300.81 $6,652.03
35 $6,652.03 $33.81 $3,317.58 $3,334.45
36 $3,334.45 $16.95 $3,334.45 -$0.00 The balance at the end of 3rd year is $0.00