Question

In: Accounting

Mortgage Payable The following amortization schedule can be used for the January, 20x3 mortgage payment on...

Mortgage Payable

The following amortization schedule can be used for the January, 20x3 mortgage payment on the 7.0%, 30- year mortgage.

Month

Payment

Interest

Principal

Balance

January

$3,500

$1,867

$1,633

$320,000

$318,367

Jan 31 The monthly payment for January of the mortgage payable was made.

Required:

What is the correct journal entry for this transaction and why?

Expert Solution

Date	Account Titles and Explanation	Debit	Credit
Jan-31	Interest expense	$ 1,867
	Mortgage Payable	$ 1,633
	Cash		$ 3,500
	(Being Mortgage payable recorded)

	Total Amount payable	=	$ 3,500

	Interest Expense	=	$ 1,867
	Principal repaid	=	$ 1,633
	Total Amount payable	=	$ 3,500

ekkarill92 answered 1 year ago

5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of...

5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage? Be sure to have a zero balance at the end of amortization. Loan Amount 180,576 Loan Length in months 240 Interest (APR) 4.250% Total interest payment Hint: Be sure to compute the total interest payments using "Sum()" function. Prepayment $150 Total # of pmts with prepay With the prepayments,...

A partial amortization schedule for a 10-year note payable issued on January 1, Year 1, is...

A partial amortization schedule for a 10-year note payable issued on January 1, Year 1, is shown next: Accounting Period Principal Balance January 1 Cash Payment Applied to Interest Applied to Principal Year 1 $ 370,000 $ 52,680 $ 25,900 $ 26,780 Year 2 343,220 52,680 24,025 28,655 Year 3 314,565 52,680 22,020 30,660 Required a. Using a financial statements model like the one shown next, record the appropriate amounts for the following two events: (1) January 1, Year 1,...

What is the amortization schedule for a mortgage of $1,600,000 in with 1). an initial ten...

What is the amortization schedule for a mortgage of $1,600,000 in with 1). an initial ten year fixed rate of 6.5%; twenty year amortization (monthly); ballooning at the end of the tenth year; and 2) Second ten year rate "capped" at 7.5%; monthly amortization over the remaining ten years on the balance rolled-over from #1.

Prepare an amortization table for the calculation of interest and payment of the Document payable to...

Prepare an amortization table for the calculation of interest and payment of the Document payable to a natural person, for $ 2,000,000 at the annual rate of 12%, payable in 3 years. The interest plus the payment of the document will be made at the end of the 3 years. Calculate with simple interest and also calculate cost with compound interest

Create a loan amortization schedule in Excell for a $275,000 mortgage that will be repaid over...

Create a loan amortization schedule in Excell for a $275,000 mortgage that will be repaid over 20 years with monthlypayments. The annual interest rate is 5.5 %. What is your monthly payment? $ What is the total dollar amount of payments made over the life of this loan? $__ What is the total dollar amount of interest paid over the life of this loan? $_ How many months will it take to pay off the loan if you pay an extra $100...

In excel, Produce the amortization schedule for a $800K mortgage at 10 years with a rae...

In excel, Produce the amortization schedule for a $800K mortgage at 10 years with a rae of 3.25 percent / year. Provide a column for labels and the excel functions used.

Constant Amortizing Mortgage Create an amortization schedule and answer the following questions for a $600,000 30-year...

Constant Amortizing Mortgage Create an amortization schedule and answer the following questions for a $600,000 30-year fully-amortizing CAM loan with monthly payments. The contract interest rate on the loan is 3.25% and there are no points associated with the loan. a.) Assuming no upfront fees/points or prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 7? b.) Assuming 1 point in origination fees but no prepayment penalty, what is the EIR...

Loan Amortization Schedule, $80,000,000 at 8% for 15 years Year Beginning Amount Payment Interest Payment of...

Loan Amortization Schedule, $80,000,000 at 8% for 15 years Year Beginning Amount Payment Interest Payment of Principal Ending Balance 1 $ 80,000,000.00 $ 1,933.28 $ 533,333.33 $ (531,400.05) $ 80,531,400.05 2 $ 80,531,400.05 $ 1,933.28 $ 536,876.00 $ (534,942.72) $ 81,066,342.77 3 $ 81,066,342.77 $ 1,933.28 $ 540,442.29 $ (538,509.01) $ 81,604,851.78 4 $ 81,604,851.78 $ 1,933.28 $ 544,032.35 $ (542,099.07) $ 82,146,950.84 179 $ 260,404,969.06 $ 1,933.28 $ 1,736,033.13 $ (1,734,099.85) $ 262,139,068.91 180 $ 262,139,068.91 $ 1,933.28 $ ...

Prepare an amortization schedule (monthly) for a 30yr mortgage on a building that costs $280,000. 20%...

Prepare an amortization schedule (monthly) for a 30yr mortgage on a building that costs $280,000. 20% down was required to get at an APR of 5%, the rest of the cost was financed. Compare the principle balance and the interest in the first, second, fifth, tenth, twentieth, and thirtieth year. Now prepare an amortization schedule for a 20yr mortgage on the same building. Compare the principle balance and interest in the same years as you did in the 30yr mortgage.

Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment....

Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. Do not use an online amortization schedule. Note the textbook amortization schedule is using an annual payment. Please complete a schedule for both 180 months (15 years) and 360 months (30 years). The interest rate for the year is 2.75% according to Bankrate for the area the home is in. Remember to divide your interest by 12 to get a monthly rate. How much...