Question: Create an amortization schedule in excel that can project a 360 month self liquidating mortgage including balance, payment, interest and principal payment. Column headings are

Create an amortization schedule in excel that can project a 360 month self liquidating mortgage including balance, payment, interest and principal payment. Column headings are period, beginning balance, payment, interest, principal, ending balance. I believe you know how to calculate payments, interest is prior balance x interest rate /12 and principal is payment - interest. As payments are applied the loan pays down to zero with the last payment. Please create this spreadsheet so that the loan amount and interest rate may be adjusted.

No numbers were given

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 Finance Questions!

Dr. Cheryl Rosenthal is a clinical psychologist. During a session with a client, the client disclosed that he has had violent thoughts about his former spouse and states that he sometimes comes close...

Instruction: Answer all the questions. Each question carries five (10) marks. (5Q10M = 50 MARKS) Question 1. You are required to analyze the Parent company of Raysut Cement Company (S.A.O.G)...

B A Question 1. - 20pts A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a....

I NEED HELP FINDING THE ARM PLEASE!!! WITH THE INFORMATION ABOVE! Wildcat Investment Company, LLC decided to purchase the investment property at 2912 N. Main Street. You have been asked to complete...

I NEED HELP PLEASE! I NEED TO DO AN AMORTIAZTION TABLE USING THE INFORMATION ABOVE!! Wildcat Investment Company, LLC decided to purchase the investment property at 2912 N. Main Street. You have been...

Payroll - Please submit answer in last screenshot format please The Caldwell Company is a retail company that began operations on October 1, 2018, when it Following is the chart of accounts for The...

Amortization Schedules This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan and a constant amortizing (CAM)...

Page of 5 ZOOM + Part I (Total 5 points): Show your solution for the following problem using the Time Value of Money (TVM) Excel function in no more than two cells. The Bank Trust will pay $12,000...

2 Must use Excel Formulas to answer the questions whenever is possible Consider a 10 year mortgage with equal monthly payment. Loan amount $109,200.00 Interest Rate (APR) 3.50% a. What is the monthly...

This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan, and a constant amortizing (CAM) loan. In your report,...

Q(15) You have just taken out a 30-year fixed-rate mortgage for $500,000 at an annual interest rate of 6.5%. Calculate the monthly mortgage payment and create an amortization schedule for the...

Five college seniors with majors in accounting are discussing alternative career plans. The first senior plans to become an internal revenue agent because his primary interest is income taxes. He...

Consider an ideal Rankine cycle using water with a high-pressure side of the cycle at a supercritical pressure. Such a cycle has a potential advantage of minimizing local temperature differences...

A client is usually in what phases of the financial life cycle from approximately age 4 5 to 6 0 or immediately preceding the clients planned retirement date

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...