Question: Construct an amortization schedule for a 30-year, $300,000 loan with a 2.7% interest rate compounded monthly. The loan will be paid back in 30 years

Construct an amortization schedule for a 30-year, $300,000 loan with a 2.7% interest rate compounded monthly. The loan will be paid back in 30 years making monthly payments. You need to calculate the principal payment and interest payment, respectively, of each month. Hint: Please refer to the excel file of "Loan Amortization "posted in Unit 4 "Lecture". Specifically, you need to update the model from "yearly" payment to "monthly" mortgage payment. 30 years *12 = 360 payments. Therefore, you should demonstrate 360 principal payments and interest payments for each month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Selected information from the Iowa Instruments accounting records for April follows: Materials Inventory Debit Credit BB (4/1) 25,000 209,000 174,000 Work-in-Process Inventory Debit Credit Labor...

Download A Alternativ class. You must provide me with an Excel file that has 4 tabs. You may use the CH 17 Excel file as a basis for the file that you e-mail to me. The file should be e-mailed by...

Unit 1 5 . 3 Amortization with a financial calculator 1 5 . Assume you get a 2 5 - year $ 1 3 0 , 0 0 0 mortgage loan at 6 . 5 % interest. Use your financial calculator to determine ( a ) your...

Use this information for problems 1 and 2. You are taking out a student loan to pay for college. The loan charges a 2.85% interest rate, compounded monthly. 1. If you want to pay the loan off by...

On the fourth tab build the full amortization table for a 30 year Graduated Payment Mortgage (GPM) Loan with a 6.5% interest rate compounded monthly. The initial loan amount should be $1,500,000....

Home Loan (B) (30 points) Knowing that you have studied amortization schedules at Illinois Tech, your parents are seeking your advice. Exactly fourteen years ago today they obtained a $320,000,...

what about now plz say that is clear Oh Ganh M Share Comments I CRAPAT GT MIG SECOND File Home Insert Page Layout Form Date Www H & Auto Be France Totalb M M Tine Me Tigcom O Studente Mortgage...

Construct an amortization schedule for a 30-year, $400,000 loan with a 6.5% interest rate compounded monthly. The loan will be paid back in 30 years making monthly payments. You need to calculate the...

business law For the year ended 30 June 2012, the audit team included a manager, two supervisors, two qualified seniors and three trainees. This audit, which lasted approximately five weeks, was very...

Use Wal-Mart's financial statements to compute the following ratios (20-31) for the year ended January 31, 2013. 20. Current ratio . 83 . .97 C 65 D. 50 21. Acid-test (quick) ratio A. .10 . .15 . 20...

Instructions 10 POINTS Module 5 Homework: Project Analysis Assignment Loan Amortization and Time Value of Money calculations help managers evaluate the best use of the funds for which they have...

A 40-year-old woman has had a 10-kg weight loss accompanied by severe nausea and vomiting of blood for the past 8 months. On physical examination, she is afebrile. Her pulse is 91/min, respirations...

Why would management be interested in the revision of probabilities?

10. Vitamin E is an antioxidant and a useless food supplement if and only if it does not reduce heart disease. It is not the case either that vitamin E does not reduce heart disease or is not an...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....