Julianne has her eyes on a cozy apartment, in a good location, currently on the market for $300,000 Owning an apartment is part of her dream, and she already knows in what colors to paint the walls and how to furnish it If they take a mortgage, the $1200 rent they pay today could accumulate instead as equity on their own place Her family is willing to lend the down payment, as long as Julianne and Thomas will pay back the loan in monthly payments over the next five years, with 2 interest, same as the rate on a savings deposit A friend that purchased a similar apartment had to put down 20 and was quoted 4 for a 30 year mortgage Thomas, on the other hand, is less open to the idea of buying He thinks that the mortgage rates plus the $200 strata fees may be a bit too much for the moment and will hinder other plans they may have down the road Also, he just read in a newspaper article that economists expect apartment prices to fall about 15 in the next five years Juliannes monthly net income is $3016, Thomas is $2940 and both incomes can be assumed constant for the next five years One big concern for both is paying back the debt they have accumulated this far Julianne has $16,000 in student loans remaining, for which she will make monthly payments at 4 5 interest quarterly compounded, for 2 more years Thomas has made a couple of un optimal spending decisions and has now about $20,000 in a student loan with similar interest rates as Juliannes, which he will pay in the next 36 months He also has about $7,500 in credit card debt, at 9 compounded monthly, which he plans to pay in the next 3 years as well Their average monthly household expenses are $2000 (not including rent or debt payments), and they think these expenses will be constant in long run A phone call brings Julianne back from her thoughts She knows that simply debating with Thomas would not lead anywhere, and she needs some hard numbers to show that it would make financial sense to buy an apartment As all the payments are per month, and different loans have different compounding periods, what is the effective monthly interest for each loan Build a table to show, month by month for the next five years (60 months) , the familys income after expenses and debt, before the rent payment Julianne Thomas House Julianne Thomas Thomas Income Month Income Income Expenses Student Loan Student Loan Credit Card Before Rent 1 2 If they keep renting for the next five years, and save everything left, how much money will they have after 5 years of monthly savings Show the cumulative savings, month by month, by adding these two more columns to the table Remember to include the compounding for these savings, not just add them Scenario 1 Rent Rent Cumulative Savings If instead the couple purchases the apartment, thus every month they pay mortgage, strata, pay back the down payment loan, what will be their cumulative savings every month And at the end of five years (hint dont forget to compound savings every month) Julianne hopes to travel to Europe next summer and estimates the trip will cost about $3500 How long it will take to save this amount if they indeed buy the apartment Would they afford the trip next year Scenario 2 Buy Mortgage Strata Down payment Cumulative Savings As shown in class, build a mortgage amortization table for the next five years How much principal do they still have to pay after five years Mortgage Schedule of Payments Month Principal begin PMT Interest Principal end 1 2 3 So far, you should have a table with 60 lines (months) and cumulative savings in each scenario Assuming they do not take the trip, and that the value of the apartment stays the same, how much equity do they have in the apartment after five years if they buy In which scenario do they have more wealth (Cumulative savings in scenario 1 vs (cumulative savings apt equity) in scenario 2) Assuming that the estimation of a 15 decrease in apartment value is trustworthy, how much equity do they have in the apartment after five years Should the couple proceed with the buy or should wait At what percent decrease in the apartment value would both options (buy or rent) lead to the same total wealth in five years (thus they would be indifferent between rent or buy)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 07, 2024

Julianne has her eyes on a cozy apartment, in a good location, currently on the market for $300,000. Owning an apartment is part of her

Julianne has her eyes on a cozy apartment, in a good location, currently on the market for $300,000. Owning an apartment is part of her dream, and she already knows in what colors to paint the walls and how to furnish it. If they take a mortgage, the $1200 rent they pay today could accumulate instead as equity on their own place. Her family is willing to lend the down payment, as long as Julianne and Thomas will pay back the loan in monthly payments over the next five years, with 2% interest, same as the rate on a savings deposit. A friend that purchased a similar apartment had to put down 20% and was quoted 4% for a 30-year mortgage. Thomas, on the other hand, is less open to the idea of buying. He thinks that the mortgage rates plus the $200 strata fees may be a bit too much for the moment and will hinder other plans they may have down the road. Also, he just read in a newspaper article that economists expect apartment prices to fall about 15% in the next five years.

Juliannes monthly net income is $3016, Thomas is $2940 and both incomes can be assumed constant for the next five years. One big concern for both is paying back the debt they have accumulated this far. Julianne has $16,000 in student loans remaining, for which she will make monthly payments at 4.5% interest quarterly compounded, for 2 more years. Thomas has made a couple of un-optimal spending decisions and has now about $20,000 in a student loan with similar interest rates as Juliannes, which he will pay in the next 36 months. He also has about $7,500 in credit card debt, at 9% compounded monthly, which he plans to pay in the next 3 years as well. Their average monthly household expenses are $2000 (not including rent or debt payments), and they think these expenses will be constant in long run.

A phone call brings Julianne back from her thoughts. She knows that simply debating with Thomas would not lead anywhere, and she needs some hard numbers to show that it would make financial sense to buy an apartment.

As all the payments are per month, and different loans have different compounding periods, what is the effective monthly interest for each loan?

Build a table to show, month by month for the next five years (60 months), the familys income after expenses and debt, before the rent payment.

	Julianne	Thomas	House	Julianne	Thomas	Thomas	Income
Month	Income	Income	Expenses	Student Loan	Student Loan	Credit Card	Before Rent
1
2

If they keep renting for the next five years, and save everything left, how much money will they have after 5 years of monthly savings? Show the cumulative savings, month by month, by adding these two more columns to the table. Remember to include the compounding for these savings, not just add them.

Scenario 1: Rent
Rent	Cumulative Savings

If instead the couple purchases the apartment, thus every month they pay mortgage, strata, pay back the down payment loan, what will be their cumulative savings every month? And at the end of five years? (hint: dont forget to compound savings every month). Julianne hopes to travel to Europe next summer and estimates the trip will cost about $3500. How long it will take to save this amount if they indeed buy the apartment? Would they afford the trip next year?

Scenario 2: Buy
Mortgage	Strata	Down-payment	Cumulative Savings

As shown in class, build a mortgage amortization table for the next five years. How much principal do they still have to pay after five years?

Mortgage Schedule of Payments
Month	Principal begin	PMT	Interest	Principal end
1
2
3

So far, you should have a table with 60 lines (months) and cumulative savings in each scenario. Assuming they do not take the trip, and that the value of the apartment stays the same, how much equity do they have in the apartment after five years if they buy? In which scenario do they have more wealth? (Cumulative savings in scenario 1 vs (cumulative savings + apt equity) in scenario 2)

Assuming that the estimation of a 15% decrease in apartment value is trustworthy, how much equity do they have in the apartment after five years? Should the couple proceed with the buy or should wait?

At what percent decrease in the apartment value would both options (buy or rent) lead to the same total wealth in five years? (thus they would be indifferent between rent or buy)