can someone help me with 19-23
Module 6 Canvas Homework 115 Points Total Note: you never need to put a negative -) sign in front of any answer! When we ask for a dollar ($) amount, we just want the amount, we don't need to know it's inflow or outflow (1/), as we'll assume this was apparent from the question. A few years out of UCCS you're earning $125,000 and decide to buy a condominium. The one you like will cost $300,000. The bank will require a 15% down payment and will lend you the difference in a 30yr traditional mortgage at an interest rate of 4.800 M) 45000 1 What is the amount of your down payment? 45000 2 What is the amount of the loan? 355000 3 What is your home equity, the day you buy the condominium? 4 What is the monthly payment on the mortgage? 1337.90 What is your taxable income for the first year you own the condominium (.e. what is your salary minus the total interest paid in year 112 1/2 84/505 If your effective tax rate is 25%, how much would you have paid in taxes if you didn't have the mortgage loan and your taxable income was $125,000? 31250. 7 If your effective tax rate is 25%, how much will you pay in taxes on your taxable income from Q5? 8 How much did you save in taxes the first year by owning the condominium 3.038.74 For three years from the day you bought the condo, Colorado real estate contines to climb. Your condo appreciates 4x every year for three years. And, interest rates fall to 3.60%(M). You decide to refinance your mortgage. You can refinance into a new mortgage for (again) 85% of the current market value of the condo. 9 What is the value of your condominium at the end of year three? 337459.20 10 What is the remaining principal balance on your mortgage? 202717.07 11 What is the amount fie new principal balance of the new mortgage loan you take out? 286840.32 12 What is the new monthly payment you'll be making on the new mortgage? 385.43 13 You paid off the original mortgage principal balance, taking out a new mortgage with a higher principal balance, how much cash did you receive after paying off the original mortgage? 28 2. 44, 123.23 1 New even more years have passed a total of ten years since you bought the condo. The real estate market slowed down and then it crushed for the next years, your condo appreciated at 1x per year, but then over building finally caught up with Colorado and in year 10 the housing market fell 20%. You pay a broker a commission to sell the condo. You also have closing costs of $2.500 14 What is the value sale price of your condo at the end of year ten? Hint it's worth less than you paid for it. 86 575, 79 15 In total, how much do you have to pay in broker commissions and closing costs? 16 8 40.90 16 What are your cash proceeds, after you sell the condo and after paying the broker and closing costs? 261,17:20 17 What is the principal balance you owe on the mortgage at the end of year ten? (Hint: be carefu here. It's 10 years since you bought the condo, but you refinanced to a new mtge at the end of year three.. so be careful how many months have passed on this new mortgage?) 186.924 18 You sell the condo, receive cash (question 16) and pay off the mortgage question 17). How much cash do you have left after the sale? 83,057 Now, you wonder, how good of an investment was this conde over these ten years? Let's look at the total economics 19 Recall from 13 that at the end of year three you refinanced your mortgage and you received cash. Now assume you took that cash amount (ie. your answer for Q13) and put it in a savings account earning 3.00XA). What is the value of that account now in year ten fie. 7 years later)? 20 Recall from 18 that you sold the condo at the end of year ten and after paying off the mortgage you had cash leftover. How much cash did you receive fie. what was your answer for 0.15)? What is the total amount of cash in your hands at the end of year ten fie sum of the answers to questions 19 & 20) 22 Recall from Q1 that when you bought the condo ten years ago you had to make a down payment, how much was the original down payment is what was your answer for Q1]? 21 23 You made an initial cash outflow (the down payment, question 22) and ten years later had cash in the bank (total cash, question 21). Your initial investment is PV (a negative number), the final cash back is FV la positive number), and 10 years passed. What was the return each year? In other words, using TVM, solve for annual to three decimal places). 2 Module 6 Canvas Homework 115 Points Total 1 3 4 6 Note: you never need to put a negative (-) sign in front of any answer! When we ask for a dollar ($) amount, we just want the amount, we don't need to know it's inflow or outflow (+/-), as well assume this was apparent from the question A few years out of UCCS you're earning $125,000 and decide to buy a condominium. The one you like will cost $300,000. The bank will require a 15% down payment and will lend you the difference in a 30yr traditional mortgage at an interest rate of 4.800%{M). What is the amount of your down payment? 45000 2 What is the amount of the loan? 255000 What is your home equity, the day you buy the condominium? 45000 What is the monthly payment on the mortgage? 1337.90 o What is your taxable income for the first year you own the condominium (i.e. what is your salary minus the total interest paid in year 112 4 1128415.05 If your effective tax rate is 25%, how much would you have paid in taxes if you didn't have the mortgage loan and your taxable income was $125,000? 31250. If your effective tax rate is 25%, how much will you pay in taxes on your taxable income from Q5? 28211.26 How much did you save in taxes the first year by owning the condominium? 3038.74 For three years from the day you bought the condo, Colorado real estate contindes to climb. Your condo appreciates 4% every year for three years. And, interest rates fall to 3.60%(M). You decide to refinance your mortgage. You can refinance into a new mortgage for (again) 85% of the current market value of the condo. What is the value of your condominium at the end of year three? 337 459,20 What is the remaining principal balance on your mortgage? 2112717.07 11 What is the amount (i.e new principal balance of the new mortgage loan you take out? 286840.32 12 What is the new monthly payment you'll be making on the new mortgage? 1385.43 13 You paid off the original mortgage principal balance, taking out a new mortgage with a higher principal balance, how much cash did you receive after paying off the original mortgage? 44, 123.25 7 8 9 10 14 Now seven more years have passed, a total of ten years since you bought the condo. The real estate market slowed down and then it crashed. For the next 6 years, your condo appreciated at 1% per year, but then over-building finally caught up with Colorado and in year 10 the housing market fell 20%. You pay a broker a 5% commission to sell the condo. You also have closing costs of $2,500 What is the value (sale price) of your condo at the end of year ten? Hint: it's worth less than you paid for it. 86575.79 15 In total, how much do you have to pay in broker commissions and closing costs? 16840.80 16 What are your cash proceeds, after you sell the condo and after paying the broker and closing costs? 869975.20 17 What is the principal balance you owe on the mortgage at the end of year ten? (Hint: be careful here... It's 10 years since you bought the condo, but you refinanced to a new mtge at the end of year three...so be careful: how many months have passed on this new mortgage?) 186.924 You sell the condo, receive cash (question 16) and pay off the mortgage (question 17). How much cash do you have left after the sale? 83,051 Now, you wonder, how good of an investment was this condo over these ten years? Let's look at the total economics. 19 Recall from Q13 that at the end of year three you refinanced your mortgage and you received cash. Now assume you took that cash amount (i.e. your answer for Q13) and put it in a savings account earning 3.00%IA). What is the value of that account now in year ten (i.e. 7 years later)? Recall from 018 that you sold the condo at the end of year ten and after paying off the mortgage you had cash leftover. How much cash did you receive (i.e. what was your answer for Q18)? What is the total amount of cash in your hands at the end of year ten (i.e. sum of the answers to questions 19 & 20). Recall from Q1 that when you bought the condo ten years ago you had to make a down payment, how much was the original down payment (i.e. what was your answer for Q1)? 18 20 21 22 23 You made an initial cash outflow (the down payment, question 22) and ten years later had cash in the bank (total cash, question 21). Your initial investment is PV (a negative number), the final cash back is FV (a positive number), and 10 years passed. What was the return each year? In other words, using TVM, solve for annuali (to three decimal places)
