N23 B 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
N23 B с 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to Account for Notes Payable 4 PROBLEM X✓ fx 9 10 5 Snade Corporation issued a five-year note to Hames Corp. on January 1, 2020, 6 and received a piece of equipment. The note requires annual interest 7 payments each December 31. Information concerning the note follows. 8 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Face value of note Stated interest rate Note term in years Value of equipment received Market interest rate of similar notes Ś $ D 50,000 5% 5 38,912 11% E F G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use Excel's RATE function with cell references to the Problem and work areas to calculate the implicit rate of the note. Use mathematical formulas with cell references to the Problem area and work area as indicated for other amounts. (a) Using Excel's Rate function, calculate the implicit interest rate. Annual interest payments Implicit interest rate (b) Prepare Snade's journal entry for the January 1, 2020 issuance. Debit Credit (c) Prepare the entry for the December 31, 2020 interest payment using the effective interest method. M N O P N23 B с 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to Account for Notes Payable 4 PROBLEM X✓ fx 9 10 5 Snade Corporation issued a five-year note to Hames Corp. on January 1, 2020, 6 and received a piece of equipment. The note requires annual interest 7 payments each December 31. Information concerning the note follows. 8 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Face value of note Stated interest rate Note term in years Value of equipment received Market interest rate of similar notes Ś $ D 50,000 5% 5 38,912 11% E F G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use Excel's RATE function with cell references to the Problem and work areas to calculate the implicit rate of the note. Use mathematical formulas with cell references to the Problem area and work area as indicated for other amounts. (a) Using Excel's Rate function, calculate the implicit interest rate. Annual interest payments Implicit interest rate (b) Prepare Snade's journal entry for the January 1, 2020 issuance. Debit Credit (c) Prepare the entry for the December 31, 2020 interest payment using the effective interest method. M N O P
Expert Answer:
Answer rating: 100% (QA)
Based on the Excel worksheet you shared youre being asked to use Excel to calculate the implicit interest rate of a note using the RATE function and then prepare journal entries for the note issuance ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
A road building company is purchasing an excavator for $500,000. The corporate tax rate is 45% and the expected after-tax rate of return is 12%. What would be the present value of the future tax...
-
From Kamal company information below; Debt, D = 30,000. Equity, E = 70,000. Cost of Debt rD = 8%. Cost of Equity, rE = 10%. Corporate Tax, Tc = 30 %. What is the weighted average Cost of Capital...
-
Build Right Supply, Co., shows the following financial statement data for 2014, 2015, and 2016. Prior to issuing the 2016 statements, auditors found the ending inventory for 2014 was understated by...
-
Since June 1, 2014, FunnyFlatables has been renting out fun items like moon walks and inflatable slides for parties and corporate events. The company has obtained the use of an abandoned ice rink...
-
A chairs variable cost is $50 and its market value as a piece of unfinished furniture is $63 at a transfer point from the Assembly division to the Finishing division. The Finishing divisions variable...
-
On December 14, 2011, appellant Aaron Olson contracted to receive telephone service from respondent CenturyLink and also applied for reduced-rate service that CenturyLink provides through Minnesotas...
-
The following control procedures are used in Mendy Langs Boutique Shoppe for cash disbursements. 1. The company accountant prepares the bank reconciliation and reports any discrepancies to the owner....
-
It is argued that decisions made in relatively risk-free environments are not optimal or not efficient. If this assertion is true, can we declare that the decision-making environment constrained by...
-
1. It is clear in the first meeting that Miguel is distracted and at some points disrespectful to Pilar in not listening to what she is saying to him. Still, Pilar does not do anything to draw him...
-
the end of year) takes three values 120, Let S(0) be 100 and S(1) (i.e., the value of 100 and 90 with probabilities 0.3, 0.3 and 0.4 repectively. Let the continuous risk free rate r be 3.85% per...
-
Natalie (who is not a stockbroker) purchased 10 shares of stock in XYZ Inc., a publicly-traded company, on April 1, 2021, for $10,000. On March 15, 2022, XYZ filed chapter 7 bankruptcy and was...
-
Overthenextyearhorizon,therisklessrateis4%andtheexpectedequityriskpremiumis5%.A portfolio has a beta of 1.2. 1. What is the expected return of the portfolio according to the CAPM? 2. If the realized...
-
Give an example of a direct relationship between two variables. Why is this type of relationship sometimes referred to as a positive relationship? Next, Give an example of an inverse relationship...
-
Choose a country other than the United States and research the following: What are the key diversity concerns for that country? Which groups are dominant and non-dominant? What are the participation...
-
The report must consist of headings such as Accounts Receivable and Inventory (topics from the textbook); other examples would be Income Statement, Balance Sheet, and the Statement of Shareholders'...
-
Joseph Shrestha, the holder of a Nepalese passport and relevant working visa, arrived in Australia from Nepal in January 2016. He started work as an administrator in a Sydney hospital. On 10 July...
-
A non-charmed baryon has strangeness S = 2 and electric charge Q = 0. What are the possible values of its isospin I and of its third component I z ? What is it usually called if I = 1/2?
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
In 2012, Lou has a salary of $54,000 from her job. She also has interest income of $1,700. Lou is single and has no dependents. During the year, Lou sold silver coins held as an investment for a...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-4. Ivan and Irene paid the following in 2012 (all by check or can otherwise be...
-
An Australian investor currently holds an A$240 million equity portfolio. He is considering rebalancing the portfolio based on an assessment of the risk and return prospects facing the Australian...
-
Identify risks faced by investors in emerging market equities over and above those that are faced by fixed-income investors in such markets.
-
Describe the main issues that arise when conducting historical analysis of real estate returns.
Study smarter with the SolutionInn App