Question

On June 1, 2020, Sheffield Corporation approached Silverman Corporation about buying a parcel of undeveloped land. Silverman was asking $258,000 for the land and Sheffield saw that there was some flexibility in the asking price. Sheffield did not have enough money to make a cash offer to Silverman and proposed to give, in return for the land, a $305,000, five-year promissory note that bears interest at the rate of 4%. The interest is to be paid annually to Silverman Corporation on June 1 of each of the next five years. Silverman insisted that the note taken in return become a mortgage note. Silverman accepted the amended offer, and Sheffield signed a mortgage note for $305,000 due June 1, 2025. Sheffield would have had to pay 10% at its local bank if it were to borrow the cash for the land purchase. Silverman, on the other hand, could borrow the funds at 9%. Both Sheffield and Silverman have calendar year ends.

Click here to view the factor table PRESENT VALUE OF 1.
Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1.

Using (1) factor tables, (2) a financial calculator, or (3) Excel function PV, calculate the purchase price of the land and prepare an effective interest amortization table for the term of the mortgage note payable that is given in the exchange. (Hint: Refer to Chapter 3 for tips on calculating.) (For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answers to 0 decimal places, e.g. 5,275.)

Purchase price of the land

$

Mortgage Note Payable – Interest Amortization
Date		Cash Paid		Interest Expense		Discount Amortized		Note Carrying Amount
June 1 2020								$
June 1 2021		$		$		$
June 1 2022
June 1 2023
June 1 2024
June 1 2025
				$		$

eTextbook and Media

List of Accounts

  

  

Prepare the journal entry for the purchase of the land. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Date	Account Titles and Explanation	Debit	Credit
June 1, 2020

eTextbook and Media

List of Accounts

  

  

Prepare any adjusting entry that is required at the end of the fiscal year and the first payment made on June 1, 2021, assuming no reversing entries are used. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Date	Account Titles and Explanation	Debit	Credit
Dec. 31, 2020
June 1, 2021

eTextbook and Media

List of Accounts

  

  

Assume that Silverman had insisted on obtaining an instalment note from Sheffield instead of a mortgage note.

Using (1) factor tables, (2) a financial calculator, or (3) Excel function PMT, calculate the amount of the instalment payments that would be required for a five-year instalment note. (Hint: Refer to Chapter 3 for tips on calculating.) Use the same cost of the land to Sheffield Corporation that you determined for the mortgage note in a previous part of the question. (For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answer to 0 decimal places, e.g. 5,275.)

Amount of the instalment

$Enter your answer in accordance to the question statement

eTextbook and Media

List of Accounts

  

  

Assume that Silverman had insisted on obtaining an instalment note from Sheffield instead of a mortgage note.

Prepare an effective interest amortization table for the five-year term of the instalment note. (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 5,275. Do not leave any answer field blank. Enter 0 for amounts.)

Instalment Note Payable
Date		Cash Paid		Interest Expense		Discount Amortized		Note Carrying Amount
June 1 2020								$
June 1 2021		$		$		$
June 1 2022
June 1 2023
June 1 2024
June 1 2025
				$		$

eTextbook and Media

List of Accounts

  

  

Prepare the journal entry for the purchase of the land and the issuance of the instalment note. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Date	Account Titles and Explanation	Debit	Credit
June 1, 2020

eTextbook and Media

List of Accounts

  

  

Prepare any adjusting journal entry that is required at the end of the fiscal year and the first payment made on June 1, 2021, assuming no reversing entries are used. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Date	Account Titles and Explanation	Debit	Credit
Dec. 31, 2020
June 1, 2021

Answer 1

1) Using (1) factor tables, (2) a financial calculator, or (3) Excel function PV, calculate the purchase price of the land and prepare an effective interest amortization table for the term of the mortgage note payable that is given in the exchange. (Hint: Refer to Chapter 3 for tips on calculating.) (For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answers to 0 decimal places, e.g. 5,275.)
Using a financial calculator:
I	10%
N	5
PMT (305,000 x 4%)	$12,200
FV	$305,000
Type	0
PV	$235,629
Purchase price of the land	$235,629
Mortgage Note Payable – Interest Amortization
Date	Cash Paid @ 4%	Interest Expense @ 10%	Discount Amortized	Notes Carrying Amount
June 1 2020				$235,629
June 1 2021	$12,200	$23,563	$11,363	$246,991
June 1 2022	$12,200	$24,699	$12,499	$259,491
June 1 2023	$12,200	$25,949	$13,749	$273,240
June 1 2024	$12,200	$27,324	$15,124	$288,364
June 1 2025	$12,200	$28,836	$16,636	$305,000
		$130,371	$69,371
Prepare the journal entry for the purchase of the land. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
Date	Account Titles and Explanation	Debit	Credit
1-Jun-20	Land	$235,629
	Notes Payable		$235,629
Prepare any adjusting entry that is required at the end of the fiscal year and the first payment made on June 1, 2021, assuming no reversing entries are used. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
Date	Account Titles and Explanation	Debit	Credit
Dec. 31, 2020	Interest Expense ($23,563 x 7/12 months)	$13,745
	Notes Payable (11,363 x 7/12 months	$6,628
	Interest Payable		$7,117
1-Jun-21	Interest Expense ($23,563 x 5/12 months)	$9,818
	Interest Payable	$7,117
	Notes Payable (11,363 x 5/12 months	$4,735
	Cash		$12,200
Assume that Silverman had insisted on obtaining an instalment note from Sheffield instead of a mortgage note.
Using (1) factor tables, (2) a financial calculator, or (3) Excel function PMT, calculate the amount of the instalment payments that would be required for a five-year instalment note. (Hint: Refer to Chapter 3 for tips on calculating.) Use the same cost of the land to Sheffield Corporation that you determined for the mortgage note in a previous part of the question. (For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answer to 0 decimal places, e.g. 5,275.)
Using a financial calculator:
I	10%
N	5
PMT	$62,158
FV	$0
Type	0
PV	$235,629
Amount of the instalment	$62,158
Prepare an effective interest amortization table for the five-year term of the instalment note. (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 5,275. Do not leave any answer field blank. Enter 0 for amounts.)
Instalment Note Payable
Date	Cash Paid	Interest Expense @ 10%	Discount Amortized	Notes Carrying Amount
June 1 2020				$235,629
June 1 2021	$62,158	$23,562.86	$38,595.37	$197,033.23
June 1 2022	$62,158	$19,703.32	$42,454.91	$154,578.32
June 1 2023	$62,158	$15,457.83	$46,700.40	$107,877.92
June 1 2024	$62,158	$10,787.79	$51,370.44	$56,507.48
June 1 2025	$62,158	$5,650.75	$56,507.48	($0.00)
		$75,162.56	$235,628.60
Prepare the journal entry for the purchase of the land and the issuance of the instalment note. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
Date	Account Titles and Explanation	Debit	Credit
1-Jun-20	Land	$235,629
	Notes Payable		$235,629
Prepare any adjusting journal entry that is required at the end of the fiscal year and the first payment made on June 1, 2021, assuming no reversing entries are used. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
Date	Account Titles and Explanation	Debit	Credit
Dec. 31, 2020	Interest Expense ($23,563 x 7/12 months)	$13,745
	Interest Payable		$13,745
1-Jun-21	Interest Expense ($23,563 x 5/12 months)	$9,818
	Interest Payable	$13,745
	Notes Payable		$38,595
	Cash		$62,158