Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FORMULA NEEDED: please help me with the wrong answers in red. A c D H 1 Function: PMT; Formula: Subtract, Multiply; Cell referencing 2 3

FORMULA NEEDED: please help me with the wrong answers in red. image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Accounting

Authors: Needles, Powers, crosson

11th Edition

1439037744, 978-1133626985, 978-1439037744

More Books

Students also viewed these Accounting questions

Question

4 billion bit charcter

Answered: 1 week ago

Question

BPR always involves automation. Group of answer choices True False

Answered: 1 week ago

Question

LO 10-1 Explain Taylors theory of scientific management.

Answered: 1 week ago