Create a two-variable data table as follows to provide the comparison that Liam requests:a)In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Liam wants to compare the monthly payments.b) Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell. ViewInsertFormat ToolsDataWindowHelp49%Fri 2:20 AMa SC EX19_4a_AisetouMagassouba_1AutoSaveOFFHomeInsertDrawPage LayoutFormulasDataReviewViewO Tell meA ShareComments2010fixDefine Name ♥B, Trace PrecedentsrawAUse in Formula vLA Trace DependentsLookup & Math &ReferenceWatchFormulas Checking WindowCalculationAutoSum Recently Financial LogicalUsedDate &TimeInsertТextMoreNameShowErrorihaFunctionTrigFunctionsManager Create from SelectionRemove Arrows vOptionsA12fx1941AВCDEFGHJKMN1 New Office Building2 Loan Calculator3Loan Payment CalculatorScenariosRenovation20 Years8 Years$ 1,020,0004 Date5 Property6 Price7 Down Payment8 Loan Amount9/15/21 Rate4.45%Loan Amount2$(920,000)Charles StreetTerm in Months180Annual Interest Rate4.45%4.25%4.45%2$2$1,150,000 Monthly Payment230,000 Total Interest(920,000) Total Cost$7,014.45$ 2,182,601.29$ 3,332,601.29Month ly Interest RateLoan Period in Years0.37%0.35%0.37%15208tLoan Period in Months180240962 PMStart Date1/3/221/3/221/3/2210Varying Interest Rates and TermsMonth ly Payment2$(6,000) $(8,000)11RateNumber of MonthsFuture Valuen/an/a12120180240133.95%144.05%154.15%164.25%1 PM174.35%184.45%194.55%204.65%214.75%224.85%234.95%t245.05%5 PM255.15%2627282930otMCB31323334DocumentationLoan CalculatorPropertiesEquipment Loan+Ready+100%Special_Programs_Transfer...est copy1138 wordsEnglish (United States)Focus+180%2022-02...3 PM CI3 2022-02...2.39 PM 2022-02...7.00 PM田

O 0. A SC EX19_4a_AisetouMagassouba_1 Q AutoSave OFF ... Home Formulas Review View O Tell me O Comments Insert Draw Page Layout Data 2 Share fx E, Trace Precedents Fa Trace Dependents v JAI - el - O Define Name v ... 2 Use in Formula v Show E Remove Arrows v Formulas Checking Window Calculation F Options Insert Watch AutoSum Recently Financial Logical Used Text Date & Lookup & Math & Time More Name Error Function Manager Create from Selection Reference Trig Functions A12 fx B D F H J K L M N New Office Building Loan Calculator 8 Years $ (920,000) Loan Payment Calculator Scenarios Renovation 20 Years Date Property Price Down Payment Loan Amount 9/15/21 Rate 4.45% Loan Amount $1,020,000 4.45% Charles Street $ Term in Months 1.150.000 Monthly Payment 180 Annual Interest Rate 4.25% 4.45% $7,014.45 $2,182,601.29 $ 3,332,601.29 Monthly Interest Rate 0.37% 0.35% 0.37% 230,000 Total Interest Loan Period in Years 15 20 (920,000) Total Cost Loan Period in Months 180 1/3/22 240 96 Start Date Monthly Payment Future Value 1/3/22 1/3/22 Varying Interest Rates and Terms Number of Months (6,000) $ (8,000) Rate n/a n/a 120 180 240 3.95% 4.05% 4.15% 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% 4 5.15% Documentation Loan Calculator Properties Equipment Loan Ready 111 CITC ScCond SLe 100% Acars 11Sto ot Special_Progı vords English (United States) E Focus 180% + Transfer...est 2022-02...3 PM 2022-02...2.39 PM 2022-02...7.00 PM

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter8: Budgets And Bank Reconciliations

Section: Chapter Questions

Problem 2.7C

See similar textbooks

Related questions

Concept explainers

Question

Create a two-variable data table as follows to provide the comparison that Liam requests:

a)In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Liam wants to compare the monthly payments.

b) Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.

View
Insert
Format Tools
Data
Window
Help
49%
Fri 2:20 AM
a SC EX19_4a_AisetouMagassouba_1
AutoSave
OFF
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
O Tell me
A Share
Comments
2010
fix
Define Name ♥
B, Trace Precedents
raw
A
Use in Formula v
LA Trace Dependents
Lookup & Math &
Reference
Watch
Formulas Checking Window
Calculation
AutoSum Recently Financial Logical
Used
Date &
Time
Insert
Тext
More
Name
Show
Error
iha
Function
Trig
Functions
Manager Create from Selection
Remove Arrows v
Options
A12
fx
1941
A
В
C
D
E
F
G
H
J
K
M
N
1 New Office Building
2 Loan Calculator
3
Loan Payment Calculator
Scenarios
Renovation
20 Years
8 Years
$ 1,020,000
4 Date
5 Property
6 Price
7 Down Payment
8 Loan Amount
9/15/21 Rate
4.45%
Loan Amount
2$
(920,000)
Charles Street
Term in Months
180
Annual Interest Rate
4.45%
4.25%
4.45%
2$
2$
1,150,000 Monthly Payment
230,000 Total Interest
(920,000) Total Cost
$7,014.45
$ 2,182,601.29
$ 3,332,601.29
Month ly Interest Rate
Loan Period in Years
0.37%
0.35%
0.37%
15
20
8
t
Loan Period in Months
180
240
96
2 PM
Start Date
1/3/22
1/3/22
1/3/22
10
Varying Interest Rates and Terms
Month ly Payment
2$
(6,000) $
(8,000)
11
Rate
Number of Months
Future Value
n/a
n/a
12
120
180
240
13
3.95%
14
4.05%
15
4.15%
16
4.25%
1 PM
17
4.35%
18
4.45%
19
4.55%
20
4.65%
21
4.75%
22
4.85%
23
4.95%
t
24
5.05%
5 PM
25
5.15%
26
27
28
29
30
ot
MCB
31
32
33
34
Documentation
Loan Calculator
Properties
Equipment Loan
+
Ready
+
100%
Special_Programs_
Transfer...est copy
1138 words
English (United States)
Focus
+
180%
2022-02...3 PM CI3 2022-02...2.39 PM 2022-02...7.00 PM
田

Expert Solution

Step 1

While creating data table, it is required to put to be find values Row and Column in the Input cell and then create it. All the values will be filled accordingly.

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.