Question: Create an amortization schedules using the following assumptions: Loan Term - 30 Year ARM Purchase Price $120,000 Down Payment 6% Loan Amount 112,800 Interest Rate

Create an amortization schedules using the following assumptions:
Loan Term - 30 Year ARM
Purchase Price $120,000
Down Payment 6%
Loan Amount 112,800
Interest Rate 11% 15% 13%
Balance @ beginning of the year Year 15 Year 16 Year 25

Please show all the formulas you use so I can understand. 360 months = 30 years

Please use this set up

Month Beginning Loan Balance PMT Interest. Amortization Ending Cash Balance

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!

Q:

find the ending balance of year 15, 16, 20 Create an amortization schedules using the following assumptions: $7,200 $112,800 Term - 30 Year ARM Purchaes Price Down Payment Loan Amount Interest Rate...

Q:

A B D E Create an amortization schedules using the following assumptions: F G Purchaes Price Down Payment Loan Amount Interest Rate Loan Term Balance @ $140,000 5% ???? 11% 30 Year - Fixed End of...

Q:

Create an amortization schedule using the following assumptions: What is the loan amount? Loan term; 25 year - ARM Purchase price: $130,000 Down payment: 5% Interest Rate: Year 1 - 12% Year 2-8%...

Q:

Create an amortization schedule using the following assumptions: What is the loan amount Loan term: 25 year - fixed Purchase price: $130,000 Down payment: 5% Interest rate: 12% O $130,000 O $123,500...

Q:

Hello, I'm working in the Investment Analysis for Real Estate Decisions, 8th edition, on page 228 I need help with #1 and #2 about income tax consequences and before tax cash flow. I put the relevant...

Q:

Calculating the debt-to-income ratio on monthly payments for qualified mortgages must be based on the highest (A O) two years of the mortgage. B O ) three years of the mortgage. (CO) five years of...

Q:

My teacher edited my project with red comments and I am struggling with how to correct those mistakes within my project. The Goldsteins Risk Management and Insurance portfolio Table of Contents Page...

Q:

The next 5 screenshots were provided my the professor to help us. This is what we have come up with. Evaluate the attached proforma information. You need to do a ten year Spreadsheet similar to...

Q:

Excel problem 7-3. I have attached the file with the data required to complete the problem. \f1. Open the MortgageCalc-07 workbook from data files folder. 2. Save the workbook as Excel 7-3. 3. Apply...

Q:

This is one that is similar but much easier then the one from earlier. Let me know if you can do this one. 1. Open the MortgageCalc-07 workbook from data files folder. 2. Save the workbook as Excel...

Q:

Write structures for all compounds with molecular formula C4H6O that would not be expected to exhibit infrared absorption in the 3200-3550-cm-1 and 1620-1780-cm-1 regions.

Q:

Select the correct answer for each of the following questions. Items 1 and 2 are based on the following: On January 2, 20X8, Pare Company acquired 75 percent of Kidd Companys outstanding common stock...

Q:

2.6 TV Time The histogram shows the distribution of selfreported numbers of hours of watching TV per weekend for 60 eighth-grade students. This graph uses a right-hand rule: Someone who watched TV...

Q:

Develop the following elements of the Marketing planning process: for CVS Health Contents must include: A mission statement A SWOT analysis Objectives A description of the target market A positioning...

Q:

Identify the characteristics of people with low and high selfesteem.

Q:

3. When asked for advice for future entrepreneurs, Vickie Stringer said, Be patient, allow room for growth, build your company on a strong accounting system, and as always, dare to dream. How does...

Q:

Define self-esteem and discuss its impact on your life.