if i could get help on question 14-18 please

i need help on 19-23 please

whats incomplete?

is this enough information?

14 15 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. In total, how much do you have to pay in broker commissions and closing costs? 16 What are your cash proceeds, after you sell the condo and after paying the broker and closing costs? 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?) You sell the condo, receive cash (question 16) and pay off the mortgage (question 17). How much cash do you have left 18 after the sale? mer thace ten years? Let's look at the total economics Module 6 Canvas Homework 115 Points Total Note: you never need to put a negative (1) sign in front of any answert When we ask for a dollar ($) amount, we just want the amount, we don't need to know it's inflow or outflow()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.800X(M) 1 2 What is the amount of your down payment? 45000 What is the amount of the loan? 2 25 5000 What is your home equity, the day you buy the condominium? 3 45 000 4 What is the monthly payment on the mortgage? 1337.90 3 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 112845.05 6 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 QS? 28211.36 8 How much did you save in taxes the first year by owning the condominium? 3038.79 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. 11 9 What is the value of your condominium at the end of year three? 337 459,20 10 What is the remaining principal balance on your mortgage? 242717.07 What is the amount (ie 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 m cash did you receive after paying off the original mortgage? 44, 123.25 19 20 3, Now, you wonder, how good of an investment was this condo over these ten years? Let's look at the total economics. 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%(A). 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)? 21 What is the total amount of cash in your hands at the end of year ten (ie 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 (i.e. what was your answer for Q1)? 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). Now seven more years have passed, a total of ten years since you bought the condo. The real estate then it crashed. For the next 6 years, your condo appreciated at 1% per year, but then over building fu Colorado and in year 10 the housing market fell 20%. You pay a broker a 5% commission to sell the co costs of $2,500 14 15 17 What is the value (sale price) of your condo at the end of year ten? Hint: it's worth less than yo 286575.79 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 cm 269,975.20 What is the principal balance you owe on the mortgage at the end of year ten? (Hint: be careful you bought the condo, but you refinanced to a new mtge at the end of year three... so be careful passed on this new mortgage?) 186.924 18 You sell the condo, receive cash (question 16) and pay off the mortgage (question 17). How mue 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 to Recall from Q13 that at the end of year three you refinanced your mortgage and you received ca that cash amount (i.e. your answer for Q13) and put it in a savings account earning 3.00%(A). W account now in year ten (i.e. 7 years later)? 19 21 20 Recall from Q18 that you sold the condo at the end of year ten and after paying off the mortgage 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 22 Recall from Q1 that when you bought the condo ten years ago you had to make a down paymen original down payment (i.e. what was your answer for Q1)? You made an initial cash outflow (the down payment, question 22) and ten years later had cash i question 21). Your initial investment is PV (a negative number), the final cash back is FV (a positiv passed. What was the % return each year? In other words, using TVM, solve for annuall(to thre 23 16 269,975: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 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, 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%(A). What is the value of that account now in year ten (i.e. 7 years later)? Recall from Q18 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)? 20 21 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). 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 (i.e. what was your answer for Q1)? 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). 14 15 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. In total, how much do you have to pay in broker commissions and closing costs? 16 What are your cash proceeds, after you sell the condo and after paying the broker and closing costs? 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?) You sell the condo, receive cash (question 16) and pay off the mortgage (question 17). How much cash do you have left 18 after the sale? mer thace ten years? Let's look at the total economics Module 6 Canvas Homework 115 Points Total Note: you never need to put a negative (1) sign in front of any answert When we ask for a dollar ($) amount, we just want the amount, we don't need to know it's inflow or outflow()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.800X(M) 1 2 What is the amount of your down payment? 45000 What is the amount of the loan? 2 25 5000 What is your home equity, the day you buy the condominium? 3 45 000 4 What is the monthly payment on the mortgage? 1337.90 3 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 112845.05 6 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 QS? 28211.36 8 How much did you save in taxes the first year by owning the condominium? 3038.79 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. 11 9 What is the value of your condominium at the end of year three? 337 459,20 10 What is the remaining principal balance on your mortgage? 242717.07 What is the amount (ie 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 m cash did you receive after paying off the original mortgage? 44, 123.25 19 20 3, Now, you wonder, how good of an investment was this condo over these ten years? Let's look at the total economics. 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%(A). 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)? 21 What is the total amount of cash in your hands at the end of year ten (ie 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 (i.e. what was your answer for Q1)? 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). Now seven more years have passed, a total of ten years since you bought the condo. The real estate then it crashed. For the next 6 years, your condo appreciated at 1% per year, but then over building fu Colorado and in year 10 the housing market fell 20%. You pay a broker a 5% commission to sell the co costs of $2,500 14 15 17 What is the value (sale price) of your condo at the end of year ten? Hint: it's worth less than yo 286575.79 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 cm 269,975.20 What is the principal balance you owe on the mortgage at the end of year ten? (Hint: be careful you bought the condo, but you refinanced to a new mtge at the end of year three... so be careful passed on this new mortgage?) 186.924 18 You sell the condo, receive cash (question 16) and pay off the mortgage (question 17). How mue 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 to Recall from Q13 that at the end of year three you refinanced your mortgage and you received ca that cash amount (i.e. your answer for Q13) and put it in a savings account earning 3.00%(A). W account now in year ten (i.e. 7 years later)? 19 21 20 Recall from Q18 that you sold the condo at the end of year ten and after paying off the mortgage 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 22 Recall from Q1 that when you bought the condo ten years ago you had to make a down paymen original down payment (i.e. what was your answer for Q1)? You made an initial cash outflow (the down payment, question 22) and ten years later had cash i question 21). Your initial investment is PV (a negative number), the final cash back is FV (a positiv passed. What was the % return each year? In other words, using TVM, solve for annuall(to thre 23 16 269,975: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 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, 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%(A). What is the value of that account now in year ten (i.e. 7 years later)? Recall from Q18 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)? 20 21 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). 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 (i.e. what was your answer for Q1)? 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)