(Annuity payments) Mr. Bills Preston, Esq., purchased a new house for $280,000. He paid $80,000 up...

(Annuity payments) Mr. Bills Preston, Esq., purchased a new house for $280,000. He paid $80,000 up front on the down payment and agreed to pay the rest over the next 25 years in 25 equal annual payments that include principal payments plus 6.2 percent compound interest on the unpaid balance.

What will these equal payments be?
Show on a spreadsheet how the loan will be paid off

Expert Solution

jeff jeffy answered 8 months ago

(Annuity payments) Mr. Bill S. Preston, Esq., purchased a new house for $100,000. He paid $15,000...

(Annuity payments) Mr. Bill S. Preston, Esq., purchased a new house for $100,000. He paid $15,000 upfront and agreed to pay the rest over the next 25 years in 25 equal annual payments that include principal payments plus 8 percent compound interest on the unpaid balance. What will these equal payments be? Mr. Bill S. Preston, Esq., purchased a new house for $100,000 and paid $15,000 upfront. How much does he need to borrow to purchase the house?

Mr. Bill S. Preston, Esq., purchased a new house for $120,000. He paid $30,000 upfront and...

Mr. Bill S. Preston, Esq., purchased a new house for $120,000. He paid $30,000 upfront and agreed to pay the rest over the next 10 years in 10 equal annual payments that include principal payments plus 8 percent compound interest on the unpaid balance. What will these equal payments be? a. Mr. Bill S. Preston, Esq., purchased a new house for $120,000 and paid $30,000 upfront. How much does he need to borrow to purchase the house?

Mr. Wilson’s house as purchased fir $280,000 five years ago and worth $300,000 now, and his...

Mr. Wilson’s house as purchased fir $280,000 five years ago and worth $300,000 now, and his mortgage was $260,000 and amortized over 25 years, at four percent interest, compounded semi-annuallu, what is his equity in the house now? ( To the nearest $1000)(show you calculation - You must assume monthly mortgage payment frequency; hint, and use amortization schedule)

John purchased a new house for $500,000. He paid 20 percent down and agreed to pay...

John purchased a new house for $500,000. He paid 20 percent down and agreed to pay the rest over the next 25 years in 25 equal annual payments at 6 percent compound interest. What will be his annual payments?

financial management principles. . Bill S.Preston purchased a new house for $100,000. He paid $20,000 upfront...

financial management principles. . Bill S.Preston purchased a new house for $100,000. He paid $20,000 upfront on the down payment and agreed to pay the rest over the 25 years in 25 equal annual payments that include principal payments plus 8 percent compound interest on the unpaid balance. What will these equal payments be? What is the present value of an annuity of $90 received at the beginning of each year for the next six years? The first payment will...

Christina purchased an annuity from an insurance company. Christina paid $156,300 for the annuity, and in...

Christina purchased an annuity from an insurance company. Christina paid $156,300 for the annuity, and in exchange she will receive $20,100 per year for the next 10 years. How much of the first $20,100 payment should Christina exclude from gross income?_________ Please explain how you got each number in your solution and/or where the number comes from.

A car was purchased for bills enterprice in the amount of 18,000: 20% was paid in...

A car was purchased for bills enterprice in the amount of 18,000: 20% was paid in cash and a promissory note was signed for the remaining balance how would I make a journal entry of this?

James moved to a new house so he rented his old home to Mr. Parker for...

James moved to a new house so he rented his old home to Mr. Parker for two years. Later the old house caught fire and had a $100,000 loss. The old house was valued at $400,000 and James had a $300,000 homeowner's insurance policy with an 80% coinsurance. How much will insurance company pay for his loss?

Preston, Alex and George recently purchased a house together, and each person bought their own insurance...

Preston, Alex and George recently purchased a house together, and each person bought their own insurance policy on the house. Preston bought $200,000 of coverage, Alex bought $200,000 of coverage, and George bought $100,000 of coverage. The day after they purchased their insurance policies, George’s electric guitar stereo shorted out and started a fire. The resulting damage totaled $40,000. How much of the loss did George's insurance company pay, assuming that all three policies contained pro?rata clauses? 16,000 24,000 40,000...

A company has a loan of 80,000 to be paid I 20 annual level payments. The...

A company has a loan of 80,000 to be paid I 20 annual level payments. The interest and the principal repayment in the 13th payment are the same. Find the amount of principal repaid in the 6th payment. Use formulas of loans.

Question