Rent Vs. Buy Spreadsheet.xlsx - Monthly Expenses Rent Condo...

This preview shows 1 out of 5 pages.

Monthly Expenses Rent Buy Rent $ 3,000.00 $ - Condo Fees $ - $ 1,055.00 Property Taxes $ - $ 300.00 Maintenance $ - $ 50.00 Monthly Mort. Payment $ - $ 2,533.62 Total Monthly Expenses $ 3,000.00 $ 3,938.62 Difference of Own vs. Rent (monthly) $ 938.62 Difference of Own vs. Rent (annual) $ 11,263.44 Present Value $ 120,000.00 Interest Rate 4.00% Compounding Periods per Year 12 1 2 Future Value of 20% Down Payment if left Invested $124,888.99 $129,977.16 Future Value of Own vs. Rent Annual Opportunity Cost $11,722.33 $12,199.92 Combined Value $136,611.32 $142,177.07 Potential Gain on Investment $16,611.32 $22,177.07 Years - Gain on sale / (Los Condo Resale Scenarios 2 5 a) Price Remains Unchanged $ - $ - $ (60,000.00) $ - c) 2 % increase per year over 10 years $ 24,240.00 $ 62,448.48 d) 5% increase per year over 10 years $ 61,500.00 $ 165,768.94 b) Condo Price drops 10% over 2 years, regains value at 5 Years, and increases 10% at 10 years
Image of page 1

Subscribe to view the full document.

Years 3 4 5 6 7 8 9 $135,272.62 $140,783.84 $146,519.59 $152,489.03 $158,701.66 $165,167.41 $171,896.59 $12,696.96 $13,214.25 $13,752.62 $14,312.92 $14,896.06 $15,502.94 $16,134.56 $147,969.58 $153,998.09 $160,272.21 $166,801.95 $173,597.72 $180,670.36 $188,031.15 $27,969.58 $33,998.09 $40,272.21 $46,801.95 $53,597.72 $60,670.36 $68,031.15 ss on sale) 10 $ - $ 60,000.00 $ 131,396.65 $ 377,336.78
Image of page 2
10 $178,899.92 $16,791.90 $195,691.83 $75,691.83
Image of page 3

Subscribe to view the full document.

$ 480,000.00 Payment # Payment Principal Interest Balance 1 $ 2,533.62 $ 933.62 $ 1,600.00 $ 479,066.38 2 $ 2,533.62 $ 936.73 $ 1,596.89 $ 478,129.65 3 $ 2,533.62 $ 939.85 $ 1,593.77 $ 477,189.79 4 $ 2,533.62 $ 942.99 $ 1,590.63 $ 476,246.81 5 $ 2,533.62 $ 946.13 $ 1,587.49 $ 475,300.68 6 $ 2,533.62 $ 949.28 $ 1,584.34 $ 474,351.39 7 $ 2,533.62 $ 952.45 $ 1,581.17 $ 473,398.94 8 $ 2,533.62 $ 955.62 $ 1,578.00 $ 472,443.32 9 $ 2,533.62 $ 958.81 $ 1,574.81 $ 471,484.51 10 $ 2,533.62 $ 962.00 $ 1,571.62 $ 470,522.50 11 $ 2,533.62 $ 965.21 $ 1,568.41 $ 469,557.29 12 $ 2,533.62 $ 968.43 $ 1,565.19 $ 468,588.86 13 $ 2,533.62 $ 971.66 $ 1,561.96 $ 467,617.21 14 $ 2,533.62 $ 974.90 $ 1,558.72 $ 466,642.31 15 $ 2,533.62 $ 978.15 $ 1,555.47 $ 465,664.17 16 $ 2,533.62 $ 981.41 $ 1,552.21 $ 464,682.76 17 $ 2,533.62 $ 984.68 $ 1,548.94 $ 463,698.08 18 $ 2,533.62 $ 987.96 $ 1,545.66 $ 462,710.12 19
Image of page 4
Image of page 5
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern