Autosav e EX19_48_AISetouMagassouba lome Insert Draw Page Layout Formulas Data Review View Tell me 2 Share O Comments 201C fx JA O Define Name v E, Trace Precedents Q el v **. 2 Use in Formula v a Trace Dependents AutoSum Recently Financial Logical Used Show E Remove Arrows v Formulas Checking Window Calculation Options Insert Text Date & Lookup & Math & Time More Functions Name Error Watch unction Reference Trig Manager Create from Selection al_Int. : x v fx 1941 B C D F L A H J K N New Office Building Loan Calculator 8 Years $ (920,000) Scenarios Loan Payment Calculator 9/15/21 Rate Renovation 20 Years 4.45% 180 Date Property Price Down Payment Loan Amount $1,020,000 4.45% Loan Amount Charles Street Term in Months Annual Interest Rate 4.25% 0.37% 15 0.35% 20 4.45% 0.37% 8 $7,014.45 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date 180 1/3/22 240 96 1/3/22 1/3/22 2 PM Varying Interest Rates and Terms (6,000) $ Monthly Payment Future Value (8,000) Rate Number of Months n/a n/a 120 180 240 3.95% 4.05% 4.15% t 1 PM 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% t ot 5.15% 5PM ot M Documentation Loan Calculator Properties Equipment Loan Ready 囲 100% ude Special_Programs_ Enelieh (United Ctetteel Ce eue 1908

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. Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:

a) For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods.

b)For the pv argument, use the Loan_Amount (cell B8) to include the present value.

c)Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount.

AutoSave
a SC_EX19_4a_AisetouMagassouba_1
OFF
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
O Tell me
Share
O Comments
2010
fx I
Define Name v
Trace Precedents
...
Use in Formula v
Trace Dependents
AutoSum Recently Financial Logical
Used
Lookup & Math &
Reference
Watch
Date &
Time
Insert
Тext
More
Name
Show
Error
Calculation
Function
Trig
Functions
Manager Create from Selection
Remove Arrows v
Formulas Checking Window
Options
Total_Int..
fx
1941
A
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$
1,150,000 Monthly Payment
230,000 Total Interest
(920,000) Total Cost
$7,014.45
Month ly Interest Rate
Loan Period in Years
0.37%
0.35%
0.37%
15
20
8
2$
Loan Period in Months
180
240
96
9
Start Date
1/3/22
1/3/22
1/3/22
2 PM
2$
Monthly Payment
Future Value
10
Varying Interest Rates and Terms
(6,000) $
(8,000)
11
Rate
Number of Months
n/a
n/a
12
120
180
240
3.95%
14
4.05%
15
4.15%
16
4.25%
it
17
4.35%
1 PM
18
4.45%
19
4.55%
20
4.65%
21
4.75%
22
4.85%
23
4.95%
24
5.05%
t
25
5.15%
Б РМ
26
27
28
29
30
31
ot
32
33
34
Documentation
Loan Calculator
Properties
Equipment Loan
%3D
Ready
+
100%
Special_Programs_
Transfer...est copy
28 words
English (United States)
Focus
+
180%
2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM
111 11
Transcribed Image Text:AutoSave a SC_EX19_4a_AisetouMagassouba_1 OFF Home Insert Draw Page Layout Formulas Data Review View O Tell me Share O Comments 2010 fx I Define Name v Trace Precedents ... Use in Formula v Trace Dependents AutoSum Recently Financial Logical Used Lookup & Math & Reference Watch Date & Time Insert Тext More Name Show Error Calculation Function Trig Functions Manager Create from Selection Remove Arrows v Formulas Checking Window Options Total_Int.. fx 1941 A 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$ 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost $7,014.45 Month ly Interest Rate Loan Period in Years 0.37% 0.35% 0.37% 15 20 8 2$ Loan Period in Months 180 240 96 9 Start Date 1/3/22 1/3/22 1/3/22 2 PM 2$ Monthly Payment Future Value 10 Varying Interest Rates and Terms (6,000) $ (8,000) 11 Rate Number of Months n/a n/a 12 120 180 240 3.95% 14 4.05% 15 4.15% 16 4.25% it 17 4.35% 1 PM 18 4.45% 19 4.55% 20 4.65% 21 4.75% 22 4.85% 23 4.95% 24 5.05% t 25 5.15% Б РМ 26 27 28 29 30 31 ot 32 33 34 Documentation Loan Calculator Properties Equipment Loan %3D Ready + 100% Special_Programs_ Transfer...est copy 28 words English (United States) Focus + 180% 2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM 111 11
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
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