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 21:00
Identifying transactions national park tours co. is a travel agency. the nine transactions recorded by national park tours during may 2019, its first month of operations, are indicated in the following t accounts: cash (1) 75,000 (2) 900 (7) 8,150 (3) 1,600 (4) 6,280 (6) 2,700 (9) 2,500 accounts receivable (5) 12,300 (7) 8,150 supplies (2) 900 (8) 660 equipment (3) 8,000 accounts payable (6) 2,700 (3) 6,400 beth worley, capital (1) 75,000 beth worley, drawing (9) 2,500 fees earned (5) 12,300 operating expenses (4) 6,280 (8) 660 indicate for each debit and each credit (a) whether an asset, liability, owner's equity, drawing, revenue, or expense account was affected and (b) whether the account was increased (+) or decreased account debited account credited transaction type effect type effect (1) (2) (3) (4) (5) (6) (7) (8) (9)
Answers: 3
question
Business, 21.06.2019 23:30
Minneapolis federal reserve bank economist edward prescott estimates the elasticity of the u.s. labor supply to be 3. given this elasticity, what would be the impact of funding the social security program with tax increases on the number of hours worked and on the amount of taxes collected to fund social security?
Answers: 2
question
Business, 22.06.2019 12:30
Provide an example of open-ended credit account that caroline has. caroline blue's credit report worksheet.
Answers: 1
question
Business, 22.06.2019 17:40
Take it all away has a cost of equity of 11.11 percent, a pretax cost of debt of 5.36 percent, and a tax rate of 40 percent. the company's capital structure consists of 67 percent debt on a book value basis, but debt is 33 percent of the company's value on a market value basis. what is the company's wacc
Answers: 2
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
English, 21.05.2021 16:40
question
Mathematics, 21.05.2021 16:40
Questions on the website: 13722360