Loan Analysis Worksheet

Loan Analysis Worksheet Loan Analysis Interest Rate:

7.00%

Years of Loan:

10

Loan Amount: Payments Due:

$250,000.00 1

Rate $2,902.71

Years 3

5

10

12

15

20

25

30

4.00%

$7,380.97

$4,604.12

$2,531.12

$2,188.82

$1,849.22

$1,514.95

$1,319.59

$1,193.54

4.25%

$7,408.81

$4,632.37

$2,560.93

$2,219.29

$1,880.69

$1,548.08

$1,354.34

$1,229.85

4.50%

$7,436.71

$4,660.74

$2,590.95

$2,250.02

$1,912.48

$1,581.62

$1,389.58

$1,266.71

Monthly Payment:

$2,902.71

4.75%

$7,464.67

$4,689.21

$2,621.19

$2,280.99

$1,944.58

$1,615.56

$1,425.29

$1,304.12

Total Payment:

$348,324.74

5.00%

$7,492.70

$4,717.79

$2,651.63

$2,312.22

$1,976.98

$1,649.89

$1,461.47

$1,342.05

Total Interest:

$98,324.74

5.25%

$7,520.79

$4,746.48

$2,682.29

$2,343.70

$2,009.69

$1,684.61

$1,498.12

$1,380.51

5.50%

$7,548.95

$4,775.28

$2,713.15

$2,375.43

$2,042.71

$1,719.72

$1,535.22

$1,419.47

5.75%

$7,577.17

$4,804.18

$2,744.22

$2,407.40

$2,076.02

$1,755.21

$1,572.76

$1,458.93

6.00%

$7,605.46

$4,833.19

$2,775.51

$2,439.62

$2,109.64

$1,791.08

$1,610.75

$1,498.88

6.25%

$7,633.81

$4,862.30

$2,807.00

$2,472.09

$2,143.55

$1,827.32

$1,649.17

$1,539.29

6.50%

$7,662.23

$4,891.52

$2,838.69

$2,504.80

$2,177.77

$1,863.93

$1,688.02

$1,580.17

6.75%

$7,690.71

$4,920.85

$2,870.60

$2,537.75

$2,212.27

$1,900.91

$1,727.28

$1,621.49

7.00%

$7,719.25

$4,950.29

$2,902.71

$2,570.95

$2,247.07

$1,938.25

$1,766.95

$1,663.26

7.25%

$7,747.86

$4,979.83

$2,935.02

$2,604.39

$2,282.15

$1,975.94

$1,807.02

$1,705.44

7.50%

$7,776.53

$5,009.47

$2,967.54

$2,638.06

$2,317.53

$2,013.98

$1,847.48

$1,748.04

7.75%

$7,805.27

$5,039.23

$3,000.26

$2,671.98

$2,353.19

$2,052.37

$1,888.32

$1,791.03

8.00%

$7,834.07

$5,069.08

$3,033.18

$2,706.13

$2,389.13

$2,091.10

$1,929.54

$1,834.41

8.25%

$7,862.93

$5,099.05

$3,066.31

$2,740.51

$2,425.35

$2,130.16

$1,971.12

$1,878.17

8.50%

$7,891.86

$5,129.12

$3,099.64

$2,775.13

$2,461.85

$2,169.56

$2,013.07

$1,922.28

8.75%

$7,920.85

$5,159.29

$3,133.16

$2,809.99

$2,498.62

$2,209.28

$2,055.36

$1,966.75

9.00%

$7,949.91

$5,189.58

$3,166.89

$2,845.07

$2,535.66

$2,249.31

$2,097.99

$2,011.56

9.25%

$7,979.03

$5,219.96

$3,200.81

$2,880.39

$2,572.98

$2,289.67

$2,140.95

$2,056.69

9.50%

$8,008.21

$5,250.45

$3,234.93

$2,915.93

$2,610.56

$2,330.33

$2,184.24

$2,102.14

9.75%

$8,037.46

$5,281.05

$3,269.25

$2,951.70

$2,648.40

$2,371.29

$2,227.84

$2,147.89

10.00%

$8,066.77

$5,311.75

$3,303.76

$2,987.69

$2,686.51

$2,412.55

$2,271.75

$2,193.93

10.25%

$8,096.15

$5,342.55

$3,338.47

$3,023.91

$2,724.87

$2,454.11

$2,315.96

$2,240.25

10.50%

$8,125.59

$5,373.46

$3,373.37

$3,060.35

$2,763.50

$2,495.95

$2,360.45

$2,286.85

10.75%

$8,155.09

