Illustrate the payment amounts and schedule for the loan

Reference no: EM13188956

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. Develop an Excel table to illustrate the payment amounts and schedule for the loan, assuming payback as follows:

a.) Method 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the load period.
b.) Method 2: Make equal principal 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.

Reference no: EM13188956

Questions Cloud

What will happen to the price of premium coffee : Assume initially that the demand and supply for premium coffees (one-pound bags) are in equilibrium. Now assume Starbucks introduces the world to premium blends, and so demand rises substantially. Describe what will happen in this market as it moves ..

How can the hr function define its mission and market : How can the HR function define its mission and market? Why is that important? What are some of the cultural differences that might exist in different countries. Can anyone give an example? How can knowing about these differences help us to operate mo..

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.

User Account

All Pages