PMT function
New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter12: Working With Document Nodes And Style Sheets: Creating A Dynamic Document Outline
Section: Chapter Questions
Problem 5CP4
Related questions
Question
- In cell G10, insert a formula using the PMT function using the monthly interest rate (cell G6), the loan period in months (cell G8), and the loan amount (cell G4) to calculate the monthly payment for the 10 Years scenario.
Transcribed Image Text:SC EX19_CS4-7a_AlexisDonald_2 -
P Search
困
AutoSave
Off
Alexis Donald AD
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Team
A Share
P Comments
From Text/csV
A Recent Sources
E Queries & Connections
Clear
組Flash Fill
S- Consolidate
From Web
B Existing Connections
E Properties
EReapply
Filter
E Remove Duplicates Relationships
Get
Refresh
Stocks
Currencies
Geography
Sort
Text to
What-If Forecast
Group Ungroup Subtotal
Automatic
Anatomy
Data v E From Table/Range
All- a Edit Links
EAdvanced
Columns co Data Validation v
8 Manage Data Model
Analysis v Sheet
Get & Transform Data
Queries & Connections
Data Types
Sort & Filter
Data Tools
Forecast
Outline
G10
A
В
D
E
G
H
J
K
M
N
P
Q
R
1 Business Expansion
2 Loan Calculator
3
Loan Payment Calculator
Scenarios
10 Years
15 Years
5 Years
4 Date
10/12/2021 Rate
4.35%
Loan Amount
1,720,000
$ 1,720,000
5 Purchase
Distribution center Term in Months
180
Annual Interest Rate
4.45%
4.40%
4.55%
2,150,000 Monthly Payment
430,000 Total Interest
1,720,000 Total Cost
$13,026.41
Monthly Interest Rate
Loan Period in Years
Loan Period in Months
6 Price
0.37%
0.37%
0.38%
7 Down Payment
$ 624,753.96
$2,774,753.96
10
15
5
Loan Amount
120
180
60
9
Start Date
1/3/2022
1/3/2022
1/3/2022
10
Varying Interest Rates and Terms
Monthly Payment
$ (16,000) $
(20,000)
11
Rate
Number of Months
Future Value
n/a
n/a
12 $
13,026
120
180
240
13
3.85%
17,291.81 $
12,593.73 $
10,287.42
Candidate Properties
17,373.32 $
17,455.07 $
14
3.95%
12,679.58 $
10,377.60
Туре
Contact
State
Months on Mkt
15
4.05%
12,765.77 $
10,468.23
16
4.15%
17,537.04 $
12,852.31 $
12,939.19 $
13,026.41 $
13,113.97 $
13,201.88
10,559.31
17
4.25%
17,619.26 $
10,650.83
18
4.35%
17,701.70 $
10,742.80
19
4.45%
17,784.38 $
10,835.20
20
4.55%
17,867.29 $
10,928.05
21
4.65%
17,950.44 Ş
13,290.12
11,021.33
13,378.71 $
18,033.81 $
18,117.42 $
18,201.26 $
18,285.33 $
22
4.75%
11,115.05
23
4.85%
13,467.63
11,209.20
24
4.95%
13,556.89 $
11,303.78
25
5.05%
13,646.49 $
11,398.80
26
27
28
29
30
31
32
33
34
Documentation
U.S.
Canada
U.K.
All Locations
Original Content
Subtotals
Expansion Funding
Ready
田
100%
6:45 PM
O Type here to search
73°F Sunny
11/1/2021
20
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Expert Answers to Latest Homework Questions
Q: Measurement systems that contain
elements do not respond
instantaneously to changes in the input…
Q: Can someone help me to solve
Q: A uniform solid cylinder of mass M and radius R rolls without slipping down an inclined frictional…
Q: A cylindrical water tank with D = 25 cm and H = 40 cm is used as a capacitance in a
hydraulic…
Q: Given the following vectors, calculate the cross product asked for:
a=-21-33
5=61+43
a x =?
O 10…
Q: Measurement system is desired to have a phase shift that varies linearly with frequency.
TRUE OR…
Q: Both bias errors and precision errors can propagate.
TRUE OR FLASE
Q: A wheel rolls without sliding to the right along a horizontal road as shown. Point P is painted on…
Q: Two masses m are attached to opposite ends of a long thin uniform rod of length L and mass M.
The…
Q: The rotor within a generator has a moment of inertia of 400 kg m2 and is rotating at 20 rad/s. The…
Q: Many plants have networks of mycorrhizal fungi around their roots. The fungi provide minerals to the…
Q: A frictionless pulley in the shape of a uniform disk has a mass M and a radius R. A massless rope…
Q: The maximum load that can be supported by a crane is determined by the torque that the load exerts…
Q: A uniform disk of radius R is free to rotate about its central axis. A mass m is hung vertically…
Q: The molecule cyanazine, once used as an herbicide, has now been phased out by the EPA because of its…
Q: A uniform metal bar of length L and mass M is mounted to an axle that passes through its center of…
Q: Please solve the question below, Thank You!
Q: Post-anal tail is a unique feature shared by
invertabrates and jawless fish
chordates
tetrapods
all…
Q: bo For each molecule, specify the polarity of the bonds and the overall polarity of the molecule.
©…
Q: A rotating disk has an angular position of 0 = 2π +πt+2πt², measured in radians. How many complete…
Q: W
[rad/s]
1
0
4
3
2
0 1 2 3 4 5 6 7 8 9 10
t [s]
The graph above shows the angular velocity of a…