Question: Create a partial amortization schedule for the first two payments on a mortgage of $152,300 at 6.25% that has a monthly payment of $1,005.18 and

Create a partial amortization schedule for the first two payments on a mortgage of $152,300 at 6.25% that has a monthly payment of $1,005.18 and is financed for 25 years?

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Month 1 interest 487700 006 12 243850 Principal portion of 1st payment 292620 24385... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

724-B-F-F-M (3026).docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Jake Drewrey is financing $142,500 for a ten-year fixed-rate mortgage at 5.75%. Create an amortization schedule for the first two payments?

Kaiser Company purchased a building and land with a fair market value of $ 500,000 (building, $ 400,000 and land, $ 100,000) on January 1, 2014. Kaiser signed a 20-year, 6% mortgage payable. Kaiser...

The head office of North Central Ltd. has operated in the western provinces for almost 50 years. North Central uses ASPE. In 2001, new offices were constructed on the same site at a cost of $9.5...

1. Calculate the future value of $9,000 invested (single amount) for ten years in an account with an APR of 6.3%. (Do not round interest rates.) a. If compounded annually? b. If compounded...

1) Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $403,442 5.50% 35 $2166.55 Month Monthly...

Mathematics of Business Management 2 Question 1 the debt is amortized by the periodic payment information below. compute the number of payments required to amortize the debt and the the outstanding...

Purpose This assignment provides you with an opportunity to investigate solving annuity problems and building repayment schedules in Excel. A working knowledge of spreadsheet use is a critical skill...

1) Justin is financing $169,500 for a home at 4.50% interest with a 20-year fixed-rate loan. Find the interest paid and principal paid for each of the first two months of the loan and find the...

A.) Conchita has made a $210,200 loan for a home. Her 22-year fixed-rate loan has an interest rate of 5.75%. Create an amortization schedule for the first two payments. View the table to find the...

#2 MA10078 LOANS & MORTGAGES (1) LUMP SUM PAYMENT. $200,000 mortgage with a 5 year term at 6% compounded semi-annually is amortized for 25 years with monthly payments. The client can put 20% of the...

An airline considers purchasing a new airplane. The purchase requires the company to pay $10 million today. Once taken, the new airplane is expected to deliver $15 million in one year. The interest...

Green Day Hardware company's payroll for November 2017 is summarized below: Amount Subject to Payroll Taxes Unemployment Tax Payroll Factory Sales Administrative Wages Due FICA Federal State $120,000...

The amount of the loss a taxpayer incurs in a sale or exchange of property might equal the excess of the property's cost over the the amount realized for the property. True False

Why do you think that the higher-paid post also carries a range of other benefits?

A $10,000, 14% coupon, 25-year bond issued on June 15, 1984, was purchased on March 20, 1987, to yield 9% to maturity, and then sold on April 20, 1990, to yield the purchaser 11.5% to maturity. What...

A $1000 face value, 7.6% coupon bond pays interest on May 15 and November 15. If its flat price on August 1 was $1065.50, at what price (expressed as a percentage of face value) would the issue have...

A $5000 bond was sold for $4860 (flat) on September 17. If the bond pays $200 interest on June 1 and December 1 of each year, what price (expressed as a percentage of face value) would have been...

2) We expect a return on the market of 9.800% and a risk free rate of 4.900%. Using data over the past five years, we measure the rate of return on Cerigo Olive Oil as 23.565% with a beta of 2.98....

Bennett Company has a potential new project that is expected to generate annual revenues of $250,400, with variabio costs of $138,800, and fixed costs of $57,400. To finance the new project, the...

answer the following Consider the same data as in Question 1, which is used to generate a scatterplot of listings vs sales figures given below. 7500 - 5000 - sales 2500 - 0 - O 10000 20000 30000...