amortization

amortization - Sheet1 Garrett Ozar Months 360 Interest Rate...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Garrett Ozar Months 360 Interest Rate 7.00% Principal $1,040,000.00 Down Payment $260,000.00 The picture and information is on List Price $1,300,000.00 sheet 2 of this document Monthly Payment $6,919.15 (PVIFA) Total Interest $1,125,432.82 (not including DP) (Including DP) Month Payment Interest Principal Amount Owed Amount Owned Total Owned $1,040,000.00 0 $260,000.00 1 $6,919.15 $6,066.67 $852.48 $1,039,147.52 $852.48 $260,852.48 2 $6,919.15 $6,061.69 $857.45 $1,038,290.07 $1,709.93 $261,709.93 3 $6,919.15 $6,056.69 $862.45 $1,037,427.61 $2,572.39 $262,572.39 4 $6,919.15 $6,051.66 $867.48 $1,036,560.13 $3,439.87 $263,439.87 5 $6,919.15 $6,046.60 $872.55 $1,035,687.58 $4,312.42 $264,312.42 6 $6,919.15 $6,041.51 $877.64 $1,034,809.95 $5,190.05 $265,190.05 7 $6,919.15 $6,036.39 $882.75 $1,033,927.20 $6,072.80 $266,072.80 8 $6,919.15 $6,031.24 $887.90 $1,033,039.29 $6,960.71 $266,960.71 9 $6,919.15 $6,026.06 $893.08 $1,032,146.21 $7,853.79 $267,853.79 10 $6,919.15 $6,020.85 $898.29 $1,031,247.91 $8,752.09 $268,752.09 11 $6,919.15 $6,015.61 $903.53 $1,030,344.38 $9,655.62 $269,655.62 12 $6,919.15 $6,010.34 $908.80 $1,029,435.58 $10,564.42 $270,564.42 13 $6,919.15 $6,005.04 $914.11 $1,028,521.47 $11,478.53 $271,478.53 14 $6,919.15 $5,999.71 $919.44 $1,027,602.04 $12,397.96 $272,397.96 15 $6,919.15 $5,994.35 $924.80 $1,026,677.23 $13,322.77 $273,322.77 16 $6,919.15 $5,988.95 $930.20 $1,025,747.04 $14,252.96 $274,252.96 17 $6,919.15 $5,983.52 $935.62 $1,024,811.42 $15,188.58 $275,188.58 18 $6,919.15 $5,978.07 $941.08 $1,023,870.34 $16,129.66 $276,129.66 19 $6,919.15 $5,972.58 $946.57 $1,022,923.77 $17,076.23 $277,076.23 20 $6,919.15 $5,967.06 $952.09 $1,021,971.68 $18,028.32 $278,028.32 21 $6,919.15 $5,961.50 $957.64 $1,021,014.03 $18,985.97 $278,985.97 22 $6,919.15 $5,955.92 $963.23 $1,020,050.80 $19,949.20 $279,949.20 23 $6,919.15 $5,950.30 $968.85 $1,019,081.95 $20,918.05 $280,918.05 24 $6,919.15 $5,944.64 $974.50 $1,018,107.45 $21,892.55 $281,892.55 25 $6,919.15 $5,938.96 $980.19 $1,017,127.27 $22,872.73 $282,872.73 26 $6,919.15 $5,933.24 $985.90 $1,016,141.36 $23,858.64 $283,858.64 27 $6,919.15 $5,927.49 $991.65 $1,015,149.71 $24,850.29 $284,850.29 28 $6,919.15 $5,921.71 $997.44 $1,014,152.27 $25,847.73 $285,847.73 29 $6,919.15 $5,915.89 $1,003.26 $1,013,149.01 $26,850.99 $286,850.99 30 $6,919.15 $5,910.04 $1,009.11 $1,012,139.90 $27,860.10 $287,860.10 31 $6,919.15 $5,904.15 $1,015.00 $1,011,124.90 $28,875.10 $288,875.10 32 $6,919.15 $5,898.23 $1,020.92 $1,010,103.99 $29,896.01 $289,896.01 33 $6,919.15 $5,892.27 $1,026.87 $1,009,077.11 $30,922.89 $290,922.89 34 $6,919.15 $5,886.28 $1,032.86 $1,008,044.25 $31,955.75 $291,955.75 35 $6,919.15 $5,880.26 $1,038.89 $1,007,005.36 $32,994.64 $292,994.64 36 $6,919.15 $5,874.20 $1,044.95 $1,005,960.42 $34,039.58 $294,039.58 37 $6,919.15 $5,868.10 $1,051.04 $1,004,909.37 $35,090.63 $295,090.63 38 $6,919.15 $5,861.97 $1,057.17 $1,003,852.20 $36,147.80 $296,147.80 39 $6,919.15 $5,855.80 $1,063.34 $1,002,788.86
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

amortization - Sheet1 Garrett Ozar Months 360 Interest Rate...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online