On January 1, 2020, Shamrock Inc. bought land that had an assessed value of $390,000 at the time of purchase. A $560,000, non–interest-bearing note due on January 1, 2023, was given in exchange. There was no established exchange price for the land, and no ready market value for the note. The interest rate that is normally charged on a note of this type is 15%. Using (1) factor tables, (2) a financial calculator, or (3) Excel function PV, determine at what amount the land should be recorded at January 1, 2020. (Hint: Refer to Chapter 3 for tips on calculating.) Determine the interest expense to be reported in 2020 related to this transaction.   Please show how to calculate in Excel

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter13: Investments And Long-term Receivables
Section: Chapter Questions
Problem 10MC: On January 1, 2019, Park Company accepted a 36,000, non-interest-bearing, 3-year note from a major...
icon
Related questions
Question
100%

On January 1, 2020, Shamrock Inc. bought land that had an assessed value of $390,000 at the time of purchase. A $560,000, non–interest-bearing note due on January 1, 2023, was given in exchange. There was no established exchange price for the land, and no ready market value for the note. The interest rate that is normally charged on a note of this type is 15%.

Using (1) factor tables, (2) a financial calculator, or (3) Excel function PV, determine at what amount the land should be recorded at January 1, 2020. (Hint: Refer to Chapter 3 for tips on calculating.) Determine the interest expense to be reported in 2020 related to this transaction.

 

Please show how to calculate in Excel 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Accounting for Notes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning