Length of loan (in years) a. Setting up amortization table Calculation of loan payment Formula #N/A Year Beginning Balance Payment Interest b. Calculating % of Payment Representing Interest and Principal for Each Year

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
ChapterA3: Time Value Of Money
Section: Chapter Questions
Problem 11E
icon
Related questions
icon
Concept explainers
Question
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
Editing v
Arial
en v A
v Av
V10
M<得
Merge
Currency
...
fx
Payment %
Representing
Payment %
Representing
Principal
Check: Total =
Year
Interest
100%
3
Formulas
Repayment of
Principal
Year
Beginning Balance
Payment
Interest
Remaining Balance
1
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
3.
#N/A
#N/A
#N/A
#N/A
#N/A
b. Calculating % of Payment Representing Interest and Principal for Each Year
Payment %
Representing
Payment %
Representing
Principal
Check: Total =
Year
Interest
100%
1
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
3.
#N/A
#N/A
#N/A
A Sheet1
culation Mode: Automatic
Workbook Statistics
Transcribed Image Text:File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Arial en v A v Av V10 M<得 Merge Currency ... fx Payment % Representing Payment % Representing Principal Check: Total = Year Interest 100% 3 Formulas Repayment of Principal Year Beginning Balance Payment Interest Remaining Balance 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 3. #N/A #N/A #N/A #N/A #N/A b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Representing Payment % Representing Principal Check: Total = Year Interest 100% 1 #N/A #N/A #N/A #N/A #N/A #N/A 3. #N/A #N/A #N/A A Sheet1 culation Mode: Automatic Workbook Statistics
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
Editing
Arial
V 10
Merge
Currency
...
B8
fx
A
1.
Amortization schedule
2.
3.
Loan amount to be repaid (PV)
$30,000.00
Interest rate (r)
4.
Length of loan (in years)
8.00%
6.
7.
a. Setting up amortization table
Formula
8.
Calculation of loan payment
#N/A
6.
Repayment of
Principal
10
Year
Beginning Balance
Payment
Interest
Remaining Balance
11
1
12
13
3
14
15 b. Calculating % of Payment Representing Interest and Principal for Each Year
Payment %
Representing
Payment %
Representing
Principal
Check: Total =
16
Year
Interest
100%
17
1
18
19
20
21
Formulas
= A Sheet1
Calculation Mode: Automatic
Workbook Statistics
LL
2 3
Transcribed Image Text:File Home Insert Draw Page Layout Formulas Data Review View Help Editing Arial V 10 Merge Currency ... B8 fx A 1. Amortization schedule 2. 3. Loan amount to be repaid (PV) $30,000.00 Interest rate (r) 4. Length of loan (in years) 8.00% 6. 7. a. Setting up amortization table Formula 8. Calculation of loan payment #N/A 6. Repayment of Principal 10 Year Beginning Balance Payment Interest Remaining Balance 11 1 12 13 3 14 15 b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Representing Payment % Representing Principal Check: Total = 16 Year Interest 100% 17 1 18 19 20 21 Formulas = A Sheet1 Calculation Mode: Automatic Workbook Statistics LL 2 3
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage