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
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images