Calculate the quarterly payment

Assignment Help Financial Accounting

Reference no: EM131290279

College students graduating from US universities often have accumulated $25,000 in loans. In recent years, the annual interest rate on those loans has been about 5% compounded quarterly. A common repayment plan is to pay the money back over 10 years.

(a) Calculate the quarterly payment.

(b) Create an amortization table with Payment in the 1st column, Principal Before Payment in the 2nd column, Interest Payment in the 3rd column, Paid On Principal in the 4th column, and Principal After Payment in the 5th column. Use the amortization table to determine the total amount paid on the loan and the amount paid on interest.

HINT** Excel format is needed and all formulas must be shown to get credit for work**

Reference no: EM131290279

Questions Cloud

Difference between incremental and breakthrough innovation : What is the difference between incremental innovation and breakthrough innovation? Define, discuss, and give examples of each. 1 page minimum.

What is the amount of marshas taxable income : Marsha Brady, a lawyer, who is single, operates a small pottery business in her spare time. During 2016, she reported the following income and expenses from this activity which is classified as a trade or business. What is the amount of Marsha's taxa..

Do these results support the agency cost/contracting model : Which of the two firms appears to have more high-growth, positive-NPV investment opportunities? Which pays the higher relative dividend? Do these results support the agency cost/contracting model? The signaling model?

Focus on the article developing your global know-how : Just write two pages focus and summary on the article "Developing Your Global Know-How" by Siegfried Russwurm, Luis Hernández, Susan Chambers, and Keumyong Chung.

Calculate the quarterly payment : College students graduating from US universities often have accumulated $25,000 in loans. In recent years, the annual interest rate on those loans has been about 5% compounded quarterly. A common repayment plan is to pay the money back over 10 years...

What is the importance of archiving and preserving the film : How did World War II impact the film industry and films in general?Compare and contrast two films from different traditions/cultures that engage with similar material (storyline, plot, characters, genre, etc.).

Determine the number of actual labor-hours spent : The auto repair shop of Quality Motor Company uses standards to control the labor time and labor cost in the shop. The standard labor cost for a motor tune-up is given below: Job Standard Hours Standard Rate Standard Cost Motor tune-up 2.50 $4.50 $11..

Decide to form a partnership : Jerry Graves and Bonnie Moss decide to form a partnership. Graves will contribute $300,000 to the partnership, while Moss will contribute only $30,000. However, Moss will be responsible for running the day-to-day operations of the partnership, which ..

Abundance of electronic documents and means : Do you think printers are becoming obsolete with the abundance of electronic documents and means to view them? How well do you think an organization could function without printers? What are the pros and cons of such a scenario?

User Account

All Pages