On June 1, 2020, the Alma Corp. acquired a piece of land with a building on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On June 1, 2020, the Alma Corp. acquired a piece of land with a building on it for $1,400,000. The land was worth $250,000, and the building was worth $1,150,000. Alma paid for this purchase by making a $300,000 cash payment and signing a four-year, 10% mortgage note for the remainder. This mortgage note calls for mortgage payments to be made annually on June 1 of each year, beginning in 2021 Required: a. Using the PMT function in Excel, compute the dollar amount of the annual mortgage payment. b. Record the acquisition of this land and building on June 1, 2020. c. Prepare the complete effective - interest - rate mortgage note payment schedule for Alma in Excel or on paper. d. Make the necessary December 31, 2020, adjusting entry related to this mortgage note. e. Indicate how much Alma will report on its December 31, 2020 balance sheet as Mortgage Notes Payable in both the current liability and long-term liability sections. f. Make the necessary June 1, 2021 entry to record the first mortgage payment. On June 1, 2020, the Alma Corp. acquired a piece of land with a building on it for $1,400,000. The land was worth $250,000, and the building was worth $1,150,000. Alma paid for this purchase by making a $300,000 cash payment and signing a four-year, 10% mortgage note for the remainder. This mortgage note calls for mortgage payments to be made annually on June 1 of each year, beginning in 2021 Required: a. Using the PMT function in Excel, compute the dollar amount of the annual mortgage payment. b. Record the acquisition of this land and building on June 1, 2020. c. Prepare the complete effective - interest - rate mortgage note payment schedule for Alma in Excel or on paper. d. Make the necessary December 31, 2020, adjusting entry related to this mortgage note. e. Indicate how much Alma will report on its December 31, 2020 balance sheet as Mortgage Notes Payable in both the current liability and long-term liability sections. f. Make the necessary June 1, 2021 entry to record the first mortgage payment.
Expert Answer:
Answer rating: 100% (QA)
a Calculating the Annual Mortgage Payment using the PMT function in Excel Loan Amount 1100000 total ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Describe how you test your product designs, what methodologies you use, and how you evaluate product usability.
-
Which form of business organization is limited by the Internal Revenue Code (IC) concerning the number and type of shareholders? A partnership An S corporation A C corporation A sole proprietorship...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Violet Flowers expects to sell 3,000 plants a month. She estimated the following monthly costs: Variable Costs $9,000 Fixed Costs $15,000 During her second month of operation, Violet would like to...
-
Suppose that f : [a, b] R is continuously differentiable and l-l on [a, b]. Prove that r(b) 70) f(x) dx + f-I(x) dx = bf (b) _ af(a).
-
The variable resistor R in the circuit of Fig. 11.50 is adjusted until it absorbs the maximum average power. Find R and the maximum average power absorbed. -j100 2 100 2 100 2 100/0 V (+ j100 2 lle
-
Compute NPVunequal net cash inflows (Learning Objective 4) The local Giant Eagle supermarket is considering investing in self-check-out kiosks for its customers. The self-check-out kiosks will cost...
-
On January 1, 2011, Foley Company (as lessor) entered into a noncancelable lease agreement with Pinkley Company for machinery which was carried on the accounting records of Foley at $4,530,000 and...
-
Morganton Company makes one product and provided the following information to help prepare its master budget: The budgeted selling price per unit is $ 7 0 . Budgeted unit sales for June, July,...
-
BCE has included service revenue of $22,100 as a result of a number of one year service policies sold late in December as an experiment. These service policies became effective on January 1, 20X4, or...
-
Murad wants to deposit RM950 on his birthday and plans to do it on an annual basis. Today is Murad's 25th birthday. Murad's account is earning 6.5% interest compounded semiannually. How much will be...
-
Explain FOUR (4) advantages of brand extension strategy for Tealive and how thesestrategies can contribute to Tealive's brand equity.(10 Marks)
-
Analyze discretionary decisions made by criminal justice professionals. Address the following in your analysis: What decisions were made by the judge? Who is affected by the decisions? Do they have...
-
1. A bond with a 20-year maturity pays a 6% annual coupon and has a face value of $1,000.What is its fair price at a yield-to-maturity of 3%? Of 6%? Of 9%? 2.The same company has another bond with a...
-
Responder ampliamente cada una de estas preguntas. 1. Cuales son los retos que enfrenta una empresa al lanzar una campaa 100% digital? 2. Que gana una marca que ha tenido mayor presencia en medios...
-
Why kitchen organization is important? Give three examples of most important functions of kitchen in an organization? and explain Is the size and area of the kitchen important in terms of operations?...
-
Prepare Balance Sheet and Statement of Owner's Equity for Adam Investment Cooperation for the year ended on July 31st, 2022 Cash 40,000 Electricity expense 8,300 Sales 180,500 Prepaid electricity...
-
Find the market equilibrium point for the following demand and supply functions. Demand: 2p = - q + 56 Supply: 3p - q = 34
-
On January 1, 2016, Arch Ltd. purchased 30% of the common shares of AP Inc. for $1,700,000. In 2016, AP reported net income of $880,000 and paid dividends of $600,000. Required: a. Which of the...
-
On January 1, 2017, LL Company acquired 20,000 shares, representing 20% of the outstanding shares of TT Limited at a price of $15 per share. On July 31, 2017, TT declared and paid a dividend of $1...
-
Ferro Ltd. began operations on January 1, 2018. Merchandise purchases and four alternative methods of valuing inventory for the first two years of operations are summarized below: Required: a. Which...
-
What are the two basic requirements to support the declaration of a cash dividend? What are the effects of a cash dividend on assets and shareholders equity?
-
Describe the roles and responsibilities of management, the board of directors, and independent auditors in the financial reporting process.
-
Independent Businesses. Galati and Brambila formed a corporation called Financial Fitness Systems, each woman taking 50 per cent of the authorized common stock. Galati is a Dottore Commercialista...
Study smarter with the SolutionInn App