FORMULA NEEDED: please help me with the wrong answers in red. A c D H 1 Function:
Fantastic news! We've Found the answer you've been seeking!
Question:
FORMULA NEEDED: please help me with the wrong answers in red.
Transcribed Image Text:
A c D H 1 Function: PMT; Formula: Subtract, Multiply; Cell referencing 2 3 Using Excel to Calculate Loan Payments PROBLEM 5 Jenseng Inc. issues a 10-year mortgage loan on December 31, 2022 with the 6 following information: Mortgage loan amount $ 800,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the PMT function with cell references in part a to the Problem area. Input cell references in parts b and c. In part c, use mathematical formulas with cell references to the Problem area to calculate both debit amounts, and a cell reference to the Cash amount you calculated in part a Annual interest rate 10% 10 Loan term in years 10 11 Annual installment payment $ 130,196 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 a Verify the annual mortgage payment amount using Excel's PMT function. Verification of payment using PMT $130.196 b. Record the journal entry for mortgage loan on December 31, 2022. Date 12/31/22 Cash Mortgage Payable Debit Credit 800,000 00.000 e. Record the journal entry for the first installment payment on December 31, 2023 Datel 12/31/23 Interest Expense Mortgage Payable Cash Debit Credit 1000 00396) 11(1301961 A c D H 1 Function: PMT; Formula: Subtract, Multiply; Cell referencing 2 3 Using Excel to Calculate Loan Payments PROBLEM 5 Jenseng Inc. issues a 10-year mortgage loan on December 31, 2022 with the 6 following information: Mortgage loan amount $ 800,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the PMT function with cell references in part a to the Problem area. Input cell references in parts b and c. In part c, use mathematical formulas with cell references to the Problem area to calculate both debit amounts, and a cell reference to the Cash amount you calculated in part a Annual interest rate 10% 10 Loan term in years 10 11 Annual installment payment $ 130,196 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 a Verify the annual mortgage payment amount using Excel's PMT function. Verification of payment using PMT $130.196 b. Record the journal entry for mortgage loan on December 31, 2022. Date 12/31/22 Cash Mortgage Payable Debit Credit 800,000 00.000 e. Record the journal entry for the first installment payment on December 31, 2023 Datel 12/31/23 Interest Expense Mortgage Payable Cash Debit Credit 1000 00396) 11(1301961
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
What will be the value of x after executing the following java statement? Assume that value of x is 5 before the execution. x += x++ - 5;
-
Suppose that the neighbor starts to help John but then realizes that, because of the layout of Johns property, putting the building back together will take much more work than dismantling it took....
-
Suppose call and put prices are given by What no-arbitrage property is violated? What spread positionwould you use to effect arbitrage? Demonstrate that the spread position is an arbitrage. Strike 50...
-
Intelligencia Inc. was incorporated as a research and development company in the biotechnology industry. The company incurred the following costs relating to various intangible assets: 1. During the...
-
If Boeings dollar aircraft prices increase 20 percent and the yen/dollar exchange rate declines 15 percent, what effective price increase is facing Japan Air Lines for the purchase of a Boeing 747?...
-
Kiley is a 50% shareholder of Skims Inc., an S corporation. Skims has the following tax items this year: Ordinary business income $1,500,000 Tax-exempt interest income $8,000 Federal taxes relating...
-
Research Sweden's economic and political behavior from 1990 to current date. Did the size of government grow or shrink during this time? Did businesses have more or less control by the government...
-
Use the information provided below to calculate the following independently: 1.3.1 1.3.3 Net profit Marginal income per unit that will enable the project to break even 1.3.2 Break-even quantity if...
-
Suppose that China and Germany each have 1,000,000 labour hours available for the pro- duction of cell phones and computers. The number of labour hours needed to produce cell phones and computers in...
-
How do I use voice commands to control my computer with the project of making a video?
-
How IP Register Is related to CS,SS and DS Registers explain?
-
How does Oracle Database manage data security and compliance requirements through features such as Transparent Data Encryption (TDE), Virtual Private Database (VPD), and Fine-Grained Auditing (FGA),...
-
The Christy Corporation had the following balance sheet as of December 31, 20x2. The transactions for the first three months of 20x3 are also presented along with other information about specific...
-
Audrey purchases a riding lawnmower using a 2-year, no-interest deferred payment plan at Lawn Depot for x dollars. There was a down payment of d dollars and a monthly payment of m dollars. Express...
-
Cherie and Tonys trial balance as at 31 December 2012 is set out below. 1. Closing inventory is 12,000. 2. 197 of the other expenses was prepaid and 200 is owed for the telephone. 3. Salaries will be...
-
Sister and Sledge are trading in partnership, sharing profits and losses in the ratio of 2:1, respectively. The partners are entitled to salaries of Sister 6,000 per annum and Sledge 5,000 per annum....
-
Red Devils Ltd has the following extracts from its accounts. 1. An audit fee is to be provided of 7,500. 2. The debenture interest for the year has not been paid. 3. The directors propose to transfer...
Study smarter with the SolutionInn App