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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
  1. 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
田
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Vertical statement analysis
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
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education