Make a single payment of principal and interest at the end

Reference no: EM13188954

You have decided to purchase a small tract of land for building a new home on the outskirts of town. You have some money available but need a loan of $18,000 to make the purchase. The land will be owner-financed over 4 years with end-of-year payments. The interest rate is 9 percent. Develop an Excel table to illustrate the payment amounts and scedule for the loan, assuming paycheck payback follows:

a.) Method 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.
b.) Method 2: Make equal prinicipal payments, plus interest on the unpaid balance at the end of the period.
c.) Method 3: Make equal end-of-period payments.
d.) Method 4: Make a single payment of principal and interest at the end of the loan period.
e.) A different method: Pay $3000 principal at the end of the first year, the $4000, $5000, and $6000 at the end of years 2, 3, 4, plus the accumulated interest at the end of each interest period.

Reference no: EM13188954

Questions Cloud

How to respond to a customer complaint : Write a letter that is no longer than 2 pages that responds to a customer complaint. You can either imagine that your company has received a complaint from a customer or client about a product, policy, or service, or you can work from a real life ..

Abbreviations in medical terminology : You are the office manager for a large physician practice. There are registered nurses, physician assistants, laboratory technicians, and X-ray technicians who also work in the office.

Illustrate the payment amounts and schedule for the loan : J&J Cattle has purchased a quarter section of land for $160,000. They make a down payment of $20,000, and the remainder of the purchase price ($140,000) is financed at 12 percent compounded quarterly with quarterly payments over 2 years.

Explain how music and culture influence one another : Explain how music and culture influence one another. Provide an example of a song or album that affected culture. Provide examples of songs with cultural references

Make a single payment of principal and interest at the end : You have decided to purchase a small tract of land for building a new home on the outskirts of town. You have some money available but need a loan of $18,000 to make the purchase. The land will be owner-financed over 4 years with end-of-year payme..

What will the fund amount to after 7 years : Semiannual deposits, beginning with $500 and increasing by $100 with each subsequent deposit, are made into a fund paying a nominal 10 percent per year compounded continuously. What will the fund amount to after 7 years

Determine who is attending conferences and events : Determine who is attending conferences and events. This will promote fostering relationships and ensure coverage of conferences that are considered of high importance.

Influence on the growth of psychology : Psychology has a long past, but a short history. What do you think this means? In your opinion, which person or perspective has had the most influence on the growth of psychology?

What was the growth rate of real gdp from 1999 to 2009 : Year Nominal GDP (in billions) GDP Deflator data (base year 2005) 2009 $14,256 109.8 1999 $9,353 86.8 What was real GDP in 1999 measured in 2005 prices? Round your answer to the nearest cent. What was the growth rate of real GDP from 1999 to 2009? R..

User Account

All Pages