$5,404.48

$3,408.46

$3,097.01

$2,802.37

$2,538.07

$2,405.23

$2,333.70

11.00%

$8,184.66

$5,435.59

$3,443.75

$3,133.88

$2,841.49

$2,580.47

$2,450.28

$2,380.81

11.25%

$8,214.29

$5,466.81

$3,479.22

$3,170.98

$2,880.86

$2,623.14

$2,495.60

$2,428.15

11.50%

$8,243.98

$5,498.14

$3,514.88

$3,208.29

$2,920.47

$2,666.07

$2,541.17

$2,475.73

11.75%

$8,273.73

$5,529.57

$3,550.73

$3,245.81

$2,960.33

$2,709.27

$2,586.99

$2,523.52

12.00%

$8,303.55

$5,561.10

$3,586.77

$3,283.54

$3,000.42

$2,752.71

$2,633.06

$2,571.53

12.25%

$8,333.44

$5,592.73

$3,622.99

$3,321.49

$3,040.74

$2,796.41

$2,679.36

$2,619.74

12.50%

$8,363.38

$5,624.47

$3,659.40

$3,359.64

$3,081.30

$2,840.35

$2,725.88

$2,668.14

12.75%

$8,393.39

$5,656.31

$3,695.99

$3,398.00

$3,122.09

$2,884.53

$2,772.63

$2,716.73

13.00%

$8,423.47

$5,688.26

$3,732.76

$3,436.56

$3,163.10

$2,928.94

$2,819.59

$2,765.50

13.25%

$8,453.60

$5,720.30

$3,769.72

$3,475.32

$3,204.34

$2,973.58

$2,866.75

$2,814.43

13.50%

$8,483.80

$5,752.45

$3,806.85

$3,514.29

$3,245.79

$3,018.44

$2,914.11

$2,863.53

13.75%

$8,514.06

$5,784.70

$3,844.17

$3,553.45

$3,287.47

$3,063.51

$2,961.66

$2,912.78

14.00%

$8,544.38

$5,817.05

$3,881.66

$3,592.82

$3,329.35

$3,108.80

$3,009.40

$2,962.18

14.25%

$8,574.77

$5,849.50

$3,919.32

$3,632.37

$3,371.45

$3,154.30

$3,057.32

$3,011.72

14.50%

$8,605.22

$5,882.06

$3,957.17

$3,672.12

$3,413.75

$3,199.99

$3,105.41

$3,061.39

14.75%

$8,635.73

$5,914.71

$3,995.18

$3,712.06

$3,456.26

$3,245.89

$3,153.66

$3,111.19

15.00%

$8,666.31

$5,947.47

$4,033.37

$3,752.19

$3,498.97

$3,291.97

$3,202.08

$3,161.11

15.25%

$8,696.95

$5,980.33

$4,071.73

$3,792.51

$3,541.87

$3,338.25

$3,250.65

$3,211.15

15.50%

$8,727.65

$6,013.29

$4,110.26

$3,833.01

$3,584.97

$3,384.70

$3,299.36

$3,261.29

15.75%

$8,758.41

$6,046.34

$4,148.96

$3,873.69

$3,628.27

$3,431.33

$3,348.22

$3,311.54

16.00%

$8,789.24

$6,079.50

$4,187.82

$3,914.56

$3,671.75

$3,478.14

$3,397.22

$3,361.89

16.25%

$8,820.12

$6,112.76

$4,226.86

$3,955.61

$3,715.42

$3,525.11

$3,446.35

$3,412.34

16.50%

$8,851.07

$6,146.12

$4,266.05

$3,996.83

$3,759.27

$3,572.25

$3,495.61

$3,462.87

16.75%

$8,882.09

$6,179.58

$4,305.41

$4,038.23

$3,803.30

$3,619.55

$3,544.99

$3,513.49

17.00%

$8,913.16

$6,213.13

$4,344.94

$4,079.81

$3,847.51

$3,667.00

$3,594.49

$3,564.19

17.25%

$8,944.30

$6,246.79

$4,384.62

$4,121.55

$3,891.89

$3,714.60

$3,644.10

$3,614.96

17.50%

$8,975.50

$6,280.54

$4,424.47

$4,163.47

$3,936.44

$3,762.35

$3,693.82

$3,665.81

17.75%

$9,006.76

$6,314.40

$4,464.47

$4,205.55

$3,981.17

$3,810.25

$3,743.65

$3,716.73

18.00%

$9,038.08

$6,348.35

$4,504.63

$4,247.80

$4,026.05

$3,858.28

$3,793.57

$3,767.71