Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

On June 1, 2020, Sheffield Corporation approached Silverman Corporation about buying a parcel of undeveloped land

Accounting Oct 01, 2020

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

     
       
       
       

Expert Solution

 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    

please see the attached file. 

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment