subject
Business, 23.02.2021 03:30 Margieeee

Amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a $650,000 loan for the condo for twenty years at 7.0% interest. What is the annual payment on the mortgage? Construct the amortization schedule of the loan for the twenty years in a spreadsheet to show the annual interest costs, the principal reduction, and the ending balance each year. Then change the amortization schedule to reflect that after ten years Sherry and Sam will increase their annual payment to $80,000 per year. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal?

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 20:50
Suppose the price of frozen yogurt, a substitute for ice cream, increases. what happens to equilibrium price and quantity of ice cream? a. the price and quantity of ice cream both increase b. the price and quantity of ice cream both decrease c. the price of ice cream increases and the quantity decreases d. the price of ice cream decreases and the quantity increases
Answers: 3
question
Business, 22.06.2019 01:00
Paar corporation bought 100 percent of kimmel, inc., on january 1, 2012. on that date, paar’s equipment (10-year life) has a book value of $420,000 but a fair value of $520,000. kimmel has equipment (10-year life) with a book value of $272,000 but a fair value of $400,000. paar uses the equity method to record its investment in kimmel. on december 31, 2014, paar has equipment with a book value of $294,000 but a fair value of $445,200. kimmel has equipment with a book value of $190,400 but a fair value of $357,000. the consolidated balance for the equipment account as of december 31, 2014 is $574,000. what would be the impact on consolidated balance for the equipment account as of december 31, 2014 if the parent had applied the initial value method rather than the equity method? the balance in the consolidated equipment account cannot be determined for the initial value method using the information given. the consolidated equipment account would have a higher reported balance. the consolidated equipment account would have a lower reported balance. no effect: the method the parent uses is for internal reporting purposes only and has no impact on consolidated totals.
Answers: 2
question
Business, 22.06.2019 10:10
Rats that received electric shocks were unlikely to develop ulcers if the
Answers: 1
question
Business, 22.06.2019 14:20
Anew 2-lane road is needed in a part of town that is growing. at some point the road will need 4 lanes to handle the anticipated traffic. if the city's optimistic estimate of growth is used, the expansion will be needed in 4 years and has a probability of happening of 40%. for the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years respectively. the probability of the pessimistic estimate happening is 20%. the expansion will cost $ 4.2 million and the interest rate is 8%. what is the expected pw the expansion will cost?
Answers: 1
You know the right answer?
Amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,00...
Questions
question
Mathematics, 21.10.2020 22:01
question
Mathematics, 21.10.2020 22:01
question
Mathematics, 21.10.2020 22:01
question
Mathematics, 21.10.2020 22:01
question
Chemistry, 21.10.2020 22:01
question
Mathematics, 21.10.2020 22:01